[platal.git] / upgrade / 1.1.0 / 05_permissions.sql

ALTER TABLE accounts CHANGE COLUMN user_perms user_perms
    SET('groups', 'mail', 'directory_ax', 'directory_private', 'edit_directory',
        'forums', 'lists', 'payment', 'api_user_readonly') DEFAULT NULL;

ALTER TABLE account_types CHANGE COLUMN perms perms
    SET('groups', 'mail', 'directory_ax', 'directory_private', 'edit_directory',
        'forums', 'lists', 'payment', 'api_user_readonly') NOT NULL;

-- vim:set syntax=mysql:
Commit	Line	Data
16d2c883 VZ	1	ALTER TABLE accounts CHANGE COLUMN user_perms user_perms
	2	SET('groups', 'mail', 'directory_ax', 'directory_private', 'edit_directory',
	3	'forums', 'lists', 'payment', 'api_user_readonly') DEFAULT NULL;
	4
	5	ALTER TABLE account_types CHANGE COLUMN perms perms
	6	SET('groups', 'mail', 'directory_ax', 'directory_private', 'edit_directory',
	7	'forums', 'lists', 'payment', 'api_user_readonly') NOT NULL;
	8
	9	-- vim:set syntax=mysql: