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.postgresql.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:: 9252 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" serial primary key,
17	"type" character varying(255) DEFAULT NULL,
18	"pattern" character varying(255) DEFAULT NULL
19	);
20
21	CREATE TABLE blogs (
22	"id" serial primary key,
23	"settings" text DEFAULT NULL,
24	"base_url" character varying(255) DEFAULT NULL
25	);
26
27	CREATE TABLE categories (
28	"id" serial primary key,
29	"name" character varying(255) DEFAULT NULL,
30	"position" integer DEFAULT NULL,
31	"permalink" character varying(255) DEFAULT NULL
32	);
33
34	CREATE TABLE categorizations (
35	"id" serial primary key,
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" serial primary key,
43	"type" character varying(255) DEFAULT NULL,
44	"title" character varying(255) DEFAULT NULL,
45	"author" character varying(255) DEFAULT NULL,
46	"body" text DEFAULT NULL,
47	"extended" text DEFAULT NULL,
48	"excerpt" text DEFAULT NULL,
49	"keywords" character varying(255) DEFAULT NULL,
50	"created_at" timestamp DEFAULT NULL,
51	"updated_at" timestamp DEFAULT NULL,
52	"user_id" integer DEFAULT NULL,
53	"permalink" character varying(255) DEFAULT NULL,
54	"guid" character varying(255) DEFAULT NULL,
55	"text_filter_id" integer DEFAULT NULL,
56	"whiteboard" text DEFAULT NULL,
57	"name" character varying(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" timestamp DEFAULT NULL,
63	"state" text DEFAULT NULL
64	);
65
66	CREATE TABLE feedback (
67	"id" serial primary key,
68	"type" character varying(255) DEFAULT NULL,
69	"title" character varying(255) DEFAULT NULL,
70	"author" character varying(255) DEFAULT NULL,
71	"body" text DEFAULT NULL,
72	"extended" text DEFAULT NULL,
73	"excerpt" text DEFAULT NULL,
74	"keywords" character varying(255) DEFAULT NULL,
75	"created_at" timestamp DEFAULT NULL,
76	"updated_at" timestamp DEFAULT NULL,
77	"user_id" integer DEFAULT NULL,
78	"permalink" character varying(255) DEFAULT NULL,
79	"guid" character varying(255) DEFAULT NULL,
80	"text_filter_id" integer DEFAULT NULL,
81	"whiteboard" text DEFAULT NULL,
82	"article_id" integer DEFAULT NULL,
83	"email" character varying(255) DEFAULT NULL,
84	"url" character varying(255) DEFAULT NULL,
85	"ip" character varying(40) DEFAULT NULL,
86	"blog_name" character varying(255) DEFAULT NULL,
87	"name" character varying(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" timestamp DEFAULT NULL,
93	"state" text DEFAULT NULL,
94	"status_confirmed" boolean DEFAULT NULL
95	);
96
97	CREATE TABLE notifications (
98	"id" serial primary key,
99	"content_id" integer DEFAULT NULL,
100	"user_id" integer DEFAULT NULL,
101	"created_at" timestamp DEFAULT NULL,
102	"updated_at" timestamp DEFAULT NULL
103	);
104
105	CREATE TABLE page_caches (
106	"id" serial primary key,
107	"name" character varying(255) DEFAULT NULL
108	);
109
110	CREATE TABLE pings (
111	"id" serial primary key,
112	"article_id" integer DEFAULT NULL,
113	"url" character varying(255) DEFAULT NULL,
114	"created_at" timestamp DEFAULT NULL
115	);
116
117	CREATE TABLE redirects (
118	"id" serial primary key,
119	"from_path" character varying(255) DEFAULT NULL,
120	"to_path" character varying(255) DEFAULT NULL
121	);
122
123	CREATE TABLE resources (
124	"id" serial primary key,
125	"size" integer DEFAULT NULL,
126	"filename" character varying(255) DEFAULT NULL,
127	"mime" character varying(255) DEFAULT NULL,
128	"created_at" timestamp DEFAULT NULL,
129	"updated_at" timestamp DEFAULT NULL,
130	"article_id" integer DEFAULT NULL,
131	"itunes_metadata" boolean DEFAULT NULL,
132	"itunes_author" character varying(255) DEFAULT NULL,
133	"itunes_subtitle" character varying(255) DEFAULT NULL,
134	"itunes_duration" integer DEFAULT NULL,
135	"itunes_summary" text DEFAULT NULL,
136	"itunes_keywords" character varying(255) DEFAULT NULL,
137	"itunes_category" character varying(255) DEFAULT NULL,
138	"itunes_explicit" boolean DEFAULT NULL
139	);
140
141	CREATE TABLE sessions (
142	"id" serial primary key,
143	"sessid" character varying(255) DEFAULT NULL,
144	"data" text DEFAULT NULL,
145	"created_at" timestamp DEFAULT NULL,
146	"updated_at" timestamp DEFAULT NULL
147	);
148
149	CREATE TABLE sidebars (
150	"id" serial primary key,
151	"active_position" integer DEFAULT NULL,
152	"config" text DEFAULT NULL,
153	"staged_position" integer DEFAULT NULL,
154	"type" character varying(255) DEFAULT NULL,
155	"blog_id" integer DEFAULT NULL
156	);
157
158	CREATE TABLE tags (
159	"id" serial primary key,
160	"name" character varying(255) DEFAULT NULL,
161	"created_at" timestamp DEFAULT NULL,
162	"updated_at" timestamp DEFAULT NULL,
163	"display_name" character varying(255) DEFAULT NULL
164	);
165
166	CREATE TABLE text_filters (
167	"id" serial primary key,
168	"name" character varying(255) DEFAULT NULL,
169	"description" character varying(255) DEFAULT NULL,
170	"markup" character varying(255) DEFAULT NULL,
171	"filters" text DEFAULT NULL,
172	"params" text DEFAULT NULL
173	);
174
175	CREATE TABLE triggers (
176	"id" serial primary key,
177	"pending_item_id" integer DEFAULT NULL,
178	"pending_item_type" character varying(255) DEFAULT NULL,
179	"due_at" timestamp DEFAULT NULL,
180	"trigger_method" character varying(255) DEFAULT NULL
181	);
182
183	CREATE TABLE users (
184	"id" serial primary key,
185	"login" character varying(255) DEFAULT NULL,
186	"password" character varying(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" character varying(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