Ferreteria/sql/uacct x ugroup: Difference between revisions

Revision as of 00:46, 27 January 2017

Purpose: user-to-ugroup assignment map
Requires: user_account, user_group
History:
- 2013-11-27 written
- 2017-01-26 moved to Ferreteria, renamed from "user_x_ugroup" to "uacct_x_ugroup"
  - changed from MyISAM to InnoDB
  - changed ID_User to ID_Acct
  - changed ID_UGrp to ID_Group

<mysql>CREATE TABLE `uacct_x_ugroup` (

 `ID_Acct`   INT    NOT NULL,
 `ID_Group`  INT    NOT NULL,
 PRIMARY KEY(`ID_Acct`,`ID_Group`)

) ENGINE=InnoDB;</mysql>

@@ Line 1: / Line 1: @@
 ==About==
 * '''Purpose''': user-to-ugroup assignment map
-* '''Requires''': {{l/same|user}}, {{l/same|ugroup}}
+* '''Requires''': {{l/same|user_account}}, {{l/same|user_group}}
 * '''History''':
 ** '''2013-11-27''' written
+** '''2017-01-26''' moved to Ferreteria, renamed from "user_x_ugroup" to "uacct_x_ugroup"
+*** changed from MyISAM to InnoDB
+*** changed ID_User to ID_Acct
+*** changed ID_UGrp to ID_Group
 ==SQL==
-<mysql>CREATE TABLE `user_x_ugroup` (
+<mysql>CREATE TABLE `uacct_x_ugroup` (
-   `ID_User`  INT              NOT NULL,
+   `ID_Acct`   INT    NOT NULL,
-   `ID_UGrp`  INT              NOT NULL,
+   `ID_Group`  INT    NOT NULL,
-   PRIMARY KEY(`ID_User`,`ID_UGrp`)
+   PRIMARY KEY(`ID_Acct`,`ID_Group`)
-) ENGINE=MyISAM;</mysql>
+) ENGINE=InnoDB;</mysql>