system_preferences
CREATE TABLE system_preferences ( identifier INTEGER NOT NULL PRIMARY KEY, new_user_type INTEGER NOT NULL REFERENCES user_type(identifier), new_user_bulk_upload_enable CHAR(1) CHECK (new_user_bulk_upload_enable IN ('t', 'f')), new_user_paper INTEGER REFERENCES paper(identifier), new_user_label INTEGER REFERENCES label(identifier), new_user_shop_enable CHAR(1) CHECK (new_user_shop_enable IN ('t', 'f')), new_user_quota_size INTEGER, new_user_quota_count INTEGER, COLUMN new_user_shared CHAR(1) CHECK (new_user_shared IN ('t', 'f')) );
None.
None.
None.
None.
None.
Version 2.6
Version 2.33
= Version 2.6 =
CREATE TABLE system_preferences ( identifier INTEGER NOT NULL PRIMARY KEY, new_user_type INTEGER NOT NULL REFERENCES user_type(identifier), new_user_bulk_upload_enable CHAR(1) CHECK (new_user_bulk_upload_enable IN ('t', 'f')), new_user_paper INTEGER REFERENCES paper(identifier), new_user_label INTEGER REFERENCES label(identifier) );
= Version 2.8 =
ALTER TABLE system_preferences ADD COLUMN new_user_shop_enable CHAR(1) CHECK (new_user_shop_enable IN ('t', 'f'));
= Version 2.13 =
ALTER TABLE system_preferences ADD new_user_quota_size INTEGER; ALTER TABLE system_preferences ADD new_user_quota_count INTEGER;
= Version 2.18 =
ALTER TABLE system_preferences ADD COLUMN new_user_shared CHAR(1) CHECK (new_user_shared IN ('t', 'f'));
= Version 2.34 =
-- Drop more obselete user stuff ALTER TABLE system_preferences DROP new_user_shared;
------ Drop system preferences table too! DROP TABLE system_preferences;
= Version 2.6 =
-- insert system preferences INSERT INTO system_preferences VALUES (1, 2, 'f', 13, 17);
= Version 2.8 =
UPDATE system_preferences SET new_user_shop_enable='f';
= Version 2.13 =
-- set new user quota to unlimited UPDATE system_preferences SET new_user_quota_size = 0; UPDATE system_preferences SET new_user_quota_count = 0;
= Version 2.18 =
UPDATE system_preferences SET new_user_shared = 'f';