CREATE TABLE users
(
id INT NOT NULL AUTO_INCREMENT,
login      text  NOT NULL,
password     text  NOT NULL,
sex     text  NOT NULL,
admin int NOT NULL,
money int NOT NULL,
name text  NOT NULL,
surname text NOT NULL,
sp     int  NOT NULL,
spu     int  NOT NULL,
drd     int  NOT NULL,
drm int NOT NULL,
drg int NOT NULL,
city int  NOT NULL,
osebe text  NOT NULL,
rating   int NOT NULL,
phone   text  NOT NULL,
datareg   int  NOT NULL,
online   int NOT NULL,
rabota   text  NOT NULL,
ucheba   text  NOT NULL,
interesy   text  NOT NULL,
films   text  NOT NULL,
music   text  NOT NULL,
icq   text  NOT NULL,
email   text  NOT NULL,
cforum   int   NOT NULL,
antiflud   int  NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE `online`
(
`id`  int(11)  NOT NULL,
`time` int(111)  NOT NULL,
`locate` text NOT NULL,
PRIMARY KEY(id)
);



CREATE TABLE `mail`
(
`id` INT NOT NULL AUTO_INCREMENT,
`admin`      int  NOT NULL,
`inid`      int  NOT NULL,
`outid`      int  NOT NULL,
`msg`      text  NOT NULL,
`data`      text  NOT NULL,
`new`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `friends`
(
`iduser`    int  NOT NULL,
`idfriend`     int  NOT NULL,
`msg`      text  NOT NULL,
`zayavka`      int  NOT NULL,
`time` int  NOT NULL,
`rating` int  NOT NULL
);# MySQL    (..  ).



CREATE TABLE `guestbook`
(
`id` INT NOT NULL AUTO_INCREMENT,
`ida`     int       NOT NULL,
`idg`      int  NOT NULL,
`data`     text  NOT NULL,
`msg`     text  NOT NULL,
`time`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `presentsadmin`
(
`id`    int  NOT NULL,
`name`      text  NOT NULL,
`money`      int  NOT NULL
);# MySQL    (..  ).


CREATE TABLE `presents`
(
`id` INT NOT NULL AUTO_INCREMENT,
`inid`    int  NOT NULL,
`outid`      int  NOT NULL,
`idpresent`      int  NOT NULL,
`msg`      text  NOT NULL,
`data`      text  NOT NULL,
`new`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).



CREATE TABLE `albums`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name`      text  NOT NULL,
`descr`      text  NOT NULL,
`admin`      int  NOT NULL,
`data`      int  NOT NULL,
`privat`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `photo`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name`      text  NOT NULL,
`descr`     text  NOT NULL,
`admin`      int  NOT NULL,
`data`      int  NOT NULL,
`album`      int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `photo_comm`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`msg`     text  NOT NULL,
`photo`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `photo_likes`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`photo`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `chat`
(
`id` INT NOT NULL AUTO_INCREMENT,
`idchat`     int       NOT NULL,
`idg`      int  NOT NULL,
`data`     text  NOT NULL,
`msg`    text  NOT NULL,
`time`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `news`
(
`id` INT NOT NULL AUTO_INCREMENT,
`admin`     int       NOT NULL,
`data`     int  NOT NULL,
`name`     text  NOT NULL,
`msg`    text  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).

CREATE TABLE `news_comm`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`msg`     text  NOT NULL,
`news`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `news_likes`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`news`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).






CREATE TABLE `jurnal`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`text`    text  NOT NULL,
`data`     int  NOT NULL,
`new`     int  NOT NULL,
`outuser`   int       NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `spam`
(
`id` INT NOT NULL AUTO_INCREMENT,
`admin`     int       NOT NULL,
`spamer`      int       NOT NULL,
`data`     text  NOT NULL,
`msg`     text  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `ban`
(
`id` int       NOT NULL,
`admin`     int       NOT NULL,
`msg`      text       NOT NULL,
`data`     text  NOT NULL,
`timeb`     int  NOT NULL
);# MySQL    (..  ).


CREATE TABLE `reklama`
(
`id` INT NOT NULL AUTO_INCREMENT,
`locate`     text       NOT NULL,
`url`      text       NOT NULL,
`name`     text  NOT NULL,
`stroka`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `myguests`
(
`id` INT NOT NULL AUTO_INCREMENT,
`admin`     int       NOT NULL,
`guest`      int       NOT NULL,
`raz`     int  NOT NULL,
`data`     text  NOT NULL,
`day`    int  NOT NULL,
`mes`     int  NOT NULL,
`god`     int  NOT NULL,
`new`     int  NOT NULL,
`time`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `smiles_cat`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name`     text       NOT NULL,
`ord`  int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `smiles`
(
`id` INT NOT NULL AUTO_INCREMENT,
`code1`     text       NOT NULL,
`code2`     text       NOT NULL,
`code3`     text       NOT NULL,
`category`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `ref`
(
`id` int   NOT NULL,
`user`     int       NOT NULL,
`partner`   int        NOT NULL,
`moneyuser`     int       NOT NULL,
`moneypartner`   int   NOT NULL,
`data`   text       NOT NULL,
`ip`   text       NOT NULL
);# MySQL    (..  ).


CREATE TABLE `partner`
(
`id`   int   NOT NULL,
`moneyrub`     int       NOT NULL,
`statmoney`     int       NOT NULL
);# MySQL    (..  ).


CREATE TABLE `status`
(
`user`  int   NOT NULL,
`img`    int       NOT NULL,
`msg`     text       NOT NULL,
`time`   int   NOT NULL
);# MySQL    (..  ).


CREATE TABLE `spams`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`text`     text  NOT NULL,
`data`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `forum_cat`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name`     text       NOT NULL,
`ord`     int       NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `forum_for`
(
`id` INT NOT NULL AUTO_INCREMENT,
`cat`     int       NOT NULL,
`name`     text       NOT NULL,
`ord`     int       NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `forum_themes`
(
`id` INT NOT NULL AUTO_INCREMENT,
`forum`     int       NOT NULL,
`user`     int       NOT NULL,
`name`     text       NOT NULL,
`data`     int       NOT NULL,
`ord`     int       NOT NULL,
`close`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `forum_msg`
(
`id` INT NOT NULL AUTO_INCREMENT,
`forum`   int   NOT NULL,
`theme`     int       NOT NULL,
`user`     int       NOT NULL,
`msg`     text       NOT NULL,
`data`     int       NOT NULL,
`num`      int       NOT NULL,
`edit`     int       NOT NULL,
`cedit`     int       NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `blog`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`   int   NOT NULL,
`name`     text       NOT NULL,
`text`     text       NOT NULL,
`data`     text       NOT NULL,
`view`     int       NOT NULL,
`privv`   int   NOT NULL,
`privc`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `blog_comm`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`msg`     text  NOT NULL,
`blog`   int   NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).


CREATE TABLE `blog_likes`
(
`id` INT NOT NULL AUTO_INCREMENT,
`user`     int       NOT NULL,
`data`     int  NOT NULL,
`blog`     int  NOT NULL,
PRIMARY KEY(id)
);# MySQL    (..  ).
