preferences

CREATE TABLE preferences (
  identifier                integer NOT NULL PRIMARY KEY,
  print_out                 char(3) CHECK (print_out IN ('ps', 'pdf')),
  start_hour                integer CHECK (start_hour >= 0 AND start_hour < 24),
  end_hour                  integer CHECK (start_hour >= 0 AND start_hour < 24),
  start_day                 integer CHECK (start_day IN (1, 0)),
  num_of_rows               integer,
  num_of_columns            integer,
  folder_view               char(5) CHECK (folder_view IN ('slide', 'list')),
  num_of_rows_l             integer,
  bulk_upload_enable        char(1) CHECK (bulk_upload_enable IN ('t', 'f')),
  paper                     integer REFERENCES paper(identifier),
  label                     integer REFERENCES label(identifier),
  shop_enable               char(1) CHECK (shop_enable IN ('t', 'f')),
  popup_enable              char(1) CHECK (shop_enable IN ('t', 'f')),
  popup_delay               integer,
  quota_size                integer,
  quota_count               integer,
  search_enable_stemming    char(1) CHECK (search_enable_stemming IN ('t', 'f')),
  search_default_mode       integer,
  download_counter          integer,
  download_expiry_period    integer
);

• label references label(identifier)
• paper references paper(identifier)

• users(preferences) references identifier

• preferences_id_sequence

None.

None.

None.

Version 2.5

Version 2.33

= Version 2.5 =

CREATE TABLE preferences (
  identifier            integer NOT NULL PRIMARY KEY,
  print_out             char(3) CHECK (print_out IN ('ps', 'pdf')),
  start_hour            integer CHECK (start_hour >= 0 AND start_hour < 24),
  end_hour              integer CHECK (start_hour >= 0 AND start_hour < 24),
  start_day             integer CHECK (start_day IN (1, 0)),
  num_of_rows           integer,
  sharpen_image_radius  float,
  sharpen_image_sigma   float,
  sharpen_thumb_radius  float,
  sharpen_thumb_sigma   float,
  num_of_columns        integer,
  copyright_statement   text,
  folder_view           char(5) CHECK (folder_view IN ('slide', 'list')),
  num_of_rows_l         integer,
  current_volume        varchar(500),
  volume_max_size       integer
);

= Version 2.6 =

ALTER TABLE preferences ADD COLUMN copyright_statement_photo text;
ALTER TABLE preferences ADD COLUMN bulk_upload_enable char(1) CHECK (bulk_upload_enable IN ('t', 'f'));
ALTER TABLE preferences ADD COLUMN paper integer REFERENCES paper(identifier);
ALTER TABLE preferences ADD COLUMN label integer REFERENCES label(identifier);

= Version 2.7 =

-- extend system preferences table with the current volume and upper size limit
ALTER TABLE system_preferences ADD COLUMN current_volume varchar(500);
ALTER TABLE system_preferences ADD COLUMN volume_max_size integer;

= Version 2.8 =

ALTER TABLE preferences ADD COLUMN shop_enable  char(1) CHECK (shop_enable IN ('t', 'f'));
ALTER TABLE preferences ADD COLUMN popup_enable char(1) CHECK (shop_enable IN ('t', 'f'));
ALTER TABLE preferences ADD COLUMN popup_delay  integer;

= Version 2.11 =

-- we rename colums first since dropping was implemented only with 7.3
ALTER TABLE preferences RENAME COLUMN sharpen_image_radius TO drop_me_sharpen_image_radius;
ALTER TABLE preferences RENAME COLUMN sharpen_image_sigma  TO drop_me_sharpen_image_sigma;
ALTER TABLE preferences RENAME COLUMN sharpen_thumb_radius TO drop_me_sharpen_thumb_radius;
ALTER TABLE preferences RENAME COLUMN sharpen_thumb_sigma  TO drop_me_sharpen_thumb_sigma;
 
-- drop columns which aren't used any longer
ALTER TABLE preferences DROP COLUMN drop_me_sharpen_image_radius;
ALTER TABLE preferences DROP COLUMN drop_me_sharpen_image_sigma;
ALTER TABLE preferences DROP COLUMN drop_me_sharpen_thumb_radius;
ALTER TABLE preferences DROP COLUMN drop_me_sharpen_thumb_sigma;

= Version 2.13 =

ALTER TABLE preferences ADD quota_size integer;
ALTER TABLE preferences ADD quota_count integer;

= Version 2.16 =

ALTER TABLE preferences ADD search_enable_stemming char(1) CHECK (search_enable_stemming IN ('t', 'f'));
ALTER TABLE preferences ADD search_default_mode  integer;

= Version 2.19 =

ALTER TABLE preferences ADD COLUMN download_counter integer;
ALTER TABLE preferences ADD COLUMN download_expiry_period integer;

= Version 2.21 =

-- remove obsolete rows
ALTER TABLE preferences DROP COLUMN copyright_statement_photo;
ALTER TABLE preferences DROP COLUMN copyright_statement;

= Version 2.34 =

-- Drop obselete user preferences
ALTER TABLE preferences DROP num_of_rows;
ALTER TABLE preferences DROP num_of_columns;
ALTER TABLE preferences DROP num_of_rows_l;

DROP TABLE preferences;

= Version 2.5 =

INSERT INTO preferences VALUES (1, 'pdf', '8', '20', '1', 4, 4, '', 'slide', '20', 0.2, 0.2, 0.4, 0.4);

= Version 2.6 =

-- set bulk upload flag to false for everybody except the administrator
UPDATE preferences SET bulk_upload_enable='f';
UPDATE preferences SET bulk_upload_enable='t' WHERE identifier = (SELECT preferences FROM users WHERE type=4);
UPDATE preferences SET paper='13';
UPDATE preferences SET label='17';

= Version 2.7 =

UPDATE system_preferences SET volume_max_size=640;

= Version 2.8 =

UPDATE preferences SET shop_enable ='f';
UPDATE preferences SET popup_enable='f';
UPDATE preferences SET popup_delay =500;
UPDATE preferences SET shop_enable ='t' WHERE identifier = (SELECT preferences FROM users WHERE type=4);
UPDATE preferences SET popup_enable='t' WHERE identifier = (SELECT preferences FROM users WHERE type=4);

= Version 2.13 =

-- set all quotas to unlimited
UPDATE preferences SET quota_size = 0;
UPDATE preferences SET quota_count = 0;

= Version 2.16 =

UPDATE preferences SET search_enable_stemming = 'f';
UPDATE preferences SET search_default_mode = 1;

= Version 2.19 =

UPDATE preferences SET download_counter = 10;
UPDATE preferences SET download_expiry_period = 14;

= Version 2.29 =

UPDATE preferences SET download_counter=10 WHERE download_counter IS NULL;
UPDATE preferences SET download_expiry_period=1095 WHERE download_expiry_period IS NULL;

= Version 2.34 =

-- Fix this broken preference..
UPDATE preferences SET search_default_mode = 1 WHERE search_default_mode IS NULL;
UPDATE preferences SET folder_view = 'slide' WHERE folder_view IS NULL;