Sha256: d062223ead8ef6341380bff6ceaf241c435b810527048ee5e2204174159668f7
Contents?: true
Size: 1.61 KB
Versions: 2
Compression:
Stored size: 1.61 KB
Contents
CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "user_id" integer, "content" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "user_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL); CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "email" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL); CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version"); INSERT INTO schema_migrations (version) VALUES ('20130225045501'); INSERT INTO schema_migrations (version) VALUES ('20130225045512'); INSERT INTO schema_migrations (version) VALUES ('20130225173707'); INSERT INTO schema_migrations (version) VALUES ('20130225173717'); INSERT INTO schema_migrations (version) VALUES ('20130226001629'); INSERT INTO schema_migrations (version) VALUES ('20130226001639');
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
embedded_associations-0.0.2 | spec/support/app/db/structure.sql |
embedded_associations-0.0.1 | spec/support/app/db/structure.sql |