diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-25 06:41:39 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-25 06:41:39 +0000 |
| commit | 8395fa501827306002e3a01c7053f495bff844c2 (patch) | |
| tree | 80c4d5718645a520e2ac95722fb3a28a1fb7ab11 /sql | |
| parent | 1b8d009a5234eda0e46f8ceef5aeeb4939e53078 (diff) | |
Moved Form.pm to parameterized queries. Did some basic testing, but can't
guarantee that nothing broke.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@146 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/Pg-tables.sql | 8 |
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, |