From 705245329bb81c7f237c8b24de1ca4fd1822e05b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sat, 8 Dec 2007 02:38:53 +0000 Subject: Removing sql/legacy-- will package new download from the files in branches/1.2 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1964 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql | 19 ------------------- 1 file changed, 19 deletions(-) delete mode 100755 sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql (limited to 'sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql') diff --git a/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql b/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql deleted file mode 100755 index 908ad198..00000000 --- a/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql +++ /dev/null @@ -1,19 +0,0 @@ -CREATE SEQUENCE session_session_id_seq; - -CREATE TABLE session( -session_id INTEGER PRIMARY KEY DEFAULT nextval('session_session_id_seq'), -sl_login VARCHAR(50), -token CHAR(32), -last_used TIMESTAMP default now() -); - --- LOCK TABLE acc_trans; -ALTER TABLE acc_trans ALTER COLUMN chart_id SET NOT NULL; - --- For older versions pre 8.0.3 -ALTER TABLE acc_trans ADD COLUMN amount2 NUMERIC; -UPDATE acc_trans set amount2 = amount; -ALTER TABLE acc_trans DROP COLUMN amount; -ALTER TABLE acc_trans RENAME column amount2 TO amount; - -UPDATE defaults SET version = '2.6.17'; -- cgit v1.2.3