PHP Classes

File: sql/pgsql/00-local.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   sql/pgsql/00-local.sql   Download  
File: sql/pgsql/00-local.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Chronicle
Append arbitrary data to a storage container
Author: By
Last change: 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: 885 bytes
 

Contents

Class file image Download
CREATE TABLE chronicle_clients ( id BIGSERIAL PRIMARY KEY, publicid TEXT NOT NULL, publickey TEXT NOT NULL, "isAdmin" BOOLEAN NOT NULL DEFAULT FALSE, comment TEXT, created TIMESTAMP, modified TIMESTAMP ); CREATE INDEX chronicle_clients_clientid_idx ON chronicle_clients(publicid); CREATE TABLE chronicle_chain ( id BIGSERIAL PRIMARY KEY, 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, UNIQUE(currhash), UNIQUE(prevhash), FOREIGN KEY (prevhash) REFERENCES chronicle_chain(currhash) ); CREATE INDEX chronicle_chain_prevhash_idx ON chronicle_chain(prevhash); CREATE INDEX chronicle_chain_currhash_idx ON chronicle_chain(currhash); CREATE INDEX chronicle_chain_summaryhash_idx ON chronicle_chain(summaryhash);