web.sql

来自「一本jsp自学教材」· SQL 代码 · 共 71 行

# Powered By Caxton

# Host: localhost    Database: web
# ------------------------------------------------------
# Server version 4.1.13-nt

CREATE DATABASE `web` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `web`;

/*!40101 SET NAMES gbk */;


#
# Table structure for table admin
#

CREATE TABLE `admin` (
  `id` int(6) NOT NULL auto_increment,
  `adminname` varchar(18) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `nickname` varchar(18) NOT NULL default '',
  `power` int(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table commentary
#

CREATE TABLE `commentary` (
  `id` int(11) NOT NULL auto_increment,
  `nid` int(10) default NULL,
  `nickname` varchar(16) default NULL,
  `content` varchar(250) default NULL,
  `time` datetime default NULL,
  `ip` varchar(16) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table news
#

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(160) NOT NULL default '',
  `style` varchar(8) default NULL,
  `pfrom` varchar(20) default NULL,
  `content` text,
  `postorid` int(3) default NULL,
  `posttime` datetime default NULL,
  `clicktime` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table user
#

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(36) default NULL,
  `password` varchar(32) NOT NULL default '',
  `age` int(3) default NULL,
  `sex` varchar(12) default NULL,
  `qq` varchar(22) default '279920018',
  `email` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;