diff options
Diffstat (limited to 'plugin_manager/SQL')
-rw-r--r-- | plugin_manager/SQL/mssql.20131209.sql | 4 | ||||
-rw-r--r-- | plugin_manager/SQL/mssql.initial.sql | 20 | ||||
-rw-r--r-- | plugin_manager/SQL/mysql.20131209.sql | 4 | ||||
-rw-r--r-- | plugin_manager/SQL/mysql.initial.sql | 21 | ||||
-rw-r--r-- | plugin_manager/SQL/pgsql.20131209.sql | 3 | ||||
-rw-r--r-- | plugin_manager/SQL/pgsql.initial.sql | 17 | ||||
-rw-r--r-- | plugin_manager/SQL/sqlite.20131209.sql | 48 | ||||
-rw-r--r-- | plugin_manager/SQL/sqlite.initial.sql | 11 |
8 files changed, 128 insertions, 0 deletions
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 |