[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phragment.phragment_fragment (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    path VARCHAR(254) NOT NULL COLLATE utf8_bin,
   5    depth INT UNSIGNED NOT NULL,
   6    latestVersionPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   9    dateCreated INT UNSIGNED NOT NULL,
  10    dateModified INT UNSIGNED NOT NULL,
  11    UNIQUE KEY `key_phid` (phid),
  12    UNIQUE KEY `key_path` (path)
  13  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  14  
  15  CREATE TABLE {$NAMESPACE}_phragment.phragment_fragmentversion (
  16    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  17    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  18    sequence INT UNSIGNED NOT NULL,
  19    fragmentPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  20    filePHID VARCHAR(64) NULL COLLATE utf8_bin,
  21    dateCreated INT UNSIGNED NOT NULL,
  22    dateModified INT UNSIGNED NOT NULL,
  23    UNIQUE KEY `key_version` (fragmentPHID, sequence)
  24  ) ENGINE=InnoDB, COLLATE utf8_general_ci;