CREATE TABLE `mxchange_admin_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
`action` VARCHAR(255) NOT NULL DEFAULT '',\r
- `what` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(255) NULL DEFAULT NULL,\r
`title` VARCHAR(50) NOT NULL DEFAULT '',\r
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`descr` blob NOT NULL,\r
DROP TABLE IF EXISTS `mxchange_guest_menu`;\r
CREATE TABLE `mxchange_guest_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
- `action` VARCHAR(20) NOT NULL DEFAULT '',\r
- `what` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `action` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(255) NULL DEFAULT NULL,\r
`title` VARCHAR(50) NOT NULL DEFAULT '',\r
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
DROP TABLE IF EXISTS `mxchange_member_menu`;\r
CREATE TABLE `mxchange_member_menu` (\r
`id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
- `action` VARCHAR(20) NOT NULL DEFAULT '',\r
- `what` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `action` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(255) NULL DEFAULT NULL,\r
`title` VARCHAR(50) NOT NULL DEFAULT '',\r
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
`locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
- `descr` blob NOT NULL,\r
`counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
ALTER TABLE `mxchange_user_data` ADD `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r
ALTER TABLE `mxchange_config` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
\r
-UPDATE `mxchange_member_menu` SET `locked` = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;\r
-\r
-UPDATE `mxchange_guest_menu` SET `counter`=0;\r
-UPDATE `mxchange_member_menu` SET `counter`=0;\r
-\r
INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);\r
ALTER TABLE `mxchange_pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
ALTER TABLE `mxchange_config` ADD `unconfirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '100';\r
`assigned_admin` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,\r
`status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW',\r
- `task_type` ENUM('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL DEFAULT 'FIRST_USER',\r
+ `task_type` ENUM('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS','EXTENSION','EXTENSION_UPDATE') NOT NULL DEFAULT 'FIRST_USER',\r
`subject` VARCHAR(255) NOT NULL DEFAULT '',\r
`text` LONGBLOB NOT NULL,\r
`task_created` VARCHAR(10) NOT NULL DEFAULT 0,\r
\r
ALTER TABLE `mxchange_task_system` CHANGE `task_type` `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER';\r
ALTER TABLE `mxchange_user_data` MODIFY `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
-ALTER TABLE `mxchange_admin_menu` MODIFY `action` VARCHAR(255) NOT NULL DEFAULT '';\r
-ALTER TABLE `mxchange_admin_menu` MODIFY `what` VARCHAR(255) NOT NULL DEFAULT '';\r
ALTER TABLE `mxchange_user_data` MODIFY `last_module` VARCHAR(255) NOT NULL DEFAULT '';\r
-ALTER TABLE `mxchange_config` ADD `allow_direct_pay` ENUM('N', 'Y') NOT NULL DEFAULT 'N';\r
+ALTER TABLE `mxchange_config` ADD `allow_direct_pay` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
ALTER TABLE `mxchange_user_data` MODIFY `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT 0;\r
ALTER TABLE `mxchange_user_data` MODIFY `last_update` VARCHAR(10) NOT NULL DEFAULT 0;\r
ALTER TABLE `mxchange_user_data` MODIFY `joined` VARCHAR(10) NOT NULL DEFAULT 0;\r