upd: rename package name and all references to it

[gigi.git] / src / club / wpia / gigi / database / upgrade / from_3.sql

diff --git a/src/club/wpia/gigi/database/upgrade/from_3.sql b/src/club/wpia/gigi/database/upgrade/from_3.sql
new file mode 100644 (file)
index 0000000..f6c3c08
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_3.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS `profiles`;
+CREATE TABLE `profiles` (
+  `id` int(3) NOT NULL AUTO_INCREMENT,
+  `keyname` varchar(60) NOT NULL,
+  `include` varchar(200) NOT NULL,
+  `requires` varchar(200) NOT NULL,
+  `name` varchar(100) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE (`keyname`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;