Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / append.sql @ 46517

History | View | Annotate | Download (425 Bytes)

1 45472 jjdelcerro 

      

      

        2
        
        
        
        
        
-- Previous SQLs


      

      

        3
        
        
        
        
        
SET LOG 1;


      

      

        4
        
        
        
        
        
SET LOCK_MODE 1;


      

      

        5
        
        
        
        
        
SET UNDO_LOG 0;


      

      

        6
        
        
        
        
        

      

      

        7
        
        
        
        
        
-- Inser SQL


      

      

        8
        
        
        
        
        
INSERT INTO "PUBLIC"."test" (


      

      

        9
        
        
        
        
        
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time",


      

      

        10
        
        
        
        
        
    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5",


      

      

        11
        
        
        
        
        
    "Decimal", "Geometry"


      

      

        12
        
        
        
        
        
  )


      

      

        13
        
        
        
        
        
  VALUES (


      

      

        14
        
        
        
        
        
     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeomFromWKB((?), (?))


      

      

        15
        
        
        
        
        
  );


      

      

        16
        
        
        
        
        

      

      

        17
        
        
        
        
        
-- Post SQLs


      

      

        18
        
        
        
        
        
SET LOG 2;


      

      

        19
        
        
        
        
        
SET LOCK_MODE 3;


      

      

        20
        
        
        
        
        
SET UNDO_LOG 1;