PHP Classes

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

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   sql/mysql/02-v1.3.0.sql   Download  
File: sql/mysql/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: 398 bytes
 

Contents

Class file image Download
CREATE TABLE chronicle_mirrors ( `id` BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, `url` TEXT NOT NULL, `publickey` TEXT NOT NULL, `comment` TEXT NULL, `sortpriority` INT NOT NULL DEFAULT 0, `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE NOW() ); CREATE INDEX chronicle_mirrors_url_idx ON chronicle_mirrors(`url`);