欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
BrowserID
来自开放百科 - 灰狐
(版本间的差异)
小 (→安装) |
小 (→图集) |
||
第50行: | 第50行: | ||
") ENGINE=InnoDB;", | ") ENGINE=InnoDB;", | ||
]; | ]; | ||
+ | |||
+ | ==PostgreSQL== | ||
+ | |||
+ | ==MySQL== | ||
+ | |||
==图集== | ==图集== |
2012年9月6日 (四) 06:50的版本
BrowserID
目录 |
安装
Mac OS X
确认已安装:
- node.js (>= 0.6.17)
- libgmp3
- g++
git clone https://github.com/mozilla/browserid.git cd browserid npm install npm start
可能出现:static (20153): error: can't read public key, exiting: Error: ENOENT, no such file or directory '/User/huihoo/browserid/var/root.cert'
example (20145): using browserid server at http://127.0.0.1:10002 example (20145): running on http://127.0.0.1:10001 example_primary (20146): using browserid server at http://127.0.0.1:10002 example_primary (20146): running on http://127.0.0.1:10005 proxy (20148): running on http://127.0.0.1:10006 verifier (20140): info: running on http://127.0.0.1:10000 keysigner (20141): info: running on http://127.0.0.1:10003
代码
数据库部分
const schemas = [ "CREATE TABLE IF NOT EXISTS user (" + "id BIGINT AUTO_INCREMENT PRIMARY KEY," + "passwd CHAR(64)" + ") ENGINE=InnoDB;",
"CREATE TABLE IF NOT EXISTS email (" + "id BIGINT AUTO_INCREMENT PRIMARY KEY," + "user BIGINT NOT NULL," + "address VARCHAR(255) UNIQUE NOT NULL," + "type ENUM('secondary', 'primary') DEFAULT 'secondary' NOT NULL," + "FOREIGN KEY user_fkey (user) REFERENCES user(id)" + ") ENGINE=InnoDB;",
"CREATE TABLE IF NOT EXISTS staged (" + "id BIGINT AUTO_INCREMENT PRIMARY KEY," + "secret CHAR(48) UNIQUE NOT NULL," + "new_acct BOOL NOT NULL," + "existing_user BIGINT," + "email VARCHAR(255) UNIQUE NOT NULL," + "passwd CHAR(64)," + "ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL," + "FOREIGN KEY existing_user_fkey (existing_user) REFERENCES user(id)" + ") ENGINE=InnoDB;", ];
PostgreSQL
MySQL
图集
链接
分享您的观点