BrowserID

2012年7月4日 (三) 03:25的版本

BrowserID

代码

数据库部分

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

链接

• https://browserid.org
• BrowserID @ GitHub