From 34e909a373bd8f9e53126a3d419ecf3dfb7a5937 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 13 Mar 2019 14:32:15 -0400 Subject: [PATCH] Remove extra db files Found in setup after big issue with merging develop and master branches. --- .../create_database_V0.0.1.sql | 52 ------------------- .../databaseScripts/drop_database_V0.0.1.sql | 1 - 2 files changed, 53 deletions(-) delete mode 100644 setup/databaseScripts/create_database_V0.0.1.sql delete mode 100644 setup/databaseScripts/drop_database_V0.0.1.sql diff --git a/setup/databaseScripts/create_database_V0.0.1.sql b/setup/databaseScripts/create_database_V0.0.1.sql deleted file mode 100644 index b5f9b39..0000000 --- a/setup/databaseScripts/create_database_V0.0.1.sql +++ /dev/null @@ -1,52 +0,0 @@ --- Gaslight Media Members Database - Job Postings --- File Created: 12/02/15 15:27:15 --- Database Version: 0.0.2 --- Database Creation Script --- --- This file is called to create a new set of tables for this --- add-on for the most receint database version for this add-on. --- --- There should only be one such file in this directory --- --- To permit each query below to be executed separately, --- all queries must be separated by a line with four dashes - --- Conditions Table -CREATE TABLE {prefix}reports ( - id INT NOT NULL AUTO_INCREMENT, - report_active BOOL NOT NULL, - report_date DATE NOT NULL, - report_notes TEXT NOT NULL, - big_bay_name TEXT NOT NULL, - big_bay_cond TEXT NOT NULL, - big_bay_groom DATE NOT NULL, - big_bay_base TINYTEXT NOT NULL, - big_bay_notes TEXT NOT NULL, - alston_cond TEXT NOT NULL, - alston_name TEXT NOT NULL, - alston_groom DATE NOT NULL, - alston_base TINYTEXT NOT NULL, - alston_notes TEXT NOT NULL, - nestoria_name TEXT NOT NULL, - nestoria_cond TEXT NOT NULL, - nestoria_groom DATE NOT NULL, - nestoria_base TINYTEXT NOT NULL, - nestoria_notes TEXT NOT NULL, - chassell_name TEXT NOT NULL, - chassell_cond TEXT NOT NULL, - chassell_groom DATE NOT NULL, - chassell_base TINYTEXT NOT NULL, - chassell_notes TEXT NOT NULL, - pinery_name TEXT NOT NULL, - pinery_groom DATE NOT NULL, - pinery_base TINYTEXT NOT NULL, - pinery_notes TEXT NOT NULL, - report_blurb TEXT NOT NULL, - PRIMARY KEY (id) -); - ----- - --- Job Postings default entries in table -INSERT INTO {prefix}reports ( id,report_date,report_notes,big_bay_name,big_bay_cond,big_bay_groom,big_bay_base,big_bay_notes,alston_name,alston_cond,alston_groom,alston_base,alston_notes,nestoria_name,nestoria_cond,nestoria_groom,nestoria_base,nestoria_notes,chassell_name,chassell_cond,chassell_groom,chassell_base,chassell_notes,pinery_name,pinery_groom,pinery_base,pinery_notes,report_blurb) VALUES -(1,NOW(),'Trail Notes','Big Bay Trail','Fair',NOW(),'8"-12"','Notes','Alston Trail','Fair',NOW(),'8"-12"','Notes','Nestoria Trail','Fair',NOW(),'8"-12"','Notes','Chassell Trail','Fair',NOW(),'8"-12"','Notes','Pinery Trail',NOW(),'8"-12"','Notes','Grooming'); \ No newline at end of file diff --git a/setup/databaseScripts/drop_database_V0.0.1.sql b/setup/databaseScripts/drop_database_V0.0.1.sql deleted file mode 100644 index 8b13789..0000000 --- a/setup/databaseScripts/drop_database_V0.0.1.sql +++ /dev/null @@ -1 +0,0 @@ - -- 2.17.1