diff options
Diffstat (limited to 'sql/Pg-upgrade-2.6.12-2.6.17.sql')
-rwxr-xr-x | sql/Pg-upgrade-2.6.12-2.6.17.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/sql/Pg-upgrade-2.6.12-2.6.17.sql b/sql/Pg-upgrade-2.6.12-2.6.17.sql deleted file mode 100755 index 908ad198..00000000 --- a/sql/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'; |