Файл: johncms.sql
Строк: 17
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1
-- Время создания: Фев 28 2015 г.,
19:38
-- Версия сервера: 5.5.25
-- Версия PHP:
5.4.38
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 */;
--
-- База данных: `johncms`
--
--
--------------------------------------------------------
--
--
Структура таблицы `mini_forum`
--
CREATE TABLE IF NOT
EXISTS `mini_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type`
enum('cat','theme','msg') NOT NULL DEFAULT 'theme',
`title` varchar(250)
NOT NULL,
`text` text NOT NULL,
`cid` int(11) NOT NULL,
`tid` int(11)
NOT NULL,
`quote` int(1) NOT NULL DEFAULT '0',
`create_time` int(11)
NOT NULL,
`last_time` int(11) NOT NULL,
`last_user_id` int(11) NOT
NULL,
`attach` varchar(250) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;