2ARKZp5U

1ALTER TABLE `server_settings` ADD `allow_friendfurnidrops` enum('0','1') NOT NULL DEFAULT '1';
2
3ALTER TABLE `permissions_ranks` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
4ALTER TABLE `permissions_ranks` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
5ALTER TABLE `permissions_ranks` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
6ALTER TABLE `permissions_ranks` ADD `floodtime` int(3) NOT NULL DEFAULT '30';
7ALTER TABLE `permissions_ranks` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
8ALTER TABLE `permissions_ranks` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
9ALTER TABLE `permissions_ranks` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
10
11ALTER TABLE `permissions_users` ADD `cmd_sa` enum('1','0') NOT NULL DEFAULT '0';
12ALTER TABLE `permissions_users` ADD `receive_sa` enum('1','0') NOT NULL DEFAULT '0';
13ALTER TABLE `permissions_users` ADD `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0';
14ALTER TABLE `permissions_users` ADD `cmd_spull` enum('1','0') NOT NULL DEFAULT '0';
15ALTER TABLE `permissions_users` ADD `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0';
16ALTER TABLE `permissions_users` ADD `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0';
17
18ALTER TABLE `permissions_vip` ADD `cmdFollow` enum('1','0') NOT NULL DEFAULT '1';
19
20DROP TABLE IF EXISTS `cmdlogs`;
21CREATE TABLE `cmdlogs` (
22  `id` int(10) NOT NULL AUTO_INCREMENT,
23  `user_id` int(10) NOT NULL,
24  `user_name` varchar(100) NOT NULL,
25  `command` varchar(50) NOT NULL,
26  `extra_data` text NOT NULL,
27  `timestamp` int(120) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31DROP TABLE IF EXISTS `texts`;
32CREATE TABLE `texts` (
33  `identifier` varchar(50) NOT NULL,
34  `display_text` text NOT NULL,
35  PRIMARY KEY (`identifier`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- ----------------------------
39-- Records of texts
40-- ----------------------------
41INSERT INTO `texts` VALUES ('emu_cleandb', 'Cleaning up database..');
42INSERT INTO `texts` VALUES ('emu_connectdb', 'Connecting to database..');
43INSERT INTO `texts` VALUES ('emu_loadroles', 'Loading Roles..');
44INSERT INTO `texts` VALUES ('emu_loadsettings', 'Loading Settings..');
45INSERT INTO `texts` VALUES ('emu_loadtexts', 'Loading Texts..');
46
47ALTER TABLE `catalog_pages` ADD `page_link_description` TEXT NOT NULL;
48ALTER TABLE `catalog_pages` ADD `page_link_pagename` TEXT NOT NULL;
49
50ALTER TABLE `catalog_items`
51ADD COLUMN `vip`  enum('0','1','2') NOT NULL DEFAULT '0';
52
53ALTER TABLE `furniture`
54MODIFY COLUMN `interaction_type`  enum('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch') DEFAULT 'default';