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 |