Photo Organizer

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