Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 86
- Log:
Initial import of I2, an Instiki clone.
- Author:
- adh
- Date:
- Mon Oct 16 10:40:36 +0100 2006
- Size:
- 1213 Bytes
1 | CREATE TABLE `authors` ( |
2 | `id` int(11) NOT NULL auto_increment, |
3 | `name` varchar(255) default NULL, |
4 | `ip` varchar(255) default NULL, |
5 | `book_id` int(11) default NULL, |
6 | PRIMARY KEY (`id`) |
7 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
8 | |
9 | CREATE TABLE `books` ( |
10 | `id` int(11) NOT NULL auto_increment, |
11 | `name` varchar(255) default NULL, |
12 | `url_name` varchar(255) default NULL, |
13 | `existing_page_titles` longtext, |
14 | `premiere` tinyint(1) default '0', |
15 | PRIMARY KEY (`id`) |
16 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
17 | |
18 | CREATE TABLE `pages` ( |
19 | `id` int(11) NOT NULL auto_increment, |
20 | `title` varchar(255) default NULL, |
21 | `book_id` int(11) default NULL, |
22 | `created_at` datetime default NULL, |
23 | `updated_at` datetime default NULL, |
24 | PRIMARY KEY (`id`) |
25 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
26 | |
27 | CREATE TABLE `schema_info` ( |
28 | `version` int(11) default NULL |
29 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
30 | |
31 | CREATE TABLE `versions` ( |
32 | `id` int(11) NOT NULL auto_increment, |
33 | `page_id` int(11) default NULL, |
34 | `author_id` int(11) default NULL, |
35 | `created_at` datetime default NULL, |
36 | `body` text, |
37 | `book_id` int(11) default NULL, |
38 | PRIMARY KEY (`id`) |
39 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
40 | |
41 | INSERT INTO schema_info (version) VALUES (8); |