Mirror of https://github.com/roostorg/coop
github.com/roostorg/coop
1-- Create hash_banks table
2CREATE TABLE IF NOT EXISTS hash_banks (
3 id SERIAL PRIMARY KEY,
4 org_id VARCHAR(255) NOT NULL REFERENCES orgs(id) ON DELETE CASCADE,
5 name VARCHAR(255) NOT NULL,
6 hma_name VARCHAR(255) NOT NULL UNIQUE,
7 description TEXT,
8 source VARCHAR(255),
9 enabled_ratio FLOAT NOT NULL DEFAULT 1.0,
10 created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
11 updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
12 CONSTRAINT unique_org_bank_name UNIQUE (org_id, name)
13);
14
15-- Create indexes for faster lookups
16CREATE INDEX IF NOT EXISTS idx_hash_banks_hma_name ON hash_banks(hma_name);
17CREATE INDEX IF NOT EXISTS idx_hash_banks_org_id ON hash_banks(org_id);