RISC OS Open: Bugs and sources: Browsing repository

You are currently browsing the Subversion repository.
Changesets can be listed by changeset number.
The Git repository is here.

root
» rool
» rails
» typo
» trunk
» db
» schema.mysql.sql

Revision:: 193

Log:

First stage commit of Typo 4.1, modified for the ROOL site.
Includes all local modifications but a final pass needs to be
made to delete any files left over from earlier Typo versions
that shouldn't be here anymore. See the 'tags' section of the
repository for a clean Typo 4.1 tree.

Note that symlinks to shared files in the RISC OS Open theme
directory have been deliberately included this time around; I
decided that on balance it was better to leave them in as
placeholders, since unlike symlinks in app/views/shared, the
Typo theme structure is not a standard Rails concept.

Author:: rool

Date:: Wed Apr 04 18:51:02 +0100 2007

Size:: 9591 Bytes

Show revision log

1	-- This file is autogenerated by the Rail schema generator, using
2	-- the schema defined in db/migration/*.rb
3	--
4	-- Do not edit this file. Instead, add a new migration using
5	-- ./script/generate migration <name>, and then run
6	-- ./script/generate schema
7
8	-- tables
9
10	CREATE TABLE articles_tags (
11	`article_id` int(11) DEFAULT NULL,
12	`tag_id` int(11) DEFAULT NULL
13	) ENGINE=InnoDB;
14
15	CREATE TABLE blacklist_patterns (
16	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
17	`type` varchar(255) DEFAULT NULL,
18	`pattern` varchar(255) DEFAULT NULL
19	) ENGINE=InnoDB;
20
21	CREATE TABLE blogs (
22	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
23	`settings` text DEFAULT NULL,
24	`base_url` varchar(255) DEFAULT NULL
25	) ENGINE=InnoDB;
26
27	CREATE TABLE categories (
28	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
29	`name` varchar(255) DEFAULT NULL,
30	`position` int(11) DEFAULT NULL,
31	`permalink` varchar(255) DEFAULT NULL
32	) ENGINE=InnoDB;
33
34	CREATE TABLE categorizations (
35	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
36	`article_id` int(11) DEFAULT NULL,
37	`category_id` int(11) DEFAULT NULL,
38	`is_primary` tinyint(1) DEFAULT NULL
39	) ENGINE=InnoDB;
40
41	CREATE TABLE contents (
42	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
43	`type` varchar(255) DEFAULT NULL,
44	`title` varchar(255) DEFAULT NULL,
45	`author` varchar(255) DEFAULT NULL,
46	`body` text DEFAULT NULL,
47	`extended` text DEFAULT NULL,
48	`excerpt` text DEFAULT NULL,
49	`keywords` varchar(255) DEFAULT NULL,
50	`created_at` datetime DEFAULT NULL,
51	`updated_at` datetime DEFAULT NULL,
52	`user_id` int(11) DEFAULT NULL,
53	`permalink` varchar(255) DEFAULT NULL,
54	`guid` varchar(255) DEFAULT NULL,
55	`text_filter_id` int(11) DEFAULT NULL,
56	`whiteboard` text DEFAULT NULL,
57	`name` varchar(255) DEFAULT NULL,
58	`published` tinyint(1) DEFAULT 0,
59	`allow_pings` tinyint(1) DEFAULT NULL,
60	`allow_comments` tinyint(1) DEFAULT NULL,
61	`blog_id` int(11) NOT NULL,
62	`published_at` datetime DEFAULT NULL,
63	`state` text DEFAULT NULL
64	) ENGINE=InnoDB;
65
66	CREATE TABLE feedback (
67	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
68	`type` varchar(255) DEFAULT NULL,
69	`title` varchar(255) DEFAULT NULL,
70	`author` varchar(255) DEFAULT NULL,
71	`body` text DEFAULT NULL,
72	`extended` text DEFAULT NULL,
73	`excerpt` text DEFAULT NULL,
74	`keywords` varchar(255) DEFAULT NULL,
75	`created_at` datetime DEFAULT NULL,
76	`updated_at` datetime DEFAULT NULL,
77	`user_id` int(11) DEFAULT NULL,
78	`permalink` varchar(255) DEFAULT NULL,
79	`guid` varchar(255) DEFAULT NULL,
80	`text_filter_id` int(11) DEFAULT NULL,
81	`whiteboard` text DEFAULT NULL,
82	`article_id` int(11) DEFAULT NULL,
83	`email` varchar(255) DEFAULT NULL,
84	`url` varchar(255) DEFAULT NULL,
85	`ip` varchar(40) DEFAULT NULL,
86	`blog_name` varchar(255) DEFAULT NULL,
87	`name` varchar(255) DEFAULT NULL,
88	`published` tinyint(1) DEFAULT 0,
89	`allow_pings` tinyint(1) DEFAULT NULL,
90	`allow_comments` tinyint(1) DEFAULT NULL,
91	`blog_id` int(11) NOT NULL,
92	`published_at` datetime DEFAULT NULL,
93	`state` text DEFAULT NULL,
94	`status_confirmed` tinyint(1) DEFAULT NULL
95	) ENGINE=InnoDB;
96
97	CREATE TABLE notifications (
98	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
99	`content_id` int(11) DEFAULT NULL,
100	`user_id` int(11) DEFAULT NULL,
101	`created_at` datetime DEFAULT NULL,
102	`updated_at` datetime DEFAULT NULL
103	) ENGINE=InnoDB;
104
105	CREATE TABLE page_caches (
106	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
107	`name` varchar(255) DEFAULT NULL
108	) ENGINE=InnoDB;
109
110	CREATE TABLE pings (
111	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
112	`article_id` int(11) DEFAULT NULL,
113	`url` varchar(255) DEFAULT NULL,
114	`created_at` datetime DEFAULT NULL
115	) ENGINE=InnoDB;
116
117	CREATE TABLE redirects (
118	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
119	`from_path` varchar(255) DEFAULT NULL,
120	`to_path` varchar(255) DEFAULT NULL
121	) ENGINE=InnoDB;
122
123	CREATE TABLE resources (
124	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
125	`size` int(11) DEFAULT NULL,
126	`filename` varchar(255) DEFAULT NULL,
127	`mime` varchar(255) DEFAULT NULL,
128	`created_at` datetime DEFAULT NULL,
129	`updated_at` datetime DEFAULT NULL,
130	`article_id` int(11) DEFAULT NULL,
131	`itunes_metadata` tinyint(1) DEFAULT NULL,
132	`itunes_author` varchar(255) DEFAULT NULL,
133	`itunes_subtitle` varchar(255) DEFAULT NULL,
134	`itunes_duration` int(11) DEFAULT NULL,
135	`itunes_summary` text DEFAULT NULL,
136	`itunes_keywords` varchar(255) DEFAULT NULL,
137	`itunes_category` varchar(255) DEFAULT NULL,
138	`itunes_explicit` tinyint(1) DEFAULT NULL
139	) ENGINE=InnoDB;
140
141	CREATE TABLE sessions (
142	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
143	`sessid` varchar(255) DEFAULT NULL,
144	`data` text DEFAULT NULL,
145	`created_at` datetime DEFAULT NULL,
146	`updated_at` datetime DEFAULT NULL
147	) ENGINE=InnoDB;
148
149	CREATE TABLE sidebars (
150	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
151	`active_position` int(11) DEFAULT NULL,
152	`config` text DEFAULT NULL,
153	`staged_position` int(11) DEFAULT NULL,
154	`type` varchar(255) DEFAULT NULL,
155	`blog_id` int(11) DEFAULT NULL
156	) ENGINE=InnoDB;
157
158	CREATE TABLE tags (
159	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
160	`name` varchar(255) DEFAULT NULL,
161	`created_at` datetime DEFAULT NULL,
162	`updated_at` datetime DEFAULT NULL,
163	`display_name` varchar(255) DEFAULT NULL
164	) ENGINE=InnoDB;
165
166	CREATE TABLE text_filters (
167	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
168	`name` varchar(255) DEFAULT NULL,
169	`description` varchar(255) DEFAULT NULL,
170	`markup` varchar(255) DEFAULT NULL,
171	`filters` text DEFAULT NULL,
172	`params` text DEFAULT NULL
173	) ENGINE=InnoDB;
174
175	CREATE TABLE triggers (
176	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
177	`pending_item_id` int(11) DEFAULT NULL,
178	`pending_item_type` varchar(255) DEFAULT NULL,
179	`due_at` datetime DEFAULT NULL,
180	`trigger_method` varchar(255) DEFAULT NULL
181	) ENGINE=InnoDB;
182
183	CREATE TABLE users (
184	`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
185	`login` varchar(255) DEFAULT NULL,
186	`password` varchar(255) DEFAULT NULL,
187	`email` text DEFAULT NULL,
188	`name` text DEFAULT NULL,
189	`notify_via_email` tinyint(1) DEFAULT NULL,
190	`notify_on_new_articles` tinyint(1) DEFAULT NULL,
191	`notify_on_comments` tinyint(1) DEFAULT NULL,
192	`notify_watch_my_articles` tinyint(1) DEFAULT NULL,
193	`notify_via_jabber` tinyint(1) DEFAULT NULL,
194	`jabber` varchar(255) DEFAULT NULL
195	) ENGINE=InnoDB;
196
197
198	-- indexes
199
200	CREATE INDEX `index_blacklist_patterns_on_pattern` ON blacklist_patterns (`pattern`);
201	CREATE INDEX `index_categories_on_permalink` ON categories (`permalink`);
202	CREATE INDEX `index_contents_on_blog_id` ON contents (`blog_id`);
203	CREATE INDEX `index_contents_on_text_filter_id` ON contents (`text_filter_id`);
204	CREATE INDEX `index_contents_on_published` ON contents (`published`);
205	CREATE INDEX `index_feedback_on_text_filter_id` ON feedback (`text_filter_id`);
206	CREATE INDEX `index_feedback_on_article_id` ON feedback (`article_id`);
207	CREATE INDEX `index_page_caches_on_name` ON page_caches (`name`);
208	CREATE INDEX `index_pings_on_article_id` ON pings (`article_id`);
209	CREATE INDEX `index_sessions_on_sessid` ON sessions (`sessid`);
210
211	-- data
212
213	INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('none', '--- []
214
215	', 'None', '--- {}
216
217	', 'none');
218	INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('markdown', '--- []
219
220	', 'Markdown', '--- {}
221
222	', 'markdown');
223	INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('smartypants', '---
224	- :smartypants
225	', 'SmartyPants', '--- {}
226
227	', 'none');
228	INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('markdown smartypants', '---
229	- :smartypants
230	', 'Markdown with SmartyPants', '--- {}
231
232	', 'markdown');
233	INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('textile', '--- []
234
235	', 'Textile', '--- {}
236
237	', 'textile');
238
239	INSERT INTO `sidebars` (`id`, `active_position`, `config`, `staged_position`, `type`, `blog_id`) VALUES (1, 0, '--- !map:HashWithIndifferentAccess \nempty: false\ncount: true\n', 0, 'CategorySidebar', 1);
240	INSERT INTO `sidebars` (`id`, `active_position`, `config`, `staged_position`, `type`, `blog_id`) VALUES (3, 2, '--- !map:HashWithIndifferentAccess \nformat: rss20\ntrackbacks: false\ncomments: true\narticles: true\n', 2, 'XmlSidebar', 1);
241	INSERT INTO `sidebars` (`id`, `active_position`, `config`, `staged_position`, `type`, `blog_id`) VALUES (4, 1, '--- !map:HashWithIndifferentAccess \nbody: "<ul>\\n <li><a href=\\"http://www.typosphere.org\\" title=\\"Typo\\">Typo</a></li>\\n <li><a href=\\"http://blog.leetsoft.com\\" title=\\"too-biased\\">too-biased</a></li>\\n <li><a href=\\"http://blog.remor.com/\\" title=\\"seth hall\\">Seth Hall</a></li>\\n <li><a href=\\"http://scottstuff.net\\" title=\\"Scottstuff\\">scottstuff.net</a></li>\\n <li><a href=\\"http://www.bofh.org.uk\\" title=\\"Just a Summary\\">Just A Summary</a></li>\\n <li><a href=\\"http://nubyonrails.com\\" title=\\"Topfunky\\">Topfunky</a></li>\\n <li><a href=\\"http://planettypo.com\\" title=\\"PlanetTypo\\">PlanetTypo</a></li>\\n <li><a href=\\"http://typoforums.org\\" title=\\"Typo Forums\\">Typo Forums</a></li>\\n <li><a href=\\"http://fredericdevillamil.com\\" title=\\"Fr\\xC3\\xA9d\\xC3\\xA9ric de Villamil\\">Fr\\xC3\\xA9d\\xC3\\xA9ric de Villamil</a></li>\\n\\\n </ul>\\n"\ntitle: Links\n', NULL, 'StaticSidebar', 1);
242
243	-- schema version meta-info
244
245	CREATE TABLE schema_info (
246	`version` int(11) DEFAULT NULL
247	) ENGINE=InnoDB;
248
249	insert into schema_info (version) values (61);

Download in other formats:

raw | text

Download in other formats:

Search tickets

Social

ROOL Store

Donate! Why?

RISC OS IPR

Options

RSS feeds