From 8de9fd30276a273e715c0f3ee4cf227d2927bb36 Mon Sep 17 00:00:00 2001
From: Jeena <spam@jeenaparadies.net>
Date: Wed, 15 Jul 2015 20:04:07 -0700
Subject: adds possibility to use sqlite as a db

---
 schema/mysql.sql | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 schema/mysql.sql

(limited to 'schema/mysql.sql')

diff --git a/schema/mysql.sql b/schema/mysql.sql
new file mode 100644
index 0000000..5f33ce6
--- /dev/null
+++ b/schema/mysql.sql
@@ -0,0 +1,23 @@
+CREATE TABLE `users` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `url` varchar(255) DEFAULT NULL,
+  `authorization_endpoint` varchar(255) DEFAULT NULL,
+  `token_endpoint` varchar(255) DEFAULT NULL,
+  `micropub_endpoint` varchar(255) DEFAULT NULL,
+  `micropub_access_token` text,
+  `micropub_scope` varchar(255) DEFAULT NULL,
+  `micropub_response` text,
+  `micropub_success` tinyint(4) DEFAULT '0',
+  `date_created` datetime DEFAULT NULL,
+  `last_login` datetime DEFAULT NULL,
+  `last_micropub_response` text,
+  `last_micropub_response_date` datetime DEFAULT NULL,
+  `location_enabled` tinyint(4) NOT NULL DEFAULT '0',
+  `syndication_targets` text,
+  `facebook_access_token` text,
+  `twitter_access_token` text,
+  `twitter_token_secret` text,
+  `twitter_username` varchar(255) DEFAULT NULL,
+  `instagram_access_token` text,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3

