Wiki source code of DsXWikiAttachment
Version 1.1 by Helmut Nagy on 2009/02/11
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | <style> | ||
| 2 | td, th {border-bottom:1px solid #666} | ||
| 3 | table.dbtable{border:1px solid #666;border-bottom:0px} | ||
| 4 | th {background-color:#EFEFEF} | ||
| 5 | .db0{width:1%;border-right:1px solid #666;} | ||
| 6 | .db1{width:25%;border-right:1px solid #666} | ||
| 7 | .db2{width:10%;border-right:1px solid #666} | ||
| 8 | .db3{width:7%;border-right:1px solid #666} | ||
| 9 | .db4{width:7%;border-right:1px solid #666} | ||
| 10 | .db5{width:10%;border-right:1px solid #666} | ||
| 11 | .db6{width:20%;border-right:1px solid #666} | ||
| 12 | .db7{width:20%} | ||
| 13 | .dbhead{background-color:#CCC;font-weight:bold} | ||
| 14 | </style> | ||
| 15 | 1.1 XWiki Attachments | ||
| 16 | |document=DevGuide.DatabaseSchema | ||
| 17 | This table contains attachment information (not including the content and versions). | ||
| 18 | |||
| 19 | <table border="0" width="100%" class="dbtable" cellpadding="3" cellspacing="0"> | ||
| 20 | <tr> | ||
| 21 | <td colspan="8" class="dbhead">xwikiattachment</td> | ||
| 22 | </tr> | ||
| 23 | <tr> | ||
| 24 | <th class="db0"> </th> | ||
| 25 | <th class="db1">Column Name</th> | ||
| 26 | <th class="db2">Datatype</th> | ||
| 27 | <th class="db3">Not null</th> | ||
| 28 | <th class="db4">auto inc</th> | ||
| 29 | <th class="db5">flags</th> | ||
| 30 | <th class="db6">Default Value</th> | ||
| 31 | <th class="db7">Comments</th> | ||
| 32 | </tr> | ||
| 33 | <tr> | ||
| 34 | <td class="db0">{image:db_key.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 35 | <td class="db1">XWA_ID</td> | ||
| 36 | <td class="db2">BIG_INT(20)</td> | ||
| 37 | <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 38 | <td class="db4"> </td> | ||
| 39 | <td class="db5"> </td> | ||
| 40 | <td class="db6">0</td> | ||
| 41 | <td class="db7"> </td> | ||
| 42 | </tr> | ||
| 43 | <tr> | ||
| 44 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 45 | <td class="db1">XWA_DOC_ID</td> | ||
| 46 | <td class="db2">BIG_INT(20)</td> | ||
| 47 | <td class="db3"> </td> | ||
| 48 | <td class="db4"> </td> | ||
| 49 | <td class="db5"> </td> | ||
| 50 | <td class="db6"> </td> | ||
| 51 | <td class="db7"> </td> | ||
| 52 | </tr> | ||
| 53 | <tr> | ||
| 54 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 55 | <td class="db1">XWA_FILENAME</td> | ||
| 56 | <td class="db2">VARCHAR(255)</td> | ||
| 57 | <td class="db3">{image:db_check.gif|16|16}</td> | ||
| 58 | <td class="db4"> </td> | ||
| 59 | <td class="db5"> </td> | ||
| 60 | <td class="db6">null</td> | ||
| 61 | <td class="db7"> </td> | ||
| 62 | </tr> | ||
| 63 | <tr> | ||
| 64 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 65 | <td class="db1">XWA_SIZE</td> | ||
| 66 | <td class="db2">INTEGER</td> | ||
| 67 | <td class="db3"> </td> | ||
| 68 | <td class="db4"> </td> | ||
| 69 | <td class="db5"> </td> | ||
| 70 | <td class="db6"> </td> | ||
| 71 | <td class="db7"> </td> | ||
| 72 | </tr> | ||
| 73 | <tr> | ||
| 74 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 75 | <td class="db1">XWA_DATE</td> | ||
| 76 | <td class="db2">DATETIME</td> | ||
| 77 | <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 78 | <td class="db4"> </td> | ||
| 79 | <td class="db5"> </td> | ||
| 80 | <td class="db6">0000-00-00 00:00:00</td> | ||
| 81 | <td class="db7"> </td> | ||
| 82 | </tr> | ||
| 83 | <tr> | ||
| 84 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 85 | <td class="db1">XWA_AUTHOR</td> | ||
| 86 | <td class="db2">VARCHAR(255)</td> | ||
| 87 | <td class="db3"> </td> | ||
| 88 | <td class="db4"> </td> | ||
| 89 | <td class="db5"> </td> | ||
| 90 | <td class="db6"> </td> | ||
| 91 | <td class="db7"> </td> | ||
| 92 | </tr> | ||
| 93 | <tr> | ||
| 94 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 95 | <td class="db1">XWA_VERSION</td> | ||
| 96 | <td class="db2">VARCHAR(255)</td> | ||
| 97 | <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 98 | <td class="db4"> </td> | ||
| 99 | <td class="db5"> </td> | ||
| 100 | <td class="db6">null</td> | ||
| 101 | <td class="db7"> </td> | ||
| 102 | </tr> | ||
| 103 | <tr> | ||
| 104 | <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td> | ||
| 105 | <td class="db1">XWA_COMMENT</td> | ||
| 106 | <td class="db2">VARCHAR(255)</td> | ||
| 107 | <td class="db3"> </td> | ||
| 108 | <td class="db4"> </td> | ||
| 109 | <td class="db5"> </td> | ||
| 110 | <td class="db6"> </td> | ||
| 111 | <td class="db7"> </td> | ||
| 112 | </tr> | ||
| 113 | </table> |
