summaryrefslogtreecommitdiff
path: root/src/pl/plpython/plpython_schema.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-05-14 17:55:22 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-05-14 17:55:22 +0000
commit0ff7a2c2ad04404aeb1f45e1ae5d67dc91b575ee (patch)
treea7ce4d78d12e02b1852bc75c502ff878d9d50aed /src/pl/plpython/plpython_schema.sql
parent1ea069b1f61aee5e901886aee8b51051e00aad54 (diff)
downloadpostgresql-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.sql42
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) ;
-
-