From 223771dd6bd03e1150a37ce2367c695eb0f63d27 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Mon, 4 Jan 2016 14:22:05 -0500 Subject: [PATCH] Saving delete so I can do a hotfix on master --- .../create_database_V0.0.2.sql | 51 ------------------- 1 file changed, 51 deletions(-) delete mode 100644 setup/databaseScripts/create_database_V0.0.2.sql diff --git a/setup/databaseScripts/create_database_V0.0.2.sql b/setup/databaseScripts/create_database_V0.0.2.sql deleted file mode 100644 index fa080fb..0000000 --- a/setup/databaseScripts/create_database_V0.0.2.sql +++ /dev/null @@ -1,51 +0,0 @@ --- Gaslight Media Members Database - Packaging --- File Created: 12/02/15 15:27:15 --- Database Version: 0.0.2 --- Database Creation Script --- --- To permit each query below to be executed separately, --- all queries must be separated by a line with four dashes - --- Packages -CREATE TABLE {prefix}packages ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, -- Package is active - title TINYTEXT NULL, -- Title of package - descr TEXT NULL, -- Description of package - short_descr TINYTEXT NULL, -- Short description of package - image TINYTEXT NULL, -- Package image - start_date TIMESTAMP NULL, -- Date display of this package starts - end_date TIMESTAMP NULL, -- Date display of this package ends (last date of display) - expire_date TIMESTAMP NULL, -- Date package expires (first date it's expired) - position INT NULL, -- Display order position - pricing TINYTEXT NULL, -- Pricing, descriptive - ref_type INT NULL, -- Type of entity this package is associated with - ref_dest INT NULL, -- Pointer to the specific entity - PRIMARY KEY (id), - INDEX(ref_type), - INDEX(ref_dest), - INDEX(start_date), - INDEX(end_date), - INDEX(expire_date) -); - ----- - --- Package Elements - Items in a package -CREATE TABLE {prefix}package_elements ( - id INT NOT NULL AUTO_INCREMENT, - package INT NULL, -- Pointer to the package - active BOOLEAN NULL, -- Package is active - title TINYTEXT NULL, -- Title of element - descr TEXT NULL, -- Description for this entity's participation in the package - short_descr TEXT NULL, -- Short description for this entity's participation in the package - image TINYTEXT NULL, -- Element image - position INT NULL, -- Display order position - ref_type INT NULL, -- Type of entity this element is association with - ref_dest INT NULL, -- Pointer to the specific entity - PRIMARY KEY (id), - INDEX(package), - INDEX(ref_type), - INDEX(ref_dest) -); - -- 2.17.1