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

---
 plugin_manager/SQL/mssql.20131209.sql  |  4 +++
 plugin_manager/SQL/mssql.initial.sql   | 20 ++++++++++++++
 plugin_manager/SQL/mysql.20131209.sql  |  4 +++
 plugin_manager/SQL/mysql.initial.sql   | 21 +++++++++++++++
 plugin_manager/SQL/pgsql.20131209.sql  |  3 +++
 plugin_manager/SQL/pgsql.initial.sql   | 17 ++++++++++++
 plugin_manager/SQL/sqlite.20131209.sql | 48 ++++++++++++++++++++++++++++++++++
 plugin_manager/SQL/sqlite.initial.sql  | 11 ++++++++
 8 files changed, 128 insertions(+)
 create mode 100644 plugin_manager/SQL/mssql.20131209.sql
 create mode 100644 plugin_manager/SQL/mssql.initial.sql
 create mode 100644 plugin_manager/SQL/mysql.20131209.sql
 create mode 100644 plugin_manager/SQL/mysql.initial.sql
 create mode 100644 plugin_manager/SQL/pgsql.20131209.sql
 create mode 100644 plugin_manager/SQL/pgsql.initial.sql
 create mode 100644 plugin_manager/SQL/sqlite.20131209.sql
 create mode 100644 plugin_manager/SQL/sqlite.initial.sql

(limited to 'plugin_manager/SQL')

diff --git a/plugin_manager/SQL/mssql.20131209.sql b/plugin_manager/SQL/mssql.20131209.sql
new file mode 100644
index 0000000..19107fc
--- /dev/null
+++ b/plugin_manager/SQL/mssql.20131209.sql
@@ -0,0 +1,4 @@
+--az initben mar benne van
+
+UPDATE [system] SET [value]='initial|20131209' WHERE [name]='myrc_plugin_manager'
+GO
diff --git a/plugin_manager/SQL/mssql.initial.sql b/plugin_manager/SQL/mssql.initial.sql
new file mode 100644
index 0000000..f800588
--- /dev/null
+++ b/plugin_manager/SQL/mssql.initial.sql
@@ -0,0 +1,20 @@
+IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[plugin_manager]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
+CREATE TABLE [plugin_manager] (
+  [id] int NOT NULL IDENTITY(1,1),
+  [conf] nvarchar(MAX) NOT NULL,
+  [value] nvarchar(MAX),
+  [type] nvarchar(MAX),
+  PRIMARY KEY ([id])
+)
+GO
+
+IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[system]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
+CREATE TABLE [system] (
+ [name] nvarchar(64) NOT NULL,
+ [value] nvarchar(MAX),
+ PRIMARY KEY([name])
+)
+GO
+
+INSERT INTO [system] (name, value) VALUES ('myrc_plugin_manager', 'initial|20131209')
+GO
\ No newline at end of file
diff --git a/plugin_manager/SQL/mysql.20131209.sql b/plugin_manager/SQL/mysql.20131209.sql
new file mode 100644
index 0000000..1afcbda
--- /dev/null
+++ b/plugin_manager/SQL/mysql.20131209.sql
@@ -0,0 +1,4 @@
+ALTER TABLE  `plugin_manager` DROP FOREIGN KEY  `user_id_fk_plugin_manager` ;
+ALTER TABLE  `plugin_manager` DROP  `user_id`;
+ALTER TABLE  `plugin_manager` ENGINE=MyISAM;
+UPDATE `system` SET `value`='initial|20131209' WHERE `name`='myrc_plugin_manager';
\ No newline at end of file
diff --git a/plugin_manager/SQL/mysql.initial.sql b/plugin_manager/SQL/mysql.initial.sql
new file mode 100644
index 0000000..e7553d5
--- /dev/null
+++ b/plugin_manager/SQL/mysql.initial.sql
@@ -0,0 +1,21 @@
+CREATE TABLE IF NOT EXISTS `plugin_manager` (
+  `id` int(10) NOT NULL AUTO_INCREMENT,
+  `user_id` int(10) unsigned NOT NULL,
+  `conf` text NOT NULL,
+  `value` text,
+  `type` text,
+  PRIMARY KEY (`id`),
+  KEY `user_id` (`user_id`),
+  KEY `user_id_index` (`user_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 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_plugin_manager', 'initial');
+
+ALTER TABLE `plugin_manager`
+  ADD CONSTRAINT `user_id_fk_plugin_manager` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
diff --git a/plugin_manager/SQL/pgsql.20131209.sql b/plugin_manager/SQL/pgsql.20131209.sql
new file mode 100644
index 0000000..2edd9bd
--- /dev/null
+++ b/plugin_manager/SQL/pgsql.20131209.sql
@@ -0,0 +1,3 @@
+ALTER TABLE plugin_manager DROP CONSTRAINT plugin_manager_user_id_fkey;
+ALTER TABLE plugin_manager DROP user_id;
+UPDATE "system" SET value='initial|20131209' WHERE name='myrc_plugin_manager';
\ No newline at end of file
diff --git a/plugin_manager/SQL/pgsql.initial.sql b/plugin_manager/SQL/pgsql.initial.sql
new file mode 100644
index 0000000..5fa498b
--- /dev/null
+++ b/plugin_manager/SQL/pgsql.initial.sql
@@ -0,0 +1,17 @@
+CREATE TABLE plugin_manager (
+  id serial NOT NULL,
+  user_id integer NOT NULL
+	REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+  conf text NOT NULL,
+  value text,
+  type text,
+  PRIMARY KEY (id)
+);
+CREATE INDEX ix_plugin_manager_user_id ON users (user_id);
+
+CREATE TABLE IF NOT EXISTS "system" (
+    name varchar(64) NOT NULL PRIMARY KEY,
+    value text
+);
+
+INSERT INTO "system" (name, value) VALUES ('myrc_plugin_manager', 'initial');
\ No newline at end of file
diff --git a/plugin_manager/SQL/sqlite.20131209.sql b/plugin_manager/SQL/sqlite.20131209.sql
new file mode 100644
index 0000000..1fa9cd6
--- /dev/null
+++ b/plugin_manager/SQL/sqlite.20131209.sql
@@ -0,0 +1,48 @@
+CREATE TABLE 'plugin_manager_tmp' (
+  'id' INTEGER NOT NULL PRIMARY KEY,
+  'user_id' INT(10) NOT NULL,
+  'conf' TEXT NOT NULL,
+  'value' TEXT,
+  'type' TEXT
+) ;
+
+INSERT INTO plugin_manager_tmp (
+  'id',
+  'user_id',
+  'conf',
+  'value',
+  'type'
+)
+SELECT
+  'id',
+  'user_id',
+  'conf',
+  'value',
+  'type'
+FROM plugin_manager;
+
+DROP TABLE plugin_manager;
+
+CREATE TABLE 'plugin_manager' (
+  'id' INTEGER NOT NULL PRIMARY KEY,
+  'conf' TEXT NOT NULL,
+  'value' TEXT,
+  'type' TEXT
+) ;
+
+INSERT INTO plugin_manager (
+  'id',
+  'conf',
+  'value',
+  'type'
+)
+SELECT
+  'id',
+  'conf',
+  'value',
+  'type'
+FROM plugin_manager_tmp;
+
+DROP TABLE plugin_manager_tmp;
+
+UPDATE 'system' SET value='initial|20131209' WHERE name='myrc_plugin_manager';
\ No newline at end of file
diff --git a/plugin_manager/SQL/sqlite.initial.sql b/plugin_manager/SQL/sqlite.initial.sql
new file mode 100644
index 0000000..c1b77a8
--- /dev/null
+++ b/plugin_manager/SQL/sqlite.initial.sql
@@ -0,0 +1,11 @@
+CREATE TABLE IF NOT EXISTS 'plugin_manager' ( 'id' integer NOT NULL PRIMARY KEY AUTOINCREMENT, 'user_id' INT(10) NOT NULL, 'conf' TEXT NOT NULL, 'value' TEXT, 'type' TEXT,
+    CONSTRAINT 'plugin_manager_ibfk_1' FOREIGN KEY ('user_id') REFERENCES 'users'
+      ('user_id') ON DELETE
+      CASCADE ON UPDATE CASCADE );
+      
+CREATE TABLE IF NOT EXISTS 'system' (
+  name varchar(64) NOT NULL PRIMARY KEY,
+  value text NOT NULL
+);
+
+INSERT INTO system (name, value) VALUES ('myrc_plugin_manager', 'initial');
\ No newline at end of file
-- 
cgit v1.2.3