library.sql

来自「一个用java开发的具有搜索功能的图书管理系统」· SQL 代码 · 共 129 行 · 第 1/5 页

# MySQL-Front 3.2  (Build 10.6)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40111 SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT */;

/*!40101 SET NAMES gbk */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
SET AUTOCOMMIT=0;
BEGIN;

# Host: localhost    Database: library
# ------------------------------------------------------
# Server version 5.0.41-community-nt

DROP DATABASE IF EXISTS `library`;
CREATE DATABASE `library` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `library`;

#
# Table structure for table administrator
#