Reply to thread

Message

<blockquote data-quote="Evilsmoothie" data-source="post: 208444" data-attributes="member: 28136">Did you run this?[CODE]DROP TABLE IF EXISTS `profile_wall`;CREATE TABLE `profile_wall` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `page_id` int(11) NOT NULL,&nbsp; `poster_id` int(11) NOT NULL,&nbsp; `message` text NOT NULL,&nbsp; `likes` int(11) NOT NULL DEFAULT '0',&nbsp; `owner_read` enum('0','1') NOT NULL DEFAULT '0',&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;&nbsp;&nbsp;DROP TABLE IF EXISTS `site_hotcampaigns`;CREATE TABLE `site_hotcampaigns` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `order_id` int(11) NOT NULL DEFAULT '1',&nbsp; `enabled` enum('0','1') NOT NULL DEFAULT '1',&nbsp; `image_url` text NOT NULL,&nbsp; `caption` text NOT NULL,&nbsp; `descr` text NOT NULL,&nbsp; `url` text NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;&nbsp;&nbsp;DROP TABLE IF EXISTS `site_news`;CREATE TABLE `site_news` (&nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT,&nbsp; `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',&nbsp; `title` text NOT NULL,&nbsp; `category_id` int(10) unsigned NOT NULL DEFAULT '1',&nbsp; `topstory_image` text NOT NULL,&nbsp; `body` text NOT NULL,&nbsp; `snippet` text NOT NULL,&nbsp; `datestr` varchar(50) NOT NULL,&nbsp; `timestamp` int(11) NOT NULL,&nbsp; PRIMARY KEY (`id`),&nbsp; KEY `datestr` (`datestr`) USING BTREE) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;&nbsp;&nbsp;DROP TABLE IF EXISTS `badge_shop`;CREATE TABLE `badge_shop` (&nbsp; `badge_id` varchar(12) NOT NULL,&nbsp; `cost` int(100) NOT NULL,&nbsp; KEY `badge_id` (`badge_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;&nbsp;DROP TABLE IF EXISTS `hk_fuses`;CREATE TABLE `hk_fuses` (&nbsp; `fuse` varchar(50) NOT NULL,&nbsp; `minrank` int(11) NOT NULL DEFAULT '1') ENGINE=MyISAM DEFAULT CHARSET=utf8;&nbsp;&nbsp;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');[/CODE]</blockquote>

[QUOTE="Evilsmoothie, post: 208444, member: 28136"] Did you run this? [CODE]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; 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');[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members