From 91ac7d162a4d99cd44a126350e60ff748a3c87a3 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Fri, 6 Nov 2015 15:42:27 -0500 Subject: [PATCH] Interim update so Steve can review --- ...e_directories_here_should_be_committed.txt | 1 - .../create_database_V1.0.30.sql | 757 ------------------ .../databaseScripts/drop_database_V1.0.30.sql | 35 - misc/documentation/glm-member-db/plugin.ini | 101 --- misc/documentation/glm-member-db/readme.txt | 7 - models/front/NOTHING_HERE_YET | 0 .../settingsPage-ISTHISNEEDED/index.html | 14 - 7 files changed, 915 deletions(-) delete mode 100644 media/Nothing_under_the_directories_here_should_be_committed.txt delete mode 100644 misc/databaseScripts/create_database_V1.0.30.sql delete mode 100644 misc/databaseScripts/drop_database_V1.0.30.sql delete mode 100644 misc/documentation/glm-member-db/plugin.ini delete mode 100644 misc/documentation/glm-member-db/readme.txt delete mode 100644 models/front/NOTHING_HERE_YET delete mode 100644 views/admin/settingsPage-ISTHISNEEDED/index.html diff --git a/media/Nothing_under_the_directories_here_should_be_committed.txt b/media/Nothing_under_the_directories_here_should_be_committed.txt deleted file mode 100644 index 12ca4a6a..00000000 --- a/media/Nothing_under_the_directories_here_should_be_committed.txt +++ /dev/null @@ -1 +0,0 @@ -Nothing in the directories found here should be committed, only the directories (i.e. "images") \ No newline at end of file diff --git a/misc/databaseScripts/create_database_V1.0.30.sql b/misc/databaseScripts/create_database_V1.0.30.sql deleted file mode 100644 index c9e5964a..00000000 --- a/misc/databaseScripts/create_database_V1.0.30.sql +++ /dev/null @@ -1,757 +0,0 @@ --- Gaslight Media Members Database --- File Created: 12/09/14 15:27:15 --- Database Version: 0.1 --- Database Creation Script --- --- To permit each query below to be executed separately, --- all queries must be separated by a line with four dashes - - -CREATE TABLE {prefix}accommodation_types ( - id INT NOT NULL AUTO_INCREMENT, - facility_type INT NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - PRIMARY KEY (id), - INDEX(facility_type), - INDEX(name(20)) -); - ----- - -CREATE TABLE {prefix}accommodations ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - name TINYTEXT NULL, - accommodation_type INT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - quant INT NULL, - reservation_url TINYTEXT NULL, - reservation_id TINYTEXT NULL, - year_round TINYINT(1) NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(accommodation_type), - INDEX(name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}accounts ( - id INT NOT NULL AUTO_INCREMENT, - member INT NULL, - payment_type INT NULL, - invoice_delivery INT NULL, - PRIMARY KEY (id), - INDEX(member) -); - ----- - -CREATE TABLE {prefix}activties ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - activity_type INT NULL, - facility INT NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - phone TINYTEXT NULL, - url TINYTEXT NULL, - notes TEXT NULL, - create_time TIMESTAMP NULL, - modify_time TIMESTAMP NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(activity_type), - INDEX(name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}amenities ( - id INT NOT NULL AUTO_INCREMENT, - active TINYINT(1) NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - ref_type INT NULL, - uses_value BOOLEAN NULL, - PRIMARY KEY (id), - INDEX(name(20)) -); - ----- - -CREATE TABLE {prefix}amenity_ref ( - id INT NOT NULL AUTO_INCREMENT, - amenity INT NULL, - ref_type INT NULL, - ref_dest INT NULL, - amenity_value TINYTEXT NULL, - PRIMARY KEY (id), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}categories ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - parent INT NULL, - PRIMARY KEY (id) -); - ----- - -CREATE TABLE {prefix}category_member_info ( - id INT NOT NULL AUTO_INCREMENT, - category INT NULL, - member_info INT NULL, - PRIMARY KEY (id), - CONSTRAINT {prefix}categories_fk_1 - FOREIGN KEY (category) - REFERENCES {prefix}categories (id) - ON DELETE CASCADE, - INDEX(category), - INDEX(member_info) -); - ----- - -CREATE TABLE {prefix}cities ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - PRIMARY KEY (id) -); - ----- - -CREATE TABLE {prefix}contacts ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - fname TINYTEXT NULL, - lname TINYTEXT NULL, - contact_type INT NULL, - org TINYTEXT NULL, - addr1 TINYTEXT NULL, - addr2 TINYTEXT NULL, - city INT NULL, - state INT NULL, - country INT NULL, - zip TINYTEXT NULL, - lat FLOAT NULL, - lon FLOAT NULL, - url TINYTEXT NULL, - office_phone TINYTEXT NULL, - home_phone TINYTEXT NULL, - mobile_phone TINYTEXT NULL, - alt_phone TINYTEXT NULL, - fax TINYTEXT NULL, - email TINYTEXT NULL, - alt_email TINYTEXT NULL, - password TINYTEXT NULL, - permissions TINYTEXT NULL, - notes TEXT NULL, - create_time TIMESTAMP NULL, - modify_time TIMESTAMP NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(fname(20)), - INDEX(lname(20)), - INDEX(city), - INDEX(zip(10)), - INDEX(lat), - INDEX(lon), - INDEX(email(20)) -); - ----- - -CREATE TABLE {prefix}facilities ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - facility_type INT NULL, - location INT NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - addr1 TINYTEXT NULL, - addr2 TINYTEXT NULL, - city INT NULL, - state INT NULL, - country INT NULL, - zip TINYTEXT NULL, - lat FLOAT NULL, - lon FLOAT NULL, - phone TINYTEXT NULL, - toll_free TINYTEXT NULL, - url TINYTEXT NULL, - logo TINYTEXT NULL, - notes TEXT NULL, - create_time TIMESTAMP NULL, - modify_time TIMESTAMP NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(city), - INDEX(zip(10)), - INDEX(lat), - INDEX(lon) -); - ----- - -CREATE TABLE {prefix}files ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - file_name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - size INT NULL, - pending TINYINT(1) NULL, - create_date DATE NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(file_name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}golf ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - rating TINYTEXT NULL, - par TINYTEXT NULL, - yardage TINYTEXT NULL, - slope TINYTEXT NULL, - walking TINYINT(1) NULL, - holes INT NULL, - reservation_url TINYTEXT NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}images ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - status TINYINT(1) NULL, - file_name TINYTEXT NULL, - descr TEXT NULL, - caption TINYTEXT NULL, - position INT NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(file_name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}locations ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - location_type INT NULL, - member INT NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - addr1 TINYTEXT NULL, - addr2 TINYTEXT NULL, - city INT NULL, - state INT NULL, - country INT NULL, - zip TINYTEXT NULL, - lat FLOAT NULL, - lon FLOAT NULL, - region INT NULL, - phone TINYTEXT NULL, - toll_free TINYTEXT NULL, - url TINYTEXT NULL, - logo TINYTEXT NULL, - notes TEXT NULL, - create_time TIMESTAMP NULL, - modify_time TIMESTAMP NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(city), - INDEX(zip(10)), - INDEX(lat), - INDEX(lon), - INDEX(region) -); - ----- - -CREATE TABLE {prefix}meals ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - menu TEXT NULL, - special_menu TEXT NULL, - daily_time TINYINT(1) NULL, - daily_start_time TIME NULL, - daily_end_time TIME NULL, - daily_res_req TINYINT(1) NULL, - sunday TINYINT(1) NULL, - sun_menu TEXT NULL, - sun_start_time TIME NULL, - sun_end_time TIME NULL, - sun_res_req TINYINT(1) NULL, - monday TINYINT(1) NULL, - mon_menu TEXT NULL, - mon_start_time TIME NULL, - mon_end_time TIME NULL, - mon_res_req TINYINT(1) NULL, - tuesday TINYINT(1) NULL, - tue_menu TEXT NULL, - tue_start_time TIME NULL, - tue_end_time TIME NULL, - tue_res_req TINYINT(1) NULL, - wednesday TINYINT(1) NULL, - wed_menu TEXT NULL, - wed_start_time TIME NULL, - wed_end_time TIME NULL, - wed_res_req TINYINT(1) NULL, - thursday TINYINT(1) NULL, - thu_menu TEXT NULL, - thu_start_time TIME NULL, - thu_end_time TIME NULL, - thu_res_req TINYINT(1) NULL, - friday TINYINT(1) NULL, - fri_menu TEXT NULL, - fri_start_time TIME NULL, - fri_end_time TIME NULL, - fri_res_req TINYINT(1) NULL, - saturday TINYINT(1) NULL, - sat_menu TEXT NULL, - sat_start_time TIME NULL, - sat_end_time TIME NULL, - sat_res_req TINYINT(1) NULL, - restaurant INT NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(name(20)) -); - ----- - -CREATE TABLE {prefix}members ( - id INT NOT NULL AUTO_INCREMENT, - access INT NULL, - member_type INT NULL, - created DATE NULL, - name TINYTEXT NULL, - member_slug TINYTEXT NULL, - PRIMARY KEY (id), - INDEX(name(20)), - INDEX(member_slug(20)), - INDEX(created) -); - ----- - -CREATE TABLE {prefix}member_info ( - id INT NOT NULL AUTO_INCREMENT, - member INT NULL, - member_name TINYTEXT NULL, - status INT NULL, - reference_name TINYTEXT NULL, - descr TEXT NULL, - short_descr TEXT NULL, - addr1 TINYTEXT NULL, - addr2 TINYTEXT NULL, - city INT NULL, - state TINYTEXT NULL, - country TINYTEXT NULL, - zip TINYTEXT NULL, - lat FLOAT NULL, - lon FLOAT NULL, - region INT NULL, - phone TINYTEXT NULL, - toll_free TINYTEXT NULL, - url TINYTEXT NULL, - email TINYTEXT NULL, - logo TINYTEXT NULL, - cc_type INT NULL, - notes TEXT NULL, - create_time TIMESTAMP NULL, - modify_time TIMESTAMP NULL, - PRIMARY KEY (id), - INDEX(status), - INDEX(city), - INDEX(zip(10)), - INDEX(lat), - INDEX(lon), - INDEX(region) -); - ----- - -CREATE TABLE {prefix}member_type ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - descr TINYTEXT NULL, - PRIMARY KEY (id) -); - ----- - -CREATE TABLE {prefix}regions ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - PRIMARY KEY (id) -); - ----- - -CREATE TABLE {prefix}restaurant_types ( - id INT NOT NULL AUTO_INCREMENT, - active TINYINT(1) NULL, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - PRIMARY KEY (id), - INDEX(name(20)) -); - ----- - -CREATE TABLE {prefix}restaurants ( - id INT NOT NULL AUTO_INCREMENT, - active BOOLEAN NULL, - name TINYTEXT NULL, - restaurant_type INT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - menu TEXT NULL, - special_menu TEXT NULL, - url TINYTEXT NULL, - reservation_url TINYTEXT NULL, - phone TINYTEXT NULL, - hours_descr TINYTEXT NULL, - alcohol TINYINT(1) NULL, - non_smoking TINYINT(1) NULL, - notes TEXT NULL, - ref_type INT NULL, - ref_dest INT NULL, - PRIMARY KEY (id), - INDEX(restaurant_type), - INDEX(name(20)), - INDEX(ref_type), - INDEX(ref_dest) -); - ----- - -CREATE TABLE {prefix}settings_general ( - id INT NOT NULL AUTO_INCREMENT, - admin_debug BOOLEAN DEFAULT '1', - admin_debug_verbose BOOLEAN DEFAULT '0', - front_debug BOOLEAN DEFAULT '0', - front_debug_verbose BOOLEAN DEFAULT '0', - google_maps_api_key TINYTEXT DEFAULT '', - maps_default_lat FLOAT DEFAULT '45.3749', - maps_default_lon FLOAT DEFAULT '-84.9592', - maps_default_zoom INTEGER DEFAULT '10', - time_zone TINYTEXT DEFAULT NULL, - canonical_member_page TINYTEXT DEFAULT NULL, - list_show_map BOOLEAN DEFAULT '1', - list_show_list BOOLEAN DEFAULT '1', - list_show_search BOOLEAN DEFAULT '1', - list_show_search_text BOOLEAN DEFAULT '1', - list_show_search_category BOOLEAN DEFAULT '1', - list_show_search_amenities BOOLEAN DEFAULT '1', - list_show_search_alpha BOOLEAN DEFAULT '1', - list_show_detail_link BOOLEAN DEFAULT '1', - list_show_logo BOOLEAN DEFAULT '1', - list_logo_size TINYTEXT NULL, - list_show_address BOOLEAN DEFAULT '1', - list_show_street BOOLEAN DEFAULT '1', - list_show_citystatezip BOOLEAN DEFAULT '1', - list_show_country BOOLEAN DEFAULT '1', - list_show_region BOOLEAN DEFAULT '1', - list_show_descr BOOLEAN DEFAULT '0', - list_show_short_descr BOOLEAN DEFAULT '1', - list_show_phone BOOLEAN DEFAULT '1', - list_show_tollfree BOOLEAN DEFAULT '1', - list_show_url BOOLEAN DEFAULT '1', - list_show_url_newtarget BOOLEAN DEFAULT '1', - list_show_email BOOLEAN DEFAULT '1', - list_show_categories BOOLEAN DEFAULT '1', - list_show_creditcards BOOLEAN DEFAULT '1', - list_show_amenities BOOLEAN DEFAULT '0', - list_map_show_detaillink BOOLEAN DEFAULT '1', - list_map_show_logo BOOLEAN DEFAULT '0', - list_map_logo_size TINYTEXT NULL, - list_map_show_descr BOOLEAN DEFAULT '0', - list_map_show_short_descr BOOLEAN DEFAULT '1', - list_map_show_address BOOLEAN DEFAULT '1', - list_map_show_street BOOLEAN DEFAULT '1', - list_map_show_citystatezip BOOLEAN DEFAULT '1', - list_map_show_country BOOLEAN DEFAULT '1', - list_map_show_region BOOLEAN DEFAULT '1', - list_map_show_phone BOOLEAN DEFAULT '1', - list_map_show_tollfree BOOLEAN DEFAULT '1', - list_map_show_url BOOLEAN DEFAULT '1', - list_map_show_url_newtarget BOOLEAN DEFAULT '1', - list_map_show_email BOOLEAN DEFAULT '1', - list_map_show_categories BOOLEAN DEFAULT '0', - list_map_show_creditcards BOOLEAN DEFAULT '0', - list_map_show_amenities BOOLEAN DEFAULT '0', - detail_show_map BOOLEAN DEFAULT '1', - detail_show_directions BOOLEAN DEFAULT '1', - detail_show_logo BOOLEAN DEFAULT '1', - detail_logo_size TINYTEXT NULL, - detail_show_descr BOOLEAN DEFAULT '1', - detail_show_short_descr BOOLEAN DEFAULT '0', - detail_show_address BOOLEAN DEFAULT '1', - detail_show_street BOOLEAN DEFAULT '1', - detail_show_citystatezip BOOLEAN DEFAULT '1', - detail_show_country BOOLEAN DEFAULT '1', - detail_show_region BOOLEAN DEFAULT '1', - detail_show_phone BOOLEAN DEFAULT '1', - detail_show_tollfree BOOLEAN DEFAULT '1', - detail_show_url BOOLEAN DEFAULT '1', - detail_show_url_newtarget BOOLEAN DEFAULT '1', - detail_show_email BOOLEAN DEFAULT '1', - detail_show_categories BOOLEAN DEFAULT '1', - detail_show_creditcards BOOLEAN DEFAULT '1', - detail_show_amenities BOOLEAN DEFAULT '1', - detail_show_imagegallery BOOLEAN DEFAULT '1', - detail_show_coupons BOOLEAN DEFAULT '0', - detail_show_packages BOOLEAN DEFAULT '0', - detail_map_show_logo BOOLEAN DEFAULT '0', - detail_map_logo_size TINYTEXT NULL, - detail_map_show_descr BOOLEAN DEFAULT '0', - detail_map_show_short_descr BOOLEAN DEFAULT '1', - detail_map_show_address BOOLEAN DEFAULT '1', - detail_map_show_street BOOLEAN DEFAULT '1', - detail_map_show_citystatezip BOOLEAN DEFAULT '1', - detail_map_show_country BOOLEAN DEFAULT '1', - detail_map_show_region BOOLEAN DEFAULT '1', - detail_map_show_phone BOOLEAN DEFAULT '1', - detail_map_show_tollfree BOOLEAN DEFAULT '1', - detail_map_show_url BOOLEAN DEFAULT '1', - detail_map_show_url_newtarget BOOLEAN DEFAULT '1', - detail_map_show_email BOOLEAN DEFAULT '1', - detail_map_show_categories BOOLEAN DEFAULT '0', - detail_map_show_creditcards BOOLEAN DEFAULT '0', - detail_map_show_amenities BOOLEAN DEFAULT '0', - PRIMARY KEY (id) -); - ----- - -INSERT INTO {prefix}settings_general - ( id, time_zone, canonical_member_page ) - VALUES - ( 1, 'America/Detroit', 'member-detail' ) -; - ----- - -CREATE TABLE {prefix}settings_terms ( - id INT NOT NULL AUTO_INCREMENT, - term_admin_menu_members TINYTEXT NULL, - term_admin_menu_member_list TINYTEXT NULL, - term_admin_menu_member TINYTEXT NULL, - term_admin_menu_configure TINYTEXT NULL, - term_admin_menu_settings TINYTEXT NULL, - term_admin_menu_shortcodes TINYTEXT NULL, - term_admin_menu_members_dashboard TINYTEXT NULL, - term_admin_menu_members_list TINYTEXT NULL, - term_admin_menu_members_reports TINYTEXT NULL, - term_admin_menu_member_dashboard TINYTEXT NULL, - term_admin_menu_member_info TINYTEXT NULL, - term_admin_menu_member_locations TINYTEXT NULL, - term_admin_menu_member_facilities TINYTEXT NULL, - term_admin_menu_member_attractions TINYTEXT NULL, - term_admin_menu_member_contacts TINYTEXT NULL, - term_admin_menu_configure_member_types TINYTEXT NULL, - term_admin_menu_configure_member_cats TINYTEXT NULL, - term_admin_menu_configure_accom_types TINYTEXT NULL, - term_admin_menu_configure_amenities TINYTEXT NULL, - term_admin_menu_configure_cities TINYTEXT NULL, - term_admin_menu_configure_regions TINYTEXT NULL, - term_admin_menu_settings_general TINYTEXT NULL, - term_admin_menu_settings_terms TINYTEXT NULL, - term_admin_menu_settings_development TINYTEXT NULL, - term_member TINYTEXT NULL, - term_member_cap TINYTEXT NULL, - term_member_plur TINYTEXT NULL, - term_member_plur_cap TINYTEXT NULL, - term_location TINYTEXT NULL, - term_location_cap TINYTEXT NULL, - term_location_plur TINYTEXT NULL, - term_location_plur_cap TINYTEXT NULL, - term_facility TINYTEXT NULL, - term_facility_cap TINYTEXT NULL, - term_facility_plur TINYTEXT NULL, - term_facility_plur_cap TINYTEXT NULL, - term_attraction TINYTEXT NULL, - term_attraction_cap TINYTEXT NULL, - term_attraction_plur TINYTEXT NULL, - term_attraction_plur_cap TINYTEXT NULL, - term_contact TINYTEXT NULL, - term_contact_cap TINYTEXT NULL, - term_contact_plur TINYTEXT NULL, - term_contact_plur_cap TINYTEXT NULL, - PRIMARY KEY (id) -); - ----- - -INSERT INTO {prefix}settings_terms - ( - id, - term_admin_menu_members, - term_admin_menu_member_list, - term_admin_menu_member, - term_admin_menu_configure, - term_admin_menu_settings, - term_admin_menu_shortcodes, - term_admin_menu_members_dashboard, - term_admin_menu_members_list, - term_admin_menu_members_reports, - term_admin_menu_member_dashboard, - term_admin_menu_member_info, - term_admin_menu_member_locations, - term_admin_menu_member_facilities, - term_admin_menu_member_attractions, - term_admin_menu_member_contacts, - term_admin_menu_configure_member_types, - term_admin_menu_configure_member_cats, - term_admin_menu_configure_accom_types, - term_admin_menu_configure_amenities, - term_admin_menu_configure_cities, - term_admin_menu_configure_regions, - term_admin_menu_settings_general, - term_admin_menu_settings_terms, - term_admin_menu_settings_development, - term_member, - term_member_cap, - term_member_plur, - term_member_plur_cap, - term_location, - term_location_cap, - term_location_plur, - term_location_plur_cap, - term_facility, - term_facility_cap, - term_facility_plur, - term_facility_plur_cap, - term_attraction, - term_attraction_cap, - term_attraction_plur, - term_attraction_plur_cap, - term_contact, - term_contact_cap, - term_contact_plur, - term_contact_plur_cap - ) - VALUES - ( - 1, - 'Members', - 'Member', - 'Add Member', - 'Configure', - 'Management', - 'Shortcodes', - 'Dashboard', - 'Member List', - 'Reports', - 'Member Dashboard', - 'Member Info', - 'Locations', - 'Facilities', - 'Attractions', - 'Contacts', - 'Member Types', - 'Member Categories', - 'Accommodation Types', - 'Amenities', - 'Cities', - 'Regions', - 'General Settings', - 'Terms & Phrases', - 'Development', - 'member', - 'Member', - 'members', - 'Members', - 'location', - 'Location', - 'locations', - 'Locations', - 'facility', - 'Facility', - 'facilities', - 'Facilities', - 'attraction', - 'Attraction', - 'attractions', - 'Attractions', - 'contact', - 'Contact', - 'contacts', - 'Contacts' - ) -; - ----- - -CREATE TABLE {prefix}social_media ( - id INT NOT NULL AUTO_INCREMENT, - name TINYTEXT NULL, - descr TEXT NULL, - short_descr TINYTEXT NULL, - PRIMARY KEY (id) -); - ----- - -CREATE TABLE {prefix}social_media_ref ( - id INT NOT NULL AUTO_INCREMENT, - ref_type INT NULL, - ref_dest INT NULL, - social_media INT NULL, - url TINYTEXT NULL, - PRIMARY KEY (id), - INDEX(ref_type), - INDEX(ref_dest), - INDEX(social_media) -); diff --git a/misc/databaseScripts/drop_database_V1.0.30.sql b/misc/databaseScripts/drop_database_V1.0.30.sql deleted file mode 100644 index 2c792d88..00000000 --- a/misc/databaseScripts/drop_database_V1.0.30.sql +++ /dev/null @@ -1,35 +0,0 @@ --- Gaslight Media Members Database --- File Created: 12/09/14 15:27:15 --- Database Version: 0.1 --- Database Deletion Script --- Note: Tables with DELETE CASCADE must appear before referenced table - -DROP TABLE - {prefix}accommodation_types, - {prefix}accommodations, - {prefix}accounts, - {prefix}activties, - {prefix}amenities, - {prefix}amenity_ref, - {prefix}category_member_info, - {prefix}categories, - {prefix}cities, - {prefix}contacts, - {prefix}facilities, - {prefix}files, - {prefix}golf, - {prefix}images, - {prefix}locations, - {prefix}meals, - {prefix}members, - {prefix}member_info, - {prefix}member_type, - {prefix}regions, - {prefix}restaurant_types, - {prefix}restaurants, - {prefix}settings_general, - {prefix}settings_terms, - {prefix}social_media, - {prefix}social_media_ref -; - diff --git a/misc/documentation/glm-member-db/plugin.ini b/misc/documentation/glm-member-db/plugin.ini deleted file mode 100644 index c93511c9..00000000 --- a/misc/documentation/glm-member-db/plugin.ini +++ /dev/null @@ -1,101 +0,0 @@ -; -; Theme Specific Configuration File -; Gaslight Media Members Database Plugin -; -; Standard ini parameters in the plugin are -; replaced by the same parameters in this file. - -; Debug Options -admin_debug = false -admin_debug_verbose = false -front_debug = false -front_debug_verbose = true - -; Front-end Member Listing - [glm-members-list] -front-config['list_show_map'] = true -front-config['list_show_list'] = true -front-config['list_show_search'] = false -front-config['list_search_text'] = true -front-config['list_search_category'] = true -front-config['list_search_amenities'] = false -front-config['list_search_alpha'] = true -; Front-end Member Listing Options -front-config['list_show_detaillink'] = true -front-config['list_show_logo'] = true -front-config['list_logo_size'] = small -front-config['list_show_address'] = true -front-config['list_show_street'] = true -front-config['list_show_citystatezip'] = true -front-config['list_show_country'] = false -front-config['list_show_region'] = true -front-config['list_show_description'] = true -front-config['list_show_short_descr'] = true -front-config['list_show_phone'] = true -front-config['list_show_tollfree'] = true -front-config['list_show_url'] = true -front-config['list_show_categories'] = false -front-config['list_show_creditcards'] = false -front-config['list_show_amenities'] = false -; Front-end Meber Listing Map Options -front-config['list_map_show_detaillink'] = true -front-config['list_map_show_logo'] = true -front-config['list_map_logo_size'] = thumb -front-config['list_map_show_description'] = true -front-config['list_map_show_short_descr'] = false -front-config['list_map_show_address'] = true -front-config['list_map_show_street'] = true -front-config['list_map_show_citystatezip'] = true -front-config['list_map_show_country'] = true -front-config['list_map_show_region'] = true -front-config['list_map_show_phone'] = true -front-config['list_map_show_tollfree'] = true -front-config['list_map_show_url'] = true -front-config['list_map_show_categories'] = true -front-config['list_map_show_creditcards'] = true -front-config['list_map_show_amenities'] = false -; Front-end Member Detail Options -front-config['detail_show_map'] = true -front-config['detail_show_directions'] = true -front-config['detail_show_detaillink'] = true -front-config['detail_show_logo'] = true -front-config['detail_logo_size'] = large -front-config['detail_show_address'] = true -front-config['detail_show_street'] = true -front-config['detail_show_citystatezip'] = true -front-config['detail_show_country'] = true -front-config['detail_show_region'] = true -front-config['detail_show_description'] = true -front-config['detail_show_short_descr'] = false -front-config['detail_show_phone'] = true -front-config['detail_show_tollfree'] = true -front-config['detail_show_url'] = true -front-config['detail_show_categories'] = true -front-config['detail_show_creditcards'] = true -front-config['detail_show_amenities'] = true - -; General Terms -term['term_member'] = 'accommodation' -term['term_member_cap'] = 'Accommodation' -term['term_member_plur'] = 'accommodations' -term['term_member_plur_cap'] = 'Accommodations' - -term['term_location'] = 'location' -term['term_location_cap'] = 'Location' -term['term_location_plur'] = 'locations' -term['term_location_plur_cap'] = 'Locations' - -term['term_facility'] = 'facility' -term['term_facility_cap'] = 'Facility' -term['term_facility_plur'] = 'facilities' -term['term_facility_plur_cap'] = 'Facilities' - -term['term_attraction'] = 'attraction' -term['term_attraction_cap'] = 'Attraction' -term['term_attraction_plur'] = 'attractions' -term['term_attraction_plur_cap'] = 'Attractions' - -term['term_contact'] = 'contact' -term['term_contact_cap'] = 'Contact' -term['term_contact_plur'] = 'contacts' -term['term_contact_plur_cap'] = 'Contacts' - diff --git a/misc/documentation/glm-member-db/readme.txt b/misc/documentation/glm-member-db/readme.txt deleted file mode 100644 index 46bd4903..00000000 --- a/misc/documentation/glm-member-db/readme.txt +++ /dev/null @@ -1,7 +0,0 @@ -Copy this entire folder into your current theme to start customizing -the Gaslight Media Member Database plugin for the current site. - -The plugin.ini file parameters overwrite matching parameters in the -plugin config files. - -More to come.... \ No newline at end of file diff --git a/models/front/NOTHING_HERE_YET b/models/front/NOTHING_HERE_YET deleted file mode 100644 index e69de29b..00000000 diff --git a/views/admin/settingsPage-ISTHISNEEDED/index.html b/views/admin/settingsPage-ISTHISNEEDED/index.html deleted file mode 100644 index de804cf0..00000000 --- a/views/admin/settingsPage-ISTHISNEEDED/index.html +++ /dev/null @@ -1,14 +0,0 @@ - -

- -
-

My Plugin Options

-
- {php} settings_fields( 'glm-member-db-settings-group' ); {/php} - {php} do_settings_sections( 'glm-member-db-settings' ); {/php} - {php} submit_button(); {/php} -
-
-- 2.17.1