【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,qiuzhi_table.sql,希望对大家有所帮助!
prompt PL/SQL Developer import file
prompt Created on 2006年10月21日 by Jerry
set feedback off
set define off
prompt Creating COMPANY...
create table COMPANY
(
ID NUMBER,
COP_NAME VARCHAR2(100) default '',
COP_MANN NUMBER default 0,
COP_CONT NUMBER default '',
COP_TEL VARCHAR2(100) default '',
COP_MAIL VARCHAR2(100) default '',
COP_TEX VARCHAR2(100) default '',
COP_ADDR VARCHAR2(1000) default '',
COP_ZIP VARCHAR2(100) default '',
COP_WWW VARCHAR2(100) default '',
COP_DESC VARCHAR2(2000) default '',
USER_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating JOBS...
create table JOBS
(
ID NUMBER,
JOB_NAME VARCHAR2(100) default '',
JOP_MANN NUMBER default 0,
JOB_ADDR VARCHAR2(100) default '',
JOB_NUM NUMBER default 0,
JOB_GET VARCHAR2(100) default '',
JOB_STA NUMBER default 0,
JOB_END NUMBER default 0,
JOB_GRAD NUMBER default 0,
JOB_AGE1 NUMBER default 0,
JOB_AGE2 NUMBER default 0,
JOB_EXPE NUMBER default 0,
JOB_LANG NUMBER default 0,
JOB_ODEM VARCHAR2(1000) default '',
JOB_OGET VARCHAR2(200) default '',
COP_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating REPLY...
create table REPLY
(
ID NUMBER,
USER_ID NUMBER,
INTRO VARCHAR2(2000),
RESUME_ID NUMBER,
JOB_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating RESUME...
create table RESUME
(
ID NUMBER,
JOB_ID NUMBER,
INTRO VARCHAR2(2000),
USER_ID NUMBER,
JOB_NAME VARCHAR2(100),
COP_NAME VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating USERS...
create table USERS
(
USERNAME VARCHAR2(40),
PASSWORD VARCHAR2(40),
ID NUMBER,
NAME VARCHAR2(100),
AGE VARCHAR2(10),
TELPHONE VARCHAR2(100),
ROLE VARCHAR2(10),
ADDRESS VARCHAR2(1000),
EMAIL VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for COMPANY...
alter table COMPANY disable all triggers;
prompt Disabling triggers for JOBS...
alter table JOBS disable all triggers;
prompt Disabling triggers for REPLY...
alter table REPLY disable all triggers;
prompt Disabling triggers for RESUME...
alter table RESUME disable all triggers;
prompt Disabling triggers for USERS...
alter table USERS disable all triggers;
prompt Deleting USERS...
delete from USERS;
commit;
prompt Deleting RESUME...
delete from RESUME;
commit;
prompt Deleting REPLY...
delete from REPLY;
commit;
prompt Deleting JOBS...
delete from JOBS;
commit;
prompt Deleting COMPANY...
delete from COMPANY;
commit;
prompt Loading COMPANY...
insert into COMPANY (ID, COP_NAME, COP_MANN, COP_CONT, COP_TEL, COP_MAIL, COP_TEX, COP_ADDR, COP_ZIP, COP_WWW, COP_DESC, USER_ID)
values (1, '浙江XX
计算机公司', 3, 2, '12345678', 'hr@xxcompany.com', '87654321', '浙江杭州舟山东路', '312000', 'www.xxcompany.com.cn', '民营企业,
注册资本1000万元<br>', 3);
commit;
prompt 1 records loaded
prompt Loading JOBS...
insert into JOBS (ID, JOB_NAME, JOP_MANN, JOB_ADDR, JOB_NUM, JOB_GET, JOB_STA, JOB_END, JOB_GRAD, JOB_AGE1, JOB_AGE2, JOB_EXPE, JOB_LANG, JOB_ODEM, JOB_OGET, COP_ID)
values (2, '软件工程师', 1, '杭州', 10, '2000', 2006, 2007, 2, 20, 25, 2, 1, '无', '无', 1);
insert into JOBS (ID, JOB_NAME, JOP_MANN, JOB_ADDR, JOB_NUM, JOB_GET, JOB_STA, JOB_END, JOB_GRAD, JOB_AGE1, JOB_AGE2, JOB_EXPE, JOB_LANG, JOB_ODEM, JOB_OGET, COP_ID)
values (1, '测试工程师', 0, '杭州', 2, '3000', 2006, 2006, 2, 25, 30, 2, 2, '会法语优先', '没有', 1);
commit;
prompt 2 records loaded
prompt Loading REPLY...
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (1, 2, '简历已进入公司人才库', 2, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (2, 2, '谢谢', 2, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (3, 1, '谢谢您的应聘', 1, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (4, 2, '好的,welcome', 3, 2);
commit;
prompt 4 records loaded
prompt Loading RESUME...
insert into RESUME (ID, JOB_ID, INTRO, USER_ID, JOB_NAME, COP_NAME)
values (1, 1, '熟悉JUnit的开发', 1, '测试工程师', '浙江哈哈');
insert into RESUME (ID, JOB_ID, INTRO, USER_ID,