Table llx boxes def - Revision history

Eldy at 07:37, 1 April 2022

2022-04-01T07:37:57Z

← Older revision		Revision as of 07:37, 1 April 2022
Line 45:		Line 45:
	\|int(11)		\|int(11)
	\|NO		\|NO
	\|~~PRI~~		\|
	\|1		\|1
	\|		\|
	\|multi company id		\|multi company id
			\|-
			\|fk_user
			\|int(11)
			\|NO
			\|
			\|0
			\|
			\|if widget is private to one given user
	{{FieldTms}}		{{FieldTms}}
	\|-		\|-
Line 61:		Line 69:

	==Keys==		==Keys==
	'''Version ~~Dolibarr 15~~'''		'''Version 1.2 2009/10/17'''
	{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"		{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\| style="background-color: #e9e9ef" \|<b>Key</b>		\| style="background-color: #e9e9ef" \|<b>Key</b>
Line 73:		Line 81:
	\|uk_boxes_def		\|uk_boxes_def
	\|UNIQUE		\|UNIQUE
	\|file, entity~~, note~~		\|file,entity
	\|}		\|}

Udo.tamm: /* Keys */

2022-03-31T22:37:13Z

Keys

← Older revision		Revision as of 22:37, 31 March 2022
Line 61:		Line 61:

	==Keys==		==Keys==
	'''Version ~~1.2 2009/10/17~~'''		'''Version Dolibarr 15'''
	{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"		{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\| style="background-color: #e9e9ef" \|<b>Key</b>		\| style="background-color: #e9e9ef" \|<b>Key</b>
Line 73:		Line 73:
	\|uk_boxes_def		\|uk_boxes_def
	\|UNIQUE		\|UNIQUE
	\|file,entity		\|file, entity, note
	\|}		\|}

Udo.tamm: /* Table */

2022-03-31T22:36:01Z

Table

← Older revision		Revision as of 22:36, 31 March 2022
Line 3:		Line 3:
	{{ListOfTables}}		{{ListOfTables}}

	= Content/Contenu/Contenido =		=Content/Contenu/Contenido=

	{{flag en}} Contains the active boxes		{{flag en}}
			Contains the active boxes

	{{flag fr}} Contient les boîtes actives		{{flag fr}}
			Contient les boîtes actives

	{{flag sp}} Contiene las cajas activas.		{{flag sp}}
			Contiene las cajas activas.

	= Structure =		=Structure=
	== Table ==		==Table==
	'''Version ~~1.1 2009/10/07~~'''		'''Version Dolibarr 15'''
	{\| ~~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"		{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\|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>
	\|style="background-color: #e9e9ef"\| <b>Null</b>		\| style="background-color: #e9e9ef" \|<b>Null</b>
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\| style="background-color: #e9e9ef" \|<b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Default</b>		\| style="background-color: #e9e9ef" \|<b>Default</b>
	\|style="background-color: #e9e9ef"\| <b>Extra</b>		\| style="background-color: #e9e9ef" \|<b>Extra</b>
	\|style="background-color: #e9e9ef"\| <b>Description</b>		\| style="background-color: #e9e9ef" \|<b>Description</b>
	\|-		\|-
	\| rowid		\|rowid
	\| int(11)		\|int(11)
	\| NO		\|NO
	\| PRI		\|PRI
	\|		\|
	\| auto_increment		\|auto_increment
	\| technical index		\|technical index
	\|-		\|-
	\| file		\|file
	\| varchar(~~255~~)		\|varchar(200)
	\| NO		\|NO
	\|		\|
	\|		\|
	\|		\|
	\| box file.php		\|box file.php
	\|-		\|-
	\| entity		\|entity
	\| int(11)		\|int(11)
	\| NO		\|NO
	\| PRI		\|PRI
	\| 1		\|1
	\|		\|
	\| multi company id		\|multi company id
	{{FieldTms}}		{{FieldTms}}
	\|-		\|-
	\| note		\|note
	\| varchar(~~255~~)		\|varchar(130)
	\| YES		\|YES
	\|		\|
	\| NULL		\|NULL
	\|		\|
	\| comments		\|comments
	\|}		\|}

	== Keys ==		==Keys==
	'''Version 1.2 2009/10/17'''		'''Version 1.2 2009/10/17'''
	{\| ~~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"		{\| rules="all" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\|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>
	\|style="background-color: #e9e9ef"\| <b>Fields</b>		\| style="background-color: #e9e9ef" \|<b>Fields</b>
	\|-		\|-
	\| PRIMARY		\|PRIMARY
	\| PRIMARY		\|PRIMARY
	\| rowid		\|rowid
	\|-		\|-
	\| uk_boxes_def		\|uk_boxes_def
	\| UNIQUE		\|UNIQUE
	\| file,entity		\|file,entity
	\|}		\|}

Eldy: /* Table */

2012-08-10T12:32:11Z

Table

← Older revision		Revision as of 12:32, 10 August 2012
Line 46:		Line 46:
	\|		\|
	\| multi company id		\| multi company id
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| note		\| note

Eldy: /* Table */

2010-08-13T23:35:53Z

Table

← Older revision		Revision as of 23:35, 13 August 2010
Line 56:		Line 56:
	\|-		\|-
	\| note		\| note
	\| ~~text~~		\| varchar(255)
	\| YES		\| YES
	\|		\|
Line 63:		Line 63:
	\| comments		\| comments
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.2 2009/10/17'''		'''Version 1.2 2009/10/17'''

Simnandez: /* Keys */

2009-10-19T07:41:35Z

Keys

← Older revision		Revision as of 07:41, 19 October 2009
Line 74:		Line 74:
	\| rowid		\| rowid
	\|-		\|-
			\| uk_boxes_def
	\| UNIQUE		\| UNIQUE
	~~\| uk_boxes_def~~
	\| file,entity		\| file,entity
	\|}		\|}

Simnandez: /* Keys */

2009-10-19T06:43:41Z

Keys

← Older revision		Revision as of 06:43, 19 October 2009
Line 64:		Line 64:
	\|}		\|}
	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/10/17'''
	{\| 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>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
Line 72:		Line 72:
	\| PRIMARY		\| PRIMARY
	\| PRIMARY		\| PRIMARY
	\| rowid,entity		\| rowid
			\|-
			\| UNIQUE
			\| uk_boxes_def
			\| file,entity
	\|}		\|}

Simnandez: /* Structure */

2009-10-16T08:26:37Z

Structure

← Older revision		Revision as of 08:26, 16 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
	'''Version 1.7 2009/04/27'''		== 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 27:		Line 27:
	\| NO		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 62:		Line 62:
	\|		\|
	\| comments		\| comments
			\|}
			== 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,entity
	\|}		\|}

Simnandez: /* Structure */

2009-10-05T14:15:10Z

Structure

← Older revision		Revision as of 14:15, 5 October 2009
Line 62:		Line 62:
	\|		\|
	\| comments		\| comments
	\|}		\|}

Simnandez: /* Structure */

2009-10-01T13:20:16Z

Structure

← Older revision		Revision as of 13:20, 1 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
			'''Version 1.7 2009/04/27'''

	{\| 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"
Line 24:		Line 25:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| NULL		\| NULL
Line 32:		Line 33:
	\| file		\| file
	\| varchar(255)		\| varchar(255)
	\| ~~ ~~		\| NO
	\|		\|
	\|		\|
Line 40:		Line 41:
	\| entity		\| entity
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\| PRI
	\| 1		\| 1
	\|		\|
Line 48:		Line 49:
	\| tms		\| tms
	\| timestamp		\| timestamp
	\|		\| NO
	\|		\|
	\| CURRENT_TIMESTAMP		\| CURRENT_TIMESTAMP