[odrs-web] trivial: Make longer varchars for app-ids



commit 3311ab90bedf67d4e4266b55881589674d5c66a8
Author: Richard Hughes <richard hughsie com>
Date:   Thu Jul 6 18:26:07 2017 +0100

    trivial: Make longer varchars for app-ids
    
    This can be migrated using ALTER TABLE analytics MODIFY COLUMN app_id VARCHAR(128) DEFAULT NULL;

 schema.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/schema.sql b/schema.sql
index 46d8ec5..5e7e6cc 100644
--- a/schema.sql
+++ b/schema.sql
@@ -51,7 +51,7 @@ CREATE TABLE eventlog (
 DROP TABLE IF EXISTS analytics;
 CREATE TABLE analytics (
   datestr INT DEFAULT 0,
-  app_id VARCHAR(64) DEFAULT NULL,
+  app_id VARCHAR(128) DEFAULT NULL,
   fetch_cnt INT DEFAULT 1,
   UNIQUE (datestr,app_id)
 ) CHARSET=utf8;


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]