Ferreteria/sql/uacct x ugroup

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

About

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

SQL

<mysql>CREATE TABLE `user_x_ugroup` (

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

) ENGINE=MyISAM;</mysql>