Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/createTable.sql

View differences:

createTable.sql
7 7 
-- end createTable
8 8 

  		




  9
  9
  
    
-- begin createTable


  		




  10
  
  
    
CREATE TABLE IF NOT EXISTS gpkg_extensions (


  		




  11
  
  
    
    table_name TEXT, 


  		




  12
  
  
    
    column_name TEXT, 


  		




  13
  
  
    
    extension_name TEXT NOT NULL, 


  		




  14
  
  
    
    definition TEXT NOT NULL, 


  		




  15
  
  
    
    scope TEXT NOT NULL, 


  		




  16
  
  
    
    CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) )


  		




  
  10
  
    
CREATE TABLE IF NOT EXISTS gpkg_extensions ( table_name TEXT, column_name TEXT, extension_name TEXT NOT NULL, definition TEXT NOT NULL, scope TEXT NOT NULL, CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) )


  		




  17
  11
  
    
-- end createTable


  		




  18
  12
  
    

  		




  19
  13
  
    
-- begin createTable


  		




  20
  
  
    
CREATE TABLE IF NOT EXISTS "gpkg_geometry_columns" (


  		




  21
  
  
    
	"table_name"	TEXT NOT NULL,


  		




  22
  
  
    
	"column_name"	TEXT NOT NULL,


  		




  23
  
  
    
	"geometry_type_name"	TEXT NOT NULL,


  		




  24
  
  
    
	"srs_id"	INTEGER NOT NULL,


  		




  25
  
  
    
	"z"	TINYINT NOT NULL,


  		




  26
  
  
    
	"m"	TINYINT NOT NULL,


  		




  27
  
  
    
	CONSTRAINT "pk_geom_cols" PRIMARY KEY("table_name","column_name"),


  		




  28
  
  
    
	CONSTRAINT "fk_gc_tn" FOREIGN KEY("table_name") REFERENCES "gpkg_contents"("table_name"),


  		




  29
  
  
    
	CONSTRAINT "uk_gc_table_name" UNIQUE("table_name"),


  		




  30
  
  
    
	CONSTRAINT "fk_gc_srs" FOREIGN KEY("srs_id") REFERENCES "gpkg_spatial_ref_sys"("srs_id")


  		




  31
  
  
    
)


  		




  
  14
  
    
CREATE TABLE IF NOT EXISTS "gpkg_geometry_columns" ( "table_name" TEXT NOT NULL, "column_name" TEXT NOT NULL, "geometry_type_name" TEXT NOT NULL, "srs_id" INTEGER NOT NULL, "z" TINYINT NOT NULL, "m" TINYINT NOT NULL, CONSTRAINT "pk_geom_cols" PRIMARY KEY("table_name","column_name"), CONSTRAINT "fk_gc_tn" FOREIGN KEY("table_name") REFERENCES "gpkg_contents"("table_name"), CONSTRAINT "uk_gc_table_name" UNIQUE("table_name"), CONSTRAINT "fk_gc_srs" FOREIGN KEY("srs_id") REFERENCES "gpkg_spatial_ref_sys"("srs_id") )


  		




  32
  15
  
    
-- end createTable


  		




  33
  16
  
    

  		




  34
  17
  
    
-- begin createTable


  		




  ......




  44
  27
  
    
-- end createTable


  		




  45
  28
  
    

  		




  46
  29
  
    
-- begin createTable


  		




  47
  
  
    
CREATE TABLE IF NOT EXISTS gpkg_extensions (


  		




  48
  
  
    
    table_name TEXT, 


  		




  49
  
  
    
    column_name TEXT, 


  		




  50
  
  
    
    extension_name TEXT NOT NULL, 


  		




  51
  
  
    
    definition TEXT NOT NULL, 


  		




  52
  
  
    
    scope TEXT NOT NULL, 


  		




  53
  
  
    
    CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) )


  		




  
  30
  
    
CREATE TABLE IF NOT EXISTS gpkg_extensions ( table_name TEXT, column_name TEXT, extension_name TEXT NOT NULL, definition TEXT NOT NULL, scope TEXT NOT NULL, CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) )


  		




  54
  31
  
    
-- end createTable


  		




  55
  32
  
    

  		




  56
  33
  
    
-- begin createTable


  		




  ......




  136
  113
  
    
    'http://www.geopackage.org/spec/#extension_rtree', 


  		




  137
  114
  
    
    'read-write'


  		




  138
  115
  
    
)


  		




  139
  
  
    
-- end createTable


  		




  
  116
  
    
-- end createTable


  		












Also available in:  Unified diff