Statistics
| Revision:

svn-gvsig-desktop / 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 @ 45008

History | View | Annotate | Download (710 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- Se usa en TestCreateTable.


    		
  

  

    
      3
    
    
      
-- Se corresponde con el fichero CSV "testCreateSource1.csv".


    		
  

  

    
      4
    
    
      

    		
  

  

    
      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] CLOB DEFAULT NULL, 


    		
  

  

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