Вход Регистрация
Файл: install/table.sql
Строк: 226
-- -- Структура таблицы `ads` -- CREATE TABLE IF NOT
EXISTS `ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `name` varchar(32) NOT NULL, `link` varchar(255) NOT NULL,
`local` int(11) NOT NULL, `time` int(11) NOT NULL, `time_end` int(11)
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `ban` -- CREATE TABLE IF NOT EXISTS
`ban` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT NULL,
`komy` int(11) NOT NULL, `time` int(11) NOT NULL, `time_end` int(11)
NOT NULL, `message` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `dialogs` -- CREATE TABLE IF NOT EXISTS
`dialogs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `komy` int(11) NOT NULL, `time_last` int(11) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `dialogs_message` -- CREATE TABLE IF NOT
EXISTS `dialogs_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `komy` int(11) NOT NULL, `time` int(11) NOT NULL,
`message` text NOT NULL, `readln` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `forum_file` -- CREATE TABLE IF NOT
EXISTS `forum_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `post_id` int(11) NOT NULL, `thema` int(11) NOT
NULL, `name` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `forum_message` -- CREATE TABLE IF NOT
EXISTS `forum_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `razdel`
int(11) NOT NULL, `section` int(11) NOT NULL, `topic` int(11) NOT
NULL, `kto` int(11) NOT NULL, `message` varchar(1024) NOT NULL,
`user_quote` varchar(255) NOT NULL, `quote` text NOT NULL, `time`
int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `forum_razdel` -- CREATE TABLE IF NOT
EXISTS `forum_razdel` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name`
varchar(255) NOT NULL, `pos` int(32) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `forum_section` -- CREATE TABLE IF NOT
EXISTS `forum_section` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name`
varchar(255) NOT NULL, `razdel` int(11) NOT NULL, `pos` int(11) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `forum_topic` -- CREATE TABLE IF NOT
EXISTS `forum_topic` ( `id` int(11) NOT NULL AUTO_INCREMENT, `razdel`
int(11) NOT NULL, `section` int(11) NOT NULL, `kto` int(11) NOT NULL,
`name` varchar(255) NOT NULL, `time` int(11) NOT NULL,
`last_message_time` int(11) NOT NULL, `is_top_topic` int(11) NOT NULL
DEFAULT '0', `is_close_topic` int(11) NOT NULL DEFAULT '0', PRIMARY KEY
(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `guests` -- CREATE TABLE IF NOT EXISTS
`guests` ( `id` int(20) NOT NULL AUTO_INCREMENT, `ip` varchar(20) NOT
NULL, `browser` text NOT NULL, `time` text NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `journal` -- CREATE TABLE IF NOT EXISTS
`journal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `komy` int(11) NOT NULL, `time` int(11) NOT NULL, `message`
text NOT NULL, `url` varchar(255) NOT NULL, `readln` int(11) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `lib_category` -- CREATE TABLE IF NOT
EXISTS `lib_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name`
varchar(32) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `lib_comments` -- CREATE TABLE IF NOT
EXISTS `lib_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `time` int(11) NOT NULL, `message` varchar(1024) NOT
NULL, `lib_r` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `lib_r` -- CREATE TABLE IF NOT EXISTS
`lib_r` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `category` int(11) NOT NULL, `name` varchar(32) NOT NULL,
`message` text NOT NULL, `txt` varchar(255) NOT NULL, `look` int(11)
NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `mini_chat` -- CREATE TABLE IF NOT
EXISTS `mini_chat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `time` int(11) NOT NULL, `message` text NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `module` -- CREATE TABLE IF NOT EXISTS
`module` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255)
NOT NULL, `open` int(11) NOT NULL, `counter` varchar(255) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `news` -- CREATE TABLE IF NOT EXISTS
`news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT NULL,
`time` int(11) NOT NULL, `name` varchar(255) NOT NULL, `message` text
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `news_comments` -- CREATE TABLE IF NOT
EXISTS `news_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `time` int(11) NOT NULL, `message` varchar(1024) NOT
NULL, `news` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `settings` -- CREATE TABLE IF NOT EXISTS
`settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `language`
varchar(255) NOT NULL, `theme` varchar(255) NOT NULL, `num` int(11) NOT
NULL DEFAULT '10', `close` int(11) NOT NULL DEFAULT '0', `keywords`
text NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; --
-------------------------------------------------------- -- -- Дамп
данных таблицы `settings` -- INSERT INTO `settings` (`id`,
`language`, `theme`, `num`, `close`, `keywords`, `description`) VALUES (1,
'ru', 'default', 15, 1, 'NomiCMS', 'NomiCMS'); --
-------------------------------------------------------- -- --
Структура таблицы `users` -- CREATE TABLE IF NOT EXISTS
`users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login` varchar(32) NOT
NULL, `password` varchar(255) NOT NULL, `level` int(11) NOT NULL
DEFAULT '1', `name` text NOT NULL, `first_name` text NOT NULL, `sex`
int(11) NOT NULL, `email` varchar(255) NOT NULL, `tg` varchar(40) NOT
NULL, `money` int(11) NOT NULL DEFAULT '1000', `date_registration`
int(11) NOT NULL, `date_last_entry` int(11) NOT NULL, `ava`
varchar(255) NOT NULL DEFAULT 'no_ava.jpg', `country` varchar(255) NOT
NULL, `city` varchar(255) NOT NULL, `about` varchar(255) NOT NULL,
`browser` varchar(255) NOT NULL, `ip` varchar(20) NOT NULL,
`browser_type` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `user_settings` -- CREATE TABLE IF NOT
EXISTS `user_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `language` varchar(255) NOT NULL, `theme`
varchar(255) NOT NULL, `num` int(11) NOT NULL DEFAULT '10', PRIMARY KEY
(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `zc_category` -- CREATE TABLE IF NOT
EXISTS `zc_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name`
varchar(32) NOT NULL, `opis` text NOT NULL, `time` int(11) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `zc_comments` -- CREATE TABLE IF NOT
EXISTS `zc_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto`
int(11) NOT NULL, `time` int(11) NOT NULL, `message` varchar(1024) NOT
NULL, `zc_file` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `zc_file` -- CREATE TABLE IF NOT EXISTS
`zc_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `category` int(11) NOT NULL, `section` int(11) NOT NULL, `name`
varchar(255) NOT NULL, `opis` text NOT NULL, `file` text NOT NULL,
`screen` text NOT NULL, `time` int(11) NOT NULL, `down` int(11) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `zc_section` -- CREATE TABLE IF NOT
EXISTS `zc_section` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category`
int(11) NOT NULL, `name` varchar(255) NOT NULL, `whitelist` text NOT
NULL, `max_size` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- CREATE TABLE
`friends` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT
NULL, `komy` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; --
-------------------------------------------------------- -- --
Структура таблицы `blogs` -- CREATE TABLE IF NOT EXISTS
`blogs` ( `id` int(20) NOT NULL AUTO_INCREMENT, `text` text NOT NULL,
`kto` int(32) NOT NULL, `time` int(32) NOT NULL, `name` varchar(100)
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `blog_comms` -- CREATE TABLE IF NOT
EXISTS `blog_comms` ( `id` int(20) NOT NULL AUTO_INCREMENT, `time`
int(32) NOT NULL, `kto` int(32) NOT NULL, `blog_id` int(32) NOT NULL,
`message` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `wall` -- CREATE TABLE IF NOT EXISTS
`wall` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kto` int(11) NOT NULL,
`komy` int(11) NOT NULL, `message` text NOT NULL, `time` int(11) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
Онлайн: 1
Реклама
Игры между пользователями