Photo Organizer

User Tools

Site Tools

Trace:
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 14:40] – Luudpodoc:preferences_sql_table [2007/10/19 18:54] (current) – Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table preferences ( create table preferences (
   identifier                integer not null primary key,   identifier                integer not null primary key,
Line 36: Line 36:
 ); );
 </code> </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 42: Line 51:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 55: Line 70:
 == Used last == == Used last ==
  
-Still in use+Version 2.33
  
 == Schema change history == == Schema change history ==
Line 61: 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 91: 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 99: 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 107: 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 123: Line 140:
 = Version 2.13 = = Version 2.13 =
  
-<code>+<code sql>
 alter table preferences add quota_size integer; alter table preferences add quota_size integer;
 alter table preferences add quota_count integer; alter table preferences add quota_count integer;
Line 130: Line 147:
 = Version 2.16 = = Version 2.16 =
  
-<code>+<code sql>
 alter table preferences add search_enable_stemming char(1) check (search_enable_stemming in ('t', 'f')); alter table preferences add search_enable_stemming char(1) check (search_enable_stemming in ('t', 'f'));
 alter table preferences add search_default_mode  integer; alter table preferences add search_default_mode  integer;
Line 137: Line 154:
 = Version 2.19 = = Version 2.19 =
  
-<code>+<code sql>
 alter table preferences add column download_counter integer; alter table preferences add column download_counter integer;
 alter table preferences add column download_expiry_period integer; alter table preferences add column download_expiry_period integer;
Line 144: Line 161:
 = Version 2.21 = = Version 2.21 =
  
-<code>+<code sql>
 -- remove obsolete rows -- remove obsolete rows
 alter table preferences drop column copyright_statement_photo; alter table preferences drop column copyright_statement_photo;
 alter table preferences drop column copyright_statement; 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 154: 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 160: 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 170: 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 176: 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 186: 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 194: 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 201: 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 208: 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.1176734424.txt.gz · Last modified: 2007/04/16 14:40 by Luud