1、酒店订餐.ldfsize=5,maxsize=25,create table cookbook( Cooknumber char (9) primary key, /*菜单编号*/ name char (20) unique, /*菜单名*/ Member_price float (6), /*会员价格*/ constraint price_chk check (Member_price=0)Create table order_list (Lnumber char (9) primary key , /*订单编号*/ Chinastyle_food char (20), /*中餐*/ Wes
2、ternstyle_food char (20), /*西餐*/ medical_food char(20), /*药膳菜品*/ snack char (20) /*小吃*/ ) Create table listorder Delivery_order char (20), /*顶单状态*/ Unumber char (20), /*订餐者编号*/ 时间 datetime, alllist decimal (6,2), /*合计*/ Cnumber char (20) /*管理员编号*/Create table 用户 ( Unumber char (9) primary key, /*会员帐
3、号*/ Uname char (20), /*姓名*/ Usex char (4) default男, /*性别*/ Ucode char (9), /*密码*/ Telephone char(12), /*常用电话*/ Address char(40) /*收货具体地点*/Create table controller (Cnumber char (9) primary key, /*管理员编号*/ Cname char (20), /*管理员姓名*/ Csex char (4), /*管理员性别*/ Cage smallint, /*管理员年龄*/ Cdepartment char (20
4、) /*管理员部门*/Create table food_data /*菜品资料*/ (systems char (10), /*菜系*/ Country char (20), /*国家*/ Disease char (20), /*不同疾病*/ Name char (20) primary key, /*菜名*/ Produce char (200), /*制作*/ Price float (6) /*价格*/ ) Create table business /*配送交易*/ ( Cnumber char (9) not null, /*管理员编号*/ Lnumber char (9), /
5、*订单编号*/ Delivery_order char(20), /*执行命令*/ 日期 datetime /*送货日期*/*建立索引*/create unique index food on food_data(name)create unique index list on order_list(Lnumber)create unique index users on 用户(Unumber) Create view Chinastyle_food As Select name, produce, price From food_data Where systems=鲁菜Create vie
6、w Westernstyle_food As Where country=美国 Create view medical_food /*药膳菜品*/ Select name, produce, price Where disease=心脏Create view snack /*小吃*/ Select produce, price Where name=炒粉create procedure insertfood Systems char (10), /*菜系*/ Country char (20), /*国家*/ Disease char (20)=无, /*不同疾病*/ Name char (2
7、0), /*菜名*/ Produce char (200)=, /*制作*/ Price float (6) asinsert into food_data values(Systems, Country,Disease,Name,Produce,Price)exec insertfood Systems=, Country=中国,Disease=养育,Name=烤鸭,Produce=香辣,Price=55deletefrom food_datawhere name=水煮牛肉 create trigger changedisplay1on food_datafor insertselect*
8、from food_datacreate procedure insertuser Unumber char (9) , /*会员帐号*/ Uname char (20), /*姓名*/ Usex char (4), /*性别*/ Ucode char (9), /*密码*/ Telephone char(12), /*常用电话*/ Address char(40) ) insert into 用户 values(Unumber,Uname,Usex,Ucode,Telephone,Address)exec insertuser Unumber=09001,Uname=常在k,Usex=女,Ucode=123457,Telephone=15100002222,Address=胜利路3号from 用户where unumber=create trigger changedisplay2on 用户for insert select*from inserte
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1