Ferreteria/sql/uacct x ugroup

From Woozle Writes Code
Jump to navigation Jump to search

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>