Revision 12253
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 358 | 358 |
|
| 359 | 359 |
|
| 360 | 360 |
|
| 361 |
|
|
| 362 |
|
|
| 363 |
|
|
| 364 |
|
|
| 365 | 361 |
-- |
| 366 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 367 |
-- |
|
| 368 |
|
|
| 369 |
CREATE TABLE source ( |
|
| 370 |
source_id int(11) NOT NULL, |
|
| 371 |
matched_source_id int(11), |
|
| 372 |
parent_id int(11), |
|
| 373 |
shortname varchar(255) NOT NULL, |
|
| 374 |
citation varchar(255), |
|
| 375 |
sourcetype varchar(255), |
|
| 376 |
accesslevel varchar(255), |
|
| 377 |
accessconditions varchar(255), |
|
| 378 |
observationtype varchar(255), |
|
| 379 |
title varchar(255), |
|
| 380 |
titlesuperior varchar(255), |
|
| 381 |
volume varchar(255), |
|
| 382 |
issue varchar(255), |
|
| 383 |
pagerange varchar(255), |
|
| 384 |
totalpages int(11), |
|
| 385 |
publisher varchar(255), |
|
| 386 |
publicationplace varchar(255), |
|
| 387 |
isbn varchar(255), |
|
| 388 |
edition varchar(255), |
|
| 389 |
numberofvolumes int(11), |
|
| 390 |
chapternumber int(11), |
|
| 391 |
reportnumber int(11), |
|
| 392 |
communicationtype varchar(255), |
|
| 393 |
degree varchar(255), |
|
| 394 |
url varchar(255), |
|
| 395 |
doi varchar(255), |
|
| 396 |
additionalinfo varchar(255), |
|
| 397 |
pubdate date, |
|
| 398 |
accessdate date, |
|
| 399 |
conferencedate date, |
|
| 400 |
datecreated date NOT NULL, |
|
| 401 |
createdby varchar(255), |
|
| 402 |
datelastmodified date NOT NULL, |
|
| 403 |
lastmodifiedby varchar(255), |
|
| 404 |
import_revision varchar(255) |
|
| 405 |
); |
|
| 406 |
|
|
| 407 |
|
|
| 408 |
-- |
|
| 409 | 362 |
-- Name: datasource_publish(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: - |
| 410 | 363 |
-- |
| 411 | 364 |
|
| ... | ... | |
| 580 | 533 |
|
| 581 | 534 |
|
| 582 | 535 |
|
| 536 |
|
|
| 537 |
|
|
| 538 |
|
|
| 539 |
|
|
| 583 | 540 |
-- |
| 584 | 541 |
-- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 585 | 542 |
-- |
| ... | ... | |
| 1578 | 1535 |
|
| 1579 | 1536 |
|
| 1580 | 1537 |
-- |
| 1538 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1539 |
-- |
|
| 1540 |
|
|
| 1541 |
CREATE TABLE source ( |
|
| 1542 |
source_id int(11) NOT NULL, |
|
| 1543 |
matched_source_id int(11), |
|
| 1544 |
parent_id int(11), |
|
| 1545 |
shortname varchar(255) NOT NULL, |
|
| 1546 |
citation varchar(255), |
|
| 1547 |
sourcetype varchar(255), |
|
| 1548 |
accesslevel varchar(255), |
|
| 1549 |
accessconditions varchar(255), |
|
| 1550 |
observationtype varchar(255), |
|
| 1551 |
title varchar(255), |
|
| 1552 |
titlesuperior varchar(255), |
|
| 1553 |
volume varchar(255), |
|
| 1554 |
issue varchar(255), |
|
| 1555 |
pagerange varchar(255), |
|
| 1556 |
totalpages int(11), |
|
| 1557 |
publisher varchar(255), |
|
| 1558 |
publicationplace varchar(255), |
|
| 1559 |
isbn varchar(255), |
|
| 1560 |
edition varchar(255), |
|
| 1561 |
numberofvolumes int(11), |
|
| 1562 |
chapternumber int(11), |
|
| 1563 |
reportnumber int(11), |
|
| 1564 |
communicationtype varchar(255), |
|
| 1565 |
degree varchar(255), |
|
| 1566 |
url varchar(255), |
|
| 1567 |
doi varchar(255), |
|
| 1568 |
additionalinfo varchar(255), |
|
| 1569 |
pubdate date, |
|
| 1570 |
accessdate date, |
|
| 1571 |
conferencedate date, |
|
| 1572 |
datecreated date NOT NULL, |
|
| 1573 |
createdby varchar(255), |
|
| 1574 |
datelastmodified date NOT NULL, |
|
| 1575 |
lastmodifiedby varchar(255), |
|
| 1576 |
import_revision varchar(255) |
|
| 1577 |
); |
|
| 1578 |
|
|
| 1579 |
|
|
| 1580 |
-- |
|
| 1581 | 1581 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1582 | 1582 |
-- |
| 1583 | 1583 |
|
| ... | ... | |
| 9380 | 9380 |
|
| 9381 | 9381 |
|
| 9382 | 9382 |
-- |
| 9383 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
|
| 9384 |
-- |
|
| 9385 |
|
|
| 9386 |
|
|
| 9387 |
|
|
| 9388 |
|
|
| 9389 |
|
|
| 9390 |
|
|
| 9391 |
|
|
| 9392 |
|
|
| 9393 |
-- |
|
| 9394 | 9383 |
-- Name: place; Type: ACL; Schema: public; Owner: - |
| 9395 | 9384 |
-- |
| 9396 | 9385 |
|
| ... | ... | |
| 9572 | 9561 |
|
| 9573 | 9562 |
|
| 9574 | 9563 |
-- |
| 9564 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
|
| 9565 |
-- |
|
| 9566 |
|
|
| 9567 |
|
|
| 9568 |
|
|
| 9569 |
|
|
| 9570 |
|
|
| 9571 |
|
|
| 9572 |
|
|
| 9573 |
|
|
| 9574 |
-- |
|
| 9575 | 9575 |
-- Name: stratum; Type: ACL; Schema: public; Owner: - |
| 9576 | 9576 |
-- |
| 9577 | 9577 |
|
Also available in: Unified diff
schemas/vegbien.sql: schema_null params: use schema_anchor instead of source for this, since it is guaranteed to exist regardless of which tables are in the VegBIEN schema