Table llx usergroup user - Revision history

Simnandez: /* Structure */

2011-07-19T16:03:37Z

Structure

← Older revision		Revision as of 16:03, 19 July 2011
Line 16:		Line 16:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 51:		Line 50:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

Simnandez: /* Structure */

2009-11-09T15:38:15Z

Structure

← Older revision		Revision as of 15:38, 9 November 2009
Line 15:		Line 15:

	= Structure =		= Structure =
			== Table ==
			'''Version 1.1 2009/10/07'''
	{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"		{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 26:		Line 28:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 35:		Line 37:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\|		\| UNI
	\|		\|
	\|		\|
Line 43:		Line 45:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\|		\| UNI
	\|		\|
	\|		\|
	\| ID of user group ([[Table llx_usergroup\|llx_usergroup]]->rowid)		\| ID of user group ([[Table llx_usergroup\|llx_usergroup]]->rowid)
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
			\|style="background-color: #e9e9ef"\| <b>Key</b>
			\|style="background-color: #e9e9ef"\| <b>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Fields</b>
			\|-
			\| PRIMARY
			\| PRIMARY
			\| rowid
			\|-
			\| fk_user
			\| UNIQUE
			\| fk_user,fk_usergroup
			\|}

Simnandez: /* Structure */

2009-09-21T08:19:52Z

Structure

← Older revision		Revision as of 08:19, 21 September 2009
Line 34:		Line 34:
	\| fk_user		\| fk_user
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\|
	\|		\|
	\|		\|
	\| ID of user		\| ID of user ([[Table llx_user\|llx_user]]->rowid)
	\|-		\|-
	\| fk_usergroup		\| fk_usergroup
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\|
	\|		\|
	\|		\|
	\| ID of user group		\| ID of user group ([[Table llx_usergroup\|llx_usergroup]]->rowid)
	\|}		\|}

Simnandez: /* Contenu */

2009-09-21T08:18:31Z

Contenu

← Older revision		Revision as of 08:18, 21 September 2009
Line 6:		Line 6:


	= Contenu =		= Content/Contenu/Contenido =

			{{flag_en}} Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]

	Contient les liens entre [[Table llx_user\|llx_user]] et [[Table llx_usergroup\|llx_usergroup]]		{{flag_fr}} Contient les liens entre [[Table llx_user\|llx_user]] et [[Table llx_usergroup\|llx_usergroup]]

	~~Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]~~		{{flag_sp}} Contiene los enlaces entre [[Table llx_user\|llx_user]] y [[Table llx_usergroup\|llx_usergroup]]

	Contiene los enlaces entre [[Table llx_user\|llx_user]] y [[Table llx_usergroup\|llx_usergroup]]

	= Structure =		= Structure =

Simnandez: /* Structure */

2009-05-06T07:17:16Z

Structure

← Older revision		Revision as of 07:17, 6 May 2009
Line 47:		Line 47:
	\|		\|
	\|		\|
	\| ID of group ~~user~~		\| ID of user group
	\|}		\|}

Simnandez: /* Structure */

2009-05-06T07:16:50Z

Structure

← Older revision		Revision as of 07:16, 6 May 2009
Line 31:		Line 31:
	\| NULL		\| NULL
	\| auto_increment		\| auto_increment
	\| index ~~technique~~		\| technical index
	\|-		\|-
	\| fk_user		\| fk_user
Line 39:		Line 39:
	\|		\|
	\|		\|
	\|		\| ID of user
	\|-		\|-
	\| fk_usergroup		\| fk_usergroup
Line 47:		Line 47:
	\|		\|
	\|		\|
	\|		\| ID of group user
	\|}		\|}

Simnandez at 08:07, 4 May 2009

2009-05-04T08:07:20Z

← Older revision		Revision as of 08:07, 4 May 2009
Line 1:		Line 1:
	[[Category:Table SQL]]		[[Category:Table SQL]]
	[[Category:Utilisateurs]]		[[Category:Utilisateurs]]
			[[Category:Users]]
			[[Category:Usuarios]]
	{{ListOfTables}}		{{ListOfTables}}

Simnandez: /* Structure */

2009-05-04T08:06:51Z

Structure

← Older revision		Revision as of 08:06, 4 May 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
	~~<pre>~~		\|style="background-color: #e9e9ef"\| <b>Field</b>
	-- =======~~=====================================================================~~		\|style="background-color: #e9e9ef"\| <b>Type</b>
	-- ~~Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>~~		\|style="background-color: #e9e9ef"\| <b>Null</b>
	--		\|style="background-color: #e9e9ef"\| <b>Key</b>
	-- ~~This program is free software; you can redistribute it and~~/~~or modify~~		\|style="background-color: #e9e9ef"\| <b>Default</b>
	-~~- it under the terms of the GNU General Public License as published by~~		\|style="background-color: #e9e9ef"\| <b>Extra</b>
	-~~- the Free Software Foundation; either version 2 of the License, or~~		\|style="background-color: #e9e9ef"\| <b>Description</b>
	-~~- (at your option) any later version.~~		\|-
	--		\| rowid
	-~~- This program is distributed in the hope that it will be useful,~~		\| int(11)
	-~~- but WITHOUT ANY WARRANTY; without even the implied warranty of~~		\|
	~~-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the~~		\| PRI
	~~-- GNU General Public License for more details.~~		\| NULL
	--		\| auto_increment
	~~-- You should have received a copy of the GNU General Public License~~		\| index technique
	~~-- along with this program; if not, write to the Free Software~~		\|-
	~~-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.~~		\| fk_user
	--		\| int(11)
	-~~- $Id: llx_usergroup_user.sql,v 1.1 2005/01/27 15:13:02 rodolphe Exp $~~		\|
	~~-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_usergroup_user.sql,v $~~		\|
	--		\|
	~~-- ===========================================================================~~		\|
			\|
	~~create table llx_usergroup_user~~		\|-
	(		\| fk_usergroup
	~~rowid integer AUTO_INCREMENT PRIMARY KEY,~~		\| int(11)
	~~fk_user integer NOT NULL,~~		\|
	fk_usergroup ~~integer NOT NULL,~~		\|
			\|
	~~UNIQUE~~(~~fk_user,fk_usergroup~~)		\|
	~~)type=innodb~~;		\|
	~~</pre>~~		\|}

Simnandez: /* Contenu */

2009-05-04T08:00:52Z

Contenu

← Older revision		Revision as of 08:00, 4 May 2009
Line 10:		Line 10:

	Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]		Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]

			Contiene los enlaces entre [[Table llx_user\|llx_user]] y [[Table llx_usergroup\|llx_usergroup]]

	= Structure =		= Structure =

Eldy at 19:13, 12 March 2009

2009-03-12T19:13:24Z

← Older revision		Revision as of 19:13, 12 March 2009
Line 1:		Line 1:
	[[Category:Table SQL]]		[[Category:Table SQL]]
	~~La documentation relative aux autres tables est disponible sur la page~~ [[~~Liste des tables~~]]		[[Category:Utilisateurs]]
	~~The documentation related to other tables is available on the tables list page: [[Liste des tables]]~~		{{ListOfTables}}


	= Contenu =		= Contenu =


	Contient les liens entre [[Table llx_user]] et [[Table llx_usergroup]]		Contient les liens entre [[Table llx_user\|llx_user]] et [[Table llx_usergroup\|llx_usergroup]]

	Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]		Contains the link between [[Table llx_user\|llx_user]] and [[Table llx_usergroup\|llx_usergroup]]