Files
sysPass/schemas/31019012201.sql
Rubén D 5503dd8de5 * [FIX] Wrong behavior when upgrading from v3.0. Thanks to @Envikia for the feedback. Related #1401
* [MOD] Improved error code when an unknown API token is used. Thanks to @matejzero for the feedback. Closes #1429
* [FIX] Wrong behavior when changing master password and there aren't any accounts for processing. Thanks to @matejzero for the feedback. Closes #1430

Signed-off-by: Rubén D <nuxsmin@syspass.org>
2019-08-21 23:50:19 +02:00

17 lines
492 B
SQL

DELIMITER $$
alter table Plugin
add versionLevel varchar(15) null $$
create table PluginData
(
name varchar(100) not null,
itemId int not null,
`data` blob not null,
`key` varbinary(2000) not null,
primary key (name, itemId),
constraint fk_PluginData_name
foreign key (name) references Plugin (name)
on update cascade
on delete cascade
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE utf8_unicode_ci $$