integrity_mysql.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `integrity_builds` (
  `id` int(11) NOT NULL auto_increment,
  `started_at` datetime default NULL,
  `completed_at` datetime default NULL,
  `successful` tinyint(1) default NULL,
  `output` text NOT NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `commit_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
CREATE TABLE IF NOT EXISTS `integrity_commits` (
  `id` int(11) NOT NULL auto_increment,
  `identifier` varchar(255) NOT NULL,
  `message` text,
  `author` varchar(255) default NULL,
  `committed_at` datetime NOT NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `project_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
CREATE TABLE IF NOT EXISTS `integrity_notifiers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `config` text NOT NULL,
  `project_id` int(11) default NULL,
  `enabled` tinyint(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
CREATE TABLE IF NOT EXISTS `integrity_projects` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `permalink` varchar(255) default NULL,
  `uri` varchar(255) NOT NULL,
  `branch` varchar(255) NOT NULL default 'master',
  `command` varchar(255) NOT NULL default 'rake',
  `public` tinyint(1) default '1',
  `building` tinyint(1) default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `build_id` int(11) default NULL,
  `notifier_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE TABLE IF NOT EXISTS `migration_info` (
  `migration_name` varchar(255) default NULL,
  UNIQUE KEY `migration_name` (`migration_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `migration_info` (`migration_name`) VALUES
('add_commits'),
('add_enabled_column'),
('initial'),
('nil_commit_metadata');