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.
Related sequences
None.
Related indexes
None.
Related functions
None.
Related views
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