• Home
• org.devocative
• demeter-common
• 1.1
• source code
• dmt_oracle_1.1.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.dmt_oracle_1.1.sql Maven / Gradle / Ivy

ALTER TABLE a_t_dmt_role
	DROP COLUMN b_dynamic;

ALTER TABLE a_t_dmt_role
	ADD e_role_mode NUMBER(10, 0);

-- ---------------

ALTER TABLE t_dmt_role
	DROP COLUMN b_dynamic;

ALTER TABLE t_dmt_role
	ADD e_role_mode NUMBER(10, 0);

UPDATE t_dmt_role
SET e_role_mode = 1;

ALTER TABLE t_dmt_role
	MODIFY e_role_mode NUMBER(10, 0) NOT NULL;

-- ---------------

ALTER TABLE mt_dmt_pageinst_role
	ADD CONSTRAINT uk_dmt_mtPageInstRole UNIQUE (f_page_inst, f_role);

ALTER TABLE mt_dmt_prvlg_role_deny
	ADD CONSTRAINT uk_dmt_mtPrvlgRoleDeny UNIQUE (f_role, f_prvlg);

ALTER TABLE mt_dmt_prvlg_role_perm
	ADD CONSTRAINT uk_dmt_mtPrvlgRolePerm UNIQUE (f_role, f_prvlg);

ALTER TABLE mt_dmt_prvlg_user_deny
	ADD CONSTRAINT uk_dmt_mtPrvlgUserDeny UNIQUE (f_user, f_prvlg);

ALTER TABLE mt_dmt_prvlg_user_perm
	ADD CONSTRAINT uk_dmt_mtPrvlgUserPerm UNIQUE (f_user, f_prvlg);

ALTER TABLE mt_dmt_user_role
	ADD CONSTRAINT uk_dmt_mtUserRole UNIQUE (f_user, f_role);