创建数据库表的sql语句.txt

用java写的一个图书馆管理系统,应该说功能相当全面.包含所有源代码,从数据库的建立到客户端.

CREATE TABLE UserTable(ID int identity, UserName char(40), Password char(40), 
Power char(40), CONSTRAINT ID_User_Containt PRIMARY KEY (ID));

CREATE TABLE books(ID int identity, BookName char(20), Press char(20), Author char(20), 
PressDate char(10), Price char(10), Com char(20), books_count char(2), 
borrowed_count char(2), CONSTRAINT ID_Contraint_PK PRIMARY KEY (ID));

CREATE TABLE bookBrowse(ID int identity, StudentName char(40), BookName char(40), 
ReturnDate char(10), BorrowDate char(10), Com char(40), Is_Returned char(2), 
CONSTRAINT ID_BookBrowse_Containt PRIMARY KEY (ID));