User Tools

Site Tools


podoc:system_preferences_sql_table

Database Table Description of "system_preferences"

Name

system_preferences

Description

Purpose

Schema

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

References tables

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

Is referenced by tables

None.

None.

None.

None.

None.

History

Used first

Version 2.6

Used last

Version 2.33

Schema change history

= 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;
Data change history

= 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';
podoc/system_preferences_sql_table.txt · Last modified: 2007/10/19 10:32 by Luud