Просмотр архива wapkat

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `comments` (
  `id0` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11)
NOT NULL,
  `name` varchar(50) NOT NULL,
  `comment` varchar(1024) NOT
NULL,
  `ip` varchar(15) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY
(`id0`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE
TABLE IF NOT EXISTS `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`nick` varchar(50) NOT NULL,
  `message` varchar(1024) NOT NULL,
  `ip`
varchar(15) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(50) NOT NULL,
  `text` varchar(1024) NOT NULL,
  `time` int(10) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `online` (
  `ip`
varchar(15) NOT NULL,
  `sess` varchar(30) NOT NULL,
  `time` int(10) NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(3)
NOT NULL,
  `category` int(11) NOT NULL,
  `about` varchar(1024) NOT NULL,

 `time` int(10) NOT NULL,
  `url` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE
TABLE IF NOT EXISTS `vote_minus` (
  `id` int(11) NOT NULL,
  `ip`
varchar(15) NOT NULL,
  `sess_id` varchar(30) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `vote_plus` (
  `id`
int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `sess_id` varchar(30) NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`admin_guest` (
  `id` int(11) NOT NULL,
  `result` varchar(1024) NOT
NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;