PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   sql/sqlite/02-v1.3.0.sql   Download  
File: sql/sqlite/02-v1.3.0.sql
Role: Auxiliary data
Content typex: text/plain
Description: Auxiliary data
Class: Chronicle
Append arbitrary data to a storage container
Author: By
Last change:
Date: 2 years ago
Size: 353 bytes
 

Contents

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

CREATE INDEX chronicle_mirrors_url_idx ON chronicle_mirrors(url);