<
From version < 2.1 >
edited by Manuel Smeria
on 2013/02/22
To version < 3.3 >
edited by Vincent Massol
on 2017/09/04
>
Change comment: Update document after refactoring.

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -DevGuide.DatabaseSchema
1 +xwiki:Documentation.DevGuide.DatabaseSchema.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ManuelSmeria
1 +XWiki.VincentMassol
Content
... ... @@ -1,68 +1,7 @@
1 -{{html clean="false" wiki="true"}}
1 +This table contains the data for long properties in XWiki Objects.
2 2  
3 -<style>
4 -td, th {border-bottom:1px solid #666}
5 -table.dbtable{border:1px solid #666;border-bottom:0px}
6 -th {background-color:#EFEFEF}
7 -.db0{width:1%;border-right:1px solid #666;}
8 -.db1{width:25%;border-right:1px solid #666}
9 -.db2{width:10%;border-right:1px solid #666}
10 -.db3{width:7%;border-right:1px solid #666}
11 -.db4{width:7%;border-right:1px solid #666}
12 -.db5{width:10%;border-right:1px solid #666}
13 -.db6{width:20%;border-right:1px solid #666}
14 -.db7{width:20%}
15 -.dbhead{background-color:#CCC;font-weight:bold}
16 -</style>
17 -
18 -=== XWiki Longs (xwikilongs) ===
19 -
20 -This table contain the data for long properties in XWiki Objects.
21 -<p/>
22 -<table border="0" width="100%" class="dbtable" cellpadding="3"
23 - cellspacing="0">
24 - <tr>
25 - <td colspan="8" class="dbhead">xwikilongs</td>
26 - </tr>
27 - <tr>
28 - <th class="db0">&nbsp;</th>
29 - <th class="db1">Column Name</th>
30 - <th class="db2">Datatype</th>
31 - <th class="db3">Not null</th>
32 - <th class="db4">auto inc</th>
33 - <th class="db5">flags</th>
34 - <th class="db6">Default Value</th>
35 - <th class="db7">Comments</th>
36 - </tr>
37 - <tr>
38 - <td class="db0">[[image:[email protected]_key.gif||height="16" width="16"]]</td>
39 - <td class="db1">XWL_ID</td>
40 - <td class="db2">INTEGER</td>
41 - <td class="db3">[[image:[email protected]_check.gif||height="16" width="16"]]</td>
42 - <td class="db4">&nbsp;</td>
43 - <td class="db5">&nbsp;</td>
44 - <td class="db6">0</td>
45 - <td class="db7">&nbsp;</td>
46 - </tr>
47 - <tr>
48 - <td class="db0">[[image:[email protected]_key.gif||height="16" width="16"]]</td>
49 - <td class="db1">XWL_NAME</td>
50 - <td class="db2">VARCHAR(255)</td>
51 - <td class="db3">[[image:[email protected]_check.gif||height="16" width="16"]]</td>
52 - <td class="db4">&nbsp;</td>
53 - <td class="db5">&nbsp;</td>
54 - <td class="db6">&nbsp;</td>
55 - <td class="db7">&nbsp;</td>
56 - </tr>
57 - <tr>
58 - <td class="db0">[[image:[email protected]_field.gif||height="16" width="16"]]</td>
59 - <td class="db1">XWL_VALUE</td>
60 - <td class="db2">BIGINT(20)</td>
61 - <td class="db3">&nbsp;</td>
62 - <td class="db4">&nbsp;</td>
63 - <td class="db5">&nbsp;</td>
64 - <td class="db6">null</td>
65 - <td class="db7">&nbsp;</td>
66 - </tr>
67 -</table>
68 -{{/html}}
3 +|=(% colspan='8'%)xwikilongs(%%)
4 +|= |=Column Name |=Datatype |=Not null |=auto inc |=flags |=Default value |=Comments
5 +|[[image:[email protected]_key.gif]]|XWL_ID|INTEGER |[[image:[email protected]_check.gif]] | | | 0|
6 +|[[image:[email protected]_key.gif]]|XWL_NAME |VARCHAR(255) |[[image:[email protected]_check.gif]] | | | |
7 +|[[image:[email protected]_field.gif]]|XWL_VALUE|BIGINT(20) | | | |null |

Get Connected