- update: upgrade from 1.4.0 or 1.4.1. Upgrade from 1.3.x is not available

  anymore.

- update: README files updated for very near branch 1.5 :-)

- new: file tools/config_local.inc.php as example for optional
  include/config_local.inc.php

- bug fixed: configuration parameter show_picture_name_on_title was useless


git-svn-id: http://piwigo.org/svn/trunk@870 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 0 insertions, 160 deletions

diff --git a/install/dbscheme.txt b/install/dbscheme.txt
deleted file mode 100644
index 002059c4d..000000000
--- a/install/dbscheme.txt
+++ /dev/null
@@ -1,160 +0,0 @@
-
-table:caddie
-table:categories
-table:comments
-table:config
-table:favorites
-table:group_access
-table:groups
-table:history
-table:image_category
-table:images
-table:rate
-table:sessions
-table:sites
-table:user_access
-table:user_forbidden
-table:user_group
-table:users
-table:waiting
-
-column:user_id                   table:caddie         type:smallint                 nullable:N length:5   signed:Y
-column:element_id                table:caddie         type:mediumint                nullable:N length:8   signed:Y
-column:id                        table:categories     type:smallint                 nullable:N length:5   signed:N
-column:date_last                 table:categories     type:datetime                 nullable:Y
-column:nb_images                 table:categories     type:mediumint                nullable:N length:8   signed:N
-column:name                      table:categories     type:varchar                  nullable:N length:255 binary:N
-column:id_uppercat               table:categories     type:smallint                 nullable:Y length:5   signed:N
-column:comment                   table:categories     type:text                     nullable:Y
-column:dir                       table:categories     type:varchar                  nullable:Y length:255 binary:N
-column:rank                      table:categories     type:tinyint                  nullable:Y length:3   signed:N
-column:status                    table:categories     type:enum('public','private') nullable:N
-column:site_id                   table:categories     type:tinyint                  nullable:Y length:4   signed:N
-column:visible                   table:categories     type:enum('true','false')     nullable:N
-column:uploadable                table:categories     type:enum('true','false')     nullable:N
-column:representative_picture_id table:categories     type:mediumint                nullable:Y length:8   signed:N
-column:uppercats                 table:categories     type:varchar                  nullable:N length:255 binary:N
-column:commentable               table:categories     type:enum('true','false')     nullable:N
-column:global_rank               table:categories     type:varchar                  nullable:Y length:255 binary:N
-column:id                        table:comments       type:int                      nullable:N length:11  signed:N
-column:image_id                  table:comments       type:mediumint                nullable:N length:8   signed:N
-column:date                      table:comments       type:datetime                 nullable:N
-column:author                    table:comments       type:varchar                  nullable:Y length:255 binary:N
-column:content                   table:comments       type:longtext                 nullable:Y
-column:validated                 table:comments       type:enum('true','false')     nullable:N
-column:validation_date           table:comments       type:datetime                 nullable:Y
-column:param                     table:config         type:varchar                  nullable:N length:40  binary:N
-column:value                     table:config         type:varchar                  nullable:Y length:255 binary:N
-column:comment                   table:config         type:varchar                  nullable:Y length:255 binary:N
-column:user_id                   table:favorites      type:smallint                 nullable:N length:5   signed:N
-column:image_id                  table:favorites      type:mediumint                nullable:N length:8   signed:N
-column:group_id                  table:group_access   type:smallint                 nullable:N length:5   signed:N
-column:cat_id                    table:group_access   type:smallint                 nullable:N length:5   signed:N
-column:id                        table:groups         type:smallint                 nullable:N length:5   signed:N
-column:name                      table:groups         type:varchar                  nullable:N length:255 binary:N
-column:date                      table:history        type:datetime                 nullable:N
-column:login                     table:history        type:varchar                  nullable:Y length:15  binary:N
-column:IP                        table:history        type:varchar                  nullable:N length:50  binary:N
-column:category                  table:history        type:varchar                  nullable:Y length:150 binary:N
-column:file                      table:history        type:varchar                  nullable:Y length:50  binary:N
-column:picture                   table:history        type:varchar                  nullable:Y length:150 binary:N
-column:image_id                  table:image_category type:mediumint                nullable:N length:8   signed:N
-column:category_id               table:image_category type:smallint                 nullable:N length:5   signed:N
-column:id                        table:images         type:mediumint                nullable:N length:8   signed:N
-column:file                      table:images         type:varchar                  nullable:N length:255 binary:N
-column:date_available            table:images         type:datetime                 nullable:N
-column:date_creation             table:images         type:date                     nullable:Y
-column:tn_ext                    table:images         type:varchar                  nullable:Y length:4   binary:N
-column:name                      table:images         type:varchar                  nullable:Y length:255 binary:N
-column:comment                   table:images         type:text                     nullable:Y
-column:author                    table:images         type:varchar                  nullable:Y length:255 binary:N
-column:hit                       table:images         type:int                      nullable:N length:10  signed:N
-column:filesize                  table:images         type:mediumint                nullable:Y length:9   signed:N
-column:width                     table:images         type:smallint                 nullable:Y length:9   signed:N
-column:height                    table:images         type:smallint                 nullable:Y length:9   signed:N
-column:keywords                  table:images         type:varchar                  nullable:Y length:255 binary:N
-column:storage_category_id       table:images         type:smallint                 nullable:Y length:5   signed:N
-column:representative_ext        table:images         type:varchar                  nullable:Y length:4   binary:N
-column:date_metadata_update      table:images         type:date                     nullable:Y
-column:average_rate              table:images         type:float                    nullable:Y length:5,2 signed:N
-column:path                      table:images         type:varchar                  nullable:N length:255 binary:N
-column:user_id                   table:rate           type:smallint                 nullable:N length:5   signed:N
-column:element_id                table:rate           type:mediumint                nullable:N length:8   signed:N
-column:rate                      table:rate           type:tinyint                  nullable:N length:2   signed:N
-column:id                        table:sessions       type:varchar                  nullable:N length:255 binary:Y
-column:user_id                   table:sessions       type:smallint                 nullable:N length:5   signed:N
-column:expiration                table:sessions       type:datetime                 nullable:N
-column:id                        table:sites          type:tinyint                  nullable:N length:4   signed:Y
-column:galleries_url             table:sites          type:varchar                  nullable:N length:255 binary:N
-column:user_id                   table:user_access    type:smallint                 nullable:N length:5   signed:N
-column:cat_id                    table:user_access    type:smallint                 nullable:N length:5   signed:N
-column:user_id                   table:user_forbidden type:smallint                 nullable:N length:5   signed:N
-column:need_update               table:user_forbidden type:enum('true','false')     nullable:N
-column:forbidden_categories      table:user_forbidden type:text                     nullable:Y
-column:user_id                   table:user_group     type:smallint                 nullable:N length:5   signed:N
-column:group_id                  table:user_group     type:smallint                 nullable:N length:5   signed:N
-column:id                        table:users          type:smallint                 nullable:N length:5   signed:N
-column:username                  table:users          type:varchar                  nullable:N length:20  binary:Y
-column:password                  table:users          type:varchar                  nullable:Y length:32  binary:N
-column:mail_address              table:users          type:varchar                  nullable:Y length:255 binary:N
-column:nb_image_line             table:users          type:tinyint                  nullable:N length:1   signed:N
-column:nb_line_page              table:users          type:tinyint                  nullable:N length:3   signed:N
-column:status                    table:users          type:enum('admin','guest')    nullable:N
-column:language                  table:users          type:varchar                  nullable:N length:50  binary:N
-column:maxwidth                  table:users          type:smallint                 nullable:Y length:6   signed:Y
-column:maxheight                 table:users          type:smallint                 nullable:Y length:6   signed:Y
-column:expand                    table:users          type:enum('true','false')     nullable:N
-column:show_nb_comments          table:users          type:enum('true','false')     nullable:N
-column:recent_period             table:users          type:tinyint                  nullable:N length:3   signed:N
-column:template                  table:users          type:varchar                  nullable:N length:255 binary:N
-column:last_feed_check           table:users          type:datetime                 nullable:Y
-column:feed_id                   table:users          type:varchar                  nullable:Y length:50  binary:Y
-column:registration_date         table:users          type:datetime                 nullable:N
-column:id                        table:waiting        type:int                      nullable:N length:10  signed:N
-column:storage_category_id       table:waiting        type:smallint                 nullable:N length:5   signed:N
-column:file                      table:waiting        type:varchar                  nullable:N length:255 binary:N
-column:username                  table:waiting        type:varchar                  nullable:N length:255 binary:N
-column:mail_address              table:waiting        type:varchar                  nullable:N length:255 binary:N
-column:date                      table:waiting        type:int                      nullable:N length:10  signed:N
-column:tn_ext                    table:waiting        type:char                     nullable:Y length:3   binary:N
-column:validated                 table:waiting        type:enum('true','false')     nullable:N
-column:infos                     table:waiting        type:text                     nullable:Y
-
-PK:caddie_pk         table:caddie         column:user_id
-PK:caddie_pk         table:caddie         column:element_id
-PK:categories_pk     table:categories     column:id
-PK:comments_pk       table:comments       column:id
-PK:config_pk         table:config         column:param
-PK:favorites_pk      table:favorites      column:user_id
-PK:favorites_pk      table:favorites      column:image_id
-PK:group_access_pk   table:group_access   column:group_id
-PK:group_access_pk   table:group_access   column:cat_id
-PK:groups_pk         table:groups         column:id
-PK:image_category_pk table:image_category column:image_id
-PK:image_category_pk table:image_category column:category_id
-PK:images_pk         table:images         column:id
-PK:rate_pk           table:rate           column:user_id
-PK:rate_pk           table:rate           column:element_id
-PK:sessions_pk       table:sessions       column:id
-PK:sites_pk          table:sites          column:id
-PK:user_access_pk    table:user_access    column:user_id
-PK:user_access_pk    table:user_access    column:cat_id
-PK:user_forbidden_pk table:user_forbidden column:user_id
-PK:user_group_pk     table:user_group     column:group_id
-PK:user_group_pk     table:user_group     column:user_id
-PK:users_pk          table:users          column:id
-PK:waiting_pk        table:waiting        column:id
-
-index:categories_i2     table:categories     column:id_uppercat
-index:comments_i2       table:comments       column:validation_date
-index:comments_i1       table:comments       column:image_id
-index:history_i1        table:history        column:date
-index:image_category_i1 table:image_category column:image_id
-index:image_category_i2 table:image_category column:category_id
-index:images_i2         table:images         column:date_available
-index:images_i1         table:images         column:storage_category_id
-index:images_i3         table:images         column:average_rate
-index:images_i4         table:images         column:hit
-index:images_i5         table:images         column:date_creation
-index:sites_ui1         table:sites          column:galleries_url
-index:users_ui1         table:users          column:username