<commit_before>/*Table structure for table `contractors` */

DROP TABLE IF EXISTS `contractors`;

CREATE TABLE `contractors` (
  `contractor_id` int(11) NOT NULL AUTO_INCREMENT,
  `contractor_name` varchar(100) DEFAULT NULL,
  `contractor_phone` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`contractor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `contracts` */

DROP TABLE IF EXISTS `contracts`;

CREATE TABLE `contracts` (
  `contract_id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_contractor` int(11) NOT NULL,
  `contract_start` date NOT NULL,
  `contract_end` date NOT NULL,
  `contract_notes` TEXT,
  PRIMARY KEY (`contract_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `intervals` */

DROP TABLE IF EXISTS `intervals`;

CREATE TABLE `intervals` (
  `intervals_id` int(11) NOT NULL AUTO_INCREMENT,
  `intervals_name` varchar(255) NOT NULL,
  `intervals_months` int(11) NOT NULL,
  PRIMARY KEY (`intervals_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Table structure for table `item_types` */

DROP TABLE IF EXISTS `item_types`;

CREATE TABLE `item_types` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `items` */

DROP TABLE IF EXISTS `items`;

CREATE TABLE `items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` int(11) NOT NULL,
  `item_location` int(11) NOT NULL,
  `item_site` int(11) NOT NULL,
  `item_contract` int(11),
  `item_interval` int(11) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_notes` text,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `locations` */

DROP TABLE IF EXISTS `locations`;

CREATE TABLE `locations` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_site` int(11) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `services` */

DROP TABLE IF EXISTS `services`;

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_item` int(11) NOT NULL,
  `service_date` date NOT NULL,
  `service_notes` text NOT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `servicing` */

DROP TABLE IF EXISTS `servicing`;

CREATE TABLE `servicing` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Location` int(11) NOT NULL,
  `Item` varchar(30) DEFAULT NULL,
  `Type` int(11) NOT NULL,
  `Contractor` int(11) NOT NULL,
  `Interval` varchar(20) DEFAULT NULL,
  `Last Serviced` date DEFAULT NULL,
  `Next Due` date DEFAULT NULL,
  `SiteID` int(11) NOT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Table structure for table `sites` */

DROP TABLE IF EXISTS `sites`;

CREATE TABLE `sites` (
  `site_id` int(11) NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) NOT NULL,
  PRIMARY KEY (`site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;<commit_msg>Add an up top date sql dump.<commit_after>DROP TABLE IF EXISTS `contractors`;
CREATE TABLE `contractors` (
  `contractor_id` int(11) NOT NULL AUTO_INCREMENT,
  `contractor_name` varchar(100) DEFAULT NULL,
  `contractor_phone` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`contractor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `contracts`;
CREATE TABLE `contracts` (
  `contract_id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_contractor` int(11) NOT NULL,
  `contract_start` date NOT NULL,
  `contract_end` date NOT NULL,
  `contract_notes` text,
  PRIMARY KEY (`contract_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `intervals`;
CREATE TABLE `intervals` (
  `intervals_id` int(11) NOT NULL AUTO_INCREMENT,
  `intervals_name` varchar(255) NOT NULL,
  `intervals_months` int(11) NOT NULL,
  PRIMARY KEY (`intervals_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `intervals` WRITE;
insert  into `intervals`(`intervals_id`,`intervals_name`,`intervals_months`) values (6,'Weekly',0),(7,'Monthly',1),(8,'Quarterly',4),(9,'Biannually',6),(10,'Annually',12),(11,'Biennially',24),(12,'Triennially',36),(13,'Quadrennially',48),(14,'Pentennially',60),(15,'Sexennial',72),(16,'Septennial',84),(17,'Octennial',96),(18,'Novennial',108),(19,'Decennial',120),(20,'Sesquiannual',18);
UNLOCK TABLES;

DROP TABLE IF EXISTS `item_types`;
CREATE TABLE `item_types` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` int(11) NOT NULL,
  `item_location` int(11) NOT NULL,
  `item_site` int(11) NOT NULL,
  `item_contract` int(11) DEFAULT NULL,
  `item_interval` int(11) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_notes` text,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `locations`;
CREATE TABLE `locations` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_site` int(11) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_item` int(11) NOT NULL,
  `service_date` date NOT NULL,
  `service_notes` text NOT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `servicing`;
CREATE TABLE `servicing` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Location` int(11) NOT NULL,
  `Item` varchar(30) DEFAULT NULL,
  `Type` int(11) NOT NULL,
  `Contractor` int(11) NOT NULL,
  `Interval` varchar(20) DEFAULT NULL,
  `Last Serviced` date DEFAULT NULL,
  `Next Due` date DEFAULT NULL,
  `SiteID` int(11) NOT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `sites`;
CREATE TABLE `sites` (
  `site_id` int(11) NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) NOT NULL,
  PRIMARY KEY (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
{'fraction_non_alphanumeric': 0.12847111394829236, 'fraction_numerical': 0.03463134375997447, 'mean_word_length': 5.688367129135539, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1821210', 'n_tokens_mistral': 2551, 'n_tokens_neox': 2311, 'n_words': 646}