Просмотр архива Витрина знакомств

CREATE TABLE IF NOT EXISTS `fr` (
  `id` int(11) unsigned NOT NULL
AUTO_INCREMENT,
  `in` int(11) DEFAULT '0',
  `out` int(11) DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `text1` (
  `id` int(11) unsigned NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `text2` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `text`
text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11)
unsigned NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `pass` text
NOT NULL,
  `age` int(2) DEFAULT NULL,
  `photo` text,
  `sex` int(1) NOT
NULL DEFAULT '0',
  `about` text,
  `city` text,
  `cz` text,
  `act`
int(1) DEFAULT '0',
  `status` text,
  `num` int(20) DEFAULT '0',
  `name`
text,
  `time` int(20) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `users` (`id`,
`login`, `pass`, `age`, `photo`, `sex`, `about`, `city`, `cz`, `act`,
`status`, `num`, `name`, `time`) VALUES
(1, 'Admin', 'Admin', 0, NULL, 1,
'', '', '', 1, NULL, 0, '', 1378390770);

CREATE TABLE IF NOT EXISTS `mail`
(
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `in` text NOT NULL,
 
`out` text NOT NULL,
  `msg` text NOT NULL,
  `time` int(20) DEFAULT '0',
 
`n` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;