Changes

m
no edit summary
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
|}
+
|}&nbsp;
 +
==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
 +
|}&nbsp;