Changeset 3572:7b171ccd8cee

Timestamp:

08/12/17 12:51:23 (8 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Reduce indexed varchar(255) fields to varchar(191) : table category, field cat_url; table dc_meta, field meta_id; table dc_ping, field ping_url; table dc_post, field post_url; table dc_pref, field pref_id; table dc_setting, field setting_id. Addresses #1278

Files:

• admin/category.php (modified) (1 diff)
• admin/post.php (modified) (1 diff)
• inc/dbschema/db-schema.php (modified) (6 diffs)
• plugins/importExport/inc/class.dc.import.dc1.php (modified) (1 diff)
• plugins/importExport/inc/class.dc.import.wp.php (modified) (1 diff)
• plugins/importExport/inc/flat/class.flat.import.php (modified) (1 diff)
• plugins/pages/page.php (modified) (1 diff)
• plugins/pings/index.php (modified) (2 diffs)
• plugins/tags/tag_posts.php (modified) (1 diff)

admin/category.php

@@ -216 +216 @@
 '<div class="lockable">'.
 '<p><label for="cat_url">'.__('URL:').'</label> '
-.form::field('cat_url',40,255,html::escapeHTML($cat_url)).
+.form::field('cat_url',40,191,html::escapeHTML($cat_url)).
 '</p>'.
 '<p class="form-note warn" id="note-cat-url">'.

admin/post.php

@@ -638 +638 @@
                          '<div class="lockable">'.
                          '<p><label for="post_url">'.__('Edit basename').'</label>'.
-                         form::field('post_url',10,255,html::escapeHTML($post_url),'maximal').
+                         form::field('post_url',10,191,html::escapeHTML($post_url),'maximal').
                          '</p>'.
                          '<p class="form-note warn">'.

inc/dbschema/db-schema.php

@@ -35 +35 @@
      ->blog_id                ('varchar',         32,       false)
      ->cat_title                   ('varchar',         255, false)
-     ->cat_url                ('varchar',         255, false)
+     ->cat_url                ('varchar',         191, false)
      ->cat_desc                    ('text',       0,        true)
      ->cat_position           ('integer',         0,        true,     0)
@@ -56 +56 @@
 
 $_s->setting
-     ->setting_id             ('varchar',         255, false)
+     ->setting_id             ('varchar',         191, false)
      ->blog_id                ('varchar',         32,       true)
      ->setting_ns             ('varchar',         32,       false,    "'system'")
@@ -110 +110 @@
      ->post_type                   ('varchar',         32,       false,    "'post'")
      ->post_format            ('varchar',         32,       false,    "'xhtml'")
-     ->post_url                    ('varchar',         255, false)
+     ->post_url                    ('varchar',         191, false)
      ->post_lang                   ('varchar',         5,        true,     null)
      ->post_title             ('varchar',         255, true,     null)
@@ -179 +179 @@
 $_s->ping
      ->post_id                ('bigint',          0,        false)
-     ->ping_url                    ('varchar',         255, false)
+     ->ping_url                    ('varchar',         191, false)
      ->ping_dt                ('timestamp',  0,        false,    'now()')
 
@@ -206 +206 @@
 
 $_s->meta
-     ->meta_id                ('varchar',         255, false)
+     ->meta_id                ('varchar',         191, false)
      ->meta_type                   ('varchar',         64,       false)
      ->post_id                ('bigint',          0,        false)
@@ -214 +214 @@
 
 $_s->pref
-     ->pref_id                ('varchar',         255, false)
+     ->pref_id                ('varchar',         191, false)
      ->user_id                ('varchar',         32,       true)
      ->pref_ws                ('varchar',         32,       false,    "'system'")

plugins/importExport/inc/class.dc.import.dc1.php

@@ -489 +489 @@
 
           $cur->post_url = date('Y/m/d/',strtotime($cur->post_dt)).$rs->post_id.'-'.$rs->post_titre_url;
-          $cur->post_url = substr($cur->post_url,0,255);
+          $cur->post_url = substr($cur->post_url,0,191);
 
           $cur->post_format        = $rs->post_content_wiki == '' ? 'xhtml' : 'wiki';

plugins/importExport/inc/class.dc.import.wp.php

@@ -624 +624 @@
                $rs->post_type== 'post' ? $this->vars['permalink_template'] : '%postname%'
           );
-          $cur->post_url = substr($cur->post_url,0,255);
+          $cur->post_url = substr($cur->post_url,0,191);
 
           if (!$cur->post_url) {

plugins/importExport/inc/flat/class.flat.import.php

@@ -834 +834 @@
                     $line->post_title = html::decodeEntities($line->post_title);
                     $line->post_url = date('Y/m/d/',strtotime($line->post_dt)).$line->post_id.'-'.$line->post_titre_url;
-                    $line->post_url = substr($line->post_url,0,255);
+                    $line->post_url = substr($line->post_url,0,191);
                     $line->post_format = $line->post_content_wiki == '' ? 'xhtml' : 'wiki';
                     $line->post_content_xhtml = $line->post_content;

plugins/pages/page.php

@@ -477 +477 @@
                          '<div class="lockable">'.
                          '<p><label for="post_url">'.__('Edit basename').'</label>'.
-                         form::field('post_url',10,255,html::escapeHTML($post_url),'maximal').
+                         form::field('post_url',10,191,html::escapeHTML($post_url),'maximal').
                          '</p>'.
                          '<p class="form-note warn">'.

plugins/pings/index.php

@@ -75 +75 @@
      form::field(array('pings_srv_name[]','pings_srv_name-'.$i),20,128,html::escapeHTML($n)).' '.
      '<label for="pings_srv_uri-'.$i.'" class="classic">'.__('Service URI:').'</label> '.
-     form::field(array('pings_srv_uri[]','pings_srv_uri-'.$i),40,255,html::escapeHTML($u));
+     form::field(array('pings_srv_uri[]','pings_srv_uri-'.$i),40,191,html::escapeHTML($u));
 
      if (!empty($_GET['test']))
@@ -95 +95 @@
 form::field(array('pings_srv_name[]','pings_srv_name2'),20,128).' '.
 '<label for="pings_srv_uri2" class="classic">'.__('Service URI:').'</label> '.
-form::field(array('pings_srv_uri[]','pings_srv_uri2'),40,255).
+form::field(array('pings_srv_uri[]','pings_srv_uri2'),40,191).
 '</p>'.
 

plugins/tags/tag_posts.php

@@ -109 +109 @@
           '<form action="'.$this_url.'" method="post" id="tag_rename">'.
           '<p><label for="new_tag_id" class="classic">'.__('Rename').'</label> '.
-          form::field('new_tag_id',20,255,html::escapeHTML($tag)).
+          form::field('new_tag_id',20,191,html::escapeHTML($tag)).
           '<input type="submit" value="'.__('OK').'" />'.
           $core->formNonce().