podoc:preferences_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:preferences_sql_table [2007/04/16 13:30] – Luud | podoc:preferences_sql_table [2007/10/19 18:54] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table preferences ( |
- | print_out | + | identifier |
- | start_hour | + | print_out |
- | end_hour | + | start_hour |
- | start_day | + | end_hour |
- | num_of_rows | + | start_day |
- | num_of_columns | + | num_of_rows |
- | | + | num_of_columns |
- | | + | folder_view |
- | num_of_rows_l | + | num_of_rows_l |
- | | + | bulk_upload_enable |
- | sharpen_image_sigma | + | paper |
- | sharpen_thumb_radius | + | label |
- | sharpen_thumb_sigma | + | shop_enable |
- | copyright_statement_photo text, | + | popup_enable |
- | | + | popup_delay |
- | paper | + | |
- | label | + | quota_count |
- | shop_enable | + | search_enable_stemming |
- | popup_enable | + | search_default_mode |
- | popup_delay | + | download_counter |
- | ); | + | download_expiry_period |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * label references [[label sql table|label]](identifier) | ||
+ | * paper references [[paper sql table|paper]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[users sql table|users]](preferences) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 40: | Line 51: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 53: | Line 70: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Schema change history == | == Schema change history == | ||
Line 59: | Line 76: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table preferences ( |
- | print_out | + | identifier |
- | start_hour | + | print_out |
- | end_hour | + | start_hour |
- | start_day | + | end_hour |
- | num_of_rows | + | start_day |
- | num_of_columns | + | num_of_rows |
- | copyright_statement | + | |
- | folder_view | + | sharpen_image_sigma |
- | num_of_rows_l | + | sharpen_thumb_radius |
- | current_volume | + | sharpen_thumb_sigma |
- | volume_max_size | + | |
- | ); | + | copyright_statement |
+ | folder_view | ||
+ | num_of_rows_l | ||
+ | current_volume | ||
+ | volume_max_size | ||
+ | ); | ||
+ | </ | ||
= Version 2.6 = | = Version 2.6 = | ||
- | < | + | < |
alter table preferences add column copyright_statement_photo text; | alter table preferences add column copyright_statement_photo text; | ||
alter table preferences add column bulk_upload_enable char(1) check (bulk_upload_enable in (' | alter table preferences add column bulk_upload_enable char(1) check (bulk_upload_enable in (' | ||
Line 85: | Line 108: | ||
= Version 2.7 = | = Version 2.7 = | ||
- | < | + | < |
-- extend system preferences table with the current volume and upper size limit | -- 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 current_volume varchar(500); | ||
Line 93: | Line 116: | ||
= Version 2.8 = | = Version 2.8 = | ||
- | < | + | < |
alter table preferences add column shop_enable | alter table preferences add column shop_enable | ||
alter table preferences add column popup_enable char(1) check (shop_enable in (' | alter table preferences add column popup_enable char(1) check (shop_enable in (' | ||
Line 101: | Line 124: | ||
= Version 2.11 = | = Version 2.11 = | ||
- | < | + | < |
-- we rename colums first since dropping was implemented only with 7.3 | -- 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_radius to drop_me_sharpen_image_radius; | ||
Line 113: | Line 136: | ||
alter table preferences drop column drop_me_sharpen_thumb_radius; | alter table preferences drop column drop_me_sharpen_thumb_radius; | ||
alter table preferences drop column drop_me_sharpen_thumb_sigma; | alter table preferences drop column drop_me_sharpen_thumb_sigma; | ||
+ | </ | ||
+ | |||
+ | = Version 2.13 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table preferences add quota_size integer; | ||
+ | alter table preferences add quota_count integer; | ||
+ | </ | ||
+ | |||
+ | = Version 2.16 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table preferences add search_enable_stemming char(1) check (search_enable_stemming in (' | ||
+ | alter table preferences add search_default_mode | ||
+ | </ | ||
+ | |||
+ | = Version 2.19 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table preferences add column download_counter integer; | ||
+ | alter table preferences add column download_expiry_period integer; | ||
+ | </ | ||
+ | |||
+ | = Version 2.21 = | ||
+ | |||
+ | <code sql> | ||
+ | -- remove obsolete rows | ||
+ | alter table preferences drop column copyright_statement_photo; | ||
+ | alter table preferences drop column copyright_statement; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- 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; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | DROP TABLE preferences; | ||
</ | </ | ||
Line 119: | Line 184: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into preferences values (1, ' | insert into preferences values (1, ' | ||
</ | </ | ||
Line 125: | Line 190: | ||
= Version 2.6 = | = Version 2.6 = | ||
- | < | + | < |
-- set bulk upload flag to false for everybody except the administrator | -- set bulk upload flag to false for everybody except the administrator | ||
update preferences set bulk_upload_enable=' | update preferences set bulk_upload_enable=' | ||
Line 135: | Line 200: | ||
= Version 2.7 = | = Version 2.7 = | ||
- | < | + | < |
update system_preferences set volume_max_size=640; | update system_preferences set volume_max_size=640; | ||
</ | </ | ||
Line 141: | Line 206: | ||
= Version 2.8 = | = Version 2.8 = | ||
- | < | + | < |
update preferences set shop_enable =' | update preferences set shop_enable =' | ||
update preferences set popup_enable=' | update preferences set popup_enable=' | ||
Line 151: | Line 216: | ||
= Version 2.13 = | = Version 2.13 = | ||
- | < | + | < |
-- set all quotas to unlimited | -- set all quotas to unlimited | ||
update preferences set quota_size = 0; | update preferences set quota_size = 0; | ||
Line 159: | Line 224: | ||
= Version 2.16 = | = Version 2.16 = | ||
- | < | + | < |
update preferences set search_enable_stemming = ' | update preferences set search_enable_stemming = ' | ||
update preferences set search_default_mode = 1; | update preferences set search_default_mode = 1; | ||
Line 166: | Line 231: | ||
= Version 2.19 = | = Version 2.19 = | ||
- | < | + | < |
update preferences set download_counter = 10; | update preferences set download_counter = 10; | ||
update preferences set download_expiry_period = 14; | update preferences set download_expiry_period = 14; | ||
Line 173: | Line 238: | ||
= Version 2.29 = | = Version 2.29 = | ||
- | < | + | < |
update preferences set download_counter=10 where download_counter is null; | update preferences set download_counter=10 where download_counter is null; | ||
update preferences set download_expiry_period=1095 where download_expiry_period is null; | update preferences set download_expiry_period=1095 where download_expiry_period is null; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Fix this broken preference.. | ||
+ | update preferences set search_default_mode = 1 where search_default_mode is null; | ||
+ | update preferences set folder_view = ' | ||
</ | </ | ||
podoc/preferences_sql_table.1176730222.txt.gz · Last modified: 2007/04/16 13:30 by Luud