Ferreteria/sql/uacct x ugroup: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(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...")
 
m (3 revisions imported: moving this project here)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': user-to-ugroup assignment map
* '''Purpose''': user-to-ugroup assignment map
* '''Requires''': {{l/same|user}}, {{l/same|ugroup}}
* '''Requires''': {{l/same|user_account}}, {{l/same|user_group}}
* '''History''':
* '''History''':
** '''2013-11-27''' written
** '''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==
==SQL==
<mysql>CREATE TABLE `user_x_ugroup` (
<mysql>CREATE TABLE `uacct_x_ugroup` (
   `ID_User` INT             NOT NULL,
   `ID_Acct`   INT   NOT NULL,
   `ID_UGrp`  INT             NOT NULL,
   `ID_Group`  INT   NOT NULL,
   PRIMARY KEY(`ID_User`,`ID_UGrp`)
   PRIMARY KEY(`ID_Acct`,`ID_Group`)
) ENGINE=MyISAM;</mysql>
) ENGINE=InnoDB;</mysql>

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>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/uacct_x_ugroup&oldid=1746"