【正文】 te index login2_FK on login ( reader_id ASC ) go create index 用戶權(quán)限 _FK on reader ( ) go create table reversation ( book_id int not null, reader_id int not null, reservation_time datetime null, reservationcancel datetime null, constraint PK_REVERSATION primary key (book_id, reader_id), constraint FK_REVERSAT_REVERSATI_BOOKS foreign key (book_id) references books (book_id), constraint FK_REVERSAT_REVERSATI_READER foreign key (reader_id) references reader (reader_id) ) go create index reversation_FK on reversation ( book_id ASC ) go create index reversation2_FK on reversation ( reader_id ASC ) go 。) and type = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。) and name = 39。) drop table reader go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。 and indid 0 and indid 255) drop index _FK go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。) drop table login go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index go 17 if exists (select 1 from sysindexes where id = object_id(39。) and name = 39。) drop table borrow_information go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。) and name = 39。) drop table booktype go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。) drop table books go if exists (select 1 from sysobjects where id = object_id(39。) and type = 39。 and indid 0 and indid 255) drop index _FK go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index _FK go if exists (select 1 from sysindexes where id = object_id(39。) and name = 39。) drop table admi