X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=create_database.sql;h=339c3371d30f07d0d1efdb03a95635120f38feed;hp=319cdd356fd6108db0a8c3fd501f4257716bdc4b;hb=03d6cd5ba13a0aac918734c1f797df4f149d9194;hpb=6206ef89ad9a9a1a541ecb67971815d11f12199b

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)
+);