upgrade_svn4367.sql « sql-files - evol/hercules - The Mana World fork of Hercules. This is vanilla Hercules with a few tiny modifications for our specific needs. Mutually-beneficial modifications are contributed upstream.

summary refs log tree commit diff

path: root/sql-files/upgrade_svn4367.sql

blob: d0b52f9f475eecea6d8872e7ca769cb98ad41c41 (plain) (blame)

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` );