wssd_table.sql

网站名称：网上商店 编写语言：JSP 后台数据库：oracle 运行环境平台：安装windows XP sp2 的PC机； 安装了oracle数据库； 安装了Tomcat 5.5 用户

prompt PL/SQL Developer import file
prompt Created on 2006年10月21日 by Jerry
set feedback off
set define off
prompt Creating WSSD_ADMINUSER...
create table WSSD_ADMINUSER
(
  ID       NUMBER,
  USERNAME VARCHAR2(100),
  PASSWORD VARCHAR2(100),
  PRIORITY NUMBER default 0 not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating WSSD_CAR...
create table WSSD_CAR
(
  ID           NUMBER,
  TITLE        VARCHAR2(100),
  PRICE        VARCHAR2(100),
  INTRODUCTION VARCHAR2(2000),
  MAINPIC      VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating WSSD_CARORDER...
create table WSSD_CARORDER
(
  ID       NUMBER not null,
  ORDER_ID NUMBER not null,
  CAR_ID   NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating WSSD_COMUSER...
create table WSSD_COMUSER
(
  ID             NUMBER not null,
  USERNAME       VARCHAR2(100),
  PASSWORD       VARCHAR2(100),
  NAME           VARCHAR2(100),
  SEX            VARCHAR2(100),
  AGE            VARCHAR2(100),
  EMAIL          VARCHAR2(100),
  PHONE          VARCHAR2(100),
  LOGIN_CISHU    NUMBER default 0,
  ORDER_CISHU    NUMBER default 0,
  PAY_MOUNT      NUMBER default 0,
  DISCOUNT_GRADE NUMBER default 0
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating WSSD_ORDER...
create table WSSD_ORDER
(
  ID         NUMBER,
  CAR_ID     NUMBER,
  PRICE      NUMBER,
  ORDER_TIME VARCHAR2(100),
  PAY_STYLE  NUMBER,
  USER_ID    NUMBER,
  STATUS     NUMBER default 0
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating WSSD_SUBSHOW...
create table WSSD_SUBSHOW
(
  ID         NUMBER,
  PICID      NUMBER,
  PICADDRESS VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for WSSD_ADMINUSER...
alter table WSSD_ADMINUSER disable all triggers;
prompt Disabling triggers for WSSD_CAR...
alter table WSSD_CAR disable all triggers;
prompt Disabling triggers for WSSD_CARORDER...
alter table WSSD_CARORDER disable all triggers;
prompt Disabling triggers for WSSD_COMUSER...
alter table WSSD_COMUSER disable all triggers;
prompt Disabling triggers for WSSD_ORDER...
alter table WSSD_ORDER disable all triggers;
prompt Disabling triggers for WSSD_SUBSHOW...
alter table WSSD_SUBSHOW disable all triggers;
prompt Deleting WSSD_SUBSHOW...
delete from WSSD_SUBSHOW;
commit;
prompt Deleting WSSD_ORDER...
delete from WSSD_ORDER;
commit;
prompt Deleting WSSD_COMUSER...
delete from WSSD_COMUSER;
commit;
prompt Deleting WSSD_CARORDER...
delete from WSSD_CARORDER;
commit;
prompt Deleting WSSD_CAR...
delete from WSSD_CAR;
commit;
prompt Deleting WSSD_ADMINUSER...
delete from WSSD_ADMINUSER;
commit;
prompt Loading WSSD_ADMINUSER...
insert into WSSD_ADMINUSER (ID, USERNAME, PASSWORD, PRIORITY)
values (1, 'admin', 'admin', 1);
insert into WSSD_ADMINUSER (ID, USERNAME, PASSWORD, PRIORITY)
values (2, 'jerry', '123', 0);
insert into WSSD_ADMINUSER (ID, USERNAME, PASSWORD, PRIORITY)
values (3, 'a', 'a', 0);
commit;
prompt 3 records loaded
prompt Loading WSSD_CAR...
insert into WSSD_CAR (ID, TITLE, PRICE, INTRODUCTION, MAINPIC)
values (1, '精工表SND897P', '1250', '适合女性佩戴', '1/SKY787P1.jpg');
insert into WSSD_CAR (ID, TITLE, PRICE, INTRODUCTION, MAINPIC)
values (2, 'SEIKO SMY015P1', '1680', '超级军钢人动电能经典款式' || chr(13) || '' || chr(10) || '精工行货，全球联保.', '2/SMY015_06a.jpg');
commit;
prompt 2 records loaded
prompt Loading WSSD_CARORDER...
insert into WSSD_CARORDER (ID, ORDER_ID, CAR_ID)
values (1, 1, 1);
insert into WSSD_CARORDER (ID, ORDER_ID, CAR_ID)
values (2, 1, 2);
commit;
prompt 2 records loaded
prompt Loading WSSD_COMUSER...
insert into WSSD_COMUSER (ID, USERNAME, PASSWORD, NAME, SEX, AGE, EMAIL, PHONE, LOGIN_CISHU, ORDER_CISHU, PAY_MOUNT, DISCOUNT_GRADE)
values (1, 'jerry', '123', 'Jerry', '0', '12', 'haha@1.1', '1234555', 18, 0, 0, 0);
commit;
prompt 1 records loaded
prompt Loading WSSD_ORDER...
insert into WSSD_ORDER (ID, CAR_ID, PRICE, ORDER_TIME, PAY_STYLE, USER_ID, STATUS)
values (1, null, 2930, '2006-4-26 9:04:27', 2, 1, 2);
commit;
prompt 1 records loaded
prompt Loading WSSD_SUBSHOW...
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (3, 1, '1/SND897P.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (4, 1, '1/SND899P.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (5, 1, '1/2005.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (1, 1, '1/SKY793P.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (2, 1, '1/SND895P.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (6, 2, '2/SMY015_07a.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (7, 2, '2/SMY015_08a.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (8, 2, '2/SMY015_09a.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (9, 2, '2/SMY015P1.jpg');
insert into WSSD_SUBSHOW (ID, PICID, PICADDRESS)
values (10, 2, '2/tj.jpg');
commit;
prompt 10 records loaded
prompt Enabling triggers for WSSD_ADMINUSER...
alter table WSSD_ADMINUSER enable all triggers;
prompt Enabling triggers for WSSD_CAR...
alter table WSSD_CAR enable all triggers;
prompt Enabling triggers for WSSD_CARORDER...
alter table WSSD_CARORDER enable all triggers;
prompt Enabling triggers for WSSD_COMUSER...
alter table WSSD_COMUSER enable all triggers;
prompt Enabling triggers for WSSD_ORDER...
alter table WSSD_ORDER enable all triggers;
prompt Enabling triggers for WSSD_SUBSHOW...
alter table WSSD_SUBSHOW enable all triggers;
set feedback on
set define on
prompt Done.