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.sqlite.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:: 8956 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" integer DEFAULT NULL,
12	"tag_id" integer DEFAULT NULL
13	);
14
15	CREATE TABLE blacklist_patterns (
16	"id" INTEGER PRIMARY KEY NOT NULL,
17	"type" varchar(255) DEFAULT NULL,
18	"pattern" varchar(255) DEFAULT NULL
19	);
20
21	CREATE TABLE blogs (
22	"id" INTEGER PRIMARY KEY NOT NULL,
23	"settings" text DEFAULT NULL,
24	"base_url" varchar(255) DEFAULT NULL
25	);
26
27	CREATE TABLE categories (
28	"id" INTEGER PRIMARY KEY NOT NULL,
29	"name" varchar(255) DEFAULT NULL,
30	"position" integer DEFAULT NULL,
31	"permalink" varchar(255) DEFAULT NULL
32	);
33
34	CREATE TABLE categorizations (
35	"id" INTEGER PRIMARY KEY NOT NULL,
36	"article_id" integer DEFAULT NULL,
37	"category_id" integer DEFAULT NULL,
38	"is_primary" boolean DEFAULT NULL
39	);
40
41	CREATE TABLE contents (
42	"id" INTEGER PRIMARY KEY NOT NULL,
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" integer DEFAULT NULL,
53	"permalink" varchar(255) DEFAULT NULL,
54	"guid" varchar(255) DEFAULT NULL,
55	"text_filter_id" integer DEFAULT NULL,
56	"whiteboard" text DEFAULT NULL,
57	"name" varchar(255) DEFAULT NULL,
58	"published" boolean DEFAULT 'f',
59	"allow_pings" boolean DEFAULT NULL,
60	"allow_comments" boolean DEFAULT NULL,
61	"blog_id" integer NOT NULL,
62	"published_at" datetime DEFAULT NULL,
63	"state" text DEFAULT NULL
64	);
65
66	CREATE TABLE feedback (
67	"id" INTEGER PRIMARY KEY NOT NULL,
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" integer DEFAULT NULL,
78	"permalink" varchar(255) DEFAULT NULL,
79	"guid" varchar(255) DEFAULT NULL,
80	"text_filter_id" integer DEFAULT NULL,
81	"whiteboard" text DEFAULT NULL,
82	"article_id" integer 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" boolean DEFAULT 'f',
89	"allow_pings" boolean DEFAULT NULL,
90	"allow_comments" boolean DEFAULT NULL,
91	"blog_id" integer NOT NULL,
92	"published_at" datetime DEFAULT NULL,
93	"state" text DEFAULT NULL,
94	"status_confirmed" boolean DEFAULT NULL
95	);
96
97	CREATE TABLE notifications (
98	"id" INTEGER PRIMARY KEY NOT NULL,
99	"content_id" integer DEFAULT NULL,
100	"user_id" integer DEFAULT NULL,
101	"created_at" datetime DEFAULT NULL,
102	"updated_at" datetime DEFAULT NULL
103	);
104
105	CREATE TABLE page_caches (
106	"id" INTEGER PRIMARY KEY NOT NULL,
107	"name" varchar(255) DEFAULT NULL
108	);
109
110	CREATE TABLE pings (
111	"id" INTEGER PRIMARY KEY NOT NULL,
112	"article_id" integer DEFAULT NULL,
113	"url" varchar(255) DEFAULT NULL,
114	"created_at" datetime DEFAULT NULL
115	);
116
117	CREATE TABLE redirects (
118	"id" INTEGER PRIMARY KEY NOT NULL,
119	"from_path" varchar(255) DEFAULT NULL,
120	"to_path" varchar(255) DEFAULT NULL
121	);
122
123	CREATE TABLE resources (
124	"id" INTEGER PRIMARY KEY NOT NULL,
125	"size" integer 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" integer DEFAULT NULL,
131	"itunes_metadata" boolean DEFAULT NULL,
132	"itunes_author" varchar(255) DEFAULT NULL,
133	"itunes_subtitle" varchar(255) DEFAULT NULL,
134	"itunes_duration" integer 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" boolean DEFAULT NULL
139	);
140
141	CREATE TABLE sessions (
142	"id" INTEGER PRIMARY KEY NOT NULL,
143	"sessid" varchar(255) DEFAULT NULL,
144	"data" text DEFAULT NULL,
145	"created_at" datetime DEFAULT NULL,
146	"updated_at" datetime DEFAULT NULL
147	);
148
149	CREATE TABLE sidebars (
150	"id" INTEGER PRIMARY KEY NOT NULL,
151	"active_position" integer DEFAULT NULL,
152	"config" text DEFAULT NULL,
153	"staged_position" integer DEFAULT NULL,
154	"type" varchar(255) DEFAULT NULL,
155	"blog_id" integer DEFAULT NULL
156	);
157
158	CREATE TABLE tags (
159	"id" INTEGER PRIMARY KEY NOT NULL,
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	);
165
166	CREATE TABLE text_filters (
167	"id" INTEGER PRIMARY KEY NOT NULL,
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	);
174
175	CREATE TABLE triggers (
176	"id" INTEGER PRIMARY KEY NOT NULL,
177	"pending_item_id" integer DEFAULT NULL,
178	"pending_item_type" varchar(255) DEFAULT NULL,
179	"due_at" datetime DEFAULT NULL,
180	"trigger_method" varchar(255) DEFAULT NULL
181	);
182
183	CREATE TABLE users (
184	"id" INTEGER PRIMARY KEY NOT NULL,
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" boolean DEFAULT NULL,
190	"notify_on_new_articles" boolean DEFAULT NULL,
191	"notify_on_comments" boolean DEFAULT NULL,
192	"notify_watch_my_articles" boolean DEFAULT NULL,
193	"notify_via_jabber" boolean DEFAULT NULL,
194	"jabber" varchar(255) DEFAULT NULL
195	);
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 (2, 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 (3, 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
244	-- schema version meta-info
245
246	CREATE TABLE schema_info (
247	"version" integer DEFAULT NULL
248	);
249
250	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