summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn4367.sql
blob: 1dd63d63f73815e1f6bf12bcd5f39f424183c566 (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` );