Файл: install/mysql.sql
Строк: 364
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 0.9 прошла успешно. Скачать эту 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 ;