oracle

create temporary tablespace root_temp 
tempfile 'E:\Data\root_temp.dbf' 
size 10m 
autoextend on 
next 10m maxsize 20480m 
extent management local;

create tablespace root 
logging 
datafile 'E:\Data\root.dbf' 
size 10m 
autoextend on 
next 10m maxsize 20480m 
extent management local; 

create user root identified by root 
default tablespace root
temporary tablespace root_temp;

grant connect,resource,dba to root;

grant unlimited tablespace to root;

select username,default_tablespace from user_users;

DROP TABLE IF EXISTS `privileges`;

CREATE TABLE "privileges" (
  "id" NUMBER NOT NULL ,
  "name" VARCHAR2(20) NOT NULL,
  "fnpath" VARCHAR2(100) NOT NULL,
  "description" VARCHAR2(200) DEFAULT NULL,
  PRIMARY KEY ("id")
)
--唯一约束
alter table "privileges"
 add  constraint uq_gradename  unique("name");
 

/*1.创建序列 实现自增长*/
create sequence pri_seq
start with 1
increment by 1
maxvalue 1000
nocycle
nocache;
-- 添加权限
INSERT INTO "privileges" VALUES ('1', '添加商品', '/function/add_product.jsp', '添加商品权限');
INSERT INTO "privileges" VALUES ('2', '删除商品', '/function/delete_product.jsp', '删除商品权限');
INSERT INTO "privileges" VALUES ('3', '修改商品', '/function/update_product.jsp', '修改商品权限');
INSERT INTO "privileges" VALUES ('4', '查询商品列表', '/functionst_product.jsp', '查看商品列表权限');
INSERT INTO "privileges" VALUES ('5', '添加用户', '/function/add_user.jsp', '添加用户权限');
INSERT INTO "privileges" VALUES ('6', '冻结用户', '/function/disable_user.jsp', '冻结用户权限');
INSERT INTO "privileges" VALUES ('7', '修改用户', '/function/update_user.jsp', '修改用户权限');
INSERT INTO "privileges" VALUES ('8', '角色授权', '/function/grant_role.jsp', '角色授权权限');
INSERT INTO "privileges" VALUES ('9', '添加角色', '/function/add_role.jsp', '添加角色权限');
INSERT INTO "privileges" VALUES ('10', '删除角色', '/function/delete_role.jsp', '删除角色权限');
INSERT INTO "privileges" VALUES ('11', '修改角色', '/function/add_role.jsp', '修改角色权限');
INSERT INTO "privileges" VALUES ('12', '角色列表', '/functionst_role.jsp', '角色列表权限');
INSERT INTO "privileges" VALUES ('13', '权限赋予', '/function/grant_privilege.jsp', '权限赋予权限');
INSERT INTO "privileges" VALUES ('14', '添加权限', '/function/add_privilege.jsp', '添加权限权限');
INSERT INTO "privileges" VALUES ('15', '删除权限', '/function/delete_privilege.jsp', '删除权限权限');
INSERT INTO "privileges" VALUES ('16', '修改权限', '/function/update_privilege.jsp', '修改权限权限');
INSERT INTO "privileges" VALUES ('17', '查询权限列表', '/function/add_privilege.jsp', '查询权限列表权限');
INSERT INTO "privileges" VALUES ('18', '支付订单权限', '/function/pay.jsp', '支付订单权限');
INSERT INTO "privileges" VALUES ('19', '后台管理', '/admin.jsp', '后台管理权限');
INSERT INTO "privileges" VALUES ('20', '查看用户列表', '/functionst_user.jsp', '查看所有用户权限');
INSERT INTO "privileges" VALUES ('21', '干掉管理员', 'function/deleteadmin.jsp', '我是超级管理员，我要干掉所有人');
INSERT INTO "privileges" VALUES ('22', '一个特别牛逼的权限', '/jsp/privilege_add.jsp', '牛逼到不知道到有什么用的权限');
INSERT INTO "privileges" VALUES ('23', '黄金VIP', '/jsp/privilege_add.jsp', '很厉害的。。。');
INSERT INTO "privileges" VALUES ('24', '白金VIP', '/jsp/privilege_add.jsp', '白金VIP权限');
INSERT INTO "privileges" VALUES ('25', '钻石VIP', '/jsp/privilege_add.jsp', '钻石VIP权限');
INSERT INTO "privileges" VALUES ('26', '黄金&白金VIP', '/jsp/privilege_add.jsp', '黄金&白金VIP权限');
INSERT INTO "privileges" VALUES ('27', '黄金钻石VIP', '/jsp/welcome.jsp', '黄金钻石VIP');

-- 创建角色表
/*1.创建序列 实现自增长*/
create sequence roles_seq
start with 1
increment by 1
maxvalue 1000
nocycle
nocache;
CREATE TABLE "roles" (
  "id" NUMBER(11) NOT NULL ,
  "name" VARCHAR2(20) NOT NULL,
  "description" VARCHAR2(200) DEFAULT NULL,
  PRIMARY KEY ("id")
) 
INSERT INTO "roles" VALUES ('1', '管理员', '具有全部权限');
INSERT INTO "roles" VALUES ('2', '普通用户', '具有查看修改个人信息，支付权限');
INSERT INTO "roles" VALUES ('3', 'new角色', 'new角色//././');
-- INSERT INTO "roles" VALUES (roles_seq.nextval, 'new角色', 'new角色//././');
--创建用户
 /*1.创建序列 实现自增长*/
create sequence users_seq
start with 1
increment by 1
maxvalue 1000
nocycle
nocache;

CREATE TABLE "users" (
  "id" NUMBER(11) NOT NULL,
  "username" VARCHAR2(20) NOT NULL,
  "password" VARCHAR2(50) NOT NULL,
  "nickname" VARCHAR2(20) NOT NULL,
  PRIMARY KEY ("id")
)

INSERT INTO "users" VALUES ('1', 'admin', 'admin', '管理员');
INSERT INTO "users" VALUES ('2', 'zhangsan', '123456', '张小三');
INSERT INTO "users" VALUES ('3', 'lisi', 'lisi', '李小四');