Changes between Version 8 and Version 9 of DataStorageEN

Timestamp:

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

Author:

Martin Kolman

Comment:

--

DataStorageEN

@@ -38 +38 @@
 }}}
 
-The storage database looks like this:
-{{{table tiles (z integer, x integer, y integer, store_filename string, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}
-The store databases look like this:
-{{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}
-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.
+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 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]]
 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.
 
@@ -50 +50 @@
 When looking for a tile in the database, modRana first asks the lookup database and when it gets an answer, it asks the store described in the store_filename for the given coordinates.
 
-'''Could this be used by other navigation apps ?'''
+'''Could this be used by other navigation apps ?'''[[br]]
 Why do you think I just roughly described how it works ? :D