Просмотр файла sql.sql

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`)
);