https://ark.lparchaeology.com/wiki/index.php?action=history&feed=atom&title=Database_Tables
Database Tables - Revision history
2026-04-22T22:41:37Z
Revision history for this page on the wiki
MediaWiki 1.27.1
https://ark.lparchaeology.com/wiki/index.php?title=Database_Tables&diff=2137&oldid=prev
Jessogden at 18:09, 24 February 2011
2011-02-24T18:09:08Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 18:09, 24 February 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7" >Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_datetype''' - stores the date types</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_datetype''' - stores the date types</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_file''' - stores the actual files</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_file''' - stores the actual files</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*'''cor_lut_filetype''' - stores the file types</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_grptype''' - stores the group types</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_grptype''' - stores the group types</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_language''' - stores the languages</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_lut_language''' - stores the languages</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l37" >Line 37:</td>
<td colspan="2" class="diff-lineno">Line 38:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_tbl_wwwpages''' - stores the pages which must appear in the ARK view</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_tbl_wwwpages''' - stores the pages which must appear in the ARK view</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_tbl_xmi''' - stores the links between instances of modules</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cor_tbl_xmi''' - stores the links between instances of modules</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*'''cor_tbl_wmc''' - stores the instances of maps created</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cxt_tbl_cxttype''' - stores the context types</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cxt_tbl_cxttype''' - stores the context types</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cxt_tbl_cxt''' - stores the instances of contexts</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''cxt_tbl_cxt''' - stores the instances of contexts</div></td></tr>
</table>
Jessogden
https://ark.lparchaeology.com/wiki/index.php?title=Database_Tables&diff=1099&oldid=prev
Andydufton at 17:40, 13 November 2008
2008-11-13T17:40:56Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 17:40, 13 November 2008</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l43" >Line 43:</td>
<td colspan="2" class="diff-lineno">Line 43:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''spf_tbl_spf''' - stores the instances of special finds</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''spf_tbl_spf''' - stores the instances of special finds</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''sph_tbl_sph''' - stores the instances of site photos</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*'''sph_tbl_sph''' - stores the instances of site photos</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[category: Administrator]]</ins></div></td></tr>
</table>
Andydufton
https://ark.lparchaeology.com/wiki/index.php?title=Database_Tables&diff=466&oldid=prev
Andydufton at 13:32, 13 November 2008
2008-11-13T13:32:45Z
<p></p>
<p><b>New page</b></p><div>*'''abk_lut_abktype''' - stores the address book types (at the moment only one: people)<br />
*'''abk_tbl_abk''' - stores the istances of the address book – the names are stores as texts in cor_tbl_txt<br />
*'''cor_lut_actiontype''' - stores action types<br />
*'''cor_lut_aliastype''' - stores alias types (at the moment only two: normal and against)<br />
*'''cor_lut_attribute''' - stores the attributes for each attribute type<br />
*'''cor_lut_attributetype''' - stores the attribute types<br />
*'''cor_lut_datetype''' - stores the date types<br />
*'''cor_lut_file''' - stores the actual files<br />
*'''cor_lut_grptype''' - stores the group types<br />
*'''cor_lut_language''' - stores the languages<br />
*'''cor_lut_place''' - stores the places<br />
*'''cor_lut_placetype''' - stores the place types<br />
*'''cor_lut_numbertype''' - stores the number types<br />
*'''cor_lut_spanlabel''' - stores the span labels for each span type<br />
*'''cor_lut_spantype''' - stores the span types<br />
*'''cor_lut_txttype''' - stores the text types<br />
*'''cor_lvu tables''' - stuff for the liveuser functionality<br />
*'''cor_tbl_action''' - stores the instances of action<br />
*'''cor_tbl_alias''' - stores the instances of aliases<br />
*'''cor_tbl_attribute''' - stores the instances of attributes<br />
*'''cor_tbl_cmap tables''' - stuff for importing functionality<br />
*'''cor_tbl_col''' - stores the columns<br />
*'''cor_tbl_date''' - stores the instances of dates<br />
*'''cor_tbl_file''' - stores the instances of files<br />
*'''cor_tbl_filters''' - stores the filters<br />
*'''cor_tbl_grp''' - stores the instances of group<br />
*'''cor_tbl_log''' - contains the log<br />
*'''cor_tbl_markup''' - stores the instances of markup<br />
*'''cor_tbl_module''' - stores the different modules in the ARK<br />
*'''cor_tbl_number''' - stores the instances of numbers<br />
*'''cor_tbl_sgrp''' - stores the security groups<br />
*'''cor_tbl_span''' - stores the instances of spans<br />
*'''cor_tbl_spanattr''' - stores the instances of span attributes<br />
*'''cor_tbl_ste''' - stores the sitecodes for the ARK<br />
*'''cor_tbl_txt''' - stores instances of text<br />
*'''cor_tbl_users''' - stores all the users<br />
*'''cor_tbl_wwwpages''' - stores the pages which must appear in the ARK view<br />
*'''cor_tbl_xmi''' - stores the links between instances of modules<br />
*'''cxt_tbl_cxttype''' - stores the context types<br />
*'''cxt_tbl_cxt''' - stores the instances of contexts<br />
*'''pln_tbl_pln''' - stores the instances of plans<br />
*'''smp_tbl_smp''' - stores the instances of samples<br />
*'''spf_tbl_spf''' - stores the instances of special finds<br />
*'''sph_tbl_sph''' - stores the instances of site photos</div>
Andydufton