<?php

final class SemiStructuredPatchList extends PhabricatorSQLPatchList {

  public function getNamespace() {
    return 'semistructured';
  }

  public function getPatches() {
    $root = dirname(phutil_get_library_root('semi-structured'));

    $db_patches = array(
      // First one is special.
      'db.semistructured' => array(
        'name' => 'semistructured',
        'type' => 'db',
        'after' => array(),
      ),
    );


    $auto = $this->buildPatchesFromDirectory($root.'/resources/sql/');

    return $db_patches + $auto;
  }

}

CREATE TABLE IF NOT EXISTS {$NAMESPACE}_diagram.diagram (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  phid varbinary(64) NOT NULL,
  version int(10) unsigned NOT NULL,
  authorPHID varbinary(64) NOT NULL,
  dateCreated int(10) unsigned NOT NULL,
  dateModified int(10) unsigned NOT NULL,
  byteSize bigint(20) unsigned NOT NULL,
  data longblob NOT NULL,
  viewPolicy varbinary(64) NOT NULL,
  editPolicy varbinary(64) NOT NULL,
  
  PRIMARY KEY (id),
  UNIQUE KEY key_version (phid,version),
  KEY key_authorPHID (authorPHID)
);

final class PhabricatorDiagram extends PhabricatorLiskDAO
implements
  PhabricatorPolicyInterface,
  PhabricatorSubscribableInterface,
  PhabricatorFlaggableInterface,
  PhabricatorTokenReceiverInterface,
  PhabricatorProjectInterface,
  PhabricatorApplicationTransactionInterface,
  PhabricatorDestructibleInterface {
// ...
protected function getConfiguration() {
  return array(
    self::CONFIG_COLUMN_SCHEMA => array(
//      'phid' => 'phid',
      'version' => 'uint32',
      'byteSize' => 'uint64',
      'data' => 'bytes'
    ),
    self::CONFIG_KEY_SCHEMA => array(
      'key_version' => array(
        'columns' => array('phid', 'version'),
        'unique' => true,
      ),
      'key_authorPHID' => array(
        'columns' => array('authorPHID'),
      ),
    ),
  ) + parent::getConfiguration();
}
// ...
}

Before running storage upgrades, you should take down the web interface and
stop any running daemons (you can disable this warning with --force).

    Are you ready to continue? [y/N] y

Applying patch "diagram:db.diagram" to host "localhost"...
Applying patch "diagram:20230626.DiagramsCreateTable.sql" to host "localhost"...
Storage is up to date. Use "storage status" for details.
Synchronizing static tables...
Verifying database schemata on "localhost"...
Found no adjustments for schemata.

Target                           Error
phabricator_diagram.diagram.phid Surplus

 SURPLUS SCHEMATA 

You have surplus schemata (extra tables or columns which this software does
not expect). For information on resolving these issues, see the "Surplus
Schemata" section in the "Managing Storage Adjustments" article in the
documentation.
 ANALYZE  Analyzing tables...
Done.                                                                         
 ANALYZED  Analyzed 528 table(s).

delete from phabricator_meta_data.patch_status where patch like 'diagram:%';
drop database phabricator_diagram;

protected function getConfiguration() {
  return array(
    self::CONFIG_AUX_PHID => true,     // <-------
    self::CONFIG_SERIALIZATION => array(
      'customFieldsConfig' => self::SERIALIZATION_JSON,
    ),
    self::CONFIG_COLUMN_SCHEMA => array(
      'name' => 'sort255',
      'status' => 'text32',
      'description' => 'text',
    ),
  ) + parent::getConfiguration();
}