PHP Classes

File: SQL File

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