db.sql.bak

java chengxu database xiangguan

create table KFC_FOODLIST (食品编号 integer not null, 食品名称 varchar2(50) not null, 食品描述 varchar2(500), 推出时间 date, 食品规格 varchar2(20), 食品单价 integer not null, primary key (食品编号));
create table KFC_CHINACITY (城市编号 integer not null, 城市名称 varchar2(20) not null, 所在省份 varchar2(10) not null, 所属区域 varchar2(20), primary key (城市编号));
create table KFC_CHAINSTORELIST (连锁店编号 integer not null, 连锁店名称 varchar2(20) not null, 所在城市 varchar2(20) not null, primary key (连锁店编号));
create table KFC_CUSTOMERLIST (顾客编号 integer not null, 顾客姓名 varchar2(20) not null, 身份证号 char(18) not null, 性别 char(2), 年龄 integer, 职业 varchar2(20), primary key (顾客编号,身份证号));
create table KFC_ORDER (订单编号 integer not null, 开单日期 date, 连锁店编号 integer not null, 顾客编号 integer not null, 订单类型 char(4), primary key (订单编号));
create table KFC_ORDERITEMS (订单项编号 varchar2(20) not null, 对应的订单编号 integer not null, 食品编号 integer not null,购买数量 integer not null, primary key (订单项编号));                
                        
                        
                        
create table MCD_FOODLIST (食品编号 integer not null, 食品名称 varchar2(50) not null, 食品描述 varchar2(500), 推出时间 date, 食品规格 varchar2(20), 食品单价 integer not null, primary key (食品编号));
create table MCD_CHINACITY (城市编号 integer not null, 城市名称 varchar2(20) not null, 所在省份 varchar2(10) not null, 所属区域 varchar2(20), primary key (城市编号));
create table MCD_CHAINSTORELIST (连锁店编号 integer not null, 连锁店名称 varchar2(20) not null, 所在城市 varchar2(20) not null, primary key (连锁店编号));
create table MCD_CUSTOMERLIST (顾客编号 integer not null, 顾客姓名 varchar2(20) not null, 身份证号 integer not null, 性别 char(2), 年龄 integer, 职业 varchar2(20), primary key (顾客编号,身份证号));
create table MCD_ORDER (订单编号 integer not null, 开单日期 date, 连锁店编号 integer not null, 顾客编号 integer not null, 订单类型 char(4), primary key (订单编号));
create table MCD_ORDERITEMS (订单项编号 integer not null, 对应的订单编号 integer not null, 食品编号 integer not null,购买数量 integer not null, primary key (订单项编号));    

insert into KFC_FOODLIST values(0,'香酥鸡腿堡','面包夹香喷喷的鸡腿','1995-3-12', '80g', 10 );
insert into KFC_FOODLIST values(1,'炸鸡腿','炸鸡腿','2000-5-6', '一只', 7 );
insert into KFC_FOODLIST values(2,'粟米棒','甜甜的玉米棒','2001-4-5', '一根', 4 );
insert into KFC_FOODLIST values(3,'香辣鸡腿堡','加辣的鸡腿堡','2001-8-7', '一只', 10 );
insert into KFC_FOODLIST values(4,'上校鸡翅','一对炸鸡翅','1990-2-21', '一对', 7 );
insert into KFC_FOODLIST values(5,'香酥鸡柳堡','夹鸡柳的汉堡','1990-2-21', '一只', 10 );
insert into KFC_FOODLIST values(6,'澳门蛋挞','澳门蛋挞','2001-4-5', '一只', 4 );
insert into KFC_FOODLIST values(7,'小署条','热烤的点心','2000-5-6', '小包', 3 );
insert into KFC_FOODLIST values(8,'土豆泥','土豆泥','2001-3-12', '一盒', 3 );
insert into KFC_FOODLIST values(9,'鲜蔬色拉','鲜蔬色拉','2000-5-6', '一盒30粒', 80 );
insert into KFC_FOODLIST values(10,'墨西哥鸡肉卷','墨西哥鸡肉卷','2000-5-6', '一盒30粒', 80 );
insert into KFC_FOODLIST values(11,'圣旦','二种口味：草莓，巧克力','2000-5-6', '一杯', 80 );
insert into KFC_FOODLIST values(12,'新奥尔良烤翅','新奥尔良烤翅','2003-8-2', '一只', 5 );
insert into KFC_FOODLIST values(13,'香酥鸡块','香酥鸡块','2000-3-8', '一块', 7 );
insert into KFC_FOODLIST values(14,'外带全家桶','里面有各种食品，适合全家外带','2004-9-4', '一大盒', 55 );
insert into KFC_FOODLIST values(15,'可乐','可乐','1995-3-12', '350ml', 4 );
insert into KFC_FOODLIST values(16,'牛奶','热牛奶','1995-3-12', '350ml', 4 );
insert into KFC_FOODLIST values(17,'咖啡','热咖啡','1995-3-12', '350ml', 4 );
insert into KFC_FOODLIST values(18,'红茶','热红茶','1995-3-12', '350ml', 4 );
insert into KFC_FOODLIST values(19,'果珍','热果珍','1995-3-12', '350ml', 4 );


insert into MCD_FOODLIST values(0,'果珍','热果珍','1995-3-12', '350ml', 4 );
insert into MCD_FOODLIST values(1,'香酥鸡腿堡','面包夹香喷喷的鸡腿','1995-3-12', '80g', 10 );
insert into MCD_FOODLIST values(2,'炸鸡腿','炸鸡腿','2000-5-6', '一只', 7 );
insert into MCD_FOODLIST values(3,'粟米棒','甜甜的玉米棒','2001-4-5', '一根', 4 );
insert into MCD_FOODLIST values(4,'香辣鸡腿堡','加辣的鸡腿堡','2001-8-7', '一只', 10 );
insert into MCD_FOODLIST values(5,'鸡翅','一对炸鸡翅','1990-2-21', '一对', 7 );
insert into MCD_FOODLIST values(6,'香酥鸡柳堡','夹鸡柳的汉堡','2003-11-12', '一只', 10 );
insert into MCD_FOODLIST values(7,'蛋筒','蛋筒冰激淋','2001-4-5', '一只', 2 );
insert into MCD_FOODLIST values(8,'小署条','热烤的点心','2000-5-6', '小包', 3 );
insert into MCD_FOODLIST values(9,'菠萝派','菠萝派','2001-3-12', '一只', 3 );
insert into MCD_FOODLIST values(10,'鲜蔬色拉','鲜蔬色拉','2000-5-6', '一盒30粒', 80 );
insert into MCD_FOODLIST values(11,'雪碧','雪碧','2000-5-6', '350ml', 4 );
insert into MCD_FOODLIST values(12,'圣旦','二种口味：草莓，巧克力','2000-5-6', '一杯', 80 );
insert into MCD_FOODLIST values(13,'苹果派','苹果派','2003-8-2', '一只', 3 );
insert into MCD_FOODLIST values(14,'香酥鸡块','香酥鸡块','2000-3-8', '一块', 7 );
insert into MCD_FOODLIST values(15,'奶昔','三种口味：草莓，云泥拿，巧克力','2004-4-9', '一杯', 4 );
insert into MCD_FOODLIST values(16,'可乐','可乐','1995-3-12', '350ml', 4 );
insert into MCD_FOODLIST values(17,'牛奶','热牛奶','1995-3-12', '350ml', 4 );
insert into MCD_FOODLIST values(18,'咖啡','热咖啡','1995-3-12', '350ml', 4 );
insert into MCD_FOODLIST values(19,'红茶','热红茶','1995-3-12', '350ml', 4 );


insert into KFC_CHINACITY values(0,'长沙','湖南','华中');
insert into KFC_CHINACITY values(1,'上海','上海','华东');
insert into KFC_CHINACITY values(2,'北京','北京','华北');
insert into KFC_CHINACITY values(3,'天津','天津','华北');
insert into KFC_CHINACITY values(4,'杭州','浙江','华东');
insert into KFC_CHINACITY values(5,'扬州','江苏','华东');
insert into KFC_CHINACITY values(6,'烟台','山东','华北');
insert into KFC_CHINACITY values(7,'长春','吉林','东北');
insert into KFC_CHINACITY values(8,'沈阳','辽宁','东北');
insert into KFC_CHINACITY values(9,'丽江','云南','西南');
insert into KFC_CHINACITY values(10,'桂林','广西','西南');
insert into KFC_CHINACITY values(11,'三亚','海南','海南');
insert into KFC_CHINACITY values(12,'成都','四川','西南');
insert into KFC_CHINACITY values(13,'西宁','青海','西北');
insert into KFC_CHINACITY values(14,'伊犁','新疆','西北');
insert into KFC_CHINACITY values(15,'拉萨','西藏','西部');
insert into KFC_CHINACITY values(16,'银川','宁夏','西北');
insert into KFC_CHINACITY values(17,'武汉','湖北','华中');
insert into KFC_CHINACITY values(18,'大连','辽宁','东北');
insert into KFC_CHINACITY values(19,'重庆','重庆','西南');


insert into MCD_CHINACITY values(0,'长沙','湖南','华中');
insert into MCD_CHINACITY values(1,'上海','上海','华东');
insert into MCD_CHINACITY values(2,'北京','北京','华北');
insert into MCD_CHINACITY values(3,'天津','天津','华北');
insert into MCD_CHINACITY values(4,'杭州','浙江','华东');
insert into MCD_CHINACITY values(5,'扬州','江苏','华东');
insert into MCD_CHINACITY values(6,'烟台','山东','华北');
insert into MCD_CHINACITY values(7,'长春','吉林','东北');
insert into MCD_CHINACITY values(8,'沈阳','辽宁','东北');
insert into MCD_CHINACITY values(9,'丽江','云南','西南');
insert into MCD_CHINACITY values(10,'桂林','广西','西南');
insert into MCD_CHINACITY values(11,'三亚','海南','海南');
insert into MCD_CHINACITY values(12,'成都','四川','西南');
insert into MCD_CHINACITY values(13,'西宁','青海','西北');
insert into MCD_CHINACITY values(14,'伊犁','新疆','西北');
insert into MCD_CHINACITY values(15,'拉萨','西藏','西部');
insert into MCD_CHINACITY values(16,'银川','宁夏','西北');
insert into MCD_CHINACITY values(17,'武汉','湖北','华中');
insert into MCD_CHINACITY values(18,'大连','辽宁','东北');
insert into MCD_CHINACITY values(19,'重庆','重庆','西南');


drop table KFC_FOODLIST;
drop table KFC_CHINACITY;
drop table KFC_CHAINSTORELIST;
drop table KFC_CUSTOMERLIST;
drop table KFC_ORDER;
drop table KFC_ORDERITEMS;

drop table MCD_FOODLIST;
drop table MCD_CHINACITY;
drop table MCD_CHAINSTORELIST;
drop table MCD_CUSTOMERLIST;
drop table MCD_ORDER;
drop table MCD_ORDERITEMS;

delete from KFC_FOODLIST;
delete from KFC_CHINACITY;
delete from KFC_CHAINSTORELIST;
delete from KFC_CUSTOMERLIST;
delete from KFC_ORDER;
delete from KFC_ORDERITEMS;

delete from MCD_FOODLIST;
delete from MCD_CHINACITY;
delete from MCD_CHAINSTORELIST;
delete from MCD_CUSTOMERLIST;
delete from MCD_ORDER;
delete from MCD_ORDERITEMS;




DELETE FROM KFC_CHAINSTORELIST;