Line 1:
Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
−
+
[[Category:Bookmarks]]
+
[[Category:Marque pages]]
+
[[Category:Marcadores]]
+
{{ListOfTables}}
{{ListOfTables}}
Line 12:
Line 15:
= Structure =
= Structure =
−
'''Version 1.8 2007/12/02'''
+
== Table ==
−
+
{| 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 27:
Line 29:
| NO
| NO
| PRI
| PRI
−
| NULL
+
|
| auto_increment
| auto_increment
| technical index
| technical index
−
|-
−
| fk_soc
−
| int(11)
−
| YES
−
|
−
| NULL
−
|
−
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| fk_user
| fk_user
Line 86:
Line 80:
|
|
| favicon of bookmark
| favicon of bookmark
−
|}
+
|}
+
==Keys==
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+
|style="background-color: #e9e9ef"| <b>Key</b>
+
|style="background-color: #e9e9ef"| <b>Type</b>
+
|style="background-color: #e9e9ef"| <b>Fields</b>
+
|-
+
| PRIMARY
+
| PRIMARY
+
| rowid
+
|-
+
| uk_bookmark_url
+
| UNIQUE
+
| fk_user,url
+
|-
+
| uk_bookmark_title
+
| UNIQUE
+
| fk_user,title
+
|}