Contents

-- This file is autogenerated by the Rail schema generator, using
-- the schema defined in db/migration/*.rb
--
-- Do not edit this file.  Instead, add a new migration using
-- ./script/generate migration <name>, and then run
-- ./script/generate schema

-- tables 

CREATE TABLE contents (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "body" text,
  "content_type" varchar(255)
);

CREATE TABLE meta_datas (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "content_id" integer NOT NULL,
  "key" varchar(255) NOT NULL,
  "value" varchar(255)
);

CREATE TABLE page_elements (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "page_id" integer NOT NULL,
  "content_id" integer NOT NULL,
  "area_name" varchar(255),
  "position" integer
);

CREATE TABLE pages (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "title" varchar(255) DEFAULT '' NOT NULL,
  "theme_name" varchar(255)
);

CREATE TABLE sessions (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "session_id" varchar(255),
  "data" text,
  "updated_at" datetime
);

CREATE TABLE urlnames (
  "id" INTEGER PRIMARY KEY NOT NULL,
  "nameable_type" varchar(255),
  "nameable_id" integer,
  "name" varchar(255)
);


-- indexes 

CREATE  INDEX "meta_datas_content_id_index" ON meta_datas ("content_id");
CREATE  INDEX "page_elements_area_name_index" ON page_elements ("area_name");
CREATE  INDEX "page_elements_position_index" ON page_elements ("position");
CREATE  INDEX "sessions_session_id_index" ON sessions ("session_id");

-- schema version meta-info 

CREATE TABLE schema_info (
  "version" integer
);

insert into schema_info (version) values (6);

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
compages-0.4.0	db/schema.sqlite.sql