Файл: tables.sql
Строк: 88
CREATE TABLE IF NOT EXISTS `guest` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`us_id` int(11) NOT NULL,
`msg` text NOT NULL,
`date` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`us_id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`msg` text NOT NULL,
`date` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `news_comments` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) NOT NULL,
`title`
text NOT NULL,
`msg` text NOT NULL,
`date` int(11) NOT NULL,
`us_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `news` (`id`,
`us_id`, `title`, `msg`, `date`) VALUES
(1, 1, 'Установка
завершена.', 'Если Вы читаете данную
новость, это значит что Вы установили
iCoreCMS v0.1 !9', 1400532990);
CREATE TABLE IF NOT EXISTS `online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`us_id` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `smiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`command` varchar(50) NOT NULL,
`folder` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
INSERT INTO `smiles` (`id`,
`command`, `folder`) VALUES
(1, '!1', '../images/smiles/1.png'),
(2,
'!2', '../images/smiles/2.png'),
(3, '!3', '../images/smiles/3.png'),
(4,
'!4', '../images/smiles/4.png'),
(5, '!5', '../images/smiles/5.png'),
(6,
'!6', '../images/smiles/6.png'),
(7, '!7', '../images/smiles/7.png'),
(8,
'!8', '../images/smiles/8.png'),
(9, '!9',
'../images/smiles/9.png'),
(10, '!10', '../images/smiles/10.png'),
(11,
'!11', '../images/smiles/11.png'),
(12, '!12',
'../images/smiles/12.png'),
(13, '!13', '../images/smiles/13.png'),
(14,
'!14', '../images/smiles/14.png'),
(15, '!15',
'../images/smiles/15.png'),
(16, '!16', '../images/smiles/16.png'),
(17,
'!17', '../images/smiles/17.png'),
(18, '!18',
'../images/smiles/18.png'),
(19, '!19', '../images/smiles/19.png'),
(20,
'!20', '../images/smiles/20.png'),
(21, '!21',
'../images/smiles/21.png'),
(22, '!22', '../images/smiles/22.png'),
(23,
'!23', '../images/smiles/23.png'),
(24, '!24',
'../images/smiles/24.png'),
(25, '!25', '../images/smiles/25.png'),
(26,
'!26', '../images/smiles/26.png'),
(27, '!27',
'../images/smiles/27.png'),
(28, '!28', '../images/smiles/28.png'),
(29,
'!29', '../images/smiles/29.png'),
(30, '!30',
'../images/smiles/30.png'),
(31, '!31', '../images/smiles/31.png'),
(32,
'!32', '../images/smiles/32.png'),
(33, '!33',
'../images/smiles/33.png'),
(34, '!34', '../images/smiles/34.png'),
(35,
'!35', '../images/smiles/35.png'),
(36, '!36',
'../images/smiles/36.png'),
(37, '!37', '../images/smiles/37.png'),
(38,
'!38', '../images/smiles/38.png'),
(39, '!39',
'../images/smiles/39.png'),
(40, '!40',
'../images/smiles/40.png');
CREATE TABLE IF NOT EXISTS `sys` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`keywords` text NOT NULL,
`description` text NOT NULL,
`copy` varchar(255) NOT NULL,
`title`
varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `sys` (`id`, `keywords`,
`description`, `copy`, `title`) VALUES
(1, 'iCoreCMS', 'iCoreCMS',
'iCoreCMS 2014', 'iCoreCMS');
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`gender` int(1) NOT NULL,
`name`
varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`city`
varchar(255) NOT NULL,
`access` int(1) NOT NULL DEFAULT '1',
`email`
varchar(255) NOT NULL,
`icq` int(10) NOT NULL,
`status` text NOT
NULL,
`about_me` text NOT NULL,
`last_name` varchar(50) NOT NULL,
`online` int(11) NOT NULL DEFAULT '0',
`items` int(11) NOT NULL DEFAULT
'5',
`date_reg` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO
`users` (`id`, `login`, `pass`, `gender`, `name`, `country`, `city`,
`access`, `email`, `date_reg`, `icq`, `status`, `about_me`, `last_name`,
`online`, `items`) VALUES
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e',
1, '', '', '', 3, '', '1399557050', 0, '', '', '', 1400773299, 5);