/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/pl/plpython/expected/plpython_schema.out
33 строки
911 B
Robert Haas
Reduce messages about implicit indexes and sequences to DEBUG1.
05 июл 2012, 04:35
05 июл 2012, 04:35
d7c7348
Код
Авторство
О чём код?
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) ;