mirror of
https://github.com/Icinga/icingaweb2.git
synced 2025-09-01 15:18:10 +02:00
49cf62a9dc
Fix coding standards in database schemes. Use DbAdapterFactory in all unit tests instead of creating own adapters. Fix DbUserBackend and DbStore to use FETCH_OBJ, instead of FETCH_ASSOC, to handle it consistently in the whole application. Remove unnecessary table columns from the "account" scheme. refs #4577 refs #4578 refs #4596 refs #4599 refs #4627
6 lines
246 B
SQL
6 lines
246 B
SQL
create table `preference`(
|
|
`username` VARCHAR(255) COLLATE latin1_general_ci NOT NULL,
|
|
`key` VARCHAR(100) COLLATE latin1_general_ci NOT NULL,
|
|
`value` VARCHAR(255) NOT NULL,
|
|
PRIMARY KEY (`username`, `key`)
|
|
) ENGINE=InnoDB; |