Файл: install/mysql.sql
Строк: 482
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 `admin_chat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `msg` varchar(255) NOT NULL, `time` int(11) NOT NULL, `avtor` int(11) NOT NULL, `id_komu` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ----------------------------------- CREATE TABLE IF NOT EXISTS `ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `time_srok` varchar(255) DEFAULT NULL, `kogda` varchar(255) DEFAULT NULL, `color` varchar(244) CHARACTER SET utf8 NOT NULL, `b` int(11) NOT NULL DEFAULT '0', `i` int(11) NOT NULL DEFAULT '0', `tip` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; ----------------------------------- 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, `friends` varchar(244) 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`, `friends`) VALUES (1, '60', '60', '60', '60', '60', '60', '60', '60', '60', '4', '60'); ----------------------------------- 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 `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 `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 `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=2 ; ----------------------------------- INSERT INTO `config` (`id`, `style`) VALUES (1, 'default'); ----------------------------------- CREATE TABLE IF NOT EXISTS `forum_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `name_file` varchar(244) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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 `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 `friends` ( `id` int(11) NOT NULL AUTO_INCREMENT, `us_a` int(11) NOT NULL, `us_b` int(11) NOT NULL, `status` int(11) NOT NULL, `time` varchar(244) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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 `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 `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 `lib_razdel` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `opis` varchar(244) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ----------------------------------- CREATE TABLE IF NOT EXISTS `lib_stat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `razdel` int(11) NOT NULL, `name` varchar(100) DEFAULT NULL, `opis` varchar(244) NOT NULL, `meta` varchar(100) NOT NULL, `files` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ----------------------------------- CREATE TABLE IF NOT EXISTS `load_ban` ( `id` int(11) NOT NULL AUTO_INCREMENT, `file_id` int(11) NOT NULL, `addban_user` int(11) NOT NULL, `cause` varchar(244) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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, `avtorlogin` varchar(244) NOT NULL, `file` varchar(244) NOT NULL, `ip` 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 `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, `mod` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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 `load_screen` ( `id` int(11) NOT NULL AUTO_INCREMENT, `file_id` int(11) NOT NULL, `name_screen` varchar(244) 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, `file` varchar(244) NOT NULL DEFAULT '', 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, `del` 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 `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=5 ; ----------------------------------- INSERT INTO `news` (`id`, `text`, `avtor`, `time`) VALUES (1, 'Доброго времени суток! \r\nЕсли Вы увидели эту новость,значит установка StrongCMS ver 1.0 beta прошла успешно.\r\nСкачать эту Wap CMS, а так же модули и обновления можно на официальном сайте - [url=http://strongcms.ru]http://StrongCMS.ru[/url]\r\nУдачи в начинаниях! .пох.', '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 `photo_album` ( `id` int(11) NOT NULL AUTO_INCREMENT, `us` int(11) NOT NULL, `name` varchar(244) NOT NULL, `info` varchar(244) NOT NULL, `tip` int(11) NOT NULL, `time` varchar(244) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ----------------------------------- CREATE TABLE IF NOT EXISTS `photo_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `album_id` int(11) NOT NULL, `time` varchar(100) NOT NULL, `files` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ----------------------------------- CREATE TABLE IF NOT EXISTS `photo_reit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `foto` 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 `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 ; ----------------------------------- 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, `reg_on` int(11) NOT NULL, `load_mod` int(11) NOT NULL, `counter` varchar(10000) NOT NULL, `counter_all` varchar(10000) NOT NULL, `forum_post_m` int(11) NOT NULL, `forum_tem_m` int(11) NOT NULL, `down_file_m` int(11) NOT NULL, `guest_post_m` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; ----------------------------------- INSERT INTO `settings` (`id`, `key`, `des`, `cop`, `reg_on`, `load_mod`, `counter`, `counter_all`, `forum_post_m`, `forum_tem_m`, `down_file_m`, `guest_post_m`) VALUES (1, 'StrongCMS.RU', 'StrongCMS.RU', 'StrongCMS.RU', 0, 1, 'Счётчики на главной', 'Счётчики на остальных страницах', 3, 1, 3, 1); ----------------------------------- 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=2 ; ----------------------------------- 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=2 ; ----------------------------------- 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, `url` varchar(555) NOT NULL, `money` varchar(50) NOT NULL DEFAULT '0', `style` varchar(255) 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, `xstatus` varchar(255) NOT NULL, `color_nick` varchar(255) NOT NULL, `max` int(30) NOT NULL DEFAULT '10', `avatar` varchar(255) NOT NULL, `new_tem` int(11) NOT NULL, `new_files` int(11) NOT NULL, `rating` varchar(244) DEFAULT '0', `form_file` int(11) NOT NULL DEFAULT '1', `bb_panel` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;