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'))
);

• new_user_label references label(identifier)
• new_user_paper references paper(identifier)
• new_user_type references user_type(identifier)

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';