您最多选择25个主题
主题必须以字母或数字开头,可以包含连字符 (-),并且长度不得超过35个字符
48 行
1.6 KiB
SQL
48 行
1.6 KiB
SQL
/*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*/
|
|
|
|
DROP TABLE IF EXISTS `available_apps`;
|
|
DROP TABLE IF EXISTS `apps`;
|
|
|
|
CREATE TABLE IF NOT EXISTS `userloginkeys` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`key` VARCHAR(255) NOT NULL,
|
|
`expires` DATETIME NULL DEFAULT NULL,
|
|
`uid` INT(11) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`, `key`),
|
|
UNIQUE INDEX `id_UNIQUE` (`id` ASC),
|
|
UNIQUE INDEX `key_UNIQUE` (`key` ASC),
|
|
INDEX `fk_userloginkeys_accounts1_idx` (`uid` ASC),
|
|
CONSTRAINT `fk_userloginkeys_accounts1`
|
|
FOREIGN KEY (`uid`)
|
|
REFERENCES `accounts` (`uid`)
|
|
ON DELETE NO ACTION
|
|
ON UPDATE NO ACTION)
|
|
ENGINE = InnoDB
|
|
DEFAULT CHARACTER SET = utf8;
|
|
|
|
ALTER TABLE `userloginkeys`
|
|
ADD COLUMN `appname` VARCHAR(255) NOT NULL AFTER `uid`;
|
|
ALTER TABLE `userloginkeys`
|
|
ADD COLUMN `appicon` TINYTEXT NULL DEFAULT NULL AFTER `appname`;
|
|
ALTER TABLE `apikeys`
|
|
ADD COLUMN `type` VARCHAR(45) NOT NULL DEFAULT 'FULL' AFTER `notes`;
|
|
|
|
CREATE TABLE IF NOT EXISTS `apppasswords` (
|
|
`passid` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`hash` VARCHAR(255) NOT NULL,
|
|
`uid` INT(11) NOT NULL,
|
|
`description` VARCHAR(255) NOT NULL,
|
|
PRIMARY KEY (`passid`, `uid`),
|
|
UNIQUE INDEX `passid_UNIQUE` (`passid` ASC),
|
|
INDEX `fk_apppasswords_accounts1_idx` (`uid` ASC),
|
|
CONSTRAINT `fk_apppasswords_accounts1`
|
|
FOREIGN KEY (`uid`)
|
|
REFERENCES `accounts` (`uid`)
|
|
ON DELETE NO ACTION
|
|
ON UPDATE NO ACTION)
|
|
ENGINE = InnoDB
|
|
DEFAULT CHARACTER SET = utf8; |