/*mySql数据库*/
/*使用root角色密码为mysql*/
drop database hr;
create database hr;
use hr;
--查看数据库编码
show create database hr;
--数据库编码改成utf8
alter database hr default character set utf8;
/*用户表*/
create table users
(
cid int primary key auto_increment,
username varchar(30),
password varchar(30)
);
/*用户表序列,oracle可以这样创建序列，mySql用auto_increment设自增长
CREATE SEQUENCE users_seq
INCREMENT BY 1
START WITH 1; */
--insert into users (cid,username,password) values(users_seq.nextval,'admin','admin');
insert into users (username,password) values('admin','admin');
insert into users (username,password) values('admin2','admin2');
/*菜单*/
create table menu
(
id int primary key auto_increment,
name varchar(30),
value varchar(100),
field1 int
);
insert into menu(name,value,field1) values('首页','/Hr/login.jsp',0);
insert into menu(name,value,field1) values('人员管理','',0);
insert into menu(name,value,field1) values('增加人员','/Hr/HumanResource/person/createPerson/createPerson.jsp',2);
insert into menu(name,value,field1) values('查询人员','/Hr/HumanResource/person/personList/personList.jsp',2);
/*性别码表*/
create table sex (
cid varchar(10) primary key,
name varchar(10)
);
/*人员表*/
create table person (
oid int primary key auto_increment, /*代理主键*/
personId varchar(10), /*人员id*/
personName varchar(20), /*姓名*/
sex varchar(10), /*性别*/
cardId varchar(20), /*身份证号*/
address varchar(50), /*地址*/
phone varchar(20), /*电话*/
image varchar(200) /*照片*/
);
ALTER TABLE person ADD mark varchar(10);/*增加一列，作为标志位，1：有效，0：无效*/
update person set mark=1;/*初始值为1有效*/
order by oid desc limit 0,10
