Changes between Version 9 and Version 10 of DataStorageEN


Ignore:
Timestamp:
Jan 5, 2011, 2:15:13 AM (13 years ago)
Author:
Martin Kolman
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DataStorageEN

    v9 v10  
    3838}}}
    3939
    40 The storage database looks like this:[[br]]
    41 {{{table tiles (z integer, x integer, y integer, store_filename string, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]]
     40The storage database looks like this:[[br]][[br]]
     41{{{table tiles (z integer, x integer, y integer, store_filename string, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]][[br]][[br]]
    4242The store databases look like this:[[br]]
    43 {{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]]
    44 The only difference in the structure is that the lookup databases only stores the name of the store for given coordinates and the store database stores the actual blob.[[br]]
     43{{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]][[br]]
     44The only difference in the structure is that the lookup databases only stores the name of the store for given coordinates and the store database stores the actual blob.
    4545Both also have a table called called version which has an integer column called v.  There is a single 1 inserted, which indicates the current version of the table.
    4646