From 8de9fd30276a273e715c0f3ee4cf227d2927bb36 Mon Sep 17 00:00:00 2001 From: Jeena 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