install.sql

来自「用Visual c++.net开发的图书管理系统」· SQL 代码 · 共 6 行

-- create database myBook;
-- use myBook;
-- create table my_book(BookID int primary key not null, BookName char(10) not null, BookPublisher char(20) not null, BookStatus char(5) not null);
-- create table my_reader(ReaderID char(10) primary key not null, ReaderName char(10) not null, ReaderLevel char(10) not null);
-- create table my_recorder(RecorderBookID char(10) not null, RecorderReaderID char(10) not null, RecorderOutDate char(10) not null);
-- create table my_Administer(Account char(10) primary key not null, [Password] char(10) not null, [Level] int not null);