Index: topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java
diff -u topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.15 topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.16
--- topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.15	Mon Aug  8 14:00:16 2005
+++ topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java	Tue Aug  9 12:24:11 2005
@@ -23,9 +23,9 @@
  * Created: 20 juillet 2005 15:25:06 CEST
  *
  * @author Benjamin POUSSIN <poussin@codelutin.com>
- * @version $Revision: 1.15 $
+ * @version $Revision: 1.16 $
  *
- * Last update: $Date: 2005/08/08 14:00:16 $
+ * Last update: $Date: 2005/08/09 12:24:11 $
  * by : $Author: dessard $
  */
 
@@ -206,8 +206,13 @@
         SQL_ORACLE.put(SQL_GET_ALL_ID,
         		"SELECT DISTINCT(id) FROM management WHERE (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)) AND id NOT IN (SELECT id FROM management WHERE isDeleted=0 AND (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)))");
 
-        SQL_DERBY.put(SQL_CREATE_TABLE_MANAGEMENT, "CREATE TABLE management (id VARCHAR(50), longdate bigint, class LONG VARCHAR, isNew integer, isDeleted integer, schemaVersion bigint, PRIMARY KEY (id, longdate))");
-        SQL_DERBY.put(SQL_CREATE_TABLE_DATA, "CREATE TABLE data (longdate bigint, field varchar(100), value blob, type LONG VARCHAR, PRIMARY KEY (id, longdate, field))");
+        SQL_DERBY.put(SQL_CREATE_TABLE_MANAGEMENT, 
+        		"CREATE TABLE management (id VARCHAR(100), longdate bigint, class LONG VARCHAR, isNew integer, isDeleted integer, schemaVersion bigint, PRIMARY KEY (id, longdate))");
+        SQL_DERBY.put(SQL_CREATE_TABLE_DATA,
+        		"CREATE TABLE data (id varchar(100), longdate bigint, field varchar(100), value blob, type LONG VARCHAR, PRIMARY KEY (id, longdate, field))");
+        SQL_DERBY.put(SQL_GET_ALL_ID,
+                "SELECT DISTINCT(id) FROM management WHERE (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)) AND id NOT IN (SELECT id FROM management WHERE isDeleted=0 AND (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)))");
+
 
 
     }