图书馆数据库各表.docVIP

创建数据库 CREATE DATABASE [Library] ON PRIMARY ( NAME = NLibrary, FILENAME = NC:\Users\Administrator\Desktop\DATA\Library.mdf , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = NLibrary_log, FILENAME = NC:\Users\Administrator\Desktop\DATA\Library_log.ldf , SIZE = 1280KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [Library] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY(IsFullTextInstalled)) begin EXEC [Library].[dbo].[sp_fulltext_database] @action = enable End 创建Users表 /* Navicat Oracle Data Transfer Oracle Client Version : 11.2.0.1.0 Source Server : g Source Server Version : 110200 Source Host : localhost:1521 Source Schema : SYSTEM Target Server Type : ORACLE Target Server Version : 110200 File Encoding : 65001 Date: 2012-05-05 22:43:30 */ -- ---------------------------- -- Table structure for SYSTEM.Users -- ---------------------------- DROP TABLE SYSTEM.Users; CREATE TABLE SYSTEM.Users ( ID NUMBER NOT NULL , 学号 VARCHAR2(10 BYTE) NOT NULL , 已借 NUMBER NULL ) LOGGING NOCOMPRESS NOCACHE ; -- ---------------------------- -- Records of Users -- ---------------------------- INSERT INTO SYSTEM.Users VALUES (2, 090210101, 3); INSERT INTO SYSTEM.Users VALUES (3, 090210102, 0); INSERT INTO SYSTEM.Users VALUES (1, 123456, 0); -- ---------------------------- -- Checks structure for table SYSTEM.Users -- ---------------------------- ALTER TABLE SYSTEM.Users ADD CHECK (ID IS NOT NULL); ALTER TABLE SYSTEM.Users ADD CHECK (学号 IS NOT NULL); 创建Return_Table表 /* Navicat Oracle Data Transfer Oracle Client Version : 11.2.0.1.0 Source Server : g Source Server Version : 110200 Source Host : localhost:1521 Source Schema : SYSTEM Target Server Type : ORACLE Target Server Version : 110200 File Encoding : 65001 Date: 2012-05-05 22:44:56 */ -- ---------------------------- -- Table structure for SYSTEM.Return_Table -- -----------