case "0.1": // SQL queries for v0.1
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_must_register";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_must_register (
-id bigint(20) NOT NULL auto_increment,
-field_name varchar(255) not null default '',
-field_required enum('Y', 'N') not null default 'Y',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+field_name VARCHAR(255) NOT NULL DEFAULT '',
+field_required ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
PRIMARY KEY(id)
) TYPE=MyISAM";
break;
case "0.4.2": // SQL queries for v0.4.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD register_default ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD register_default ENUM('Y','N') NOT NULL DEFAULT 'N'";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET what='config_register2' WHERE what='config_reg' LIMIT 1";
// Update notes (these will be set as task text!)