PHP Classes

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

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 type: text/plain
Description: Auxiliary data
Class: Chronicle
Append arbitrary data to a storage container
Author: By
Last change:
Date: 1 year 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);