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 

    		
  

  

    
      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;