oracle_data--数据库文件.sql

福建博洋教育C/C++软件项目实战：POS收银系统

prompt PL/SQL Developer import file
prompt Created on 2008年8月17日 by Administrator
set feedback off
set define off
prompt Creating PRODUCT...
create table PRODUCT
(
  BAR_CODE       VARCHAR2(8) not null,
  PRODUCT_NAME   VARCHAR2(30),
  UNIT           VARCHAR2(16),
  SPEC           VARCHAR2(16),
  SALE_PRICE     FLOAT,
  PURCHASE_PRICE FLOAT,
  COUNT          INTEGER,
  DISCOUNT       FLOAT
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table PRODUCT
  add constraint PK_PRODUCT primary key (BAR_CODE)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );

prompt Creating SALE...
create table SALE
(
  SALE_ID    VARCHAR2(18) not null,
  TRANS_ID   VARCHAR2(4),
  STAFF_ID   VARCHAR2(6),
  SALE_DATE  DATE,
  GIVEN_SUM  FLOAT,
  REAL_SUM   FLOAT,
  SALE_MONEY FLOAT,
  CHANGE     FLOAT,
  SALE_STATE INTEGER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table SALE
  add constraint PK_SALE primary key (SALE_ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );

prompt Creating SALE_DETAIL...
create table SALE_DETAIL
(
  DETAIL_ID  VARCHAR2(18) not null,
  SALE_ID    VARCHAR2(18),
  BAR_CODE   VARCHAR2(8),
  COUNT      INTEGER,
  SALE_PRICE FLOAT,
  SALE_STATE INTEGER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
comment on column SALE_DETAIL.DETAIL_ID
  is '销售明细ID';
alter table SALE_DETAIL
  add constraint PK_SALE_DETAIL primary key (DETAIL_ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table SALE_DETAIL
  add constraint FK_D_R_SALE foreign key (SALE_ID)
  references SALE (SALE_ID) on delete cascade;

prompt Creating SALE_TMP...
create table SALE_TMP
(
  SALE_ID  VARCHAR2(18) not null,
  STAFF_ID VARCHAR2(6)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table SALE_TMP
  add constraint PK_SALE_TMP primary key (SALE_ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );

prompt Creating STAFF...
create table STAFF
(
  STAFF_ID   VARCHAR2(6) not null,
  STAFF_NAME VARCHAR2(15),
  STAFF_PWD  VARCHAR2(16),
  STAFF_TYPE INTEGER,
  REMARK     VARCHAR2(30)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );
alter table STAFF
  add constraint PK_STAFF primary key (STAFF_ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 64K
    minextents 1
    maxextents unlimited
    pctincrease 50
  );

prompt Disabling triggers for PRODUCT...
alter table PRODUCT disable all triggers;
prompt Disabling triggers for SALE...
alter table SALE disable all triggers;
prompt Disabling triggers for SALE_DETAIL...
alter table SALE_DETAIL disable all triggers;
prompt Disabling triggers for SALE_TMP...
alter table SALE_TMP disable all triggers;
prompt Disabling triggers for STAFF...
alter table STAFF disable all triggers;
prompt Disabling foreign key constraints for SALE_DETAIL...
alter table SALE_DETAIL disable constraint FK_D_R_SALE;
prompt Loading PRODUCT...
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000001', '雪碧', '瓶', '355ml', 2.5, 1.7, 9982, .8);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000003', '百事可乐', '瓶', '355ml', 2.5, 1.8, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000002', '可口可乐', '瓶', '355ml', 2.5, 1.8, 9995, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000004', '美年达', '瓶', '355ml', 2.5, 1.8, 9998, .9);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000005', '七喜', '瓶', '355ml', 2.5, 1.7, 9997, .7);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000006', '农夫山泉', '瓶', '500ml', 1.5, .9, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000007', '娃哈哈矿泉水', '瓶', '500ml', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000008', '心相印', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000009', '笔记本', '本', '16开', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000010', '康师傅牛肉面', '袋', '5包', 7.8, 4, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000011', '高露洁牙膏', '盒', '200g', 3, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000012', '佳洁士牙刷', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000013', '飘柔', '瓶', '400ml', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000014', '六神沐浴露', '瓶', '400ml', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000015', '雕牌洗衣粉', '袋', '200g', 3, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000016', '快餐', '盒', '自助', 5, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000017', '成人纸尿片', '张', '10片', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000018', '安尔乐', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000019', '高级笔记本', '本', '16开', 8, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000020', '统一牛肉面', '袋', '5包', 7.8, 4, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000021', '开水', '瓶', '355ml', 2.5, 1.7, 9987, .8);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000023', '白开水', '瓶', '355ml', 2.5, 1.8, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000022', '咸开水', '瓶', '355ml', 2.5, 1.8, 9995, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000024', '甜开水', '瓶', '355ml', 2.5, 1.8, 9998, .9);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000025', '馊水', '瓶', '355ml', 2.5, 1.7, 9997, .7);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000026', '茶水', '瓶', '500ml', 1.5, .9, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000027', '咖啡', '瓶', '500ml', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)