Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 13
- Log:
Initial import of Typo 2.6.0 sources from a downloaded Tarball.
Typo is a Ruby On Rails based blog engine.
- Author:
- adh
- Date:
- Sat Jul 22 22:25:02 +0100 2006
- Size:
- 4501 Bytes
1 | CREATE TABLE 'users' ( |
2 | 'id' INTEGER PRIMARY KEY NOT NULL, |
3 | 'login' VARCHAR(80) DEFAULT NULL, |
4 | 'password' VARCHAR(40) DEFAULT NULL, |
5 | 'name' VARCHAR(80) DEFAULT NULL, |
6 | 'email' VARCHAR(80) DEFAULT NULL |
7 | ); |
8 | |
9 | CREATE TABLE 'articles' ( |
10 | 'id' INTEGER PRIMARY KEY NOT NULL, |
11 | 'title' VARCHAR(255) DEFAULT NULL, |
12 | 'author' VARCHAR(255) DEFAULT NULL, |
13 | 'body' TEXT DEFAULT NULL, |
14 | 'body_html' TEXT DEFAULT NULL, |
15 | 'extended' TEXT DEFAULT NULL, |
16 | 'extended_html' TEXT DEFAULT NULL, |
17 | 'excerpt' TEXT DEFAULT NULL, |
18 | 'keywords' TEXT DEFAULT NULL, |
19 | 'allow_comments' INTEGER DEFAULT 1, |
20 | 'allow_pings' INTEGER DEFAULT 1, |
21 | 'published' INTEGER DEFAULT 1, |
22 | 'text_filter' VARCHAR(20) DEFAULT NULL, |
23 | 'user_id' INTEGER DEFAULT NULL, |
24 | 'created_at' DATETIME DEFAULT NULL, |
25 | 'updated_at' DATETIME DEFAULT NULL, |
26 | 'permalink' VARCHAR(255) DEFAULT NULL, |
27 | 'guid' VARCHAR(255) DEFAULT NULL |
28 | ); |
29 | |
30 | CREATE TABLE 'articles_categories' ( |
31 | 'article_id' INTEGER, |
32 | 'category_id' INTEGER, |
33 | 'is_primary' INTEGER DEFAULT 0 |
34 | ); |
35 | |
36 | CREATE TABLE 'blacklist_patterns' ( |
37 | 'id' INTEGER PRIMARY KEY NOT NULL, |
38 | 'type' VARCHAR(15) DEFAULT NULL, |
39 | 'pattern' VARCHAR(255) DEFAULT NULL |
40 | ); |
41 | |
42 | CREATE TABLE 'page_caches' ( |
43 | 'id' INTEGER PRIMARY KEY NOT NULL, |
44 | 'name' VARCHAR(255) |
45 | ); |
46 | |
47 | CREATE TABLE 'pages' ( |
48 | 'id' INTEGER PRIMARY KEY NOT NULL, |
49 | 'name' VARCHAR(255) DEFAULT NULL, |
50 | 'title' VARCHAR(255) DEFAULT NULL, |
51 | 'body' TEXT DEFAULT NULL, |
52 | 'body_html' TEXT DEFAULT NULL, |
53 | 'text_filter' VARCHAR(20) DEFAULT NULL, |
54 | 'user_id' INTEGER DEFAULT NULL, |
55 | 'created_at' DATETIME DEFAULT NULL, |
56 | 'updated_at' DATETIME DEFAULT NULL |
57 | ); |
58 | |
59 | CREATE TABLE 'categories' ( |
60 | 'id' INTEGER PRIMARY KEY NOT NULL, |
61 | 'name' VARCHAR(255) DEFAULT NULL, |
62 | 'position' INTEGER, |
63 | 'permalink' VARCHAR(255) DEFAULT NULL |
64 | ); |
65 | |
66 | CREATE TABLE 'comments' ( |
67 | 'id' INTEGER PRIMARY KEY NOT NULL, |
68 | 'article_id' INTEGER DEFAULT NULL, |
69 | 'author' VARCHAR(255) DEFAULT NULL, |
70 | 'email' VARCHAR(255) DEFAULT NULL, |
71 | 'url' VARCHAR(255) DEFAULT NULL, |
72 | 'ip' VARCHAR(15) DEFAULT NULL, |
73 | 'body' TEXT DEFAULT NULL, |
74 | 'body_html' TEXT DEFAULT NULL, |
75 | 'created_at' DATETIME DEFAULT NULL, |
76 | 'updated_at' DATETIME DEFAULT NULL |
77 | ); |
78 | |
79 | CREATE TABLE 'pings' ( |
80 | 'id' INTEGER PRIMARY KEY NOT NULL, |
81 | 'article_id' INTEGER, |
82 | 'url' VARCHAR(15) DEFAULT NULL, |
83 | 'created_at' DATETIME DEFAULT NULL |
84 | ); |
85 | |
86 | CREATE TABLE 'resources' ( |
87 | 'id' INTEGER PRIMARY KEY NOT NULL, |
88 | 'size' INTEGER DEFAULT NULL, |
89 | 'filename' VARCHAR(255) DEFAULT NULL, |
90 | 'mime' VARCHAR(255) DEFAULT NULL, |
91 | 'created_at' DATETIME DEFAULT NULL, |
92 | 'updated_at' DATETIME DEFAULT NULL |
93 | ); |
94 | |
95 | CREATE TABLE 'sessions' ( |
96 | 'id' INTEGER PRIMARY KEY NOT NULL, |
97 | 'sessid' VARCHAR(32) DEFAULT NULL, |
98 | 'data' TEXT, |
99 | 'updated_at' DATETIME DEFAULT NULL |
100 | ); |
101 | |
102 | CREATE TABLE 'settings' ( |
103 | 'id' INTEGER PRIMARY KEY NOT NULL, |
104 | 'name' VARCHAR(255) DEFAULT NULL, |
105 | 'value' VARCHAR(255) DEFAULT NULL, |
106 | 'position' INTEGER |
107 | ); |
108 | |
109 | CREATE TABLE 'sidebars' ( |
110 | 'id' INTEGER PRIMARY KEY NOT NULL, |
111 | 'controller' VARCHAR(32) DEFAULT NULL, |
112 | 'active_position' INTEGER, |
113 | 'active_config' TEXT, |
114 | 'staged_position' INTEGER, |
115 | 'staged_config' TEXT, |
116 | 'created_at' DATETIME DEFAULT NULL, |
117 | 'updated_at' DATETIME DEFAULT NULL |
118 | ); |
119 | insert into sidebars (id,controller,active_position,staged_position) |
120 | values (1,'category',0,0); |
121 | insert into sidebars (id,controller,active_position,staged_position) |
122 | values (2,'static',1,1); |
123 | insert into sidebars (id,controller,active_position,staged_position) |
124 | values (3,'xml',2,2); |
125 | |
126 | CREATE TABLE 'trackbacks' ( |
127 | 'id' INTEGER PRIMARY KEY NOT NULL, |
128 | 'article_id' INTEGER, |
129 | 'category_id' INTEGER, |
130 | 'blog_name' VARCHAR(255) DEFAULT NULL, |
131 | 'title' VARCHAR(255) DEFAULT NULL, |
132 | 'excerpt' VARCHAR(255) DEFAULT NULL, |
133 | 'url' VARCHAR(255) DEFAULT NULL, |
134 | 'ip' VARCHAR(15) DEFAULT NULL, |
135 | 'created_at' DATETIME DEFAULT NULL, |
136 | 'updated_at' DATETIME DEFAULT NULL |
137 | ); |
138 | |
139 | CREATE TABLE 'schema_info' ( |
140 | 'version' INTEGER |
141 | ); |
142 | |
143 | INSERT into schema_info VALUES (9); |