diff options
| author | plegall <plg@piwigo.org> | 2005-07-16 14:29:35 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2005-07-16 14:29:35 +0000 |
| commit | 9bafdff17166028ed7448487d0ca8a19f3c2fbb3 (patch) | |
| tree | 331aec15d000a13451bb6fbc1cd1cb6beec0902d /install/dbscheme.txt | |
| parent | 315f9c5670b631fcc279c4d6ac00ae9386d67455 (diff) | |
- new feature : RSS notification feed. Feed generator is an external tool
(FeedCreator class v1.7.2). New file feed.php
- new database field : comments.validation_date (datetime). This field is
required for notification feed.
- new database field : users.feed_id (varchar(50)). users.feed_id is an
alias of users.id but is much more complicated to find (50 characters,
figures or letters, case sensitive) : the purpose is to keep it secret (as
far as possible).
- new database field : users.last_feed_check (datetime)
- new database field : users.registration_date (datetime)
- bug fixed : no need to add the (unavailable) session id to install.php in
the installation form.
- modified database field : images.date_available become more precise (date
to datetime). This precision is needed for notification feed.
- new index : comments_i1 (validation_date). Might be useful for feed
queries.
- new index : comments_i2 (image_id). Useful each time you want to have
informations about an element and its associated comments.
- version 9.11 of mysqldump outputs database field names and table names
with backquote "`" (didn't find how to take them off)
git-svn-id: http://piwigo.org/svn/trunk@801 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/dbscheme.txt')
| -rw-r--r-- | install/dbscheme.txt | 17 |
1 files changed, 14 insertions, 3 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index d53e742c4..002059c4d 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -1,4 +1,5 @@ +table:caddie table:categories table:comments table:config @@ -17,8 +18,10 @@ 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:date nullable:Y +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 @@ -39,6 +42,7 @@ column:date table:comments type:datetime 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 @@ -58,7 +62,7 @@ column:image_id table:image_category type:mediumint 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:date nullable: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 @@ -91,7 +95,7 @@ column:user_id table:user_group type:smallint 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:N length:255 binary:N +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 @@ -103,6 +107,9 @@ column:expand table:users type:enum('true','false') 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 @@ -113,6 +120,8 @@ column:tn_ext table:waiting type:char 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 @@ -137,6 +146,8 @@ 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 |