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

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(20) NOT NULL,
  `dat` varchar(50) NOT NULL,
  `msg` varchar(255) NOT NULL,
  `otvet` varchar(255) NOT NULL,
  `browser` text,
  `pi` text,
  `ban` smallint(1) NOT NULL,
  `time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `main` (
`style` INT( 1 ) NOT NULL ,
`privet` VARCHAR( 100 ) NOT NULL ,
`password` VARCHAR( 25 ) NOT NULL,
`sait` VARCHAR( 30 ) NOT NULL,
`mess` SMALLINT( 2 ) NOT NULL,
`js` SMALLINT( 1 ) NOT NULL,
`site_name` VARCHAR( 25 ) NOT NULL
);
INSERT INTO `main` VALUES ('2', 'Гостевая', '12345', 'saratov-x.ru', '5', '1', 'saratov-x.ru');