[odrs-web/production] trivial: Make longer varchars for app-ids
- From: Richard Hughes <rhughes src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [odrs-web/production] trivial: Make longer varchars for app-ids
- Date: Fri, 7 Jul 2017 15:56:24 +0000 (UTC)
commit e32259242ff9f80e44e8087a18f60ce1701a022b
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]