users

CREATE TABLE users (
  identifier                     integer NOT NULL PRIMARY KEY,
  first_name                     varchar(50),
  last_name                      varchar(50),
  company                        varchar(50),
  username                       varchar(30),
  password                       varchar(30),
  contact                        integer REFERENCES contact_info(identifier),
  member_since                   timestamp,
  type                           integer NOT NULL REFERENCES user_type(identifier)
);

• contact references contact_info(identifier)
• dcraw_options references dcraw_options(identifier)
• imagemagick_options references imagemagick_options(identifier)
• imagemagick_composite_options references imagemagick_composite_options(identifier)
• preferences references preferences(identifier)
• type references user_type(identifier)

• album(users) references identifier
• calendar(users) references identifier
• calendar(client) references identifier
• camera(users) references identifier
• camera_type(users) references identifier
• client(client) references identifier
• client(users) references identifier
• film(users) references identifier
• film_type(last_modifying_users) references identifier
• filter(users) references identifier
• filter_type(last_modifying_users) references identifier
• flash(users) references identifier
• flash_type(last_modifying_users) references identifier
• folder(users) references identifier
• label(users) references identifier
• lens(users) references identifier
• lens_type(last_modifying_users) references identifier
• location(users) references identifier
• manufacturer(last_modifying_users) references identifier
• paper(users) references identifier
• photo(users) references identifier
• photo_spooler(users) references identifier
• rating(users) references identifier
• scanner(users) references identifier
• scanner_type(last_modifying_users) references identifier
• shop_category(users) references identifier
• shop_item(users) references identifier
• shop_item_generator_rule(users) references identifier
• shop_order(client) references identifier
• submission(users) references identifier
• support(users) references identifier
• support_type(last_modifying_users) references identifier

• users_id_sequence

• users_idx removed in 2.34

• count_users

• view_client
• view_contact
• view_rating
• view_users_subscribed_to
• view_submission removed in 2.34

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE users (
  identifier            integer NOT NULL PRIMARY KEY,
  first_name            varchar(50),
  last_name             varchar(50),
  company               varchar(50),
  username              varchar(30),
  password              varchar(30),
  session_id            varchar(32),
  contact               integer REFERENCES contact_info(identifier),
  member_since          timestamp,
  preferences           integer REFERENCES preferences(identifier),
  type                  integer NOT NULL REFERENCES user_type(identifier),
  hide                  BOOLEAN NOT NULL DEFAULT 'f'
);

= Version 2.11 =

-- create new reference from the users table
ALTER TABLE users ADD COLUMN imagemagick_options integer REFERENCES imagemagick_options(identifier);

= Version 2.18 =

ALTER TABLE users ADD COLUMN shared char(1) CHECK (shared IN ('t', 'f'));

= Version 2.21 =

ALTER TABLE users ADD COLUMN imagemagick_composite_options integer REFERENCES imagemagick_composite_options(identifier);
 
UPDATE users SET imagemagick_composite_options = imagemagick_options;
ALTER TABLE users ALTER COLUMN imagemagick_composite_options SET NOT NULL;
 
ALTER TABLE users ADD COLUMN dcraw_options integer REFERENCES dcraw_options(identifier);
 
UPDATE users SET dcraw_options = imagemagick_options;
ALTER TABLE users ALTER COLUMN dcraw_options SET NOT NULL;

= Version 2.34 =

-- Drop more obsolete user stuff
 
ALTER TABLE users DROP shared;
ALTER TABLE users DROP session_id;
ALTER TABLE users DROP preferences;
ALTER TABLE users DROP imagemagick_options;
ALTER TABLE users DROP imagemagick_composite_options;
ALTER TABLE users DROP dcraw_options;

--- Add a 'hide' field to the users table.
 
ALTER TABLE users ADD hide BOOLEAN;
ALTER TABLE users ALTER COLUMN hide SET DEFAULT 'f';

ALTER TABLE users ALTER COLUMN hide SET NOT NULL;

= Version 2.5 =

INSERT INTO users VALUES (1, 'admin', 'admin', '', 'admin', 'admin', '30091973', 1, now(), 1, 4);

= Version 2.11 =

-- update the newly created imagemagick reference that is the same as for the preferences
UPDATE users SET imagemagick_options = preferences;
ALTER TABLE users ALTER COLUMN imagemagick_options SET NOT NULL;

= Version 2.12 =

-- we do this just to make sure that that error in the 2.11 release is cleared.
UPDATE users SET imagemagick_options=preferences;

= Version 2.18 =

UPDATE users SET shared = 'f';

= Version 2.34 =

UPDATE users SET hide = 'f';