cic-internal-integration/apps/cic-meta/scripts/initdb/postgresql.sh

16 lines
375 B
Bash
Raw Permalink Normal View History

2021-02-09 18:32:36 +01:00
#!/bin/bash
set -e
psql -v ON_ERROR_STOP=1 --username grassroots --dbname cic_meta <<-EOSQL
create table if not exists store (
id serial primary key not null,
owner_fingerprint text not null,
hash char(64) not null unique,
content text not null
);
create index if not exists idx_fp on store ((lower(owner_fingerprint)));
EOSQL