Ferreteria/sql/ugroup x upermit: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page VbzCart/tables/ugroup x uperm to Ferreteria/sql/ugroup x upermit without leaving a redirect: and finally, this is also part of Ferreteria user management)
m (3 revisions imported: moving this project here)
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': ugroup-to-uperm assignment map
* '''Purpose''': ugroup-to-upermit assignment map
* '''Requires''': {{l/same|ugroup}}, {{l/same|uperm}}
* '''Requires''': {{l/same|user_group}}, {{l/same|user_permit}}
* '''History''':
* '''History''':
** '''2013-11-27''' written
** '''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==
==SQL==
<mysql>CREATE TABLE `ugroup_x_uperm` (
<mysql>CREATE TABLE `ugroup_x_uperm` (
   `ID_UGrp` INT              NOT NULL,
   `ID_Group`   INT              NOT NULL,
   `ID_UPrm`  INT              NOT NULL,
   `ID_Permit`  INT              NOT NULL,
   PRIMARY KEY(`ID_UGrp`,`ID_UPrm`)
   PRIMARY KEY(`ID_Group`,`ID_Permit`)
) ENGINE=MyISAM;</mysql>
) ENGINE=InnoDB;</mysql>

Latest revision as of 16:42, 22 May 2022

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>

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