public
Description: Merb based blog engine
Homepage: http://groups.google.com/group/blerb-list
Clone URL: git://github.com/hornbeck/blerb.git
blerb / dev.db
100644 1 lines (1 sloc) 8.192 kb
1
SQLite format 3@       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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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) BBg1tabletagstagsCREATE 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)