Просмотр архива vkcms-ajax

CREATE TABLE `book` (
  `id` int(11) NOT NULL auto_increment,
  `name`
varchar(15) NOT NULL,
  `data` text NOT NULL,
  `msg` varchar(500) NOT
NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `down` (
  `id` int(11)
NOT NULL auto_increment,
  `name` varchar(15) NOT NULL,
  `opis`
varchar(500) NOT NULL,
  `pach` varchar(100) NOT NULL,
  PRIMARY KEY 
(`id`)
);

CREATE TABLE `down_conf` (
  `id` int(11) NOT NULL
auto_increment,
  `rass` varchar(15) NOT NULL,
  PRIMARY KEY 
(`id`)
);

CREATE TABLE `user` (
  `id` int(11) NOT NULL
auto_increment,
  `user` varchar(30) NOT NULL,
  `pass` varchar(30) NOT
NULL,
  `kod` varchar(30) NOT NULL,
  `time` text NOT NULL,
  `leval`
set('0','1','2','3','4') NOT NULL,
  PRIMARY KEY  (`id`)
);

CREATE
TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `name`
varchar(30) NOT NULL,
  `data` text NOT NULL,
  `msg` varchar(500) NOT
NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `blog` (
  `id` int(11)
NOT NULL auto_increment,
  `user` varchar(30) NOT NULL,
  `name`
varchar(30) NOT NULL,
  `data` text NOT NULL,
  `msg` text NOT NULL,
 
PRIMARY KEY  (`id`)
);

CREATE TABLE `modul` (
  `id` int(11) NOT NULL
auto_increment,
  `modul` text NOT NULL,
  `name` text NULL,
  PRIMARY
KEY  (`id`)
);

CREATE TABLE `love` (
  `id` int(11) NOT NULL
auto_increment,
  `user` varchar(30) NOT NULL,
  `photo` text NULL,
 
`f` text NULL,
  `i` text NULL,
  `o` text NULL,
  `cel` text NULL,
 
`sp` text NULL,
  `o_sebe` text NULL,
  `pol` text NULL,
  `tel` text
NULL,
  `skype` text NULL,
  `icq` text NULL,
  `gorod` text NULL,
 
`vozrast` text NULL,
  PRIMARY KEY  (`id`)
);