Reply to thread

Message

<blockquote data-quote="iHarrison" data-source="post: 188174" data-attributes="member: 13942">[code]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');&nbsp;&nbsp;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;ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULLALTER TABLE `users` ADD `acc_pornbanned` TEXT NOT NULL[/COLOR]&nbsp;[/code]&nbsp;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.</blockquote>

[QUOTE="iHarrison, post: 188174, member: 13942"] [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] [/code] 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. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members