BrowserID

来自开放百科 - 灰狐
2012年7月4日 (三) 15:33Allen (讨论 | 贡献)的版本

跳转到: 导航, 搜索

BrowserID

Browserid-persona-chain-of-trust.png

代码

数据库部分

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;",
];

图集

链接

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱