diff options
| author | asanoaozora <fifitaneki@hotmail.com> | 2017-07-04 17:46:17 +0200 |
|---|---|---|
| committer | asanoaozora <fifitaneki@hotmail.com> | 2017-07-04 17:46:17 +0200 |
| commit | afa5a4f857628684d39de2618894f423dd1af5c2 (patch) | |
| tree | 82f0443623bca944c8ee87412d7a9779637da302 /test/poi-service | |
| parent | 4c3e24b04f8ff1e41a94f1c1dd181ae3412c3db9 (diff) | |
| download | poi-service-afa5a4f857628684d39de2618894f423dd1af5c2.tar.gz | |
add DLT to several plugins, allow case insensitive search
Diffstat (limited to 'test/poi-service')
| -rw-r--r-- | test/poi-service/script/create-scheme.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/test/poi-service/script/create-scheme.sql b/test/poi-service/script/create-scheme.sql index 154f550..fe20826 100644 --- a/test/poi-service/script/create-scheme.sql +++ b/test/poi-service/script/create-scheme.sql @@ -1,6 +1,6 @@ /** * @licence app begin@ - * Copyright (C) 2011-2012 PCA Peugeot Citroën + * Copyright (C) 2017 PSA GROUP * * This file is part of GENIVI Project POISearch Proof Of Concept [POIPOCSupplier]. * @@ -18,6 +18,8 @@ * Modifications: * 19-12-2013 Philippe Colliot * add new fields to poi (brand and operateur) + * 04-07-2017 Philippe Colliot + * add COLLATE NOCASE to poi name * * For further information see http://www.genivi.org/. * @licence end@ @@ -52,7 +54,7 @@ CREATE TABLE poiattribute ( DROP TABLE IF EXISTS poi; CREATE TABLE poi ( Id int NOT NULL, - name text UNIQUE, + name text UNIQUE COLLATE NOCASE, latitude double DEFAULT NULL, longitude double DEFAULT NULL, altitude int DEFAULT NULL, |