Changeset 3423:e34ec8af1a67 for inc/dbschema

Timestamp:

11/26/16 11:53:12 (9 years ago)

Author:

Jean-Christian Denis

Branch:

default

Message:

Add First Publication mecanism, closes #970, adresses #784, #843, #871, #548

Location:

inc/dbschema

Files:

• db-schema.php (modified) (1 diff)
• upgrade.php (modified) (1 diff)

inc/dbschema/db-schema.php

@@ -121 +121 @@
      ->post_words             ('text',       0,        true,     null)
      ->post_status            ('smallint',   0,        false,    0)
+     ->post_firstpub               ('smallint',   0,        false,    0)
      ->post_selected               ('smallint',   0,        false,    0)
      ->post_position               ('integer',         0,        false,    0)

inc/dbschema/upgrade.php

@@ -610 +610 @@
                $core->con->execute($strReq);
 
+               # Update first publication on published posts
+               $strReq = 'UPDATE '.$core->prefix.'post '.
+                         'SET post_firstpub = 1 '.
+                         'WHERE post_status = 1 ';
+               $core->con->execute($strReq);
+
                # A bit of housecleaning for no longer needed files
                $remfiles = array (