summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn4367.sql
blob: d0b52f9f475eecea6d8872e7ca769cb98ad41c41 (plain) (blame)
1
2
3
4
5
6
7
8
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` );