PHP Classes

File: sql/pgsql/02-v1.3.0.sql

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   sql/pgsql/02-v1.3.0.sql   Download  
File: sql/pgsql/02-v1.3.0.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: 1 year ago
Size: 285 bytes
 

Contents

Class file image Download 
CREATE TABLE chronicle_mirrors (
  id BIGSERIAL PRIMARY KEY,
  url TEXT NOT NULL,
  publickey TEXT NOT NULL,
  comment TEXT NULL,
  sortpriority INTEGER NOT NULL DEFAULT 0,
  created TIMESTAMP,
  modified TIMESTAMP
);

CREATE INDEX chronicle_mirrors_url_idx ON chronicle_mirrors(url);