Просмотр архива StrongCMS Ver 1.1 beta

SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-----------------------------------
SET
time_zone =
"+00:00";
-----------------------------------
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`antispam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news`
varchar(244) NOT NULL,
  `stena` varchar(244) NOT NULL,
  `chat`
varchar(244) NOT NULL,
  `forum_tema` varchar(255) NOT NULL,
 
`forum_post` varchar(255) NOT NULL,
  `guest` varchar(255) NOT NULL,
 
`blog` varchar(244) NOT NULL,
  `mes` varchar(244) NOT NULL,
  `down`
varchar(244) NOT NULL,
  `repa` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
INSERT INTO `antispam` (`id`,
`news`, `stena`, `chat`, `forum_tema`, `forum_post`, `guest`, `blog`,
`mes`, `down`, `repa`) VALUES
(1, '60', '60', '60', '60', '60', '60',
'60', '60', '60', '4');
-----------------------------------
CREATE TABLE
IF NOT EXISTS `lenta` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`text`
text NOT NULL, 
`kto` varchar(100) NOT NULL, 
`komy` varchar(100) NOT
NULL, 
`time` varchar(100) NOT NULL, 
`readlen` varchar(1) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `blog_com` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`msg`
text NOT NULL, 
`avtor` varchar(100) NOT NULL, 
`time` varchar(100) NOT
NULL, 
`blog` varchar(244) NOT NULL, 
`avtorlogin` varchar(100) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `blog_r` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`name`
varchar(30) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`blog_reit` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`stat` varchar(244)
NOT NULL, 
`r` varchar(244) NOT NULL, 
`kto` varchar(100) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `load_reit` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`file`
varchar(244) NOT NULL, 
`r` varchar(244) NOT NULL, 
`kto` varchar(100)
NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `blog_search` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`meta`
varchar(100) NOT NULL, 
`kto` varchar(100) NOT NULL, 
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`blog_stat` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`titlename`
varchar(100) NOT NULL, 
`text` text NOT NULL, 
`meta` varchar(100) NOT
NULL, 
`razdel` varchar(100) NOT NULL, 
`avtor` varchar(100) NOT NULL,

`time` varchar(100) NOT NULL, 
`readlen` varchar(244) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `chat_post` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`room`
int(10) NOT NULL, 
`msg` text NOT NULL, 
`avtor` varchar(244) NOT NULL,

`avtorlogin` varchar(244) NOT NULL, 
`time` varchar(244) NOT NULL,

`color` varchar(25) NOT NULL, 
`emotion` varchar(40) NOT NULL, 
PRIMARY
KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`chat_room` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`name` varchar(244)
NOT NULL, 
`about` text NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_kat` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`razdel`
varchar(244) NOT NULL, 
`name` varchar(244) NOT NULL, 
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_post` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`razdel` int(11)
NOT NULL, 
`kat` int(11) NOT NULL, 
`tema` int(11) NOT NULL, 
`text`
mediumtext NOT NULL, 
`us` varchar(255) NOT NULL, 
`time` varchar(255)
NOT NULL, 
`citata` mediumtext NOT NULL, 
`citata_us` varchar(255) NOT
NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `forum_razdel` ( 
`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(244) NOT NULL, 
`opis` varchar(255) NOT NULL, 
PRIMARY
KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_tema` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`razdel` int(11)
NOT NULL, 
`kat` int(11) NOT NULL, 
`text` varchar(244) NOT NULL,

`name` varchar(244) NOT NULL, 
`us` varchar(255) NOT NULL, 
`time`
varchar(255) NOT NULL, 
`status` int(11) NOT NULL, 
`up` varchar(255) NOT
NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `news` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`text` text
NOT NULL, 
`avtor` varchar(244) NOT NULL, 
`time` varchar(244) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
INSERT INTO `news`
(`id`, `text`, `avtor`, `time`) VALUES
(1, 'Доброго времени
суток! 
Если Вы увидели эту
новость,значит установка StrongCMS ver 1.1
прошла успешно.
Скачать эту Wap CMS, а так же
модули и обновления можно на официальном
сайте - [url=http://strongcms.ru]http://StrongCMS.ru[/url]
Удачи
в начинаниях! .пох.', '1',
'1386831074');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `news_com` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`time`
varchar(244) NOT NULL, 
`msg` text NOT NULL, 
`avtor` int(244) NOT NULL,

`avtorlogin` varchar(244) NOT NULL, 
`news` varchar(244) NOT NULL,

PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `rules` ( 
`site` text NOT NULL, 
`forum` text NOT NULL,

`chat` text NOT NULL 
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
-----------------------------------
INSERT INTO `rules`
(`site`, `forum`, `chat`) VALUES
('Правил пока нет!',
'Правил пока нет!', 'Правил пока
нет!');
-----------------------------------
CREATE TABLE IF NOT EXISTS
`settings` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`key` text NOT NULL,

`des` text NOT NULL, 
`cop` varchar(50) NOT NULL, 
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
INSERT INTO `settings` (`id`,
`key`, `des`, `cop`) VALUES
(1, 'StrongCMS.RU', 'StrongCMS.RU',
'StrongCMS.RU');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `smile` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`name`
varchar(244) NOT NULL, 
`icon` varchar(244) NOT NULL, 
`papka`
varchar(30) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
INSERT INTO `smile` (`id`, `name`,
`icon`, `papka`) VALUES
(1, '.пох.', 'pox.png',
'1');
-----------------------------------
CREATE TABLE IF NOT EXISTS
`smile_p` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`name` varchar(30)
NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
INSERT INTO
`smile_p` (`id`, `name`) VALUES 
(1,
'Разные');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `stena` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`msg` text NOT
NULL, 
`avtor` varchar(244) NOT NULL, 
`ukogo` varchar(244) NOT NULL,

`time` varchar(244) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `users`
( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`login` varchar(20) NOT NULL,

`pass` varchar(255) NOT NULL, 
`sex` varchar(1) NOT NULL, 
`name`
varchar(30) NOT NULL, 
`email` varchar(40) NOT NULL, 
`strana`
varchar(255) NOT NULL, 
`gorod` varchar(255) NOT NULL,  
`osebe`
varchar(555) NOT NULL, 
`stat` varchar(555) NOT NULL, 
`skype`
varchar(555) NOT NULL, 
`icq` varchar(555) NOT NULL, 
`money`
decimal(6,2) NOT NULL, 
`style` varchar(255)  NULL DEFAULT
'default',
`news` int(11) NOT NULL,
`datareg` varchar(255) NOT NULL,

`level` varchar(1) NOT NULL, 
`browser` varchar(250) NOT NULL, 
`ip`
varchar(250) NOT NULL, 
`viz` varchar(250) NOT NULL, 
`online`
varchar(250) NOT NULL, 
`gde` varchar(255) NOT NULL, 
`max` int(30) NOT
NULL DEFAULT '10', 
`avatar` varchar(255) NOT NULL, 
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `config`
( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`style` varchar(244) NOT NULL
default 'style', 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
INSERT INTO `config` (`id`,
`style`) VALUES
(1,
'default');
-----------------------------------
CREATE TABLE IF NOT
EXISTS `forum_zaklad` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`tema`
varchar(244) NOT NULL, 
`us` varchar(244) NOT NULL, 
PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`ban_list` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`kto` varchar(255)
DEFAULT NULL, 
`about` varchar(255) DEFAULT NULL, 
`time_play`
varchar(255) DEFAULT NULL, 
`time_end` varchar(255) DEFAULT NULL,

`add_ban` varchar(255) DEFAULT NULL, 
PRIMARY KEY (`id`) 
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`jalob_ba` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`about` text NOT
NULL, 
`avtor` varchar(244) NOT NULL, 
`komy` varchar(244) NOT NULL,

`time` varchar(244) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `guest`
( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`msg` text NOT NULL,

`avtorlogin` varchar(244) NOT NULL, 
`avtor` varchar(244) NOT NULL,

`time` varchar(244) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`load_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` varchar(244)
NOT NULL,
`msg` text NOT NULL,
`avtor` int(244) NOT NULL,
`avtorlogin`
varchar(244) NOT NULL,
`file` varchar(244) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`load_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_dir` int(11) NOT
NULL,
`name` varchar(100) DEFAULT NULL,
`url` text,
`time` int(11) NOT
NULL,
`avtor` varchar(25) NOT NULL,
`format` varchar(244) NOT
NULL,
`about` text NOT NULL,
`files` varchar(244) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`load_dir` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_dir` int(11) NOT
NULL DEFAULT '0',
`url` text,
`name` varchar(100) DEFAULT NULL,
`icon`
varchar(244) NOT NULL,
`files` varchar(1) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` varchar(244) NOT
NULL,
`komy` varchar(244) NOT NULL,
`text` text NOT NULL,
`time`
varchar(244) NOT NULL,
`readlen` varchar(1) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`message_c` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` varchar(244)
NOT NULL,
`kogo` varchar(244) NOT NULL,
`time` varchar(244) NOT
NULL,
`ignor` varchar(1) NOT NULL,
`posl_time` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`message_save` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT
NULL,
`kto` varchar(244) NOT NULL,
`ktoavtor` varchar(244) NOT
NULL,
`uid` varchar(244) NOT NULL,
`time` varchar(244) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`repa_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT
NULL,
  `kto` varchar(244) NOT NULL,
  `komy` varchar(244) NOT NULL,
 
`time` varchar(244) NOT NULL,
  `repa` varchar(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;