summaryrefslogtreecommitdiff
path: root/schema/schema.sql
diff options
context:
space:
mode:
authorJeena <spam@jeenaparadies.net>2015-07-15 20:04:07 -0700
committerJeena <spam@jeenaparadies.net>2015-07-24 20:52:16 +0200
commit8de9fd30276a273e715c0f3ee4cf227d2927bb36 (patch)
tree9cda9fbe2cd4ea6a80541445cec223b6e8de9bc4 /schema/schema.sql
parent91307d4a362a8fab0022aba19ab74bec9cb46f8f (diff)
adds possibility to use sqlite as a db
Diffstat (limited to 'schema/schema.sql')
-rw-r--r--schema/schema.sql23
1 files changed, 0 insertions, 23 deletions
diff --git a/schema/schema.sql b/schema/schema.sql
deleted file mode 100644
index 5f33ce6..0000000
--- a/schema/schema.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-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;