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/16 13:30] 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')), 
-    copyright_statement_photo text, +  popup_enable              char(1) check (shop_enable in ('t', 'f')), 
-    bulk_upload_enable        char(1) check (bulk_upload_enable in ('t', 'f')), +  popup_delay               integer, 
-    paper                     integer references paper(identifier), +  quota_size                integer, 
-    label                     integer references label(identifier), +  quota_count               integer, 
-    shop_enable               char(1) check (shop_enable in ('t', 'f')), +  search_enable_stemming    char(1) check (search_enable_stemming in ('t', 'f')), 
-    popup_enable              char(1) check (shop_enable in ('t', 'f')), +  search_default_mode       integer, 
-    popup_delay               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 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 =
  
-  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, 
-    current_volume        varchar(500), +  sharpen_thumb_sigma   float, 
-    volume_max_size       integer +  num_of_columns        integer, 
-  );+  copyright_statement   text, 
 +  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 = = 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 85: 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 93: Line 116:
 = Version 2.8 = = Version 2.8 =
  
-<code>+<code sql>
 alter table preferences add column shop_enable  char(1) check (shop_enable in ('t', 'f')); 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_enable char(1) check (shop_enable in ('t', 'f'));
Line 101: Line 124:
 = Version 2.11 = = Version 2.11 =
  
-<code>+<code sql>
 -- 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;
 +</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> </code>
  
Line 119: Line 184:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into preferences values (1, 'pdf', '8', '20', '1', 4, 4, '', 'slide', '20', 0.2, 0.2, 0.4, 0.4); insert into preferences values (1, 'pdf', '8', '20', '1', 4, 4, '', 'slide', '20', 0.2, 0.2, 0.4, 0.4);
 </code> </code>
Line 125: Line 190:
 = 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 135: Line 200:
 = Version 2.7 = = Version 2.7 =
  
-<code>+<code sql>
 update system_preferences set volume_max_size=640; update system_preferences set volume_max_size=640;
 </code> </code>
Line 141: Line 206:
 = Version 2.8 = = Version 2.8 =
  
-<code>+<code sql>
 update preferences set shop_enable ='f'; update preferences set shop_enable ='f';
 update preferences set popup_enable='f'; update preferences set popup_enable='f';
Line 151: Line 216:
 = Version 2.13 = = Version 2.13 =
  
-<code>+<code sql>
 -- 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 =
  
-<code>+<code sql>
 update preferences set search_enable_stemming = 'f'; update preferences set search_enable_stemming = 'f';
 update preferences set search_default_mode = 1; update preferences set search_default_mode = 1;
Line 166: Line 231:
 = Version 2.19 = = Version 2.19 =
  
-<code>+<code sql>
 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 =
  
-<code>+<code sql>
 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.1176730222.txt.gz · Last modified: 2007/04/16 13:30 by Luud