From 07412baa3500a8ff4086adb0edf03c9bd2a69310 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Thu, 3 Mar 2016 10:52:10 +1300 Subject: Start db changelogs from scratch --- database/changelog-3.3.xml | 187 ++++++++++++++++++++++++++++++++ database/changelog-master.xml | 9 ++ database/db.changelog-3.0.xml | 207 ------------------------------------ database/db.changelog-3.1.xml | 131 ----------------------- database/db.changelog-3.2.xml | 63 ----------- database/db.changelog-3.3.xml | 32 ------ database/db.changelog-master.xml | 13 --- database/db.changelog-normalize.xml | 114 -------------------- debug.xml | 2 +- 9 files changed, 197 insertions(+), 561 deletions(-) create mode 100644 database/changelog-3.3.xml create mode 100644 database/changelog-master.xml delete mode 100644 database/db.changelog-3.0.xml delete mode 100644 database/db.changelog-3.1.xml delete mode 100644 database/db.changelog-3.2.xml delete mode 100644 database/db.changelog-3.3.xml delete mode 100644 database/db.changelog-master.xml delete mode 100644 database/db.changelog-normalize.xml diff --git a/database/changelog-3.3.xml b/database/changelog-3.3.xml new file mode 100644 index 000000000..25b359401 --- /dev/null +++ b/database/changelog-3.3.xml @@ -0,0 +1,187 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/database/changelog-master.xml b/database/changelog-master.xml new file mode 100644 index 000000000..595643dce --- /dev/null +++ b/database/changelog-master.xml @@ -0,0 +1,9 @@ + + + + + diff --git a/database/db.changelog-3.0.xml b/database/db.changelog-3.0.xml deleted file mode 100644 index 453f6f00b..000000000 --- a/database/db.changelog-3.0.xml +++ /dev/null @@ -1,207 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/database/db.changelog-3.1.xml b/database/db.changelog-3.1.xml deleted file mode 100644 index 740da4e2f..000000000 --- a/database/db.changelog-3.1.xml +++ /dev/null @@ -1,131 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/database/db.changelog-3.2.xml b/database/db.changelog-3.2.xml deleted file mode 100644 index fdeabfb68..000000000 --- a/database/db.changelog-3.2.xml +++ /dev/null @@ -1,63 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/database/db.changelog-3.3.xml b/database/db.changelog-3.3.xml deleted file mode 100644 index 22fcd6f5c..000000000 --- a/database/db.changelog-3.3.xml +++ /dev/null @@ -1,32 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/database/db.changelog-master.xml b/database/db.changelog-master.xml deleted file mode 100644 index 06fc7a695..000000000 --- a/database/db.changelog-master.xml +++ /dev/null @@ -1,13 +0,0 @@ - - - - - - - - - diff --git a/database/db.changelog-normalize.xml b/database/db.changelog-normalize.xml deleted file mode 100644 index 7621846ca..000000000 --- a/database/db.changelog-normalize.xml +++ /dev/null @@ -1,114 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - CREATE ALIAS IF NOT EXISTS EXECUTE AS $$ void executeSql(Connection conn, String sql) throws SQLException { try { conn.createStatement().executeUpdate(sql); } catch (Exception e) {} } $$; - - CALL EXECUTE('ALTER TABLE POSITION DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'POSITION' AND COLUMN_LIST = 'DEVICEID')); - CALL EXECUTE('ALTER TABLE DEVICE DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'DEVICE' AND COLUMN_LIST = 'POSITIONID')); - CALL EXECUTE('ALTER TABLE DEVICE DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'DEVICE' AND COLUMN_LIST = 'DATAID')); - CALL EXECUTE('ALTER TABLE USER_DEVICE DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'USER_DEVICE' AND COLUMN_LIST = 'USERID')); - CALL EXECUTE('ALTER TABLE USER_DEVICE DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'USER_DEVICE' AND COLUMN_LIST = 'DEVICEID')); - CALL EXECUTE('ALTER TABLE DATA DROP CONSTRAINT ' || (SELECT DISTINCT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE CONSTRAINT_TYPE = 'REFERENTIAL' AND TABLE_NAME = 'DATA' AND COLUMN_LIST = 'DEVICEID')); - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - diff --git a/debug.xml b/debug.xml index 82600a3eb..eb2038cd5 100644 --- a/debug.xml +++ b/debug.xml @@ -49,7 +49,7 @@ sa false - ./database/db.changelog-master.xml + ./database/changelog-master.xml SELECT * FROM server; -- cgit v1.2.3