Skip to content

Instantly share code, notes, and snippets.

@hobodave
Created July 24, 2009 23:29
Show Gist options
  • Save hobodave/82b992328d6d32d00d9c to your computer and use it in GitHub Desktop.
Save hobodave/82b992328d6d32d00d9c to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment