PHP Classes

File: sql/pgsql/01-remote.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   sql/pgsql/01-remote.sql   Download  
File: sql/pgsql/01-remote.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Chronicle
Append arbitrary data to a storage container
Author: By
Last change: Merge branch 'master' into feature-travis-cover-all-database
Remove constraint that breaks PostgreSQL install
Fix all database issues
Add foreign key / unique constraints.
Future Genesis blocks will have a NULL prevhash, thereby allowing UNIQUE
FOREIGN KEY constraints to be created on prevhash pointing to a previous
row's currahsh.
Date: 1 year ago
Size: 1,133 bytes
 

Contents

Class file image Download
CREATE TABLE chronicle_xsign_targets ( id BIGSERIAL PRIMARY KEY, name TEXT NOT NULL, url TEXT NOT NULL, clientid TEXT NOT NULL, publickey TEXT NOT NULL, policy TEXT NOT NULL, lastrun TEXT ); CREATE TABLE chronicle_replication_sources ( id BIGSERIAL PRIMARY KEY, uniqueid TEXT NOT NULL, name TEXT NOT NULL, url TEXT NOT NULL, publickey TEXT NOT NULL ); CREATE TABLE chronicle_replication_chain ( id BIGSERIAL PRIMARY KEY, source BIGINT NOT NULL REFERENCES chronicle_replication_sources(id), data TEXT NOT NULL, prevhash TEXT NULL, currhash TEXT NOT NULL, hashstate TEXT NOT NULL, summaryhash TEXT NOT NULL, publickey TEXT NOT NULL, signature TEXT NOT NULL, created TIMESTAMP, replicated TIMESTAMP, UNIQUE(currhash), UNIQUE(prevhash), UNIQUE(source, prevhash) ); CREATE INDEX chronicle_replication_chain_prevhash_idx ON chronicle_replication_chain(source, prevhash); CREATE INDEX chronicle_replication_chain_currhash_idx ON chronicle_replication_chain(source, currhash); CREATE INDEX chronicle_replication_chain_summaryhash_idx ON chronicle_replication_chain(source, summaryhash);