summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn4367.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn4367.sql')
-rw-r--r--sql-files/upgrade_svn4367.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn4367.sql b/sql-files/upgrade_svn4367.sql
new file mode 100644
index 000000000..1dd63d63f
--- /dev/null
+++ b/sql-files/upgrade_svn4367.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `mapreg`;
+CREATE TABLE `mapreg` (
+ `varname` char(32) NOT NULL,
+ `index` int(11) unsigned NOT NULL default '0',
+ `value` char(255) NOT NULL
+) TYPE=MyISAM;
+
+ALTER TABLE `mapreg` ADD INDEX ( `varname` );
+ALTER TABLE `mapreg` ADD INDEX ( `index` );