Changeset 407:eb5bd0f66932 for inc/dbschema

Timestamp:

06/23/11 13:00:59 (14 years ago)

Author:

Dsls <dsls@…>

Branch:

default

Message:

• Re-enabled blank post_type required by media.php in class dcBlog
• Attachments are now handled by a plugins/attachments/_admin.php
• Added core dcPostMedia multi-purpose class, and 'link_type' in post_media table
• Added new behavior : tplIfConditions, to enable to add new attributes to tpl:XXXIf tags
• Moved tpl:SysIf has_tag attribute to Tags plugin

File:

• inc/dbschema/db-schema.php (modified) (2 diffs)

inc/dbschema/db-schema.php

@@ -152 +152 @@
      ->media_id     ('bigint',     0,   false)
      ->post_id      ('bigint',     0,   false)
-     
-     ->primary('pk_post_media','media_id','post_id')
+     ->link_type         ('varchar',    32,  false,    "'attachment'")
+     
+     ->primary('pk_post_media','media_id','post_id','link_type')
      ;
 
@@ -235 +236 @@
 $_s->media->index        ('idx_media_user_id',              'btree',  'user_id');
 $_s->post_media->index   ('idx_post_media_post_id',         'btree',  'post_id');
+$_s->post_media->index   ('idx_post_media_media_id',        'btree',  'media_id');
 $_s->log->index          ('idx_log_user_id',                'btree',  'user_id');
 $_s->comment->index      ('idx_comment_post_id',            'btree',  'post_id');