4,395
edits
Changes
→Structure
Line 11:
Line 11:
create table llx_user_entrepot+(+ rowid integer AUTO_INCREMENT PRIMARY KEY,+ fk_entrepot integer UNSIGNED, -- pointe sur llx_entrepot+ fk_user integer UNSIGNED, -- pointe sur llx_user+ consult tinyint(1) UNSIGNED,+ send tinyint(1) UNSIGNED+)type=innodb;+
= 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"
− |style="background-color: #e9e9ef"| <b>Field</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
− |style="background-color: #e9e9ef"| <b>Null</b>
− |style="background-color: #e9e9ef"| <b>Key</b>
− |style="background-color: #e9e9ef"| <b>Default</b>
− |style="background-color: #e9e9ef"| <b>Extra</b>
− |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+|
+| PRI
+| NULL
+| auto_increment
+| index technique
+|-
+| fk_entrepot
+| int(10)
+| YES
+|
+| NULL
+|
+| pointe sur llx_entrepot
+|-
+| fk_user
+| int(10)
+| YES
+|
+| NULL
+|
+| pointe sur llx_user
+|-
+| consult
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|-
+| send
+| tinyint(1)
+| YES
+|
+| NULL
+|
+|
+|}