SQLite format 3 @ -
/ */ tableusersusersCREATE TABLE users (
id INTEGER PRIMARY KEY,
created_on INTEGER,
username TEXT,
password TEXT,
UNIQUE(username)
))= indexsqlite_autoindex_users_1usersktablemediasmediasCREATE TABLE medias (
id INTEGER PRIMARY KEY,
edited INTEGER,
entry_uri TEXT,
entry_etag TEXT,
entry_body TEXT, -- XML
media_uri TEXT,
media_etag TEXT,
media_body TEXT, -- Base64
media_type TEXT,
UNIQUE(entry_uri)
)+? indexsqlite_autoindex_medias_1medias tableentriesentriesCREATE TABLE entries (
id INTEGER PRIMARY KEY,
edited INTEGER,
uri TEXT,
etag TEXT,
body TEXT, -- XML
UNIQUE(uri)
)-A indexsqlite_autoindex_entries_1entries
( Mfooacbd18db4cc2f85cedef654fccc4a4d8
foo
q 7o A GKhttp://localhost:3000/mediacollection/media_1.atomhttp://localhost:3000/mediacollection/media_1.atom/20080215-231019-193935
2008-02-15T23:10:19+09:00
Media 1, ver.2 http://localhost:3000/mediacollection/media_1.atom 2008-02-15T23:10:19+09:00
http://localhost:3000/mediacollection/media_1.gifhttp://localhost:3000/mediacollection/media_1.gif/20080215-23; q 7o ; GLhttp://localhost:3000/mediacollection/media_1.atomhttp://localhost:3000/mediacollecti
Z M3 KA Ghttp://localhost:3000/mediacollection/media_1-20080113-145840-331245.atomhttp://loc on/media_1.atom/20080215-231001-462974
2008-02-15T23:10:00+09:00
Media 1, ver.2 http://localhost:3000/mediacollection/media_1.atom 2008-02-15T23:10:01+09:00
http://localhost:3000/mediacollection/media_1.gifhttp://localhost:3000/mediacollection/media_1.gif/20080215-231001-462306iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAACXBIWXMAAAsTAAALEwEAmpwYAAAA
B3RJTUUH1wgcAiYELme2ggAAAB10RVh0Q29tbWVudABDcmVhdGVkIHdpdGggVGhlIEdJTVDvZCVu
AAAAFUlEQVQY02NkYPjPgBswMeAFI1UaAD8uARPOK1abAAAAAElFTkSuQmCC
image/png
MOG http://localhost:3000/entrycollection/entry_1-20080113-145625-689927.atomhttp://localhost:3000/entrycollection/entry_1-20080113-145625-689927.atom/20080113-145625-692791
Entry 1
This is the 1st entry
2008-01-13T14:56:25+09:00 2008-01-13T14:56:25+09:00 http://localhost:3000/entrycollection/entry_1-20080113-145625-689927.atom
diacollection/media_1-20080215-231000-313268.atom/20080215-231000-315757
2008-02-15T23:10:00+09:00
2008-02-15T23:10:00+09:00
Media 1
http://localhost:3000/mediacollection/media_1-20080215-231000-313268.atom
http://localhost:3000/mediacollection/media_1-20080215-231000-313268.gifhttp://localhost:3000/mediacollection/media_1-20080215-231000-313268.gif/20080215-231000-315998R0lGODlhCgAKAIABAP8AAP///yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAsAAAAAAoACgAAAgiE
j6nL7Q9jKwA7
image/gif
MOG0http://localhost:3000/entrycollection/entry_1-20080113-145704-083991.atomhttp://localhost:3000/entrycollection/entry_1-20080113-145704-083991.atom/20080113-145704-086724
Entry 1
This is the 1st entry
2008-01-13T14:57:04+09:00 2008-01-13T14:57:04+09:00 http://localhost:3000/entrycollection/entry_1-20080113-145704-083991.atom
q Ma KA G8http://localhost:3000/mediacollection/media_1-20080215-231000-313268.atomhttp://localhost:3000/me
MOGehttp://localhost:3000/entrycollection/entry_1-20080113-145757-593126.atomhttp://localhost:3000/entrycollection/entry_1-20080113-145757-593126.atom/20080113-145757-595876
Entry 1
This is the 1st entry
2008-01-13T14:57:57+09:00 2008-01-13T14:57:57+09:00 http://localhost:3000/entrycollection/entry_1-20080113-145757-593126.atom
diacollection/media_1-20080215-231019-114611.atom/20080215-231019-117080
2008-02-15T23:10:19+09:00
2008-02-15T23:10:19+09:00
Media 1
http://localhost:3000/mediacollection/media_1-20080215-231019-114611.atom
http://localhost:3000/mediacollection/media_1-20080215-231019-114611.gifhttp://localhost:3000/mediacollection/media_1-20080215-231019-114611.gif/20080215-231019-117312R0lGODlhCgAKAIABAP8AAP///yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAsAAAAAAoACgAAAgiE
j6nL7Q9jKwA7
image/gif
MOGhttp://localhost:3000/entrycollection/entry_1-20080113-145826-572878.atomhttp://localhost:3000/entrycollection/entry_1-20080113-145826-572878.atom/20080113-145826-575803
Entry 1
This is the 1st entry
2008-01-13T14:58:26+09:00 2008-01-13T14:58:26+09:00 http://localhost:3000/entrycollection/entry_1-20080113-145826-572878.atom
q 7o A G8http://localhost:3000/mediacollection/media_1.atomhttp://localhost:3000/mediacollection/media_1.atom/20080215-231000-389866
2008-02-15T23:10:00+09:00
Media 1, ver.2 http://localhost:3000/mediacollection/media_1.atom 2008-02-15T23:10:00+09:00
http://localhost:3000/mediacollection/media_1.gifhttp://localhost:3000/mediacollection/media_1.gif/20080215-23; q 7o ; G9http://localhost:3000/mediacollection/media_1.atomhttp://localhost:3000/mediacollecti
MOG8http://localhost:3000/entrycollection/entry_1-20080215-231000-095604.atomhttp://localhost:3000/entrycollection/entry_1-20080215-231000-095604.atom/20080215-231000-098558
Entry 1
This is the 1st entry
2008-02-15T23:10:00+09:00 2008-02-15T23:10:00+09:00 http://localhost:3000/entrycollection/entry_1-20080215-231000-095604.atom
q Ma KA GKhttp://localhost:3000/mediacollection/media_1-20080215-231019-114611.atomhttp://localhost:3000/me
Z M3 KA Ghttp://localhost:3000/mediacollection/media_1-20080113-145826-770155.atomhttp://loc on/media_1.atom/20080215-231020-262473
2008-02-15T23:10:19+09:00
Media 1, ver.2 http://localhost:3000/mediacollection/media_1.atom 2008-02-15T23:10:20+09:00
http://localhost:3000/mediacollection/media_1.gifhttp://localhost:3000/mediacollection/media_1.gif/20080215-231020-261748iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAIAAAACUFjqAAAACXBIWXMAAAsTAAALEwEAmpwYAAAA
B3RJTUUH1wgcAiYELme2ggAAAB10RVh0Q29tbWVudABDcmVhdGVkIHdpdGggVGhlIEdJTVDvZCVu
AAAAFUlEQVQY02NkYPjPgBswMeAFI1UaAD8uARPOK1abAAAAAElFTkSuQmCC
image/png