resources/sql/patches/20130330.phrequent.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / 20130330.phrequent.sql

at recaptime-dev/main 10 lines 429 B view raw

wrap content

James Rhodes Added initial storage structure for Phrequent. 13y ago

dd3b3bdd

 1CREATE TABLE {$NAMESPACE}_phrequent.phrequent_usertime (
 2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 3  userPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 4  objectPHID VARCHAR(64) NULL COLLATE utf8_bin,
 5  note LONGTEXT NULL COLLATE utf8_bin,
 6  dateStarted INT UNSIGNED NOT NULL,
 7  dateEnded INT UNSIGNED NULL,
 8  dateCreated INT UNSIGNED NOT NULL,
 9  dateModified INT UNSIGNED NOT NULL
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;