Ferreteria/sql/ugroup x upermit

From Woozle Writes Code
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>