test.sql

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

# Powered By Caxton


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

CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `test`;


#
# Table structure for table posts
#

CREATE TABLE `posts` (
  `id` int(10) NOT NULL default '0',
  `name` varchar(10) NOT NULL default '0',
  `topic` varchar(22) NOT NULL default '0',
  `reply` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `post_index` (`topic`(16)),
  KEY `post2_index` (`topic`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Table structure for table user
#

CREATE TABLE `user` (
  `id` int(5) NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `sex` char(2) NOT NULL default '',
  `email` varchar(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;