source: install/scripts/upgrades/0.9.3.sql @ 500

-- add support for .it
INSERT IGNORE INTO tld VALUES ('it', 1);
INSERT IGNORE INTO tld VALUES ('ws', 1);

-- remove the old "estelle" default mx in older tables
ALTER TABLE `domaines` MODIFY `mx` varchar(64) DEFAULT NULL;
ALTER TABLE `domaines_standby` MODIFY `mx` varchar(64) DEFAULT NULL;

-- add the new variable table
CREATE TABLE variable (
  name varchar(48) NOT NULL default '',
  value longtext NOT NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

USE mysql;

-- In AlternC 0.9.3, the GRANTS were created with the wrong Db
-- pattern: the underscores were not escaped.

-- this allowed the user to create extra tables not under alternc's
-- quota controls since the underscore is a wildcard in MySQL.

-- the database creation and deletion code has been update, so the
-- grants themselves need to be modified otherwise the AlternC
-- deletion code will fail and produce evil errors
UPDATE `db` set `Db` = REPLACE(`Db`,'_','\_') WHERE `Db` REGEXP '[^\\]_';

-- make sure this has an effect at all.
FLUSH PRIVILEGES;