Ferreteria/sql/uacct x ugroup: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(post-move adjustments) |
m (3 revisions imported: moving this project here) |
(No difference)
|
Latest revision as of 16:42, 22 May 2022
About
- 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
SQL
<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>