www.pudn.com > VBproject VCD.rar > sql1.sql, change:2004-03-27,size:4042b


insert Orders values ('00001','00001','001','love',1,getdate(),dateadd(dd,2,getdate()),5) 
drop table love,cartoon,comedy,war,art,advertisement,terror,venture,science,action 
sp_help 
create table Member 
( cMemberID char (5), 
  cMemberName char (10), 
  mMoney money, 
  cAge char (3), 
  cSex char (4), 
  cEmail char (30), 
  cAddress char (40), 
  cPostcode char (6), 
  cPhone char (20), 
  cCardnum char (18) 
) 
select * from customer 
 
create table Love 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table Comedy 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table Cartoon 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table Science 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table Terrorֲ 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table War 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
 
create table Action 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
create table Venture(ð) 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
 
create table Art 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  iPrice int, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
 
create table advertisement 
( cID char (5), 
  cName char (20), 
  cLanguage char (15), 
  cLenth char (3), 
  dPublishDate datetime, 
  mPrice money, 
  cParts char (50), 
  cDirector char (15), 
  cStory char (2000), 
  cPicpath char (200), 
  cLevel char (10), 
  iStock int 
) 
 
create table Orders 
(  cOrderNo char (5), 
   cMemberID char(5), 
   cVCDName char (100), 
   cType char (20), 
   iRentNum int, 
   dOrderDate datetime, 
   dcReturnDate datetime, 
   dfReturnDate datetime, 
   iRental int 
) 
 
create table Orderdetails 
(   
   cOrderNo char (5), 
   cMemberID char(5), 
   cVCDName char (100), 
   cType char (20), 
   iRentNum int, 
   dOrderDate datetime, 
   dcReturnDate datetime, 
   dfReturnDate datetime, 
   iRental int 
) 
create table rent  
(  cCustomerID char (5), 
   cOrderNo char (5), 
   cID char (3), 
   dRentDate datetime, 
   iRentNum int, 
   iRental int 
) 
 
create table Manager 
(   cManageID char (5), 
    cPassword char (10), 
    cName     char (10), 
    cAge      char (3), 
    cEmail    char (20), 
    cTel      char (15), 
    cAddress  char (100) 
)