diff options
Diffstat (limited to 'db_config/SQL')
-rw-r--r-- | db_config/SQL/mssql.20131110.sql | 2 | ||||
-rw-r--r-- | db_config/SQL/mssql.20141115.sql | 2 | ||||
-rw-r--r-- | db_config/SQL/mssql.initial.sql | 12 | ||||
-rw-r--r-- | db_config/SQL/mysql.20131110.sql | 2 | ||||
-rw-r--r-- | db_config/SQL/mysql.20141115.sql | 4 | ||||
-rw-r--r-- | db_config/SQL/mysql.initial.sql | 15 | ||||
-rw-r--r-- | db_config/SQL/pgsql.20131110.sql | 1 | ||||
-rw-r--r-- | db_config/SQL/pgsql.20141115.sql | 1 | ||||
-rw-r--r-- | db_config/SQL/pgsql.initial.sql | 13 | ||||
-rw-r--r-- | db_config/SQL/sqlite.20131110.sql | 1 | ||||
-rw-r--r-- | db_config/SQL/sqlite.20141115.sql | 1 | ||||
-rw-r--r-- | db_config/SQL/sqlite.initial.sql | 13 |
12 files changed, 67 insertions, 0 deletions
diff --git a/db_config/SQL/mssql.20131110.sql b/db_config/SQL/mssql.20131110.sql new file mode 100644 index 0000000..eb35e62 --- /dev/null +++ b/db_config/SQL/mssql.20131110.sql @@ -0,0 +1,2 @@ +UPDATE [system] SET [value]='initial|20131110' WHERE [name]='myrc_db_config'
+GO
diff --git a/db_config/SQL/mssql.20141115.sql b/db_config/SQL/mssql.20141115.sql new file mode 100644 index 0000000..0819c6e --- /dev/null +++ b/db_config/SQL/mssql.20141115.sql @@ -0,0 +1,2 @@ +UPDATE [system] SET [value]='initial|20131110|20141115' WHERE [name]='myrc_db_config'
+GO
diff --git a/db_config/SQL/mssql.initial.sql b/db_config/SQL/mssql.initial.sql new file mode 100644 index 0000000..1e806b0 --- /dev/null +++ b/db_config/SQL/mssql.initial.sql @@ -0,0 +1,12 @@ +IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[db_config]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
+CREATE TABLE [db_config] (
+ [id] int NOT NULL IDENTITY(1,1),
+ [env] nvarchar(255) NOT NULL,
+ [conf] nvarchar(MAX) NOT NULL,
+ [admin] nvarchar(128) NOT NULL,
+ PRIMARY KEY ([id])
+)
+GO
+
+INSERT INTO [system] (name, value) VALUES ('myrc_db_config', 'initial')
+GO
diff --git a/db_config/SQL/mysql.20131110.sql b/db_config/SQL/mysql.20131110.sql new file mode 100644 index 0000000..e0a4247 --- /dev/null +++ b/db_config/SQL/mysql.20131110.sql @@ -0,0 +1,2 @@ +ALTER TABLE `db_config` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+UPDATE `system` SET `value`='initial|20131110' WHERE `name`='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/mysql.20141115.sql b/db_config/SQL/mysql.20141115.sql new file mode 100644 index 0000000..57e1605 --- /dev/null +++ b/db_config/SQL/mysql.20141115.sql @@ -0,0 +1,4 @@ +ALTER TABLE `db_config` CHANGE `env` `env` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
+ALTER TABLE `db_config` CHANGE `conf` `conf` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
+ALTER TABLE `db_config` CHANGE `admin` `admin` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
+UPDATE `system` SET `value`='initial|20131110|20141115' WHERE `name`='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/mysql.initial.sql b/db_config/SQL/mysql.initial.sql new file mode 100644 index 0000000..6d02e7c --- /dev/null +++ b/db_config/SQL/mysql.initial.sql @@ -0,0 +1,15 @@ +CREATE TABLE IF NOT EXISTS `db_config` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `env` varchar(255) NOT NULL,
+ `conf` longtext NOT NULL,
+ `admin` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+CREATE TABLE IF NOT EXISTS `system` (
+ `name` varchar(64) NOT NULL,
+ `value` mediumtext,
+ PRIMARY KEY(`name`)
+);
+
+INSERT INTO `system` (name, value) VALUES ('myrc_db_config', 'initial');
\ No newline at end of file diff --git a/db_config/SQL/pgsql.20131110.sql b/db_config/SQL/pgsql.20131110.sql new file mode 100644 index 0000000..e5d0335 --- /dev/null +++ b/db_config/SQL/pgsql.20131110.sql @@ -0,0 +1 @@ +UPDATE "system" SET value='initial|20131110' WHERE name='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/pgsql.20141115.sql b/db_config/SQL/pgsql.20141115.sql new file mode 100644 index 0000000..d3df0b4 --- /dev/null +++ b/db_config/SQL/pgsql.20141115.sql @@ -0,0 +1 @@ +UPDATE "system" SET value='initial|20131110|20141115' WHERE name='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/pgsql.initial.sql b/db_config/SQL/pgsql.initial.sql new file mode 100644 index 0000000..e6f53fa --- /dev/null +++ b/db_config/SQL/pgsql.initial.sql @@ -0,0 +1,13 @@ +CREATE TABLE IF NOT EXISTS db_config ( + id serial PRIMARY KEY, + env varchar(255) DEFAULT NULL, + conf text, + admin varchar(128) NOT NULL +); + +CREATE TABLE IF NOT EXISTS "system" ( + name varchar(64) NOT NULL PRIMARY KEY, + value text +); + +INSERT INTO "system" (name, value) VALUES ('myrc_db_config', 'initial');
\ No newline at end of file diff --git a/db_config/SQL/sqlite.20131110.sql b/db_config/SQL/sqlite.20131110.sql new file mode 100644 index 0000000..f4c349d --- /dev/null +++ b/db_config/SQL/sqlite.20131110.sql @@ -0,0 +1 @@ +UPDATE 'system' SET value='initial|20131110' WHERE name='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/sqlite.20141115.sql b/db_config/SQL/sqlite.20141115.sql new file mode 100644 index 0000000..6d13072 --- /dev/null +++ b/db_config/SQL/sqlite.20141115.sql @@ -0,0 +1 @@ +UPDATE 'system' SET value='initial|20131110|20141115' WHERE name='myrc_db_config';
\ No newline at end of file diff --git a/db_config/SQL/sqlite.initial.sql b/db_config/SQL/sqlite.initial.sql new file mode 100644 index 0000000..d1d81ec --- /dev/null +++ b/db_config/SQL/sqlite.initial.sql @@ -0,0 +1,13 @@ +CREATE TABLE IF NOT EXISTS 'db_config' (
+ 'id' INTEGER NOT NULL PRIMARY KEY ASC,
+ 'env' varchar(255) NOT NULL,
+ 'conf' text NOT NULL,
+ 'admin' varchar(128) NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS 'system' (
+ name varchar(64) NOT NULL PRIMARY KEY,
+ value text NOT NULL
+);
+
+INSERT INTO system (name, value) VALUES ('myrc_db_config', 'initial');
\ No newline at end of file |