IlluminaCMS Edit Queries

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;