study.sql

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

# Powered By Caxton


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

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

/*!40101 SET NAMES gbk */;


#
# Table structure for table ordering
#

CREATE TABLE `ordering` (
  `id` int(8) NOT NULL auto_increment,
  `name` varchar(16) NOT NULL default '',
  `pdm` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Table structure for table product
#

CREATE TABLE `product` (
  `id` int(11) NOT NULL auto_increment,
  `pdm` varchar(10) NOT NULL default '',
  `pname` varchar(16) default NULL,
  `provider` varchar(16) default NULL,
  `info` varchar(200) default NULL,
  `stock` int(11) default '0',
  `price` float(8,2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table roles
#

CREATE TABLE `roles` (
  `id` int(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `info` varchar(250) default NULL,
  `image` longblob,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table tomcatrole
#

CREATE TABLE `tomcatrole` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `roles` varchar(16) default NULL,
  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(18) default NULL,
  `password` varchar(16) NOT NULL default '',
  `age` int(3) default NULL,
  `sex` varchar(6) default NULL,
  `qq` varchar(11) default '279920018',
  `email` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

#
# Table structure for table votes
#

CREATE TABLE `votes` (
  `id` int(6) NOT NULL auto_increment,
  `type` int(1) default '0',
  `topicid` int(5) default NULL,
  `title` varchar(50) default NULL,
  `result` int(10) default '0',
  `ip` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;