/* database files */

CREATE TABLE `corporations` (
  `corp_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `corp_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`corp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `elements_of_time` (
  `element_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `time_id` int(11) unsigned NOT NULL DEFAULT '1',
  `corp_id` int(11) unsigned NOT NULL DEFAULT '1',
  `element_start_date` date DEFAULT '0000-00-00',
  `general_title` varchar(100) DEFAULT NULL,
  `created_by_id` int(11) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`element_id`),
  KEY `time_id` (`time_id`),
  KEY `corp_id` (`corp_id`),
  KEY `element_start_date` (`element_start_date`),
  KEY `created_by_id` (`created_by_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `payee` (
  `payee_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `payee_first_name` varchar(50) DEFAULT NULL,
  `payee_last_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`payee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `time_sub_gps` (
  `time_sub_gps_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `time_id` int(11) unsigned NOT NULL DEFAULT '1',
  `corp_id` int(11) unsigned NOT NULL DEFAULT '1',
  `created_by_id` int(11) unsigned NOT NULL DEFAULT '1',
  `created_date_time` datetime DEFAULT '0000-00-00 00:00:00',
  `sub_gps_date` date DEFAULT '0000-00-00',
  `sub_gps_time` time DEFAULT '00:00:00',
  `use_sub_gps_time` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sub_gps_x` varchar(25) DEFAULT NULL,
  `sub_gps_y` varchar(25) DEFAULT NULL,
  `sub_gps_z` varchar(25) DEFAULT NULL,
  `sub_gps_unit_num` varchar(50) DEFAULT NULL,
  `sub_gps_title` varchar(100) DEFAULT NULL,
  `sub_gps_notes` varchar(255) DEFAULT NULL,
  `sub_gps_sort` int(11) unsigned NOT NULL DEFAULT '100',
  `sub_gps_status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`time_sub_gps_id`),
  KEY `time_id` (`time_id`),
  KEY `corp_id` (`corp_id`),
  KEY `created_by_id` (`created_by_id`),
  KEY `sub_gps_date` (`sub_gps_date`),
  KEY `sub_gps_unit_num` (`sub_gps_unit_num`),
  KEY `sub_gps_sort` (`sub_gps_sort`),
  KEY `sub_gps_status` (`sub_gps_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `corporations` VALUES (1,'Dummy'),(2,'Adilas, LLC.'),(3,'Test Corp'),(4,'Morningstar Auto, Inc.');

INSERT INTO `elements_of_time` VALUES (1,1,1,'2015-01-28','Dummy',1);

INSERT INTO `payee` VALUES (1,'Dummy','Dummy'),(2,'Brandon','Moore'),(3,'Dave','Forbis'),(4,'Garrett','Kirschbaum'),(5,'Bryan','Dayton'),(6,'James','Broadbent'),(7,'Adam','Tew'),(8,'Derrick','Saunders'),(9,'Randy','Wright'),(10,'Daniel','Swainston'),(11,'Shawn','Curtis');

INSERT INTO `time_sub_gps` VALUES (1,1,1,1,'2015-01-28 12:00:00','2015-01-28','12:00:00',1,'Dummy','Dummy','Dummy','Dummy','Dummy','Dummy',100,1);