## Hallo CMS ## [New Crypto] 25.08.13 23:48
- Código:
DROP TABLE IF EXISTS `hk_fuses`;
CREATE TABLE `hk_fuses` (
`fuse` varchar(50) NOT NULL,
`minrank` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `hk_fuses` VALUES ('login', '9');
INSERT INTO `hk_fuses` VALUES ('site_manage', '11');
INSERT INTO `hk_fuses` VALUES ('pornban', '11');
INSERT INTO `hk_fuses` VALUES ('adv_edit', '11');
DROP TABLE IF EXISTS `profile_wall`;
CREATE TABLE `profile_wall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`page_id` int(11) NOT NULL,
`poster_id` int(11) NOT NULL,
`message` text NOT NULL,
`likes` int(11) NOT NULL DEFAULT '0',
`owner_read` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `site_hotcampaigns`;
CREATE TABLE `site_hotcampaigns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`image_url` text NOT NULL,
`caption` text NOT NULL,
`descr` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `site_news`;
CREATE TABLE `site_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
`title` text NOT NULL,
`category_id` int(10) unsigned NOT NULL DEFAULT '1',
`topstory_image` text NOT NULL,
`body` text NOT NULL,
`snippet` text NOT NULL,
`datestr` varchar(50) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `datestr` (`datestr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `site_rotw_entries`;
CREATE TABLE `site_rotw_entries` (
`room_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '1',
`room_name` text NOT NULL,
`room_owner` text NOT NULL,
PRIMARY KEY (`room_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `badge_shop`;
CREATE TABLE `badge_shop` (
`badge_id` varchar(12) NOT NULL,
`cost` int(100) NOT NULL,
KEY `badge_id` (`badge_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL;
ALTER TABLE `users` ADD `acc_pornbanned` ENUM('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `users` ADD COLUMN `vault_won` int(11) NOT NULL DEFAULT 0;
Clique Aqui