[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_pholio.pholio_mock (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
   5    originalName VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
   6    description LONGTEXT NOT NULL COLLATE utf8_general_ci,
   7    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   9    coverPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  10    mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
  11    dateCreated INT UNSIGNED NOT NULL,
  12    dateModified INT UNSIGNED NOT NULL,
  13    UNIQUE KEY (phid),
  14    KEY (authorPHID)
  15  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  16  
  17  CREATE TABLE {$NAMESPACE}_pholio.edge (
  18    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  19    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  20    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  21    dateCreated INT UNSIGNED NOT NULL,
  22    seq INT UNSIGNED NOT NULL,
  23    dataID INT UNSIGNED,
  24    PRIMARY KEY (src, type, dst),
  25    KEY (src, type, dateCreated, seq)
  26  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  27  
  28  CREATE TABLE {$NAMESPACE}_pholio.edgedata (
  29    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  30    data LONGTEXT NOT NULL COLLATE utf8_bin
  31  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  32  
  33  CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction (
  34    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  35    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  36    mockID INT UNSIGNED NOT NULL,
  37    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  38    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  39    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  40    comment LONGTEXT NOT NULL COLLATE utf8_general_ci,
  41    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  42    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  43    dateCreated INT UNSIGNED NOT NULL,
  44    dateModified INT UNSIGNED NOT NULL
  45  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  46  
  47  CREATE TABLE {$NAMESPACE}_pholio.pholio_image (
  48    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  49    mockID INT UNSIGNED NOT NULL,
  50    filePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  51    name VARCHAR(128) NOT NULL COLLATE utf8_general_ci,
  52    description LONGTEXT NOT NULL COLLATE utf8_general_ci,
  53    sequence INT UNSIGNED NOT NULL,
  54    dateCreated INT UNSIGNED NOT NULL,
  55    dateModified INT UNSIGNED NOT NULL,
  56    KEY (mockID, sequence)
  57  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  58  
  59  CREATE TABLE {$NAMESPACE}_pholio.pholio_pixelcomment (
  60    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  61    mockID INT UNSIGNED NOT NULL,
  62    imageID INT UNSIGNED NOT NULL,
  63    transactionID INT UNSIGNED,
  64    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  65    x INT UNSIGNED NOT NULL,
  66    y INT UNSIGNED NOT NULL,
  67    width INT UNSIGNED NOT NULL,
  68    height INT UNSIGNED NOT NULL,
  69    comment LONGTEXT NOT NULL COLLATE utf8_general_ci,
  70    dateCreated INT UNSIGNED NOT NULL,
  71    dateModified INT UNSIGNED NOT NULL,
  72    KEY (mockID),
  73    KEY (authorPHID, transactionID)
  74  ) ENGINE=InnoDB, COLLATE utf8_general_ci;