【SQL开源代码栏目提醒】:本文主要为网学会员提供kjgl_table.sql,希望对需要kjgl_table.sql网友有所帮助,学习一下!
prompt PL/SQL Developer import file
prompt Created on 2006年10月21日 by Jerry
set feedback off
set define off
prompt Creating ADMIN...
create table ADMIN
(
ID NUMBER,
NAME VARCHAR2(100),
PASSWORD VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating CLASSES...
create table CLASSES
(
ID NUMBER,
TEA_ID NUMBER,
COUR_ID NUMBER,
COUR_TIME VARCHAR2(1000),
ROOM_ID VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating COURSE...
create table COURSE
(
ID NUMBER,
NAME VARCHAR2(100),
MARK NUMBER,
DEP VARCHAR2(100),
PREPARE VARCHAR2(1000)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating ENROL...
create table ENROL
(
STU_ID NUMBER,
CLASS_ID NUMBER,
ACCEPT VARCHAR2(100) default '0',
SCORE NUMBER default 0
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating STUDENT...
create table STUDENT
(
ID NUMBER,
NAME VARCHAR2(100),
PASSWORD VARCHAR2(100),
JIGUAN VARCHAR2(200),
DEPARTMENT VARCHAR2(100),
SEX VARCHAR2(100),
TEL VARCHAR2(100),
EMAIL VARCHAR2(200),
MARK NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TEACHER...
create table TEACHER
(
ID NUMBER,
NAME VARCHAR2(100),
TITLE VARCHAR2(200),
PASSWORD VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for ADMIN...
alter table ADMIN disable all triggers;
prompt Disabling triggers for CLASSES...
alter table CLASSES disable all triggers;
prompt Disabling triggers for COURSE...
alter table COURSE disable all triggers;
prompt Disabling triggers for ENROL...
alter table ENROL disable all triggers;
prompt Disabling triggers for STUDENT...
alter table STUDENT disable all triggers;
prompt Disabling triggers for TEACHER...
alter table TEACHER disable all triggers;
prompt Deleting TEACHER...
delete from TEACHER;
commit;
prompt Deleting STUDENT...
delete from STUDENT;
commit;
prompt Deleting ENROL...
delete from ENROL;
commit;
prompt Deleting COURSE...
delete from COURSE;
commit;
prompt Deleting CLASSES...
delete from CLASSES;
commit;
prompt Deleting ADMIN...
delete from ADMIN;
commit;
prompt Loading ADMIN...
insert into ADMIN (ID, NAME, PASSWORD)
values (1, 'admin', 'admin');
commit;
prompt 1 records loaded
prompt Loading CLASSES...
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (1, 1, 1, 'Mon_2', '101');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (2, 2, 2, 'Mon_1', '103');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (3, 1, 1, 'Fri_3', '306');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (4, 1, 1, 'Thurs_2', '102');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (5, 1, 1, 'Wed_2', '201');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (7, 2, 2, 'Tues_1', '103');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (6, 2, 2, 'Wed_1', '202');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (8, 3, 3, 'Mon_3', '105');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (9, 3, 3, 'Tues_3', '205');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (10, 5, 5, 'Thurs_3', '304');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (11, 4, 5, 'Wed_2', '201');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (12, 6, 11, 'Thurs_3', '101');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (14, 6, 1, 'Fri_3', '303');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (15, 5, 7, 'Wed_3', '301');
commit;
prompt 14 records loaded
prompt Loading COURSE...
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (1, '电子商务', 2, '计算机', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (2, '计算机文化', 2, 'public', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (3, '计算机图形学', 4, '计算机', '0');
insert into COURS