View file znak_otzuv(mysql)/SQL.txt

File size: 939B
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `nick` text NOT NULL,
  `pass` text NOT NULL,
  `name` text NOT NULL,
  `sex` text NOT NULL,
  `bday` text NOT NULL,
  `bmonth` text NOT NULL,
  `byear` text NOT NULL,
  `gorod` text NOT NULL,
  `rost` text NOT NULL,
  `ves` text NOT NULL,
  `ssex` text NOT NULL,
  `swhy` text NOT NULL,
  `mail` text NOT NULL,
  `mob` text NOT NULL,
  `infa` text NOT NULL,
  `foto` text NOT NULL,
  `counter` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
################################################

CREATE TABLE `otziv` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `komu` varchar(100) NOT NULL default '',
  `otkogo` varchar(100) NOT NULL default '',
  `message` varchar(250) NOT NULL default '',
  `data` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;