From 59c4e0c8a50ff521868625357dc986558bd491e5 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 10 Dec 2018 10:21:28 -0500 Subject: [PATCH] Updating the db changes from version 0.0.29 Had error in creating an index --- setup/databaseScripts/create_database_V0.0.30.sql | 2 +- setup/databaseScripts/update_database_V0.0.29.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.0.30.sql b/setup/databaseScripts/create_database_V0.0.30.sql index c443285..f18b8b9 100644 --- a/setup/databaseScripts/create_database_V0.0.30.sql +++ b/setup/databaseScripts/create_database_V0.0.30.sql @@ -48,7 +48,7 @@ CREATE TABLE {prefix}accounts ( INDEX(email(20)), INDEX(invoice_type), INDEX(renewal_date), - INDEX(billing_county(20)) + INDEX(billing_county) ); ---- diff --git a/setup/databaseScripts/update_database_V0.0.29.sql b/setup/databaseScripts/update_database_V0.0.29.sql index d8d6773..dc7fc17 100644 --- a/setup/databaseScripts/update_database_V0.0.29.sql +++ b/setup/databaseScripts/update_database_V0.0.29.sql @@ -10,7 +10,7 @@ ALTER TABLE {prefix}accounts ADD billing_county INT NULL; ---- -CREATE INDEX billing_county ON {prefix}accounts (billing_county(20)); +CREATE INDEX billing_county ON {prefix}accounts (billing_county); ---- -- 2.17.1