Table llx usergroup user: Difference between revisions

Jump to navigation Jump to search

Table llx usergroup user (view source)

Revision as of 08:06, 4 May 2009

564 bytes removed ,  17 years ago
→‎Structure
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>
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/10709"

Navigation menu