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:
Date: 3 years ago
Size: 917 bytes
 

Contents

Class file image Download
CREATE TABLE chronicle_xsign_targets (
  id BIGSERIAL PRIMARY KEY,
  name TEXT,
  url TEXT,
  clientid TEXT,
  publickey TEXT,
  policy TEXT,
  lastrun TEXT
);

CREATE TABLE chronicle_replication_sources (
  id BIGSERIAL PRIMARY KEY,
  uniqueid TEXT,
  name TEXT,
  url TEXT,
  publickey TEXT
);

CREATE TABLE chronicle_replication_chain (
  id BIGSERIAL PRIMARY KEY,
  source BIGINT REFERENCES chronicle_replication_sources(id),
  data TEXT,
  prevhash TEXT,
  currhash TEXT,
  hashstate TEXT,
  summaryhash TEXT,
  publickey TEXT,
  signature TEXT,
  created TIMESTAMP,
  replicated TIMESTAMP
);

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);
For more information send a message to info at phpclasses dot org.