prompt Creating COMTYPE...
create table COMTYPE
(
TYPE_ID INTEGER not null,
TYPE VARCHAR2(50)
)
;
alter table COMTYPE
add primary key (TYPE_ID);
prompt Creating COMPUTER...
create table COMPUTER
(
COMPUTER_ID INTEGER not null,
COMPUTER_NAME VARCHAR2(200),
MEMORY INTEGER,
CUP INTEGER,
VIDEOCARD INTEGER,
DISPLAY INTEGER,
HDD INTEGER,
PRICE VARCHAR2(20)
)
;
alter table COMPUTER
add primary key (COMPUTER_ID);
alter table COMPUTER
add foreign key (MEMORY)
references COMTYPE (TYPE_ID);
alter table COMPUTER
add foreign key (CUP)
references COMTYPE (TYPE_ID);
alter table COMPUTER
add foreign key (VIDEOCARD)
references COMTYPE (TYPE_ID);
alter table COMPUTER
add foreign key (DISPLAY)
references COMTYPE (TYPE_ID);
alter table COMPUTER
add foreign key (HDD)
references COMTYPE (TYPE_ID);
prompt Creating PEIZHI...
create table PEIZHI
(
COMPONENT_ID INTEGER not null,
TYPE_ID INTEGER,
COMPONENT_NAME VARCHAR2(200),
CAPACITY VARCHAR2(20),
PRICE INTEGER
)
;
alter table PEIZHI add primary key (COMPONENT_ID);
alter table PEIZHI
add foreign key (TYPE_ID)
references COMTYPE (TYPE_ID);
prompt Disabling triggers for COMTYPE...
alter table COMTYPE disable all triggers;
prompt Disabling triggers for COMPUTER...
alter table COMPUTER disable all triggers;
prompt Disabling triggers for PEIZHI...
alter table PEIZHI disable all triggers;
prompt Disabling foreign key constraints for COMPUTER...
alter table COMPUTER disable constraint SYS_C0011099;
alter table COMPUTER disable constraint SYS_C0011100;
alter table COMPUTER disable constraint SYS_C0011101;
alter table COMPUTER disable constraint SYS_C0011102;
alter table COMPUTER disable constraint SYS_C0011103;
prompt Disabling foreign key constraints for PEIZHI...
alter table PEIZHI disable constraint SYS_C0011097;
prompt Loading COMTYPE...
insert into COMTYPE (TYPE_ID, TYPE)
values (1, 'CPU');
insert into COMTYPE (TYPE_ID, TYPE)
values (2, '内存');
insert into COMTYPE (TYPE_ID, TYPE)
values (3, '显卡');
insert into COMTYPE (TYPE_ID, TYPE)
values (4, '硬盘');
insert into COMTYPE (TYPE_ID, TYPE)
values (5, '显示器');
commit;
prompt 5 records loaded
prompt Loading COMPUTER...
insert into COMPUTER (COMPUTER_ID, COMPUTER_NAME, MEMORY, CUP, VIDEOCARD, DISPLAY, HDD, PRICE)
values (2, '戴尔3888台式', 4, 1, 5, 3, 4, '7147');
commit;
prompt 1 records loaded
prompt Loading PEIZHI...
insert into PEIZHI (COMPONENT_ID, TYPE_ID, COMPONENT_NAME, CAPACITY, PRICE)
values (1, 5, '戴尔25寸2k显示器', null, 2599);
insert into PEIZHI (COMPONENT_ID, TYPE_ID, COMPONENT_NAME, CAPACITY, PRICE)
values (2, 4, '西部数据蓝盘', '1000', 2599);
insert into PEIZHI (COMPONENT_ID, TYPE_ID, COMPONENT_NAME, CAPACITY, PRICE)
values (3, 2, '金士顿', '8', 320);
commit;
prompt 3 records loaded
prompt Enabling foreign key constraints for COMPUTER...
alter table COMPUTER enable constraint SYS_C0011099;
alter table COMPUTER enable constraint SYS_C0011100;
alter table COMPUTER enable constraint SYS_C0011101;
alter table COMPUTER enable constraint SYS_C0011102;
alter table COMPUTER enable constraint SYS_C0011103;
prompt Enabling foreign key constraints for PEIZHI...
alter table PEIZHI enable constraint SYS_C0011097;
prompt Enabling triggers for COMTYPE...
alter table COMTYPE enable all triggers;
prompt Enabling triggers for COMPUTER...
alter table COMPUTER enable all triggers;
prompt Enabling triggers for PEIZHI...
alter table PEIZHI enable all triggers;
set feedback on
set define on
prompt Done.
