Просмотр файла 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 `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`)
);