[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phragment.phragment_snapshot (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    primaryFragmentPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    name VARCHAR(192) NOT NULL COLLATE utf8_bin,
   6    description LONGTEXT NULL COLLATE utf8_bin,
   7    dateCreated INT UNSIGNED NOT NULL,
   8    dateModified INT UNSIGNED NOT NULL,
   9    UNIQUE KEY `key_phid` (phid),
  10    UNIQUE KEY `key_name` (primaryFragmentPHID, name)
  11  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  12  
  13  CREATE TABLE {$NAMESPACE}_phragment.phragment_snapshotchild (
  14    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  15    snapshotPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    fragmentPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  17    fragmentVersionPHID VARCHAR(64) NULL COLLATE utf8_bin,
  18    dateCreated INT UNSIGNED NOT NULL,
  19    dateModified INT UNSIGNED NOT NULL,
  20    UNIQUE KEY `key_child` (snapshotPHID, fragmentPHID, fragmentVersionPHID)
  21  ) ENGINE=InnoDB, COLLATE utf8_general_ci;