sql.sql

jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码 jsp学习源码

# DBTools 1.0.15 - MySQL Database Dump
#

#CREATE DATABASE popten;
#USE popten;

# Dumping Table Structure for admin

#
CREATE TABLE `admin` (
  `name` varchar(20) NOT NULL default '',
  `password` varchar(35) NOT NULL default '',
  `sex` enum('帅哥','美女') NOT NULL default '帅哥',
  `email` varchar(32) NOT NULL default '',
  `qq` int(11) unsigned NOT NULL default '0',
  `phone` bigint(20) unsigned NOT NULL default '0',
  `question` varchar(100) NOT NULL default '',
  `answer` varchar(35) NOT NULL default '',
  `clas` tinyint(4) unsigned NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `news_coun` smallint(6) unsigned NOT NULL default '0',
  `user_id` tinyint(4) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for cata0

#
CREATE TABLE `cata0` (
  `cata0_id` tinyint(4) unsigned NOT NULL auto_increment,
  `cata0_name` varchar(12) NOT NULL default '',
  `coun` smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cata0_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for cata1

#
CREATE TABLE `cata1` (
  `cata1_id` smallint(6) unsigned NOT NULL auto_increment,
  `cata1_name` varchar(30) NOT NULL default '',
  `cata0_id` tinyint(4) unsigned default NULL,
  `coun` smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cata1_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for cata2

#
CREATE TABLE `cata2` (
  `cata2_id` smallint(6) unsigned NOT NULL auto_increment,
  `cata2_name` varchar(30) NOT NULL default '',
  `cata1_id` tinyint(4) unsigned default NULL,
  `coun` smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cata2_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for commen

#
CREATE TABLE `commen` (
  `commen_id` tinyint(4) unsigned NOT NULL auto_increment,
  `commen_content` text NOT NULL,
  `commen_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `news_id` smallint(6) unsigned NOT NULL default '0',
  `news_title` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`commen_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for coun

#
CREATE TABLE `coun` (
  `all_coun` int(11) unsigned NOT NULL default '0',
  `today_coun` mediumint(6) unsigned NOT NULL default '0',
  `average_coun` int(10) unsigned NOT NULL default '0',
  `max_coun` mediumint(9) unsigned NOT NULL default '0',
  `max_dat` date NOT NULL default '0000-00-00',
  `today` date NOT NULL default '0000-00-00',
  `creat_dat` date NOT NULL default '0000-00-00'
) TYPE=MyISAM;
#
# Dumping Table Structure for daytop

#
CREATE TABLE `daytop` (
  `news_id` smallint(6) unsigned NOT NULL default '0',
  `news_title` varchar(50) NOT NULL default '',
  `dat` date NOT NULL default '0000-00-00',
  `coun_day` smallint(6) unsigned NOT NULL default '0',
  `coun_week` smallint(6) unsigned NOT NULL default '0',
  `day_id` tinyint(3) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`day_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for news

#
CREATE TABLE `news` (
  `news_id` smallint(6) unsigned NOT NULL auto_increment,
  `cata0_id` tinyint(4) unsigned NOT NULL default '0',
  `cata1_id` tinyint(4) unsigned NOT NULL default '0',
  `cata2_id` tinyint(4) unsigned NOT NULL default '0',
  `news_title` varchar(50) NOT NULL default '0',
  `conten` text,
  `sour` varchar(50) NOT NULL default '0',
  `dat` datetime NOT NULL default '0000-00-00 00:00:00',
  `img` tinyint(4) unsigned NOT NULL default '0',
  `imgsrc` varchar(15) default NULL,
  `hot` tinyint(4) unsigned NOT NULL default '0',
  `coun` smallint(6) unsigned NOT NULL default '0',
  `author` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`news_id`)
) TYPE=MyISAM;
#