Revision 8065
Added by Aaron Marcuse-Kubitza almost 12 years ago
| salvias_plots.schema.sql | ||
|---|---|---|
| 90 | 90 |
"plot_notes" text, |
| 91 | 91 |
"tmp_del" char(3) DEFAULT NULL, |
| 92 | 92 |
PRIMARY KEY ("PlotID"),
|
| 93 |
"Country_index" boolean,
|
|
| 94 |
"PrimOwnerID_index" boolean,
|
|
| 95 |
"plot_administrator_index" boolean,
|
|
| 96 |
"project_id_index" boolean,
|
|
| 97 |
"tmp_del_index" boolean
|
|
| 93 |
/*KEY "Country" ("Country")*/CHECK (true),
|
|
| 94 |
/*KEY "PrimOwnerID" ("PrimOwnerID")*/CHECK (true),
|
|
| 95 |
/*KEY "plot_administrator" ("plot_administrator")*/CHECK (true),
|
|
| 96 |
/*KEY "project_id" ("project_id")*/CHECK (true),
|
|
| 97 |
/*KEY "tmp_del" ("tmp_del")*/CHECK (true)
|
|
| 98 | 98 |
); |
| 99 | 99 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 100 | 100 |
|
| ... | ... | |
| 170 | 170 |
"temp_liandbh" double precision DEFAULT NULL, |
| 171 | 171 |
"tmp_del" char(3) DEFAULT NULL, |
| 172 | 172 |
PRIMARY KEY ("PlotObsID"),
|
| 173 |
"PlotID_index" boolean,
|
|
| 174 |
"tmp_del_index" boolean,
|
|
| 175 |
"tmp_PlotObsID_index" boolean
|
|
| 173 |
/*KEY "PlotID" ("PlotID")*/CHECK (true),
|
|
| 174 |
/*KEY "tmp_del" ("tmp_del")*/CHECK (true),
|
|
| 175 |
/*KEY "tmp_PlotObsID" ("tmp_PlotObsID")*/CHECK (true)
|
|
| 176 | 176 |
); |
| 177 | 177 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 178 | 178 |
|
| ... | ... | |
| 191 | 191 |
"plot_administrator" varchar(30) NOT NULL DEFAULT '', |
| 192 | 192 |
"project_id" integer NOT NULL DEFAULT '0', |
| 193 | 193 |
PRIMARY KEY ("EnteredBy","download_timestamp"),
|
| 194 |
"plot_administrator_index" boolean
|
|
| 194 |
/*KEY "plot_administrator" ("plot_administrator","project_id")*/CHECK (true)
|
|
| 195 | 195 |
); |
| 196 | 196 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 197 | 197 |
|
| ... | ... | |
| 235 | 235 |
"username" varchar(50) NOT NULL DEFAULT '', |
| 236 | 236 |
"access_level" integer NOT NULL DEFAULT '0', |
| 237 | 237 |
PRIMARY KEY ("plot_id","username"),
|
| 238 |
"access_level_index" boolean
|
|
| 238 |
/*KEY "access_level" ("access_level")*/CHECK (true)
|
|
| 239 | 239 |
); |
| 240 | 240 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 241 | 241 |
|
| ... | ... | |
| 312 | 312 |
"plot_notes" text, |
| 313 | 313 |
"tmp_del" char(3) DEFAULT NULL, |
| 314 | 314 |
PRIMARY KEY ("PlotID"),
|
| 315 |
"Country_index" boolean,
|
|
| 316 |
"PrimOwnerID_index" boolean,
|
|
| 317 |
"plot_administrator_index" boolean,
|
|
| 318 |
"project_id_index" boolean
|
|
| 315 |
/*KEY "Country" ("Country")*/CHECK (true),
|
|
| 316 |
/*KEY "PrimOwnerID" ("PrimOwnerID")*/CHECK (true),
|
|
| 317 |
/*KEY "plot_administrator" ("plot_administrator")*/CHECK (true),
|
|
| 318 |
/*KEY "project_id" ("project_id")*/CHECK (true)
|
|
| 319 | 319 |
); |
| 320 | 320 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 321 | 321 |
|
| ... | ... | |
| 334 | 334 |
"ipr_specific" text, |
| 335 | 335 |
"ipr_specific_updated" date DEFAULT NULL, |
| 336 | 336 |
PRIMARY KEY ("project_id"),
|
| 337 |
"project_name_index" boolean,
|
|
| 338 |
"on_project_list_index" boolean,
|
|
| 339 |
"project_distinct_index" boolean
|
|
| 337 |
/*KEY "project_name" ("project_name")*/CHECK (true),
|
|
| 338 |
/*KEY "on_project_list" ("allow_download_all")*/CHECK (true),
|
|
| 339 |
/*KEY "project_distinct" ("project_id","project_name","project_pi")*/CHECK (true)
|
|
| 340 | 340 |
); |
| 341 | 341 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 342 | 342 |
|
| ... | ... | |
| 365 | 365 |
"stem_liana_infestation" varchar(50) DEFAULT NULL, |
| 366 | 366 |
"tmp_del" char(3) DEFAULT NULL, |
| 367 | 367 |
PRIMARY KEY ("stem_id"),
|
| 368 |
"plotobs_id_index" boolean
|
|
| 368 |
/*KEY "plotobs_id" ("PlotObsID")*/CHECK (true)
|
|
| 369 | 369 |
); |
| 370 | 370 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 371 | 371 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
Also available in: Unified diff
inputs/SALVIAS/: Regenerated salvias_*.schema.sql from the MySQL version, to take advantage of my2pg improvements. The placeholder *_index columns which take the place of MySQL's inline index definitions have now been replaced by no-op CHECK constraints, so that there are no longer lots of dummy *_index columns in the map spreadsheets.