【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“createPersonal.sql”一文,供大家参考学习
CREATE USER "PERSONAL" IDENTIFIED BY "PERSONAL"
DEFAULT TABLESPACE USERS
QUOTA UNLIMITED ON USERS;
GRANT "AQ_ADMINISTRATOR_ROLE" TO "PERSONAL" WITH ADMIN OPTION;
GRANT "DBA" TO "PERSONAL" WITH ADMIN OPTION;
GRANT "SALES_HISTORY_ROLE" TO "PERSONAL" WITH ADMIN OPTION;
ALTER USER "PERSONAL" DEFAULT ROLE "AQ_ADMINISTRATOR_ROLE",
"DBA",
"SALES_HISTORY_ROLE";
DROP TABLE nation;
CREATE TABLE nation (
nationname VARCHAR2(20) NOT NULL,
PRIMARY KEY(nationname)
);
DROP TABLE business;
CREATE TABLE business (
businessname VARCHAR2(50) NOT NULL,
PRIMARY KEY(businessname)
);
DROP TABLE typeofwork;
CREATE TABLE typeofwork (
typeofworkname VARCHAR2(50) NOT NULL,
PRIMARY KEY(typeofworkname)
);
DROP TABLE dept;
CREATE TABLE dept (
deptname VARCHAR2(30) NOT NULL,
PRIMARY KEY(deptname)
);
DROP TABLE personal;
CREATE TABLE personal (
personalid VARCHAR2(20) NOT NULL,
name VARCHAR2(20),
sex VARCHAR2(5),
nationname VARCHAR2(20),
politics VARCHAR2(20),
diploma VARCHAR2(20),
businessname VARCHAR2(50),
typeofworkname VARCHAR2(50),
deptname VARCHAR2(50),
birthdate VARCHAR2(30),
folddate VARCHAR2(30),
joinworkdate VARCHAR2(30),
homeaddr VARCHAR2(1000),
phone VARCHAR2(20),
mobile VARCHAR2(20),
email VARCHAR2(50),
identitycard VARCHAR2(20),
basepay VARCHAR2(20),
PRIMARY KEY(personalid)
);