Ferreteria/sql/ugroup x upermit

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 15:29, 27 November 2013 by htyp>Woozle (Created page with "==About== * '''Purpose''': ugroup-to-uperm assignment map * '''Requires''': {{l/same|ugroup}}, {{l/same|uperm}} * '''History''': ** '''2013-11-27''' written ==SQL== <mysql>CRE...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: ugroup-to-uperm assignment map
  • Requires: ugroup, uperm
  • History:
    • 2013-11-27 written

SQL

<mysql>CREATE TABLE `ugroup_x_uperm` (

 `ID_UGrp`  INT              NOT NULL,
 `ID_UPrm`  INT              NOT NULL,
 PRIMARY KEY(`ID_UGrp`,`ID_UPrm`)

) ENGINE=MyISAM;</mysql>