PHP Classes

File: sql/sqlite/01-remote.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski  >  Chronicle  >  sql/sqlite/01-remote.sql  >  Download  
File: sql/sqlite/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: 869 bytes
 

Contents

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

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

CREATE TABLE chronicle_replication_chain (
  id INTEGER PRIMARY KEY ASC,
  source INTEGER,
  data TEXT,
  prevhash TEXT,
  currhash TEXT,
  hashstate TEXT,
  summaryhash TEXT,
  publickey TEXT,
  signature TEXT,
  created TEXT,
  replicated TEXT
);

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.