Changeset 3572:7b171ccd8cee for inc

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

File:

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

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'")