Revision f3b04802
Added by Andreas Müller almost 11 years ago
| cdmlib-io/src/test/resources/dbscripts/001-cdm.h2.sql | ||
|---|---|---|
| 600 | 600 |
|
| 601 | 601 |
CREATE TABLE PUBLIC.CLONING ( |
| 602 | 602 |
ID INTEGER NOT NULL, |
| 603 |
CREATED TIMESTAMP, |
|
| 604 | 603 |
UUID VARCHAR(36), |
| 604 |
CREATED TIMESTAMP, |
|
| 605 | 605 |
UPDATED TIMESTAMP, |
| 606 |
CREATEDBY_ID INTEGER, |
|
| 607 |
UPDATEDBY_ID INTEGER, |
|
| 606 | 608 |
DESCRIPTION VARCHAR(255), |
| 607 | 609 |
TIMEPERIOD_END VARCHAR(255), |
| 608 | 610 |
TIMEPERIOD_FREETEXT VARCHAR(255), |
| 609 | 611 |
TIMEPERIOD_START VARCHAR(255), |
| 610 |
METHOD BINARY(255), |
|
| 611 |
STRAIN VARCHAR(255), |
|
| 612 |
CREATEDBY_ID INTEGER, |
|
| 613 |
UPDATEDBY_ID INTEGER, |
|
| 612 |
STRAIN VARCHAR(255), |
|
| 613 |
METHOD_ID INTEGER, |
|
| 614 | 614 |
ACTOR_ID INTEGER, |
| 615 | 615 |
FORWARDPRIMER_ID INTEGER, |
| 616 | 616 |
REVERSEPRIMER_ID INTEGER, |
| 617 | 617 |
PRIMARY KEY (ID) |
| 618 |
);
|
|
| 618 |
); |
|
| 619 | 619 |
|
| 620 | 620 |
CREATE TABLE PUBLIC.CLONING_AUD ( |
| 621 | 621 |
ID INTEGER NOT NULL, |
| ... | ... | |
| 628 | 628 |
TIMEPERIOD_END VARCHAR(255), |
| 629 | 629 |
TIMEPERIOD_FREETEXT VARCHAR(255), |
| 630 | 630 |
TIMEPERIOD_START VARCHAR(255), |
| 631 |
METHOD BINARY(255),
|
|
| 631 |
METHOD_ID INTEGER,
|
|
| 632 | 632 |
STRAIN VARCHAR(255), |
| 633 | 633 |
CREATEDBY_ID INTEGER, |
| 634 | 634 |
UPDATEDBY_ID INTEGER, |
Also available in: Unified diff
fix test schema for cloning