User Tools

Site Tools


podoc:system_preferences_sql_table

This is an old revision of the document!


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

None.

Is referenced by tables

None.

None.

None.

None.

None.

History

Used first

Version 2.6

Used last

Still in use

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'));
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.1177080491.txt.gz · Last modified: 2007/04/20 14:48 by Luud