[NEED] Zap Hotel DB

iHarrison

Member
Mar 11, 2012
321
131
Code:
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 `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` TEXT NOT NULL[/COLOR]

I dunno if that's what you're looking for but run that if you haven't already. If you're having problems with Illumina CMS then that would be the first thing to try.
 

Users who are viewing this thread

Top