24 lines
1.1 KiB
MySQL
24 lines
1.1 KiB
MySQL
|
-- account.accountConfig
|
||
|
|
ALTER TABLE account.accountConfig MODIFY COLUMN id tinyint(3) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.accountConfig ADD CONSTRAINT accountConfig_check CHECK (id = 1);
|
||
|
|
|
||
|
|
-- account.ldapConfig
|
||
|
|
ALTER TABLE account.ldapConfig MODIFY COLUMN id int(10) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.ldapConfig ADD CONSTRAINT ldapConfig_check CHECK (id = 1);
|
||
|
|
|
||
|
|
-- account.mailConfig
|
||
|
|
ALTER TABLE account.mailConfig MODIFY COLUMN id int(10) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.mailConfig ADD CONSTRAINT mailConfig_check CHECK (id = 1);
|
||
|
|
|
||
|
|
-- account.roleConfig
|
||
|
|
ALTER TABLE account.roleConfig MODIFY COLUMN id int(10) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.roleConfig ADD CONSTRAINT roleConfig_check CHECK (id = 1);
|
||
|
|
|
||
|
|
-- account.sambaConfig
|
||
|
|
ALTER TABLE account.sambaConfig MODIFY COLUMN id tinyint(3) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.sambaConfig ADD CONSTRAINT sambaConfig_check CHECK (id = 1);
|
||
|
|
|
||
|
|
-- account.userConfig
|
||
|
|
ALTER TABLE account.userConfig MODIFY COLUMN id int(10) unsigned NOT NULL;
|
||
|
|
ALTER TABLE account.userConfig ADD CONSTRAINT userConfig_check CHECK (id = 1);
|