From 99f904adcc37d93c90defcd8ce898598e25be212 Mon Sep 17 00:00:00 2001
From: Hugues Hiegel <root@paranoid>
Date: Wed, 11 Mar 2015 16:55:04 +0100
Subject: Lot of plugins

---
 db_config/SQL/mssql.20131110.sql  |  2 ++
 db_config/SQL/mssql.20141115.sql  |  2 ++
 db_config/SQL/mssql.initial.sql   | 12 ++++++++++++
 db_config/SQL/mysql.20131110.sql  |  2 ++
 db_config/SQL/mysql.20141115.sql  |  4 ++++
 db_config/SQL/mysql.initial.sql   | 15 +++++++++++++++
 db_config/SQL/pgsql.20131110.sql  |  1 +
 db_config/SQL/pgsql.20141115.sql  |  1 +
 db_config/SQL/pgsql.initial.sql   | 13 +++++++++++++
 db_config/SQL/sqlite.20131110.sql |  1 +
 db_config/SQL/sqlite.20141115.sql |  1 +
 db_config/SQL/sqlite.initial.sql  | 13 +++++++++++++
 12 files changed, 67 insertions(+)
 create mode 100644 db_config/SQL/mssql.20131110.sql
 create mode 100644 db_config/SQL/mssql.20141115.sql
 create mode 100644 db_config/SQL/mssql.initial.sql
 create mode 100644 db_config/SQL/mysql.20131110.sql
 create mode 100644 db_config/SQL/mysql.20141115.sql
 create mode 100644 db_config/SQL/mysql.initial.sql
 create mode 100644 db_config/SQL/pgsql.20131110.sql
 create mode 100644 db_config/SQL/pgsql.20141115.sql
 create mode 100644 db_config/SQL/pgsql.initial.sql
 create mode 100644 db_config/SQL/sqlite.20131110.sql
 create mode 100644 db_config/SQL/sqlite.20141115.sql
 create mode 100644 db_config/SQL/sqlite.initial.sql

(limited to 'db_config/SQL')

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
-- 
cgit v1.2.3