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/10/19 14:24] – Luud | podoc:preferences_sql_table [2007/10/19 18:54] (current) – Luud | ||
---|---|---|---|
Line 70: | Line 70: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Schema change history == | == Schema change history == | ||
Line 76: | 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 |
- | sharpen_image_radius | + | num_of_rows |
- | sharpen_image_sigma | + | sharpen_image_radius |
- | sharpen_thumb_radius | + | sharpen_image_sigma |
- | sharpen_thumb_sigma | + | sharpen_thumb_radius |
- | num_of_columns | + | sharpen_thumb_sigma |
- | copyright_statement | + | num_of_columns |
- | folder_view | + | copyright_statement |
- | num_of_rows_l | + | folder_view |
- | current_volume | + | num_of_rows_l |
- | volume_max_size | + | 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 106: | 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 175: | Line 177: | ||
<code sql> | <code sql> | ||
- | -- DROP TABLE preferences; | + | DROP TABLE preferences; |
</ | </ | ||
Line 239: | Line 241: | ||
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.1192803843.txt.gz · Last modified: 2007/10/19 14:24 by Luud