Table llx usergroup user: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
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
| &nbsp;
-- 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 $
| &nbsp;
-- $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,
| &nbsp;
  fk_usergroup integer NOT NULL,
|
 
|
  UNIQUE(fk_user,fk_usergroup)
|
)type=innodb;
|
</pre>
|}

Revision as of 08:06, 4 May 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Contenu

Contient les liens entre llx_user et llx_usergroup

Contains the link between llx_user and llx_usergroup

Contiene los enlaces entre llx_user y llx_usergroup

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment index technique
fk_user int(11)  
fk_usergroup int(11)  
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_usergroup_user&oldid=10709"