VbxQzmLc

1ALTER TABLE `server_settings` ADD `enable_cmdlogs` enum('0','1') NOT NULL DEFAULT '1';
2ALTER TABLE `server_settings` ADD `allow_friendfurnidrops` enum('0','1') NOT NULL DEFAULT '1';
3
4ALTER TABLE `permissions_ranks` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
5ALTER TABLE `permissions_ranks` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
6ALTER TABLE `permissions_ranks` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
7ALTER TABLE `permissions_ranks` ADD `floodtime` int(3) NOT NULL DEFAULT '30';
8ALTER TABLE `permissions_ranks` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
9ALTER TABLE `permissions_ranks` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
10ALTER TABLE `permissions_ranks` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
11
12ALTER TABLE `permissions_users` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
13ALTER TABLE `permissions_users` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
14ALTER TABLE `permissions_users` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
15ALTER TABLE `permissions_users` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
16ALTER TABLE `permissions_users` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
17ALTER TABLE `permissions_users` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
18
19ALTER TABLE `permissions_vip` ADD `cmdFollow` enum('1','0') NOT NULL DEFAULT '1';
20
21DROP TABLE IF EXISTS `cmdlogs`;
22CREATE TABLE `cmdlogs` (
23`id` int(10) NOT NULL AUTO_INCREMENT,
24`user_id` int(10) NOT NULL,
25`user_name` varchar(100) NOT NULL,
26`command` varchar(50) NOT NULL,
27`extra_data` text NOT NULL,
28`timestamp` int(120) NOT NULL,
29PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32DROP TABLE IF EXISTS `texts`;
33CREATE TABLE `texts` (
34`identifier` varchar(50) NOT NULL,
35`display_text` text NOT NULL,
36PRIMARY KEY (`identifier`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39-- ----------------------------
40-- Records of texts
41-- ----------------------------
42INSERT INTO `texts` VALUES ('emu_cleandb', 'Cleaning up database..');
43INSERT INTO `texts` VALUES ('emu_connectdb', 'Connecting to database..');
44INSERT INTO `texts` VALUES ('emu_loadroles', 'Loading Roles..');
45INSERT INTO `texts` VALUES ('emu_loadsettings', 'Loading Settings..');
46INSERT INTO `texts` VALUES ('emu_loadtexts', 'Loading Texts..');
47
48ALTER TABLE `catalog_pages` ADD `page_link_description` TEXT NOT NULL;
49ALTER TABLE `catalog_pages` ADD `page_link_pagename` TEXT NOT NULL;
50
51ALTER TABLE `catalog_items`
52ADD COLUMN `vip` enum('0','1','2') NOT NULL DEFAULT '0';