summaryrefslogtreecommitdiffstats
path: root/create_database.sql
diff options
context:
space:
mode:
authorArun Persaud <arun@nubati.net>2009-04-25 00:33:14 -0700
committerArun Persaud <arun@nubati.net>2009-04-25 11:32:25 -0700
commita57cfa3be6ee0fbce336dc98e2862ac39f2b1add (patch)
treeb7e4fc46ca06b6147c005700fb2a092c5b13a080 /create_database.sql
parent4cbc3848a891ac9addf10264d24a9f4273c5e355 (diff)
downloade-DoKo-a57cfa3be6ee0fbce336dc98e2862ac39f2b1add.tar.gz
e-DoKo-a57cfa3be6ee0fbce336dc98e2862ac39f2b1add.tar.bz2
e-DoKo-a57cfa3be6ee0fbce336dc98e2862ac39f2b1add.zip
NEW FEATURE: added OpenID support
Users can add and delete OpenIDs on the settings page and then log in user those OpenIds. They can also use their OpenIDs to register.
Diffstat (limited to 'create_database.sql')
-rw-r--r--create_database.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql
index 319cdd3..339c337 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -457,3 +457,11 @@ UNLOCK TABLES;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+DROP TABLE IF EXISTS `user_openids`;
+create table user_openids (
+ openid_url varchar(255) not null,
+ primary key (openid_url),
+
+ user_id int not null,
+ index (user_id)
+);