D9wZX8xr

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2CREATE TABLE IF NOT EXISTS `integrity_builds` (
3  `id` int(11) NOT NULL auto_increment,
4  `started_at` datetime default NULL,
5  `completed_at` datetime default NULL,
6  `successful` tinyint(1) default NULL,
7  `output` text NOT NULL,
8  `created_at` datetime default NULL,
9  `updated_at` datetime default NULL,
10  `commit_id` int(11) default NULL,
11  PRIMARY KEY  (`id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
13CREATE TABLE IF NOT EXISTS `integrity_commits` (
14  `id` int(11) NOT NULL auto_increment,
15  `identifier` varchar(255) NOT NULL,
16  `message` text,
17  `author` varchar(255) default NULL,
18  `committed_at` datetime NOT NULL,
19  `created_at` datetime default NULL,
20  `updated_at` datetime default NULL,
21  `project_id` int(11) default NULL,
22  PRIMARY KEY  (`id`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
24CREATE TABLE IF NOT EXISTS `integrity_notifiers` (
25  `id` int(11) NOT NULL auto_increment,
26  `name` varchar(255) NOT NULL,
27  `config` text NOT NULL,
28  `project_id` int(11) default NULL,
29  `enabled` tinyint(1) default NULL,
30  PRIMARY KEY  (`id`)
31) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
32CREATE TABLE IF NOT EXISTS `integrity_projects` (
33  `id` int(11) NOT NULL auto_increment,
34  `name` varchar(255) NOT NULL,
35  `permalink` varchar(255) default NULL,
36  `uri` varchar(255) NOT NULL,
37  `branch` varchar(255) NOT NULL default 'master',
38  `command` varchar(255) NOT NULL default 'rake',
39  `public` tinyint(1) default '1',
40  `building` tinyint(1) default '0',
41  `created_at` datetime default NULL,
42  `updated_at` datetime default NULL,
43  `build_id` int(11) default NULL,
44  `notifier_id` int(11) default NULL,
45  PRIMARY KEY  (`id`)
46) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
47CREATE TABLE IF NOT EXISTS `migration_info` (
48  `migration_name` varchar(255) default NULL,
49  UNIQUE KEY `migration_name` (`migration_name`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51INSERT INTO `migration_info` (`migration_name`) VALUES
52('add_commits'),
53('add_enabled_column'),
54('initial'),
55('nil_commit_metadata');