SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `ab_historical_data` (
`ip_address` varchar(15) NOT NULL,
`referral_page` varchar(255) NOT NULL,
`converted` int(5) NOT NULL,
`time_started` int(30) NOT NULL,
`time_ended` int(15) NOT NULL,
`test_id` int(15) NOT NULL,
`step` int(15) NOT NULL,
`page_id` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ab_pages` (
`id` int(12) NOT NULL,
`page_impressions` varchar(255) NOT NULL,
`test_id` int(12) NOT NULL,
`active` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `banned` (
`id` int(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`reason` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `daily_actions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`active` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;
INSERT INTO `daily_actions` (`id`, `name`, `active`) VALUES
(1, 'test', 1);
CREATE TABLE `daily_current_tracking` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `game_settings` (
`game_active` int(1) NOT NULL,
`game_inactive_message` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `game_settings` (`game_active`, `game_inactive_message`) VALUES
(1, '');
CREATE TABLE `inactive_users` (
`login_name` varchar(100) NOT NULL,
`password` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ships` (
`owner_id` int(12) NOT NULL,
`navigation_max` int(12) NOT NULL,
`navigation` int(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `staff_ip` (
`ip` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `stats` (
`online` int(15) NOT NULL,
`onlinetoday` int(15) NOT NULL,
`totalusers` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`active` int(5) NOT NULL,
`login_name` varchar(100) NOT NULL,
`password` varchar(32) NOT NULL,
`user_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`user_level` int(5) NOT NULL,
`sessionkey` varchar(50) NOT NULL,
`last_ip` varchar(20) NOT NULL,
`last_useragent` varchar(32) NOT NULL,
`gender` int(5) NOT NULL,
`last_ip2` varchar(15) NOT NULL,
`reg_ip` varchar(15) NOT NULL,
`join_date` int(15) NOT NULL,
`referedby` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`ad_refer` varchar(100) NOT NULL,
`notifications` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `user_levels` (
`id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
но ....
