Author: bpoussin Date: 2010-06-02 18:48:29 +0200 (Wed, 02 Jun 2010) New Revision: 83 Url: http://nuiton.org/repositories/revision/wikitty/83 Log: suppression des "IF NOT EXISTS" qui n'est pas dans le sql standard et donc ne fonctionne pas sur toutes les bases et entre autre postgresql :( Modified: trunk/wikitty-jdbc-impl/src/main/resources/wikitty-jdbc-query.properties Modified: trunk/wikitty-jdbc-impl/src/main/resources/wikitty-jdbc-query.properties =================================================================== --- trunk/wikitty-jdbc-impl/src/main/resources/wikitty-jdbc-query.properties 2010-06-02 15:29:09 UTC (rev 82) +++ trunk/wikitty-jdbc-impl/src/main/resources/wikitty-jdbc-query.properties 2010-06-02 16:48:29 UTC (rev 83) @@ -1,5 +1,5 @@ #table extension_admin creation query -jdbc.queries.creation.extension.admin=CREATE TABLE IF NOT EXISTS extension_admin (\ +jdbc.queries.creation.extension.admin=CREATE TABLE extension_admin (\ id text NOT NULL,\ name text NOT NULL,\ version varchar(8) NOT NULL,\ @@ -8,7 +8,7 @@ PRIMARY KEY (id)); #table extension_data creation query -jdbc.queries.creation.extension.data=CREATE TABLE IF NOT EXISTS extension_data (\ +jdbc.queries.creation.extension.data=CREATE TABLE extension_data (\ id text NOT NULL,\ fieldName text NOT NULL,\ fieldType text NOT NULL,\ @@ -16,7 +16,7 @@ FOREIGN KEY (id) REFERENCES extension_admin (id)); #table wikitty_admin creation query -jdbc.queries.creation.wikitty.admin=CREATE TABLE IF NOT EXISTS wikitty_admin (\ +jdbc.queries.creation.wikitty.admin=CREATE TABLE wikitty_admin (\ id varchar(64) NOT NULL,\ version varchar(8) NOT NULL,\ extension_list text NOT NULL,\ @@ -24,7 +24,7 @@ PRIMARY KEY (id)); #table wikitty_data creation query -jdbc.queries.creation.wikitty.data=CREATE TABLE IF NOT EXISTS wikitty_data (\ +jdbc.queries.creation.wikitty.data=CREATE TABLE wikitty_data (\ id varchar(64) NOT NULL,\ fieldName text NOT NULL,\ numberValue numeric,\