From: Jason Woofenden <jason@jasonwoof.com>
Date: Thu, 8 Jun 2017 03:57:21 +0000 (-0400)
Subject: remove sql files now that it's all in inc/db_upgrade.php
X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl-cms.git;a=commitdiff_plain;h=d15f2b1e0aac45e7798c2b32816d233d633e2ca4

remove sql files now that it's all in inc/db_upgrade.php
---

diff --git a/admin_email_templates.sql b/admin_email_templates.sql
deleted file mode 100644
index dc11783..0000000
--- a/admin_email_templates.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-drop table if exists email_templates;
-create table email_templates (
-    id int unique auto_increment,
-    slug varchar(200) binary not null default "",
-    notes text binary not null default "",
-    from_addr varchar(100) binary not null default "",
-    to_addr varchar(100) binary not null default "",
-    cc_addr varchar(100) binary not null default "",
-    bcc_addr varchar(100) binary not null default "",
-    subject varchar(200) binary not null default "",
-    content text binary not null default ""
-) CHARSET=utf8;
diff --git a/admin_files.sql b/admin_files.sql
deleted file mode 100644
index 718d3b7..0000000
--- a/admin_files.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-drop table if exists files;
-create table files (
-    id int unique auto_increment,
-    filename varchar(100) not null default "",
-    description varchar(200) not null default ""
-);
diff --git a/admin_images.sql b/admin_images.sql
deleted file mode 100644
index 27e29e7..0000000
--- a/admin_images.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-drop table if exists cms_images;
-create table cms_images (
-    id int unique auto_increment,
-    image varchar(240) not null default "",
-    name varchar(200) not null default "",
-    caption varchar(200) not null default "",
-    created_at int not null default 0
-);
diff --git a/admin_pages.sql b/admin_pages.sql
deleted file mode 100644
index c03a27e..0000000
--- a/admin_pages.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-drop table if exists pages;
-create table cms_pages (
-    id int unique auto_increment,
-    filename varchar(200) not null default "",
-    title varchar(200) not null default "",
-    nav_title varchar(200) not null default "",
-    navbar int not null default 0,
-    layout int not null default 0,
-    content mediumtext not null default "",
-    sidebar_content mediumtext not null default "",
-    description text not null default "",
-    keywords text not null default ""
-);
-insert into cms_pages (filename,title,content,navbar) values ('index','Home','Under Construction',1000000000);
diff --git a/admin_users.sql b/admin_users.sql
deleted file mode 100644
index 34307c8..0000000
--- a/admin_users.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-drop table if exists users;
-create table users (
-	id int unique auto_increment,
-	name varchar(200) binary not null default "",
-	username varchar(200) binary not null default "",
-	password varchar(255) binary not null default "",
-	role varchar(200) binary not null default "",
-	last_active int(11) not null default 0,
-	last_login int(11) not null default 0
-) CHARSET=utf8;
-
-insert into users set
-	name="fixme",
-	username="fixme",
-	password="$2y$10$84xUpPFQFRYRwpGkt01YtObJZcRKGReM/5ywHXCbwDF2bja41CDZm",
-	role="admin";
diff --git a/inc/wfpl b/inc/wfpl
index 646be71..5b22312 160000
--- a/inc/wfpl
+++ b/inc/wfpl
@@ -1 +1 @@
-Subproject commit 646be7194f9fd096ef22f52074cf9c03d595b6ec
+Subproject commit 5b223129ade45127f3945a354f8b2a56799f472c
diff --git a/paypal_ipn.sql b/paypal_ipn.sql
deleted file mode 100644
index c246e93..0000000
--- a/paypal_ipn.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-drop table if exists paypal_ipn;
-create table paypal_ipn (
-	id int unique auto_increment,
-	txn_id varchar(250) not null default "",
-	status varchar(250) not null default "",
-	ipn_at int(11) not null default 0,
-	txn_type varchar(100) not null default "",
-	subscr_id varchar(100) not null default "",
-	custom varchar(250) not null default "",
-	for_table_id int not null default 0,
-	for_row_id int not null default 0,
-	processed int(1) not null default 0,
-	item_name varchar(250) not null default "",
-	item_number varchar(250) not null default "",
-	needs_review int(1) not null default 0,
-	payment_status varchar(250) not null default "",
-	mc_gross varchar(250) not null default "",
-	mc_currency varchar(250) not null default "",
-	receiver_email varchar(250) not null default "",
-	payer_email varchar(250) not null default "",
-	log text not null default "");