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:
- 4722 Bytes
1 | CREATE TABLE `users` ( |
2 | `id` int(11) NOT NULL auto_increment, |
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 | PRIMARY KEY (`id`), |
8 | UNIQUE KEY `login` (`login`) |
9 | ) TYPE=MyISAM; |
10 | |
11 | CREATE TABLE `articles` ( |
12 | `id` int(11) NOT NULL auto_increment, |
13 | `title` varchar(255) default NULL, |
14 | `author` varchar(255) default NULL, |
15 | `body` text, |
16 | `body_html` text, |
17 | `extended` text, |
18 | `extended_html` text, |
19 | `excerpt` text, |
20 | `keywords` varchar(255) default NULL, |
21 | `allow_comments` tinyint(1) default NULL, |
22 | `allow_pings` tinyint(1) default NULL, |
23 | `published` tinyint(1) NOT NULL default '1', |
24 | `text_filter` varchar(20) default NULL, |
25 | `user_id` int(11) default NULL, |
26 | `created_at` datetime default NULL, |
27 | `updated_at` datetime default NULL, |
28 | `permalink` varchar(255) default NULL, |
29 | `guid` varchar(255) default NULL, |
30 | PRIMARY KEY (`id`), |
31 | KEY `articles_permalink_index` (`permalink`) |
32 | ) TYPE=MyISAM; |
33 | |
34 | CREATE TABLE `articles_categories` ( |
35 | `article_id` int(11) default NULL, |
36 | `category_id` int(11) default NULL, |
37 | `is_primary` tinyint(1) NOT NULL default '0' |
38 | ) TYPE=MyISAM; |
39 | |
40 | CREATE TABLE `blacklist_patterns` ( |
41 | `id` int(11) NOT NULL auto_increment, |
42 | `type` varchar(15) default NULL, |
43 | `pattern` varchar(255) default NULL, |
44 | PRIMARY KEY (`id`) |
45 | ) TYPE=MyISAM; |
46 | |
47 | CREATE TABLE `page_caches` ( |
48 | `id` int(11) NOT NULL auto_increment, |
49 | `name` varchar(255) NOT NULL, |
50 | PRIMARY KEY (`id`), |
51 | KEY `name` (`name`) |
52 | ) TYPE=MyISAM; |
53 | |
54 | CREATE TABLE `pages` ( |
55 | `id` int(11) NOT NULL auto_increment, |
56 | `name` varchar(255) default NULL, |
57 | `title` varchar(255) default NULL, |
58 | `body` text, |
59 | `body_html` text, |
60 | `text_filter` varchar(20) default NULL, |
61 | `user_id` int(11) default NULL, |
62 | `created_at` datetime default NULL, |
63 | `updated_at` datetime default NULL, |
64 | PRIMARY KEY (`id`) |
65 | ) TYPE=MyISAM; |
66 | |
67 | CREATE TABLE `categories` ( |
68 | `id` int(11) NOT NULL auto_increment, |
69 | `name` varchar(255) default NULL, |
70 | `position` int(11) NOT NULL default '0', |
71 | `permalink` varchar(255) default NULL, |
72 | PRIMARY KEY (`id`), |
73 | KEY `categories_permalink_index` (`permalink`) |
74 | ) TYPE=MyISAM; |
75 | |
76 | CREATE TABLE `comments` ( |
77 | `id` int(11) NOT NULL auto_increment, |
78 | `article_id` int(11) default NULL, |
79 | `author` varchar(255) default NULL, |
80 | `email` varchar(255) default NULL, |
81 | `url` varchar(255) default NULL, |
82 | `ip` varchar(15) default NULL, |
83 | `body` text, |
84 | `body_html` text, |
85 | `created_at` datetime default NULL, |
86 | `updated_at` datetime default NULL, |
87 | PRIMARY KEY (`id`), |
88 | KEY `article_id` (`article_id`) |
89 | ) TYPE=MyISAM; |
90 | |
91 | CREATE TABLE `pings` ( |
92 | `id` int(11) NOT NULL auto_increment, |
93 | `article_id` int(11) default NULL, |
94 | `url` varchar(255) default NULL, |
95 | `created_at` datetime default NULL, |
96 | PRIMARY KEY (`id`), |
97 | KEY `article_id` (`article_id`) |
98 | ) TYPE=MyISAM; |
99 | |
100 | CREATE TABLE `resources` ( |
101 | `id` int(11) NOT NULL auto_increment, |
102 | `size` int(11) default NULL, |
103 | `filename` varchar(255) default NULL, |
104 | `mime` varchar(255) default NULL, |
105 | `created_at` datetime default NULL, |
106 | `updated_at` datetime default NULL, |
107 | PRIMARY KEY (`id`) |
108 | ) TYPE=MyISAM; |
109 | |
110 | CREATE TABLE `sessions` ( |
111 | `id` int(11) unsigned NOT NULL auto_increment, |
112 | `sessid` varchar(32) default NULL, |
113 | `data` text, |
114 | `updated_at` datetime default NULL, |
115 | PRIMARY KEY (`id`), |
116 | UNIQUE KEY `sessid` (`sessid`) |
117 | ) TYPE=MyISAM; |
118 | |
119 | CREATE TABLE `settings` ( |
120 | `id` int(11) NOT NULL auto_increment, |
121 | `name` varchar(255) default NULL, |
122 | `value` varchar(255) default NULL, |
123 | PRIMARY KEY (`id`) |
124 | ) TYPE=MyISAM; |
125 | |
126 | CREATE TABLE `sidebars` ( |
127 | `id` int(11) unsigned NOT NULL auto_increment, |
128 | `controller` varchar(32) default NULL, |
129 | `active_position` int(11), |
130 | `active_config` text, |
131 | `staged_position` int(11), |
132 | `staged_config` text, |
133 | `updated_at` datetime default NULL, |
134 | PRIMARY KEY (`id`) |
135 | ) TYPE=MyISAM; |
136 | |
137 | insert into sidebars (id,controller,active_position,staged_position) |
138 | values (1,'category',0,0); |
139 | insert into sidebars (id,controller,active_position,staged_position) |
140 | values (2,'static',1,1); |
141 | insert into sidebars (id,controller,active_position,staged_position) |
142 | values (3,'xml',2,2); |
143 | |
144 | CREATE TABLE `trackbacks` ( |
145 | `id` int(11) NOT NULL auto_increment, |
146 | `article_id` int(11) default NULL, |
147 | `category_id` int(11) default NULL, |
148 | `blog_name` varchar(255) default NULL, |
149 | `title` varchar(255) default NULL, |
150 | `excerpt` varchar(255) default NULL, |
151 | `url` varchar(255) default NULL, |
152 | `ip` varchar(15) default NULL, |
153 | `created_at` datetime default NULL, |
154 | `updated_at` datetime default NULL, |
155 | PRIMARY KEY (`id`), |
156 | KEY `article_id` (`article_id`) |
157 | ) TYPE=MyISAM; |
158 | |
159 | CREATE TABLE `schema_info` ( |
160 | `version` int(11) default NULL |
161 | ) TYPE=MyISAM; |
162 | |
163 | INSERT into `schema_info` VALUES (9); |