quarta-feira, 4 de julho de 2012
babbo
CREATE TABLE IF NOT EXISTS `user_quests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`quest` int(11) NOT NULL,
`process` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
CREATE TABLE IF NOT EXISTS `quests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`data` varchar(255) NOT NULL,
`hearts` int(11) NOT NULL DEFAULT '5',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=173 ;
INSERT INTO `quests` (`id`, `item`, `time`, `data`, `hearts`) VALUES
(115, 'bath', '1296716400000', 'DAY01', 5),
(116, 'bling_bed', '1296802800000', 'DAY02', 5),
(172, 'val_table1', '1296630000000', 'EXTRA02', 5),
(171, 'bling_chair_c', '1296543600000', 'EXTRA01', 5),
(117, 'bling_toilet', '1296889200000', 'DAY03', 5);
CREATE TABLE IF NOT EXISTS `wordfilter` (
`word` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `wordfilter` (`word`) VALUES
('mamaverga');
ALTER TABLE `users` ADD `hearts` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `users` ADD `quests_passed` INT( 11 ) NOT NULL;
ALTER TABLE `users` ADD `name_allreadychanged` ENUM('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `catalog_items` ADD `quest_active` INT(255) NOT NULL DEFAULT '0';
ALTER TABLE `catalog_items` ADD `quest_cost` INT(255) NOT NULL DEFAULT '0';
ALTER TABLE `catalog_items` ADD `quest_type` varchar(500) NOT NULL DEFAULT 'val';
CREATE TABLE `wired_keywords` (
`item_id` int(5) DEFAULT NULL,
`keyword` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `wired_show_message` (
`item_id` int(5) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Assinar:
Postagens (Atom)