Ferreteria/sql/ugroup x upermit: Difference between revisions

Latest revision as of 16:42, 22 May 2022

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

<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>

@@ Line 1: / Line 1: @@
 ==About==
-* '''Purpose''': ugroup-to-uperm assignment map
+* '''Purpose''': ugroup-to-upermit assignment map
-* '''Requires''': {{l/same|ugroup}}, {{l/same|uperm}}
+* '''Requires''': {{l/same|user_group}}, {{l/same|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_UGrp`  INT              NOT NULL,
+   `ID_Group`   INT              NOT NULL,
-   `ID_UPrm`  INT              NOT NULL,
+   `ID_Permit`  INT              NOT NULL,
-   PRIMARY KEY(`ID_UGrp`,`ID_UPrm`)
+   PRIMARY KEY(`ID_Group`,`ID_Permit`)
-) ENGINE=MyISAM;</mysql>
+) ENGINE=InnoDB;</mysql>