summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rwxr-xr-xsql/Pg-tables.sql8
1 files changed, 6 insertions, 2 deletions
diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql
index 8e49dcd4..82703efc 100755
--- a/sql/Pg-tables.sql
+++ b/sql/Pg-tables.sql
@@ -12,7 +12,11 @@ CREATE SEQUENCE jcitemsid;
SELECT nextval ('jcitemsid');
--
-
+create table transactions (
+ id int PRIMARY KEY,
+ table_name text
+);
+--
CREATE TABLE makemodel (
parts_id int PRIMARY KEY,
make text,
@@ -75,7 +79,7 @@ CREATE TABLE defaults (
);
--
CREATE TABLE acc_trans (
- trans_id int,
+ trans_id int REFERENCES transactions(id),
chart_id int NOT NULL REFERENCES chart (id),
amount NUMERIC,
transdate date DEFAULT current_date,