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] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [body] text,
  [content_type] varchar(255)
);

CREATE TABLE meta_datas (
  [id] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [content_id] int NOT NULL,
  [key] varchar(255) NOT NULL,
  [value] varchar(255)
);

CREATE TABLE page_elements (
  [id] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [page_id] int NOT NULL,
  [content_id] int NOT NULL,
  [area_name] varchar(255),
  [position] int
);

CREATE TABLE pages (
  [id] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [title] varchar(255) DEFAULT '' NOT NULL,
  [theme_name] varchar(255)
);

CREATE TABLE sessions (
  [id] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [session_id] varchar(255),
  [data] text,
  [updated_at] datetime
);

CREATE TABLE urlnames (
  [id] int NOT NULL IDENTITY(1,
  1) PRIMARY KEY,
  [nameable_type] varchar(255),
  [nameable_id] int,
  [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] int
);

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.sqlserver.sql