summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAaron Parecki <aaron@parecki.com>2015-04-18 17:45:14 -0700
committerAaron Parecki <aaron@parecki.com>2015-04-18 17:45:14 -0700
commitecd4b8de9393a4cf1a9469075e9479214a4148ca (patch)
tree50d00d0314305347fad6f544515214dd9214685f
parent1c4bf54da4ca2419598a8cb541b3cb3737452aab (diff)
add DB schema
closes #6
-rw-r--r--schema/schema.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/schema/schema.sql b/schema/schema.sql
new file mode 100644
index 0000000..5f33ce6
--- /dev/null
+++ b/schema/schema.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;