Файл: install/mysql.sql
Строк: 178
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,
`gues` varchar(1)
DEFAULT '5',
`komav` varchar(1) DEFAULT '5',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
INSERT INTO `antispam` (`id`,
`news`, `stena`, `chat`, `forum_tema`, `forum_post`, `guest`, `blog`,
`mes`, `down`, `gues`, `komav`) VALUES
(1, '5', '5', '5', '5', '5', '5',
'5', '5', '5', '5', '5');
-----------------------------------
CREATE TABLE
IF NOT EXISTS `ava_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ava`
int(11) NOT NULL,
`kto` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM 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
`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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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,
`icon` varchar(255) 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,
`icon`
varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM 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,
`us_red` int(11) NOT NULL,
`time_red` int(11)
NOT NULL,
`chislo_red` int(11) NOT NULL,
`file` varchar(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM 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,
`icon`
varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM 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,
`zakr` int(1) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM 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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `friend`
(
`N` int(11) NOT NULL AUTO_INCREMENT,
`id` int(11) NOT NULL,
`friend` int(11) NOT NULL,
`i` int(1) NOT NULL,
`time` varchar(240)
CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`N`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `gues` (
`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=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
CREATE
TABLE IF NOT EXISTS `guest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` text NOT NULL,
`avtor` varchar(244) NOT NULL,
`time` varchar(244)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM 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=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
CREATE
TABLE IF NOT EXISTS `komav` (
`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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `like` (
`id_user` int(11) NOT NULL,
`id_post` int(11) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;
-----------------------------------
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=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,
`screen` varchar(50) 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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `logi`
(
`id` int(11) NOT NULL,
`login` varchar(250) CHARACTER SET utf8 NOT
NULL,
`time` varchar(100) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=latin1;
-----------------------------------
CREATE TABLE
IF NOT EXISTS `logi_strong` (
`id` int(11) NOT NULL,
`strong`
varchar(250) CHARACTER SET utf8 NOT NULL,
`time` varchar(100) CHARACTER
SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=latin1;
-----------------------------------
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=MyISAM 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,
`posl_mes` varchar(244) NOT NULL,
`ignor` varchar(1) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM 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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `nar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`komy` int(11) NOT NULL,
`kto`
varchar(50) CHARACTER SET utf8 NOT NULL,
`prichina` varchar(250)
CHARACTER SET utf8 NOT NULL,
`link` varchar(150) CHARACTER SET utf8 NOT
NULL,
`time` varchar(100) CHARACTER SET utf8 NOT NULL,
`kom`
varchar(250) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1 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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
INSERT INTO `news` (`id`, `text`,
`avtor`, `time`) VALUES
(1, 'Доброго времени суток!
Если Вы увидели эту новость,значит вы
установили Strong Social v 1.0 Скачать эту CMS,а
так же модули и обновления можно на
официальном сайте - http://Strong-Social.ru , и
хотим вам сказать этот мод и есть strongcms
,но разделеный на 2ветки ! Удачной
Разработке !', '1',
'1396173764');
-----------------------------------
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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`podarki` (
`idpod` int(11) NOT NULL AUTO_INCREMENT,
`id` int(11) NOT
NULL,
`podarok` varchar(32) CHARACTER SET utf8 NOT NULL,
`us`
varchar(244) CHARACTER SET utf8 NOT NULL,
`papka` varchar(30) CHARACTER
SET utf8 NOT NULL,
PRIMARY KEY (`idpod`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`podarki_p` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30)
CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`podarok` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30)
CHARACTER SET utf8 NOT NULL,
`icon` varchar(30) CHARACTER SET utf8 NOT
NULL,
`papka` varchar(30) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`reklamaind` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sait` varchar(32)
NOT NULL,
`name` varchar(32) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `rules`
(
`site` text NOT NULL,
`forum` text NOT NULL,
`chat` text NOT NULL
)
ENGINE=MyISAM 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,
`name`
varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
-----------------------------------
INSERT
INTO `settings` (`id`, `key`, `des`, `cop`) VALUES
(1, 'сайт
скрипт стронг социал strong social помощь
поддержка форум загрузки', 'Сайт
поддержки strong social; Создатель Cheburek &
OneMobi; У нас можно скачать скрипт для strong
social и просто получить помощь в
сайтостроении',
'strong-social.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=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`smile_p` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `status` (
`user` int(11) NOT NULL,
`text` varchar(100)
CHARACTER SET utf8 NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY
(`user`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `status_like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status`
int(11) NOT NULL,
`kto` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=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=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `stol`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`name` varchar(20) CHARACTER SET utf8 NOT NULL,
`opis` varchar(200)
CHARACTER SET utf8 NOT NULL,
`status` int(1) NOT NULL,
`type`
varchar(50) CHARACTER SET utf8 NOT NULL,
`prinal` int(11) NOT NULL,
`money` int(11) NOT NULL,
`time` varchar(100) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `users`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`status` varchar(80) NOT NULL,
`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,
`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,
`reiting` double NOT
NULL,
`prosm` int(100) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`perehodu` int(11) NOT NULL,
`status_saita` varchar(80) NOT NULL,
`set_them` varchar(32) DEFAULT 'default',
`wmid` varchar(50) NOT NULL,
`guestact` varchar(1) DEFAULT '1',
`avaact` varchar(1) DEFAULT '1',
`monet` int(11) NOT NULL,
`msg` int(1) NOT NULL,
`style_panel`
varchar(50) NOT NULL DEFAULT 'tnav',
`style_foot` varchar(50) NOT NULL
DEFAULT 'copy',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF
NOT EXISTS `user_gb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guest_id`
int(11) NOT NULL,
`msg` varchar(512) DEFAULT NULL,
`time` int(11) NOT
NULL DEFAULT '0',
`who` int(11) NOT NULL,
`id_otv` int(11) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;