PHP Classes

File: sql/mysql/00-local.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski  >  Chronicle  >  sql/mysql/00-local.sql  >  Download  
File: sql/mysql/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:
Date: 3 years ago
Size: 742 bytes
 

Contents

Class file image Download
CREATE TABLE chronicle_clients (
  id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  publicid TEXT,
  publickey TEXT,
  isAdmin BOOLEAN NOT NULL DEFAULT FALSE,
  comment TEXT,
  created DATETIME,
  modified DATETIME
);

CREATE INDEX chronicle_clients_clientid_idx ON chronicle_clients(publicid);

CREATE TABLE chronicle_chain (
  id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  data TEXT,
  prevhash TEXT,
  currhash TEXT,
  hashstate TEXT,
  summaryhash TEXT,
  publickey TEXT,
  signature TEXT,
  created DATETIME
);

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