【正文】 ***************************************************//*用戶表*/create table Users( userNo char(6) not null primary key, /*用戶標(biāo)識(shí)*/ userName varchar(12) null default 39。root39。, /*用戶名稱*/ userPwd char(20) null default 39。12345639。/*用戶口令*/)on other/*系統(tǒng)功能表*/create table SysFunction( functionNo char(6) not null primary key, /*功能編號(hào)*/ functionName varchar(12) null /*功能名稱*/)on other/*權(quán)限表*/create table Permission( userNo char(6) not null, /*用戶標(biāo)識(shí)*/ functionNo char(6) not null, /*功能編號(hào)*/ classNo char(2) not null, /*操作類型編號(hào)*/ constraint PermissionPK primary key(userNo,functionNo), constraint PermissionFK1 foreign key(functionNo) references SysFunction(functionNo),/*functionNo外鍵約束*/ constraint PermissionFK2 foreign key(classNo) references DCClass(classNo)/*classNo外鍵約束*/ )on otherinsert into DCSex values(39。139。,39。男39。,null)insert into DCSex values(39。239。,39。女39。,null)insert into DCSex values(39。339。,39。未知39。,null)insert into DCDpartment values(39。0139。,39。財(cái)務(wù)科39。,null)insert into DCDpartment values(39。0239。,39。業(yè)務(wù)科39。,null)insert into DCDpartment values(39。0339。,39。辦公室39。,null)insert into DCHeadship values(39。139。,39。銷售39。,null)insert into DCHeadship values(39。239。,39。采購(gòu)39。,null)insert into DCHeadship values(39。339。,39。監(jiān)管39。,null)insert into DCGoodsHot values(39。139。,39。熱門39。,null)insert into DCGoodsHot values(39。239。,39。一般39。,null)insert into DCGoodsHot values(39。339。,39。冷門39。,null)insert into DCClass values(39。139。,39。select39。,null)insert into DCClass values(39。239。,39。update39。,null)insert into DCClass values(39。339。,39。insert39。,null)insert into Employee values(39。E2010000139。,39。12345639。,39。劉貴軍39。,39。男39。,39。1990071539。,39。江西省39。,null,null,39。2010122739。,null,null,5000)insert into Employee values(39。E2010000239。,39。12345639。,39。john39。,39。男39。,39。1990032539。,39。江西省39。,null,null,39。2010122739。,null,null,3000)insert into Employee values(39。E2010000339。,39。12345639。,39。tom39。,39。女39。,39。1990070539。,39。江西省39。,null,null,39。2010122739。,null,null,8000)insert into Customer values(39。C2010000139。,39。12345639。,39。劉貴軍39。,39。男39。,39。1990071539。,0,39。江西省39。,null,null)insert into Customer values(39。C2010000239。,39。12345639。,39。john39。,39。男39。,39。1990032539。,0,39。江西省39。,null,null)insert into Customer values(39。C2010000339。,39。12345639。,39。tom39。,39。女39。,39。1990070539。,0,39。江西省39。,null,null)insert into Supplier values(39。S2010000139。,39。新大新公司39。,39。浙江省杭州市39。,39。0791382704539。,null)insert into Supplier values(39。S2010000239。,39。江西食品有限公司39。,39。江西省南昌市39。,39。0796382504939。,null)insert into Supplier values(39。S2010000339。,39。太和集團(tuán)39。,39。廣州經(jīng)濟(jì)開發(fā)區(qū)39。,39。0797384604439。,null)insert into WareHouse values(39。H2010000139。,39。倉(cāng)庫(kù)一39。,null,2000)insert into WareHouse values(39。H2010000239。,39。倉(cāng)庫(kù)二39。,null,5000)insert into WareHouse values(39。H2010000339。,39。倉(cāng)庫(kù)三39。,null,6000)insert into Goods values(39。G2010000139。,39。蘋果39。,39。食品39。,39。一般39。,20,5,39。H2010000139。)insert into Goods values(39。G2010000239。,39。西瓜39。,39。食品39。,39。熱門39。,50,39。H2010000139。)insert into Goods values(39。G2010000339。,39。西紅柿39。,39。食品39。,39。冷門39。,100,2,39。H2010000139。)insert into BuyMaster values(39。B2010000139。,60,39。2010122739。,39。E2010000139。,39。S2010000139。)insert into BuyMaster values(39。B2010000239。,50,39。2010122739。,39。E2010000239。,39。S2010000239。)insert into BuyMaster values(39。B2010000339。,10,39。2010122739。,39。E2010000339。,39。S2010000139。)insert into BuyDetail values(39。B2010000139。,39。G2010000139。,10)insert into BuyDetail values(39。B2010000239。,39。G2010000139。,5,10)insert into BuyDetail values(39。B2010000339。,39。G2010000239。,5,10)insert into InputMaster values(39。I2010000139。,39。2010122739。,39。B2010000139。,39。E2010000139。,39。H2010000139。)insert into InputMaster values(39。I2010000239。,39。2010122739。,39。B2010000139。,39。E2010000239。,39。H2010000239。)insert into InputMaster values(39。I2010000339。,39。2010122739。,39。B2010000139。,39。E2010000339。,39。H2010000139。)insert into InputDetail values(39。I2010000139。,39。G2010000139。,10)insert into InputDetail values(39。I2010000239。,39。G2010000139。,10)insert into InputDetail values(39。I2010000339。,39。G2010000239。,10)insert into OrderMaster values(39。O2010000139。,60,39。2010122739。,39。E2010000139。,39。C2010000139。)insert into OrderMaster values(39。O2010000239。,50,39。2010122739。,39。E2010000239。,39。C2010000239。)insert into OrderMaster values(39。O2010000339。,10,39。2010122739。,39。E2010000339。,39。C2010000139。)insert into OrderDetail values(39。O2010000139。,39。G2010000139。,5,10)insert into OrderDetail values(39。O2010000239。,39。G2010000139。,10)insert into OrderDetail values(39。O2010000339。,39。G2010000239。,10)insert into OutputMaster values(39。P2010000139。,39。2010122739。,39。O2010000139。,39。E2010000139。,39。H2010000139。)insert into OutputMaster values(39。P2010000239。,39。2010122739。,39。O2010000139。,39。E2010000239。,39。H2010000239。)insert into OutputMaster values(39。P2010000339。,39。2010122739。,39。O2010000139。,39。E2010000339。,39。H2010000139。)insert into OutputDetail values(39。I2010000139。,39。G2010000139。,10)insert into OutputDetail values(39。I2010000239。,39。G2010000139。,10)insert into OutputDetail values(39。I2010000339。,39。G2010000239。,10)insert into Users values(39。00000139。,39。john39。,39。12345639。)insert into Users values(39。00000239。,39。tom39。,39。12345639。)insert into Users values(39。00000339。,39。mike39。,39。12345639。)insert into SysFunction values(39。00000139。,39?；拘畔?9。)insert into SysFunction values(39。00000239。,39。業(yè)務(wù)信息39。)insert into SysFunction values(39。00000339。,39。財(cái)務(wù)信息39。)insert into Permission values(39。00000139。,39。00000139。,39。139。)insert into Permission values(39。00000239。,39。00000139。,39。239。)insert into Permission values(39。00000339。,39。00000239。,39。339。)8 附錄2 視圖、觸發(fā)器、存儲(chǔ)過(guò)程和索引(1) 視圖： /***************************************************//**************** 創(chuàng)建視圖 *****************//***************************************************//*統(tǒng)計(jì)各用戶的購(gòu)買商品金額的視圖*/create view CustomerViewas select ,customerName,sum() sum from Orde