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/04/13 08:41] Luudpodoc:preferences_sql_table [2007/10/19 18:54] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  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)), 
-    num_of_columns        integer, +  num_of_rows               integer, 
-    copyright_statement   text, +  num_of_columns            integer, 
-    folder_view           char(5) check (folder_view in ('slide', 'list')), +  folder_view               char(5) check (folder_view in ('slide', 'list')), 
-    num_of_rows_l         integer, +  num_of_rows_l             integer, 
-    sharpen_image_radius  float+  bulk_upload_enable        char(1) check (bulk_upload_enable in ('t', 'f'))
-    sharpen_image_sigma   float+  paper                     integer references paper(identifier)
-    sharpen_thumb_radius  float+  label                     integer references label(identifier)
-    sharpen_thumb_sigma   float +  shop_enable               char(1) check (shop_enable in ('t', 'f')), 
-  );+  popup_enable              char(1) check (shop_enable in ('t', 'f')), 
 +  popup_delay               integer, 
 +  quota_size                integer, 
 +  quota_count               integer, 
 +  search_enable_stemming    char(1) check (search_enable_stemming in ('t', 'f')), 
 +  search_default_mode       integer, 
 +  download_counter          integer, 
 +  download_expiry_period    integer 
 +); 
 +</code> 
 + 
 +=== 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 =
  
-  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)), 
-    num_of_columns        integer, +  num_of_rows           integer, 
-    copyright_statement   text, +  sharpen_image_radius  float, 
-    folder_view           char(5) check (folder_view in ('slide', 'list')), +  sharpen_image_sigma   float, 
-    num_of_rows_l         integer, +  sharpen_thumb_radius  float, 
-    sharpen_image_radius  float+  sharpen_thumb_sigma   float, 
-    sharpen_image_sigma   float+  num_of_columns        integer, 
-    sharpen_thumb_radius  float+  copyright_statement   text, 
-    sharpen_thumb_sigma   float +  folder_view           char(5) check (folder_view in ('slide', 'list')), 
-  );+  num_of_rows_l         integer, 
 +  current_volume        varchar(500)
 +  volume_max_size       integer 
 +); 
 +</code> 
 + 
 += 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 ('t''f')); 
 +alter table preferences add column paper integer references paper(identifier); 
 +alter table preferences add column label integer references label(identifier); 
 +</code> 
 + 
 += 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; 
 +</code> 
 + 
 += Version 2.8 = 
 + 
 +<code sql> 
 +alter table preferences add column shop_enable  char(1) check (shop_enable in ('t''f')); 
 +alter table preferences add column popup_enable char(1) check (shop_enable in ('t', 'f')); 
 +alter table preferences add column popup_delay  integer; 
 +</code> 
 + 
 += 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  to drop_me_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  to drop_me_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; 
 +</code> 
 + 
 += Version 2.13 = 
 + 
 +<code sql> 
 +alter table preferences add quota_size integer; 
 +alter table preferences add quota_count integer; 
 +</code> 
 + 
 += Version 2.16 = 
 + 
 +<code sql> 
 +alter table preferences add search_enable_stemming char(1) check (search_enable_stemming in ('t', 'f')); 
 +alter table preferences add search_default_mode  integer; 
 +</code> 
 + 
 += Version 2.19 = 
 + 
 +<code sql> 
 +alter table preferences add column download_counter integer; 
 +alter table preferences add column download_expiry_period integer; 
 +</code> 
 + 
 += Version 2.21 = 
 + 
 +<code sql> 
 +-- remove obsolete rows 
 +alter table preferences drop column copyright_statement_photo; 
 +alter table preferences drop column copyright_statement; 
 +</code> 
 + 
 += 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> 
 + 
 +<code sql> 
 +DROP TABLE preferences; 
 +</code>
  
-= Data change history =+== Data change history ==
  
 = Version 2.5 = = Version 2.5 =
 +
 +<code sql>
 +insert into preferences values (1, 'pdf', '8', '20', '1', 4, 4, '', 'slide', '20', 0.2, 0.2, 0.4, 0.4);
 +</code>
  
 = Version 2.6 = = Version 2.6 =
  
-<code>+<code sql>
 -- 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='f'; update preferences set bulk_upload_enable='f';
Line 82: Line 197:
 update preferences set label='17'; update preferences set label='17';
 </code> </code>
 +
 += Version 2.7 =
 +
 +<code sql>
 +update system_preferences set volume_max_size=640;
 +</code>
 +
 += Version 2.8 =
 +
 +<code sql>
 +update preferences set shop_enable ='f';
 +update preferences set popup_enable='f';
 +update preferences set popup_delay =500;
 +update preferences set shop_enable ='t' where identifier = (select preferences from users where type=4);
 +update preferences set popup_enable='t' where identifier = (select preferences from users where type=4);
 +</code>
 +
 += Version 2.13 =
 +
 +<code sql>
 +-- set all quotas to unlimited
 +update preferences set quota_size = 0;
 +update preferences set quota_count = 0;
 +</code>
 +
 += Version 2.16 =
 +
 +<code sql>
 +update preferences set search_enable_stemming = 'f';
 +update preferences set search_default_mode = 1;
 +</code>
 +
 += Version 2.19 =
 +
 +<code sql>
 +update preferences set download_counter = 10;
 +update preferences set download_expiry_period = 14;
 +</code>
 +
 += 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;
 +</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>
 +
podoc/preferences_sql_table.1176453691.txt.gz · Last modified: 2007/04/13 08:41 by Luud