Sha256: 12df8021990326b99bf74134a597b1e9455e7e4d3c2a47a7c031b65e6cb4d891

Contents?: true

Size: 1.73 KB

Versions: 1

Compression:

Stored size: 1.73 KB

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(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `body` text,
  `content_type` varchar(255)
) ENGINE=InnoDB;

CREATE TABLE meta_datas (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `content_id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` varchar(255)
) ENGINE=InnoDB;

CREATE TABLE page_elements (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `page_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `area_name` varchar(255),
  `position` int(11)
) ENGINE=InnoDB;

CREATE TABLE pages (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `title` varchar(255) DEFAULT '' NOT NULL,
  `theme_name` varchar(255)
) ENGINE=InnoDB;

CREATE TABLE sessions (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `session_id` varchar(255),
  `data` text,
  `updated_at` datetime
) ENGINE=InnoDB;

CREATE TABLE urlnames (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `nameable_type` varchar(255),
  `nameable_id` int(11),
  `name` varchar(255)
) ENGINE=InnoDB;


-- 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(11)
) ENGINE=InnoDB;

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