Changes between Version 9 and Version 10 of DataStorageEN

Timestamp:

Jan 5, 2011, 2:15:13 AM (14 years ago)

Author:

Martin Kolman

Comment:

--

DataStorageEN

@@ -38 +38 @@
 }}}
 
-The storage database looks like this:[[br]]
-{{{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]]
+The storage database looks like this:[[br]][[br]]
+{{{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]]
 The store databases look like this:[[br]]
-{{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]]
-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]]
+{{{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]]
+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.
 Both 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.