SQLite format 3@ !-K?I!iindexusers_nameusersCREATE UNIQUE INDEX users_name ON users (name)L#mindexusers_emailusersCREATE UNIQUE INDEX users_email ON users (email)\tableusersusersCREATE TABLE users ( userid INTEGER PRIMARY KEY NOT NULL, name varchar(200) NOT NULL, password char(60) NOT NULL, created_at datetime NOT NULL, updated_at datetime, email varchar(255) )ytablesessionssessionsCREATE TABLE sessions ( sessionid char(72) NOT NULL, session_data text, expires int, PRIMARY KEY (sessionid) )/Cindexsqlite_autoindex_sessions_1sessionsI!iindexroles_namerolesCREATE UNIQUE INDEX roles_name ON roles (name)p?tablerolesrolesCREATE TABLE roles ( roleid INTEGER PRIMARY KEY NOT NULL, name varchar  user user session6session:d95de228153c609987afca6fef6af71c1b6837efSmAsession:4471d6b3a58990739fccffcd0d006b3fe0b4fbd5BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjkzMzQ3NjYAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTMz NDc2NwAAAAlfX3VwZGF0ZWQ= O<SmAsession:f6dd189524b076b124b68acb19792027d28d555cBQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0EAwAAAAYKFmRldmluLmF1c3RpbkBnbWFp bC5jb20AAAAFZW1haWwKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091MnVu dDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAApj cmVhdGVkX2F0CIEAAAAGdXNlcmlkChMyMDEyLTAyLTE0IDE4OjU1OjM4AAAACnVwZGF0ZWRfYXQK BWRob3NzAAAABG5hbWUAAAAGX191c2VyCgoxMzI5MjQ1NzM4AAAACV9fY3JlYXRlZAoKMTMyOTI0 NTcz !  #X,a4msession:ec4d56e0796d0db41351d01d13b5236fcb1eb3f7 4msession:6a725d5cd684245a3b8b1bf48f4d7098f9d5ea9a 4msession:33ab7f2bcdbb161b4d052d179223adf83f3d74f3 4msession:7f79a40ec6379e90c1015a9d72787d9a89a6c1e94msession:6aa12cbab9d15b9f93237bed7c435aa4748e42ab4msession:e3c6a526b9e851c84ca46d19d09e836d55d1b1b74msession:bf84c0e7fa2b46934c21cf810cdace652fda6ad74msession:bb51580ef006ccf26af5978325a06a55c93665d64msession:d95de228153c609987afca6fef6af71c1b6837ef4msession:4471d6b3a58990739fccffcd0d006b3fe0b4fbd54msession:f6dd189524b076b124b68acb19792027d28d555c xx339dhoss$2a$08$Y7JVJ6yyw7cZb3kN2WezJeFECNie3Ou2unt5N5YAOzzzfhhr8aKgy2012-02-14 18:55:382012-02-14 18:55:38devin.austin@gmail.com 9devin.austin@gmail.com  dhoss **mKsession:ec4d56e0796d0db41351d01d13b5236fcb1eb3f7BQcDAAAABQoHbS mAsession:ec4d56e0796d0db41351d01d13b5236fcb1eb3f7BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0EAwAAAAYKFmRldmluLmF1c3RpbkBnbWFp bC5jb20AAAAFZW1haWwKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091MnVu dDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAApj cmVhdGVkX2F0CgExAAAABnVzZXJpZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAAp1cGRhdGVkX2F0 CgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTkzNzA5OAAAAAlfX2NyZWF0ZWQKCjEzMjk5 Mzk5OTgAAAAJX191cGRhdGVk OEo #n5bp?tablerolesrolesCREATE TABLE roles ( roleid INTEGER PRIMARY KEY NOT NULL, name varchar(50) NOT NULL )I!iindexroles_namerolesCREATE UNIQUE INDEX roles_name ON roles (name)ytablesessionssessionsCREATE TABLE sessions ( sessionid char(72) NOT NULL, session_data text, expires int, PRIMARY KEY (sessionid) )/Cindexsqlite_autoindex_sessions_1sessions\tableusersusersCREATE TABLE users ( userid INTEGER PRIMARY KEY NOT NULL, name varchar(200) NOT NULL, password char(60) NOT NULL, created_at datetime NOT NULL, updated_at datetime, email varchar(255) )L#mindexusers_emailusersCREATE UNIQUE INDEX users_email ON users (email)I!iindexusers_nameusersCREATE UNIQUE INDEX users_name ON users (name)S LkR5 AtableentriesentriesCREATE TABLE entries ( entryid INTEGER PRIMARY KEY NOT NULL, title varchar(200) NOT NULL, display_title varchar(200) NOT NULL, path varchar(255), parent bigint, body text NOT NULL, author int NOT NULL, created_at datetime NOT NULL, updated_at datetime, published tinyint NOT NULL DEFAULT 0, FOREIGN KEY(author) REFERENCES users(userid), FOREIGN KEY(parent) REFERENCES entries(entryid) )X1sindexentries_idx_authorentriesCREATE INDEX entries_idx_author ON entries (author)X1sindexentries_idx_parententriesCREATE INDEX entries_idx_parent ON entries (parent) iii#s) qq%33RE:RE:huhuhuhuhuh0.8331355863224130.30374744007981RE-RE-huhuhuhuhuh0-8331355863224130-303747440079811.5.7asdfasdfasdf2012-02-18 03:56:022012-02-18 03:56:02 KK!33RE:huhuhuhuhuh0.953109389209327RE-huhuhuhuhuh0-9531093892093271.6asfasfadsf2012-02-18 03:55:592012-02-18 03:55:59 KK#33RE:huhuhuhuhuh0.833135586322413RE-huhuhuhuhuh0-8331355863224131.5asfasfasfad2012-02-18 03:55:552012-02-18 03:55:55 CCC33asdfasdfasdfadsfhuhuhuhuhuhasdfasdfasdfadsfhuhuhuhuhuh4asdfasdfasdfdsafasdfasdfads2012-02-14 19:00:182012-02-14 19:00:19y 77C33huhuhuhuhuhkjjjjjadsfhuhuhuhuhuhkjjjjjadsxCC%33asdfasdfasdfadsfhuhuhuhuhuhasdfasdfasdfadsfhuhuhuhuhuh3asdfasdfadsf2012-02-20 20:31:462012-02-20 20:31:46933tetL 33asdfasdfasdfasdf3asdfasdf2012-02-22 20:22:252012-02-22 20:22:27I33tetetettetetet2fdafa2012-02-20 20:15:292012-02-22 20:21:26    6qRE-RE-huhuhuhuhuh0-8331355863224130-30374744007981#KRE-huhuhuhuhuh0-953109389209327#KRE-huhuhuhuhuh0-833135586322413Casdfasdfasdfadsfhuhuhuhuhuh7hu asdfasdfasdfadsfhuhuhuhuhuh tetetet asdfasdf 6qRE:RE:huhuhuhuhuh0.8331355863224130.30374744007981#KRE:huhuhuhuhuh0.953109389209327#KRE:huhuhuhuhuh0.833135586322413Casdfasdfasdfadsfhuhuhuhuhuh7hu asdfasdfasdfadsfhuhuhuhuhuh tetetet asdfasdf   ld7!indexuser_roles_idx_useriduser_rolesCREATE INDEX user_roles_idx_userid ON user_roles (userid)d7!indexuser_roles_idx_roleiduser_rolesCREATE INDEX user_roles_idx_roleid ON user_roles (roleid)Faindextree_dataentriesCREATE INDEX tree_data ON entries (parent)m7indexentries_display_titleentriesCREATE UNIQUE INDEX entries_display_title ON entries (display_title)T'uindexentries_titleentriesCREATE UNIQUE INDEX entries_title ON entries (title)i!!tableuser_rolesuser_rolesCREATE TABLE user_roles ( userid int NOT NULL, roleid int NOT NULL, PRIMARY KEY (userid, roleid), FOREIGN KEY(roleid) REFERENCES roles(roleid), FOREIGN KEY(userid) REFERENCES users(userid) )3G!indexsqlite_autoindex_user_roles_1user_roles    Y --!33asdfsadfsdf34g3gasdfsadfsdf34g3gggaeg3g34g2012-02-14 19:12:572012-02-14 19:12:57S !!-33asdfasdfasasdfasdfasasdfasdfasdfasdf2012-02-14 19:11:292012-02-15 19:45:33G 33f4tgagdgf4tgagdgg35g3g3g2012-02-14 19:09:022012-02-14 19:09:02K %33gahgasfggahgasfghrthwrthwt6h2012-02-14 19:07:552012-02-14 19:07:55a --133dfgsdfhdsafghdfadfgsdfhdsafghdfabsdfghsdfgsdfhsdfh2012-02-14 19:06:472012-02-14 19:06:47c))=33f5f3f43fq34f3qf5f3f43fq34f3qrgq3g43qgq3g4q3gq34g34qg2012-02-14 19:05:562012-02-14 19:05:56J##33huhuehuehuehuhuehuehuehlagh2012-02-14 19:02:142012-02-14 19:02:14w77C33huhuhuhuhuhkjjjjjadsfhuhuhuhuhuhkjjjjjadsfasdfasdfasdfdsafasdfasdfads2012-02-14 19:00:132012-02-14 19:00:13mn//C33huhuhuhuhuhkjjjjjhuhuhuhuhuhkjjjjjasdfasdfasdfdsafasdfasdfads2012-02-14 19:01:322012-02-14 19:01:32##C33huhuhuhuhuhhuhuhuhuhuhasdfasdfasdfdsafasdfasdfads2012-02-14 19:00:192012-02-14 19:00:191 332012-02-14 18:55:442012-02-14 18:55:44 T*TmKsession6session:33ab7f2bcdbb161b4d052d179223adf83f3d74f3SmAsession:7f79a40ec6379e90c1015a9d72787d9a89a6c1e9BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0EAwAAAAYKFmRldmluLmF1c3RpbkBnbWFp bC5jb20AAAAFZW1haWwKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091MnVu dDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAApj cmVhdGVkX2F0CgExAAAABnVzZXJpZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAAp1cGRhdGVkX2F0 CgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTc2ODkxNAAAAAlfX2NyZWF0ZWQKCjEzMjk3 Njg5MzYAAAAJX191cGRhdGVk OBSmAsession:6aa12cbab9d15b9f93237bed7c435aa4748e42abBQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjk3MDU0ODkAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTcw NTQ5MAAAAAlfX3VwZGF0ZWQ= OAR T*TmKsession6session:ec4d56e0796d0db41351d01d13b5236fcb1eb3f7S mAsession:6a725d5cd684245a3b8b1bf48f4d7098f9d5ea9aBQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjk4NjAwNTUAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTg2 MDA1NQAAAAlfX3VwZGF0ZWQ= ODbS mAsession:33ab7f2bcdbb161b4d052d179223adf83f3d74f3BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjk3NzUxOTkAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTc3 NTIwMAAAAAlfX3VwZGF0ZWQ= OB T*TSmAsession:4471d6b3a58990739fccffcd0d006b3fe0b4fbd5BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjkzMzQ3NjYAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTMz NDc2NwAAAAlfX3VwZGF0ZWQ= O<SmAsession:f6dd189524b076b124b68acb19792027d28d555cBQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0EAwAAAAYKFmRldmluLmF1c3RpbkBnbWFp bC5jb20AAAAFZW1haWwKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091MnVu dDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAAAApj cmVhdGVkX2F0CIEAAAAGdXNlcmlkChMyMDEyLTAyLTE0IDE4OjU1OjM4AAAACnVwZGF0ZWRfYXQK BWRob3NzAAAABG5hbWUAAAAGX191c2VyCgoxMzI5MjQ1NzM4AAAACV9fY3JlYXRlZAoKMTMyOTI0 NTczOAAAAAlfX3VwZGF0ZWQ= O:2 T*TmKsession6session:bf84c0e7fa2b46934c21cf810cdace652fda6ad7SmAsession:bb51580ef006ccf26af5978325a06a55c93665d6BQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjk0Mjg0NTkAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTQy ODQ2MQAAAAlfX3VwZGF0ZWQ= O=SSmAsession:d95de228153c609987afca6fef6af71c1b6837efBQcDAAAABAoHbWVtYmVycwAAAAxfX3VzZXJfcmVhbG0KCjEzMjkzNDIzMzQAAAAJX19jcmVhdGVk BAMAAAAGChZkZXZpbi5hdXN0aW5AZ21haWwuY29tAAAABWVtYWlsChMyMDEyLTAyLTE0IDE4OjU1 OjM4AAAACmNyZWF0ZWRfYXQKPCQyYSQwOCRZN0pWSjZ5eXc3Y1piM2tOMldlekplRkVDTmllM091 MnVudDVONVlBT3p6emZoaHI4YUtneQAAAAhwYXNzd29yZAoTMjAxMi0wMi0xNCAxODo1NTozOAAA AAp1cGRhdGVkX2F0CIEAAAAGdXNlcmlkCgVkaG9zcwAAAARuYW1lAAAABl9fdXNlcgoKMTMyOTM0 MjMzNAAAAAlfX3VwZGF0ZWQ= O