[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_owners.owners_package (
   2    id int unsigned not null auto_increment primary key,
   3    phid varchar(64) binary not null,
   4    unique key(phid),
   5    name varchar(255) COLLATE `binary` not null,
   6    unique key(name),
   7    description text not null,
   8    primaryOwnerPHID varchar(64) binary
   9  );
  10  
  11  CREATE TABLE {$NAMESPACE}_owners.owners_owner (
  12    id int unsigned not null auto_increment primary key,
  13    packageID int unsigned not null,
  14    userPHID varchar(64) binary not null,
  15    UNIQUE KEY(packageID, userPHID),
  16    KEY(userPHID)
  17  );
  18  
  19  CREATE TABLE {$NAMESPACE}_owners.owners_path (
  20    id int unsigned not null auto_increment primary key,
  21    packageID int unsigned not null,
  22    key(packageID),
  23    repositoryPHID varchar(64) binary not null,
  24    path varchar(255) not null
  25  );