online.sql

来自「在线读书交流平台」· SQL 代码 · 共 135 行 · 第 1/5 页

# SQL-Front 3.3  (Build 1.10)

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: online
# ------------------------------------------------------
# Server version 5.0.51a-community-nt

DROP DATABASE IF EXISTS `online`;
CREATE DATABASE `online` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `online`;

/*!40101 SET NAMES utf8 */;

#
# Table structure for table book
#

CREATE TABLE `book` (
  `bookId` int(15) NOT NULL auto_increment,
  `bookname` varchar(20) NOT NULL default '',