gistfile1.sql

mysql> show create table tickets\G
*************************** 1. row ***************************
       Table: tickets
Create Table: CREATE TABLE `tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `resolved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `fk_tickets_shop_id` (`shop_id`,`ticket_status`),
  KEY `idx_tickets_created` (`created`),
  KEY `idx_tickets_resolved` (`resolved`),
) ENGINE=MyISAM AUTO_INCREMENT=210368 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> show create table shifts\G
*************************** 1. row ***************************
       Table: shifts
Create Table: CREATE TABLE `shifts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shop_id_fk_idx` (`shop_id`),
  KEY `updated_by_fk_idx` (`updated_by`)
) ENGINE=MyISAM AUTO_INCREMENT=349 DEFAULT CHARSET=utf8
1 row in set (0.02 sec)

mysql> show create table shifts_users\G
*************************** 1. row ***************************
       Table: shifts_users
Create Table: CREATE TABLE `shifts_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shift_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `shift_position_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `shift_id_fk_idx` (`shift_id`),
  KEY `user_id_fk_idx` (`user_id`),
  KEY `shift_position_id_fk_idx` (`shift_position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1809 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> show create table shift_positions\G
*************************** 1. row ***************************
       Table: shift_positions
Create Table: CREATE TABLE `shift_positions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `level` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
1 row in set (0.03 sec)

mysql> show create table shift_times\G
*************************** 1. row ***************************
       Table: shift_times
Create Table: CREATE TABLE `shift_times` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shift_id` int(11) NOT NULL,
  `start` time NOT NULL,
  `end` time NOT NULL,
  `dow` enum('1','2','3','4','5','6','7') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `shift_id_fk_idx` (`shift_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3415 DEFAULT CHARSET=utf8