CREATE TABLE tb_corporation_and_user
(
	user_id int(10) NOT NULL,
	corporation_id int(10) NOT NULL,
	role_id int(10) NOT NULL,

	PRIMARY KEY(user_id, corporation_id),
	FOREIGN KEY(user_id) REFERENCES tb_user(id),
	FOREIGN KEY(corporation_id) REFERENCES tb_corporation(id),
	FOREIGN KEY(role_id) REFERENCES tb_role(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE tb_corporation
	ADD COLUMN access_type TINYINT NOT NULL COMMENT '权限控制, 10普通, 20公开'
		DEFAULT 10;

ALTER TABLE tb_corporation
	ADD COLUMN `desc` text NOT NULL COMMENT '备注';

ALTER TABLE tb_project
	ADD COLUMN access_type TINYINT NOT NULL COMMENT '权限控制, 10普通, 0私有'
		DEFAULT 10;

CREATE TABLE tb_rule (
	action_id int(10) NOT NULL
		PRIMARY KEY,  
	rules text NOT NULL, -- JSON规则
	update_time datetime NOT NULL
		DEFAULT NOW(),   -- 最近更新时间

	FOREIGN KEY(action_id) REFERENCES tb_action(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 将老的团队全部设为公开
UPDATE tb_corporation SET access_type = 20;

ALTER TABLE `rap_db`.`tb_module` CHANGE COLUMN `name` `name` VARCHAR(256) NOT NULL  ;
ALTER TABLE `rap_db`.`tb_action` ADD COLUMN disable_cache TINYINT NOT NULL DEFAULT 0;

ALTER TABLE tb_project
ADD COLUMN mock_num int(10) NOT NULL
	DEFAULT 0

ALTER TABLE tb_user
    ADD emp_id varchar(128) NULL