【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了wssd_table.sql提供大家参考,希望对大家有所帮助!
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/