Revision 44951 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.mdb/src/test/resources/org/gvsig/fmap/dal/store/mdb/createTable.sql

View differences:

createTable.sql
2 2 
-- Se usa en TestCreateTable.
3 3 
-- Se corresponde con el fichero CSV "testCreateSource1.csv".
4 4 

  		




  5
  
  
    
CREATE TABLE "PUBLIC"."test" (


  		




  6
  
  
    
  "ID" INTEGER PRIMARY KEY NOT NULL, 


  		




  7
  
  
    
  "Byte" TINYINT DEFAULT NULL, 


  		




  8
  
  
    
  "Bool1" BOOLEAN DEFAULT NULL, 


  		




  9
  
  
    
  "Long" BIGINT DEFAULT NULL, 


  		




  10
  
  
    
  "Timestamp" TIMESTAMP DEFAULT NULL, 


  		




  11
  
  
    
  "Date" DATE DEFAULT NULL, 


  		




  12
  
  
    
  "Time" TIME DEFAULT NULL, 


  		




  13
  
  
    
  "Bool2" BOOLEAN DEFAULT NULL, 


  		




  14
  
  
    
  "String" VARCHAR(30) DEFAULT NULL, 


  		




  15
  
  
    
  "Bool3" BOOLEAN DEFAULT NULL, 


  		




  16
  
  
    
  "Double" DOUBLE DEFAULT NULL, 


  		




  17
  
  
    
  "Bool4" BOOLEAN DEFAULT NULL, 


  		




  18
  
  
    
  "Float" REAL DEFAULT NULL, 


  		




  19
  
  
    
  "Bool5" BOOLEAN DEFAULT NULL, 


  		




  20
  
  
    
  "Decimal" DECIMAL(6,3) DEFAULT NULL, 


  		




  21
  
  
    
-- H2 Spatial usa la constraint para averiguar el tipo de geometria, 


  		




  22
  
  
    
-- la dimension de esta (2D,3D,...) y el SRID.


  		




  23
  
  
    
  "Geometry" GEOMETRY(1) CHECK NVL2("Geometry", ST_GeometryTypeCode("Geometry") = 1 AND ST_CoordDim("Geometry") = 2 AND ST_SRID("Geometry") = 4326, TRUE) 


  		




  24
  
  
    
);


  		




  
  5
  
    
CREATE TABLE [test] (


  		




  
  6
  
    
  [ID] INTEGER PRIMARY KEY NOT NULL, 


  		




  
  7
  
    
  [Byte] TINYINT DEFAULT NULL, 


  		




  
  8
  
    
  [Bool1] BOOLEAN DEFAULT NULL, 


  		




  
  9
  
    
  [Long] DECIMAL(19,0) DEFAULT NULL, 


  		




  
  10
  
    
  [Timestamp] DATETIME DEFAULT NULL, 


  		




  
  11
  
    
  [Date] DATETIME DEFAULT NULL, 


  		




  
  12
  
    
  [Time] DATETIME DEFAULT NULL, 


  		




  
  13
  
    
  [Bool2] BOOLEAN DEFAULT NULL, 


  		




  
  14
  
    
  [String] VARCHAR(30) DEFAULT NULL, 


  		




  
  15
  
    
  [Bool3] BOOLEAN DEFAULT NULL, 


  		




  
  16
  
    
  [Double] FLOAT DEFAULT NULL, 


  		




  
  17
  
    
  [Bool4] BOOLEAN DEFAULT NULL, 


  		




  
  18
  
    
  [Float] REAL DEFAULT NULL, 


  		




  
  19
  
    
  [Bool5] BOOLEAN DEFAULT NULL, 


  		




  
  20
  
    
  [Decimal] DECIMAL(6,3) DEFAULT NULL, 


  		




  
  21
  
    
  [Geometry] VARCHAR(50) DEFAULT NULL, 


  		




  
  22
  
    
  [Decimal19_0] DECIMAL(19) DEFAULT NULL );


  		












Also available in:  Unified diff