SQLite format 3 @
usersarticles
4 4
1]]] ?]?? daniel@example.com36a1edc0bdd97d5a9c0f26ab1db807fI
1]]] ?? daniel@example.com36a1edc0bdd97d5a9c0f26ab1db807fb56ec35272d425c636c6b820209a5d250da38b28bebf31d6b74bd955fcaf04bbd7bccbc121a5e9e654b5a5b092008-02-04T18:51:22-06:002008-02-04T18:51:22-06:00
w n%w c 5 ?? 5My Bestest Blog Post2008-02-04T18:51:21-06:002008-02-04T18:51:21-06:00my-bestest-blog-postG ?? post 32008-01-12T04:14:10-06:002008-02-04T18:51:21-06:00post-3G ?? post 22007-12-28T07:42:17-06:002008-02-04T18:51:21-06:00post-2G ?? post 12007-12-31T07:44:25-06:002008-02-04T18:51:21-06:00post-1G ?? post 02008-01-07T10:07:54-06:002008-02-04T18:51:21-06:00post-0
P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ftablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "title" TEXT, "body" TEXT, "created_at" datetime, "updated_at" datetime, "published_at" datetime, "draft" INTEGER, "slug" TEXT)tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "body" TEXT, "email" TEXT, "name" TEXT, "url" TEXT, "created_at" datetime, "user_ip" TEXT, "user_agent" TEXT, "referrer" TEXT, "approved" INTEGER DEFAULT 1, "article_id" INTEGER)
B B g1tabletagstagsCREATE TABLE "tags" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT)RtableusersusersCREATE TABLE "users" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "email" TEXT, "crypted_password" TEXT, "salt" TEXT, "activation_code" TEXT, "activated_at" datetime, "remember_token_expires_at" datetime, "remember_token" TEXT, "created_at" datetime, "updated_at" datetime, "first_name" TEXT, "last_name" TEXT)