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/sqlite.20131209.sql | 48 ++++++++++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 plugin_manager/SQL/sqlite.20131209.sql

(limited to 'plugin_manager/SQL/sqlite.20131209.sql')

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

