Файл: Krimos/krime.sql
Строк: 85
CREATE TABLE `banned` (
`id` bigint(100) NOT NULL auto_increment,
`useragent` varchar(50) NOT NULL,
`userip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE `forums` (
`id` bigint(100) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`description` varchar(100) NOT NULL,
`position` int(3) NOT NULL default '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO
`forums` VALUES (1, 'Info', 'Info about Krimos.', 1);
CREATE TABLE
`invites` (
`id` bigint(100) NOT NULL auto_increment,
`user`
bigint(100) NOT NULL,
`code` varchar(15) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE
TABLE `online` (
`id` bigint(100) NOT NULL auto_increment,
`user`
bigint(100) NOT NULL,
`where` varchar(100) NOT NULL,
`time` int(10)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
CREATE TABLE `posts` (
`id` bigint(100) NOT NULL
auto_increment,
`thread` bigint(100) NOT NULL,
`post` varchar(5000)
NOT NULL,
`poster` bigint(100) NOT NULL,
`date` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
CREATE TABLE `private` (
`id` bigint(100) NOT NULL
auto_increment,
`from` bigint(100) NOT NULL,
`to` bigint(100) NOT
NULL,
`date` int(10) NOT NULL,
`message` varchar(5000) NOT NULL
default '',
`read` tinyint(1) NOT NULL default '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE
TABLE `recover` (
`id` bigint(100) NOT NULL auto_increment,
`user`
bigint(100) NOT NULL,
`code` varchar(15) NOT NULL,
`date` int(10) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
CREATE TABLE `shoutbox` (
`id` bigint(100) NOT
NULL auto_increment,
`user` bigint(100) NOT NULL,
`message`
varchar(5000) NOT NULL,
`date` int(10) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT
INTO `shoutbox` VALUES (1, 1, 'Krimos 0.2!', 1299955933);
CREATE TABLE
`threads` (
`id` bigint(100) NOT NULL auto_increment,
`forum`
bigint(100) NOT NULL,
`title` varchar(30) NOT NULL,
`post`
varchar(5000) NOT NULL,
`poster` bigint(100) NOT NULL,
`date` int(10)
NOT NULL,
`lastpost` int(10) NOT NULL,
`pinned` tinyint(1) NOT
NULL,
`locked` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE
`users` (
`id` bigint(100) NOT NULL auto_increment,
`username`
varchar(25) NOT NULL,
`password` varchar(60) NOT NULL,
`email`
varchar(30) NOT NULL,
`date` int(10) NOT NULL,
`useragent`
varchar(150) NOT NULL,
`userip` varchar(15) NOT NULL,
`status`
tinyint(1) NOT NULL default '1',
`banned` tinyint(1) NOT NULL default
'0',
`approved` tinyint(1) NOT NULL default '0',
`bantime` int(10)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
INSERT INTO `users` VALUES (1, 'admin',
'c3284d0f94606de1fd2af172aba15bf3', 'admin@mysite.com', 1299955933,
'Opera/9.80 (Windows NT 6.1; U; en) Presto/2.7.62 Version/11.01',
'192.168.0.5', 3, 0, 1, 0);