Ferreteria/sql/ugroup x upermit
< Ferreteria | sql
Jump to navigation
Jump to search
About
- Purpose: ugroup-to-upermit assignment map
- Requires: user_group, user_permit
- History:
- 2013-11-27 written
- 2017-01-26 moved to Ferreteria, renamed from ugroup_x_uperm to ugroup_x_upermit
- changed from MyISAM to InnoDB
- renamed ID_UGrp to ID_Group
- renamed ID_UPrm to ID_Permit
SQL
<mysql>CREATE TABLE `ugroup_x_uperm` (
`ID_Group` INT NOT NULL, `ID_Permit` INT NOT NULL, PRIMARY KEY(`ID_Group`,`ID_Permit`)
) ENGINE=InnoDB;</mysql>