User Tools

Site Tools


podoc:preferences_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:preferences_sql_table [2007/10/19 14:24] Luudpodoc: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 =
  
-  create table preferences ( +<code sql> 
-    identifier            integer not null primary key, +create table preferences ( 
-    print_out             char(3) check (print_out in ('ps', 'pdf')), +  identifier            integer not null primary key, 
-    start_hour            integer check (start_hour >= 0 and start_hour < 24), +  print_out             char(3) check (print_out in ('ps', 'pdf')), 
-    end_hour              integer check (start_hour >= 0 and start_hour < 24), +  start_hour            integer check (start_hour >= 0 and start_hour < 24), 
-    start_day             integer check (start_day in (1, 0)), +  end_hour              integer check (start_hour >= 0 and start_hour < 24), 
-    num_of_rows           integer, +  start_day             integer check (start_day in (1, 0)), 
-    sharpen_image_radius  float, +  num_of_rows           integer, 
-    sharpen_image_sigma   float, +  sharpen_image_radius  float, 
-    sharpen_thumb_radius  float, +  sharpen_image_sigma   float, 
-    sharpen_thumb_sigma   float, +  sharpen_thumb_radius  float, 
-    num_of_columns        integer, +  sharpen_thumb_sigma   float, 
-    copyright_statement   text, +  num_of_columns        integer, 
-    folder_view           char(5) check (folder_view in ('slide', 'list')), +  copyright_statement   text, 
-    num_of_rows_l         integer, +  folder_view           char(5) check (folder_view in ('slide', 'list')), 
-    current_volume        varchar(500), +  num_of_rows_l         integer, 
-    volume_max_size       integer +  current_volume        varchar(500), 
-  );+  volume_max_size       integer 
 +); 
 +</code>
  
 = Version 2.6 = = Version 2.6 =
  
-<code>+<code sql>
 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 ('t', 'f')); alter table preferences add column bulk_upload_enable char(1) check (bulk_upload_enable in ('t', 'f'));
Line 106: Line 108:
 = Version 2.7 = = Version 2.7 =
  
-<code>+<code sql>
 -- 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;
 </code> </code>
  
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;
 +</code>
 +
 += 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 = 'slide' where folder_view is null;
 </code> </code>
  
podoc/preferences_sql_table.1192803843.txt.gz · Last modified: 2007/10/19 14:24 by Luud