petclinic-uncached

Merge pull request #134 from broccolinisoup/master owners …

3/6/2016 9:53:19 AM

search has been case insensitive

Antoine Rey

Commit: 9ad12d3

Tree: dda1c6e

Parents: df4e3a5
e7f6899

Changes

src/main/resources/db/hsqldb/initDB.sql 2(+1 -1)

Details

src/main/resources/db/hsqldb/initDB.sql 2(+1 -1)

diff --git a/src/main/resources/db/hsqldb/initDB.sql b/src/main/resources/db/hsqldb/initDB.sql
index a16c42d..f3c6947 100644
--- a/src/main/resources/db/hsqldb/initDB.sql
+++ b/src/main/resources/db/hsqldb/initDB.sql
@@ -36,7 +36,7 @@ CREATE INDEX types_name ON types (name);
 CREATE TABLE owners (
   id         INTEGER IDENTITY PRIMARY KEY,
   first_name VARCHAR(30),
-  last_name  VARCHAR(30),
+  last_name  VARCHAR_IGNORECASE(30),
   address    VARCHAR(255),
   city       VARCHAR(80),
   telephone  VARCHAR(20)