Project

General

Profile

« Previous | Next » 

Revision 10443

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/{.,}*/*.schema.sql: regenerated using the instructions in bin/my2pg. this primarily replaces timestamp with text/*timestamp*/ (to preserve indefinite dates).

View differences:

geoscrub.schema.sql
39 39 
  "minDistKm" integer DEFAULT NULL,
40 40 
  "countryID" integer DEFAULT NULL,
41 41 
  PRIMARY KEY ("objectID"),
42 
  "Index_city_index" boolean,
43 
  "Index_fips_country_index" boolean,
44 
  "Index_popRank_index" boolean,
45 
  "Index_population_index" boolean,
46 
  "Index_longitude_index" boolean,
47 
  "Index_latitude_index" boolean,
48 
  "Index_minDistKm_index" boolean,
49 
  "Index_country_index" boolean,
50 
  "Index_countryID_index" boolean
42 
  /*KEY "Index_city" ("cityName")*/CHECK (true),
43 
  /*KEY "Index_fips_country" ("fipsCountry")*/CHECK (true),
44 
  /*KEY "Index_popRank" ("popRank")*/CHECK (true),
45 
  /*KEY "Index_population" ("Population")*/CHECK (true),
46 
  /*KEY "Index_longitude" ("Longitude")*/CHECK (true),
47 
  /*KEY "Index_latitude" ("Latitude")*/CHECK (true),
48 
  /*KEY "Index_minDistKm" ("minDistKm")*/CHECK (true),
49 
  /*KEY "Index_country" ("countryVerbatim")*/CHECK (true),
50 
  /*KEY "Index_countryID" ("countryID")*/CHECK (true)
51 51 
);
52 52 
/*!40101 SET character_set_client = @saved_cs_client */;
53 53 

  		




  ......




  64
  64
  
    
  "isNewWorld" varchar(255) DEFAULT NULL,


  		




  65
  65
  
    
  "countryNameStd" varchar(255) DEFAULT NULL,


  		




  66
  66
  
    
  PRIMARY KEY ("countryID"),


  		




  67
  
  
    
  "isNewWorld_index" boolean,


  		




  68
  
  
    
  "countryNameStd_index" boolean,


  		




  69
  
  
    
  "isoCode_index" boolean


  		




  
  67
  
    
  /*KEY "isNewWorld" ("isNewWorld")*/CHECK (true),


  		




  
  68
  
    
  /*KEY "countryNameStd" ("countryNameStd")*/CHECK (true),


  		




  
  69
  
    
  /*KEY "isoCode" ("isoCode")*/CHECK (true)


  		




  70
  70
  
    
);


  		




  71
  71
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  72
  72
  
    
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


  		












Also available in:  Unified diff