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/13 08:41] – 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 |
- | | + | |
- | | + | |
- | | + | |
- | | + | |
- | ); | + | popup_enable |
+ | popup_delay | ||
+ | quota_size | ||
+ | quota_count | ||
+ | search_enable_stemming | ||
+ | | ||
+ | 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 33: | Line 51: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 46: | Line 70: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Schema change history == | == Schema change history == | ||
Line 52: | 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 |
- | | + | sharpen_thumb_sigma |
- | | + | |
- | | + | copyright_statement |
- | | + | folder_view |
- | ); | + | num_of_rows_l |
+ | | ||
+ | | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | = Version 2.6 = | ||
+ | |||
+ | <code sql> | ||
+ | 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 paper integer references paper(identifier); | ||
+ | alter table preferences add column label integer references label(identifier); | ||
+ | </ | ||
+ | |||
+ | = Version 2.7 = | ||
+ | |||
+ | <code sql> | ||
+ | -- 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 volume_max_size integer; | ||
+ | </ | ||
+ | |||
+ | = Version 2.8 = | ||
+ | |||
+ | <code sql> | ||
+ | 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_delay | ||
+ | </ | ||
+ | |||
+ | = Version 2.11 = | ||
+ | |||
+ | <code sql> | ||
+ | -- 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_sigma | ||
+ | alter table preferences rename column sharpen_thumb_radius to drop_me_sharpen_thumb_radius; | ||
+ | alter table preferences rename column sharpen_thumb_sigma | ||
+ | |||
+ | -- drop columns which aren't used any longer | ||
+ | alter table preferences drop column drop_me_sharpen_image_radius; | ||
+ | alter table preferences drop column drop_me_sharpen_image_sigma; | ||
+ | alter table preferences drop column drop_me_sharpen_thumb_radius; | ||
+ | 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; | ||
+ | </ | ||
- | = Data change history = | + | == Data change history |
= Version 2.5 = | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | insert into preferences values (1, ' | ||
+ | </ | ||
= 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 82: | Line 197: | ||
update preferences set label=' | update preferences set label=' | ||
</ | </ | ||
+ | |||
+ | = Version 2.7 = | ||
+ | |||
+ | <code sql> | ||
+ | update system_preferences set volume_max_size=640; | ||
+ | </ | ||
+ | |||
+ | = Version 2.8 = | ||
+ | |||
+ | <code sql> | ||
+ | update preferences set shop_enable =' | ||
+ | update preferences set popup_enable=' | ||
+ | update preferences set popup_delay =500; | ||
+ | update preferences set shop_enable =' | ||
+ | update preferences set popup_enable=' | ||
+ | </ | ||
+ | |||
+ | = Version 2.13 = | ||
+ | |||
+ | <code sql> | ||
+ | -- set all quotas to unlimited | ||
+ | update preferences set quota_size = 0; | ||
+ | update preferences set quota_count = 0; | ||
+ | </ | ||
+ | |||
+ | = Version 2.16 = | ||
+ | |||
+ | <code sql> | ||
+ | update preferences set search_enable_stemming = ' | ||
+ | update preferences set search_default_mode = 1; | ||
+ | </ | ||
+ | |||
+ | = Version 2.19 = | ||
+ | |||
+ | <code sql> | ||
+ | update preferences set download_counter = 10; | ||
+ | update preferences set download_expiry_period = 14; | ||
+ | </ | ||
+ | |||
+ | = Version 2.29 = | ||
+ | |||
+ | <code sql> | ||
+ | update preferences set download_counter=10 where download_counter 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.1176453691.txt.gz · Last modified: 2007/04/13 08:41 by Luud