NEW FEATURE: added OpenID support

[e-DoKo.git] / create_database.sql

diff --git a/create_database.sql b/create_database.sql
index 319cdd356fd6108db0a8c3fd501f4257716bdc4b..339c3371d30f07d0d1efdb03a95635120f38feed 100644 (file)
--- 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)
+);