diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-14 17:55:22 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-14 17:55:22 +0000 |
| commit | 0ff7a2c2ad04404aeb1f45e1ae5d67dc91b575ee (patch) | |
| tree | a7ce4d78d12e02b1852bc75c502ff878d9d50aed /src/pl/plpython/plpython_schema.sql | |
| parent | 1ea069b1f61aee5e901886aee8b51051e00aad54 (diff) | |
| download | postgresql-0ff7a2c2ad04404aeb1f45e1ae5d67dc91b575ee.tar.gz | |
Convert the existing regression test scripts for the various optional
PLs to use the standard pg_regress infrastructure. No changes in the
tests themselves. Andrew Dunstan
Diffstat (limited to 'src/pl/plpython/plpython_schema.sql')
| -rw-r--r-- | src/pl/plpython/plpython_schema.sql | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/src/pl/plpython/plpython_schema.sql b/src/pl/plpython/plpython_schema.sql deleted file mode 100644 index 2f8766431f..0000000000 --- a/src/pl/plpython/plpython_schema.sql +++ /dev/null @@ -1,42 +0,0 @@ - -CREATE TABLE users ( - fname text not null, - lname text not null, - username text, - userid serial, - PRIMARY KEY(lname, fname) - ) ; - -CREATE INDEX users_username_idx ON users(username); -CREATE INDEX users_fname_idx ON users(fname); -CREATE INDEX users_lname_idx ON users(lname); -CREATE INDEX users_userid_idx ON users(userid); - - -CREATE TABLE taxonomy ( - id serial primary key, - name text unique - ) ; - -CREATE TABLE entry ( - accession text not null primary key, - eid serial unique, - txid int2 not null references taxonomy(id) - ) ; - -CREATE TABLE sequences ( - eid int4 not null references entry(eid), - pid serial primary key, - product text not null, - sequence text not null, - multipart bool default 'false' - ) ; -CREATE INDEX sequences_product_idx ON sequences(product) ; - -CREATE TABLE xsequences ( - pid int4 not null references sequences(pid), - sequence text not null - ) ; -CREATE INDEX xsequences_pid_idx ON xsequences(pid) ; - - |
