diff --git a/src/lib/php/Dao/FolderDao.php b/src/lib/php/Dao/FolderDao.php
index b27e7e99..cfcfc0ba 100644
--- a/src/lib/php/Dao/FolderDao.php
+++ b/src/lib/php/Dao/FolderDao.php
@@ -1,406 +1,406 @@
 <?php
 /*
 Copyright (C) 2014-2015, Siemens AG
 Authors: Andreas Würl, Steffen Weber
 
 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 version 2 as published by the Free Software Foundation.
 
 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.
 
 You should have received a copy of the GNU General Public License along
 with this program; if not, write to the Free Software Foundation, Inc.,
 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */
 
 namespace Fossology\Lib\Dao;
 
 use Fossology\Lib\Auth\Auth;
 use Fossology\Lib\Data\Folder\Folder;
 use Fossology\Lib\Data\Upload\UploadProgress;
 use Fossology\Lib\Db\DbManager;
 use Fossology\Lib\Util\Object;
 use Monolog\Logger;
 
 class FolderDao extends Object
 {
   const FOLDER_KEY = "folder" ;
   const DEPTH_KEY = "depth" ;
   const REUSE_KEY = 'reuse';
   const TOP_LEVEL = 1;
 
   const MODE_FOLDER = 1;
   const MODE_UPLOAD = 2;
   const MODE_ITEM = 4;
   
   /** @var DbManager */
   private $dbManager;
   /** @var UserDao */
   private $userDao;
   /** @var UploadDao */
   private $uploadDao;
   /** @var Logger */
   private $logger;
 
   public function __construct(DbManager $dbManager, UserDao $userDao, UploadDao $uploadDao)
   {
     $this->dbManager = $dbManager;
     $this->logger = new Logger(self::className());
     $this->uploadDao = $uploadDao;
     $this->userDao = $userDao;
   }
 
   /**
    * @return boolean
    */
   public function hasTopLevelFolder()
   {
     $folderInfo = $this->dbManager->getSingleRow("SELECT count(*) cnt FROM folder WHERE folder_pk=$1",array(self::TOP_LEVEL),__METHOD__);
     $hasFolder = $folderInfo['cnt']>0;
     return $hasFolder;
   }
 
   public function insertFolder($folderName, $folderDescription, $parentFolderId=self::TOP_LEVEL) {
 
     $statementName = __METHOD__;
 
     $this->dbManager->prepare($statementName,
       "INSERT INTO folder (folder_name, folder_desc) VALUES ($1, $2) returning folder_pk");
     $res = $this->dbManager->execute($statementName, array($folderName, $folderDescription));
     $folderRow=$this->dbManager->fetchArray($res);
     $folderId=$folderRow["folder_pk"];
     $this->dbManager->freeResult($res);
     $this->insertFolderContents($parentFolderId, self::MODE_FOLDER, $folderId);
     
     return $folderId;
   }
 
   public function getFolderId($folderName, $parentFolderId=self::TOP_LEVEL) {
     $statementName = __METHOD__;
     $this->dbManager->prepare($statementName,
         "SELECT folder_pk FROM folder, foldercontents fc"
        ." WHERE folder_name=$1 AND fc.parent_fk=$2 AND fc.foldercontents_mode=$3 AND folder_pk=child_id");
     $res = $this->dbManager->execute($statementName, array( $folderName, $parentFolderId, self::MODE_FOLDER));
     $rows= $this->dbManager->fetchAll($res);
 
     $rootFolder = !empty($rows) ? intval($rows[0]['folder_pk']) : null;
     $this->dbManager->freeResult($res);
 
     return $rootFolder;
   }
 
   public function insertFolderContents($parentId, $foldercontentsMode, $childId) {
     $statementName = __METHOD__;
     $this->dbManager->prepare($statementName,
         "INSERT INTO foldercontents (parent_fk, foldercontents_mode, child_id) VALUES ($1, $2, $3)");
     $res = $this->dbManager->execute($statementName, array($parentId, $foldercontentsMode, $childId));
     $this->dbManager->freeResult($res);
   }
 
   protected function fixFolderSequence() {
     $statementName = __METHOD__;
     $this->dbManager->prepare($statementName,
         "SELECT setval('folder_folder_pk_seq', (SELECT max(folder_pk) + 1 FROM folder LIMIT 1))");
     $res = $this->dbManager->execute($statementName);
     $this->dbManager->freeResult($res);
   }
 
   /**
    * @param int $userId
    * @return Folder|null
    */
   public function getRootFolder($userId) {
     $statementName = __METHOD__;
     $this->dbManager->prepare($statementName,
         "SELECT f.* FROM folder f INNER JOIN users u ON f.folder_pk = u.root_folder_fk WHERE u.user_pk = $1");
     $res = $this->dbManager->execute($statementName, array($userId));
     $row = $this->dbManager->fetchArray($res);
     $rootFolder = $row ? new Folder(intval($row['folder_pk']), $row['folder_name'], $row['folder_desc'], intval($row['folder_perm'])) : null;
     $this->dbManager->freeResult($res);
     return $rootFolder;
   }
 
   public function getFolderTreeCte($parentId=null) {
     $parentCondition = $parentId ? 'folder_pk=$1' : 'folder_pk='.self::TOP_LEVEL;
 
     return "WITH RECURSIVE folder_tree(folder_pk, parent_fk, folder_name, folder_desc, folder_perm, id_path, name_path, depth, cycle_detected) AS (
   SELECT
     f.folder_pk, fc.parent_fk, f.folder_name, f.folder_desc, f.folder_perm,
     ARRAY [f.folder_pk]   AS id_path,
     ARRAY [f.folder_name] AS name_path,
     0                     AS depth,
     FALSE                 AS cycle_detected
   FROM folder f LEFT JOIN foldercontents fc ON fc.foldercontents_mode=".self::MODE_FOLDER." AND f.folder_pk=fc.child_id
   WHERE $parentCondition
   UNION ALL
   SELECT
     f.folder_pk, fc.parent_fk, f.folder_name, f.folder_desc, f.folder_perm,
     id_path || f.folder_pk,
     name_path || f.folder_name,
     array_length(id_path, 1),
     f.folder_pk = ANY (id_path)
   FROM folder f, foldercontents fc, folder_tree ft
   WHERE f.folder_pk=fc.child_id AND foldercontents_mode=".self::MODE_FOLDER." AND fc.parent_fk = ft.folder_pk AND NOT cycle_detected
 )";
   }
     
   public function getFolderStructure($parentId=null) {
     $statementName = __METHOD__ . ($parentId ? '.relativeToParent' : '');
     $parameters = $parentId ? array($parentId) : array();
     $this->dbManager->prepare($statementName, $this->getFolderTreeCte($parentId)
             . " SELECT folder_pk, parent_fk, folder_name, folder_desc, folder_perm, depth FROM folder_tree ORDER BY name_path");
     $res = $this->dbManager->execute($statementName, $parameters);
   
     $userGroupMap = $this->userDao->getUserGroupMap(Auth::getUserId());
     
     $results = array();
     while ($row = $this->dbManager->fetchArray($res))
     {
       $countUploads = $this->countFolderUploads(intval($row['folder_pk']), $userGroupMap);
       
       $results[] = array(
           self::FOLDER_KEY => new Folder(
                   intval($row['folder_pk']), $row['folder_name'], $row['folder_desc'], intval($row['folder_perm'])),
           self::DEPTH_KEY => $row['depth'],
           self::REUSE_KEY => $countUploads
       );
     }
     $this->dbManager->freeResult($res);
     return $results;
   }
 
   /**
    * @param int $parentId
    * @param string[] $userGroupMap map groupId=>groupName
    * @return array  of array(group_id,count,group_name)
    */
   public function countFolderUploads($parentId, $userGroupMap)
   {
     $trustGroupIds = array_keys($userGroupMap);
     $statementName = __METHOD__;
     $trustedGroups = '{'. implode(',', $trustGroupIds) .'}';
     $parameters = array($parentId, $trustedGroups);
 
     $this->dbManager->prepare($statementName, "
 SELECT group_fk group_id,count(*) FROM foldercontents fc
   INNER JOIN upload u ON u.upload_pk = fc.child_id
   INNER JOIN upload_clearing uc ON u.upload_pk=uc.upload_fk AND uc.group_fk=ANY($2)
 WHERE fc.parent_fk = $1 AND fc.foldercontents_mode = ". self::MODE_UPLOAD ." AND u.upload_mode = 104
 GROUP BY group_fk
 ");
     $res = $this->dbManager->execute($statementName, $parameters);
     $results = array();
     while ($row = $this->dbManager->fetchArray($res))
     {
       $row['group_name'] = $userGroupMap[$row['group_id']];
       $results[$row['group_name']] = $row;
     }
     $this->dbManager->freeResult($res);
     return $results;
   }
   
   
   public function getFolderChildUploads($parentId, $trustGroupId)
   {
     $statementName = __METHOD__;
     $parameters = array($parentId, $trustGroupId);
 
     $this->dbManager->prepare($statementName, $sql="
 SELECT u.*,uc.*,fc.foldercontents_pk FROM foldercontents fc
   INNER JOIN upload u ON u.upload_pk = fc.child_id
   INNER JOIN upload_clearing uc ON u.upload_pk=uc.upload_fk AND uc.group_fk=$2
 WHERE fc.parent_fk = $1 AND fc.foldercontents_mode = " .self::MODE_UPLOAD. " AND u.upload_mode = 104
 ");
     $res = $this->dbManager->execute($statementName, $parameters);
     $results = $this->dbManager->fetchAll($res);
     $this->dbManager->freeResult($res);
     return $results;
   }
   
   /**
    * @param int $parentId
    * @param int $trustGroupId
    * @return UploadProgress[]
    */
   public function getFolderUploads($parentId, $trustGroupId=null)
   {
     if (empty($trustGroupId)) {
       $trustGroupId = Auth::getGroupId();
     }
     $results = array();
     foreach($this->getFolderChildUploads($parentId, $trustGroupId) as $row)
     {
       $results[] = UploadProgress::createFromTable($row);
     }
     return $results;
   }
 
   public function createFolder($folderName, $folderDescription, $parentId)
   {
-    $folderId = $this->dbManager->insertTableRow("folder", array("folder_name"=>$folderName, "folder_desc"=>$folderDescription), null, 'folder_pk');
+    $folderId = $this->dbManager->insertTableRow("folder", array("folder_name"=>$folderName, "user_fk"=>Auth::getUserId(), "folder_desc"=>$folderDescription), null, 'folder_pk');
     $this->insertFolderContents($parentId, self::MODE_FOLDER, $folderId);
     return $folderId;
   }
   
   
   public function ensureTopLevelFolder() {
     if (!$this->hasTopLevelFolder())
     {
       $this->dbManager->insertTableRow("folder", array("folder_pk"=>self::TOP_LEVEL, "folder_name"=>"Software Repository", "folder_desc"=>"Top Folder"));
       $this->insertFolderContents(1,0,0);
       $this->fixFolderSequence();
     }
   }
 
   public function isWithoutReusableFolders($folderStructure) {
     foreach($folderStructure as $folder)
     {
       $posibilities = array_reduce($folder[self::REUSE_KEY],
                                  function($sum,$groupInfo){ return $sum+$groupInfo['count'];},
                                  0);
       if($posibilities > 0) {
         return false;
       }
     }
     return true;
   }
   
   protected function isInFolderTree($parentId,$folderId)
   {
     $cycle = $this->dbManager->getSingleRow(
         $this->getFolderTreeCte($parentId) . " SELECT depth FROM folder_tree WHERE folder_pk=$2 LIMIT 1",
         array($parentId,$folderId),
         __METHOD__);
     return !empty($cycle);
   }
   
   protected function getContent($folderContentId)
   {
     $content = $this->dbManager->getSingleRow('SELECT * FROM foldercontents WHERE foldercontents_pk=$1',
             array($folderContentId),
             __METHOD__.'.getContent' );
     if (empty($content)) {
       throw new \Exception('invalid FolderContentId');
     }
     return $content;
   }
   
   protected function isContentMovable($content, $newParentId)
   {
     if ($content['parent_fk'] == $newParentId) {
       return false;
     }
     $newParent = $this->dbManager->getSingleRow('SELECT * FROM folder WHERE folder_pk=$1',
             array($newParentId),
             __METHOD__.'.getParent');
     if (empty($newParent)) {
       throw new \Exception('invalid parent folder');
     }
     
     if($content['foldercontents_mode']==self::MODE_FOLDER)
     {
       if ($this->isInFolderTree($content['child_id'],$newParentId)) {
         throw new \Exception("action would cause a cycle");
       }
     }
     elseif($content['foldercontents_mode']==self::MODE_UPLOAD)
     {
       $uploadId = $content['child_id'];
       if (!$this->uploadDao->isEditable($uploadId, Auth::getGroupId())) {
         throw new \Exception('permission to upload denied');
       }
     }
     
     return true;
   }
   
   public function moveContent($folderContentId, $newParentId)
   {
     $content = $this->getContent($folderContentId);
     if (!$this->isContentMovable($content, $newParentId)) {
       return;
     }
 
     $this->dbManager->getSingleRow('UPDATE foldercontents SET parent_fk=$2 WHERE foldercontents_pk=$1',
               array($folderContentId,$newParentId),__METHOD__.'.updateFolderParent');
   }
   
   public function copyContent($folderContentId, $newParentId)
   {
     $content = $this->getContent($folderContentId);
     if (!$this->isContentMovable($content, $newParentId)) {
       return;
     }
     
     $this->insertFolderContents($newParentId, $content['foldercontents_mode'], $content['child_id']);
   }
   
   public function getRemovableContents($folderId)
   {
     $sqlChildren = "SELECT child_id,foldercontents_mode
              FROM foldercontents GROUP BY child_id,foldercontents_mode
              HAVING count(*)>1 AND bool_or(parent_fk=$1)";
     $sql = "SELECT fc.* FROM foldercontents fc,($sqlChildren) chi "
             . "WHERE fc.child_id=chi.child_id AND fc.foldercontents_mode=chi.foldercontents_mode and fc.parent_fk=$1";
     $this->dbManager->prepare($stmt=__METHOD__,$sql);
     $res = $this->dbManager->execute($stmt,array($folderId));
     $contents = array();
     while($row=$this->dbManager->fetchArray($res))
     {
       $contents[] = $row['foldercontents_pk'];
     }
     $this->dbManager->freeResult($res);
     return $contents;
   }
   
   protected function isRemovableContent($childId,$mode)
   {
     $sql = "SELECT count(parent_fk) FROM foldercontents WHERE child_id=$1 AND foldercontents_mode=$2";
     $parentCounter = $this->dbManager->getSingleRow($sql,array($childId,$mode),__METHOD__);
     return $parentCounter['count']>1;
   }
   
   public function removeContent($folderContentId)
   {
     $content = $this->getContent($folderContentId);
     if($this->isRemovableContent($content['child_id'],$content['foldercontents_mode']))
     {
       $sql = "DELETE FROM foldercontents WHERE foldercontents_pk=$1";
       $this->dbManager->getSingleRow($sql,array($folderContentId),__METHOD__);
     }
   }
   
   public function getFolderChildFolders($folderId)
   {
     $results = array();
     $stmtFolder = __METHOD__;
     $sqlFolder = "SELECT foldercontents_pk,foldercontents_mode, folder_name FROM foldercontents,folder "
             . "WHERE foldercontents.parent_fk=$1 AND foldercontents.child_id=folder.folder_pk"
             . " AND foldercontents_mode=".self::MODE_FOLDER;
     $this->dbManager->prepare($stmtFolder, $sqlFolder);
     $res = $this->dbManager->execute($stmtFolder,array($folderId));
     while($row=$this->dbManager->fetchArray($res))
     {
       $results[$row['foldercontents_pk']] = $row;
     }
     $this->dbManager->freeResult($res);
     return $results;
   }
   
   /**
    * @param int $folderId
    * @return Folder|null
    */
   public function getFolder($folderId)
   {
     $folderRow = $this->dbManager->getSingleRow('SELECT * FROM folder WHERE folder_pk = $1', array($folderId));
     if (!$folderRow) {
       return null;
     }
     return new Folder($folderRow['folder_pk'],$folderRow['folder_name'],$folderRow['folder_desc'],$folderRow['folder_perm']);
   }
-}
\ No newline at end of file
+}
diff --git a/src/www/ui/admin-folder-delete.php b/src/www/ui/admin-folder-delete.php
index ac527a5c..29338359 100644
--- a/src/www/ui/admin-folder-delete.php
+++ b/src/www/ui/admin-folder-delete.php
@@ -1,131 +1,135 @@
 <?php
 
 use Fossology\Lib\Auth\Auth;
 use Fossology\Lib\Db\DbManager;
 /***********************************************************
  Copyright (C) 2008-2013 Hewlett-Packard Development Company, L.P.
 
  This program is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  version 2 as published by the Free Software Foundation.
 
  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.
 
  You should have received a copy of the GNU General Public License along
  with this program; if not, write to the Free Software Foundation, Inc.,
  51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
  ***********************************************************/
 
 define("TITLE_admin_folder_delete", _("Delete Folder"));
 
 class admin_folder_delete extends FO_Plugin {
 
   /** @var DbManager */
   private $dbManager;
 
   function __construct()
   {
     $this->Name = "admin_folder_delete";
     $this->Title = TITLE_admin_folder_delete;
     $this->MenuList = "Organize::Folders::Delete Folder";
     $this->Dependency = array();
     $this->DBaccess = PLUGIN_DB_WRITE;
     parent::__construct();
     $this->dbManager = $GLOBALS['container']->get('db.manager');
   }
 
   /**
    * \brief Delete
    * Creates a job to detele the folder
    *
    * \param $folderpk - the folder_pk to remove
    * \return NULL on success, string on failure.
    */
-  function Delete($folderpk, $Depends = NULL) 
+  function Delete($folderpk, $userId) 
   {
     /* Can't remove top folder */
     if ($folderpk == FolderGetTop()) {
       $text = _("Can Not Delete Root Folder");
       return ($text);
     }
     /* Get the folder's name */
     $FolderName = FolderGetName($folderpk);
     /* Prepare the job: job "Delete" */
-    $userId = Auth::getUserId();
     $groupId = Auth::getGroupId();
     $jobpk = JobAddJob($userId, $groupId, "Delete Folder: $FolderName");
     if (empty($jobpk) || ($jobpk < 0)) {
       $text = _("Failed to create job record");
       return ($text);
     }
     /* Add job: job "Delete" has jobqueue item "delagent" */
     $jqargs = "DELETE FOLDER $folderpk";
     $jobqueuepk = JobQueueAdd($jobpk, "delagent", $jqargs, NULL, NULL);
     if (empty($jobqueuepk)) {
       $text = _("Failed to place delete in job queue");
       return ($text);
     }
 
     /* Tell the scheduler to check the queue. */
     $success  = fo_communicate_with_scheduler("database", $output, $error_msg);
     if (!$success) return $error_msg . "\n" . $output;
 
     return (NULL);
   } // Delete()
 
   /**
    * \brief Generate the text for this plugin.
    */
   public function Output() {
     /* If this is a POST, then process the request. */
     $folder = GetParm('folder', PARM_INTEGER);
     if (!empty($folder)) {
-      $rc = $this->Delete($folder);
-      $sql = "SELECT * FROM folder where folder_pk = $1;";
-      $Folder = $this->dbManager->getSingleRow($sql,array($folder),__METHOD__."GetRowWithFolderName");
-      if (empty($rc)) {
-        /* Need to refresh the screen */
-        $text = _("Deletion of folder ");
-        $text1 = _(" added to job queue");
-        $this->vars['message'] = $text . $Folder['folder_name'] . $text1;
-      }
-      else {
-        $text = _("Deletion of ");
-        $text1 = _(" failed: ");
-        $this->vars['message'] =  $text . $Folder['folder_name'] . $text1 . $rc;
+      $userId = Auth::getUserId();
+      $sql = "SELECT folder_name FROM folder join users on (users.user_pk = folder.user_fk or users.user_perm = 10) where folder_pk = '$1' and users.user_pk = $2;";
+      $Folder = $this->dbManager->getSingleRow($sql,array($folder,$userId),__METHOD__."GetRowWithFolderName");
+      if(!empty($Folder['folder_name'])){
+        $rc = $this->Delete($folder, $userId);
+        if (empty($rc)) {
+          /* Need to refresh the screen */
+          $text = _("Deletion of folder ");
+          $text1 = _(" added to job queue");
+          $this->vars['message'] = $text . $Folder['folder_name'] . $text1;
+        }else{
+          $text = _("Deletion of ");
+          $text1 = _(" failed: ");
+          $this->vars['message'] =  $text . $Folder['folder_name'] . $text1 . $rc;
+        }
+      }else{
+        $text = _("Cannot delete this folder :: Permission denied");
+        $this->vars['message'] = $text;
       }
     }
 
     $V= "<form method='post'>\n"; // no url = this url
     $text  =  _("Select the folder to");
     $text1 = _("delete");
     $V.= "$text <em>$text1</em>.\n";
     $V.= "<ul>\n";
     $text = _("This will");
     $text1 = _("delete");
     $text2 = _("the folder, all subfolders, and all uploaded files stored within the folder!");
     $V.= "<li>$text <em>$text1</em> $text2\n";
     $text = _("Be very careful with your selection since you can delete a lot of work!");
     $V.= "<li>$text\n";
     $text = _("All analysis only associated with the deleted uploads will also be deleted.");
     $V.= "<li>$text\n";
     $text = _("THERE IS NO UNDELETE. When you select something to delete, it will be removed from the database and file repository.");
     $V.= "<li>$text\n";
     $V.= "</ul>\n";
     $text = _("Select the folder to delete:  ");
     $V.= "<P>$text\n";
     $V.= "<select name='folder'>\n";
     $text = _("select folder");
     $V.= "<option value=''>[$text]</option>\n";
     $V.= FolderListOption(-1, 0);
     $V.= "</select><P />\n";
     $text = _("Delete");
     $V.= "<input type='submit' value='$text!'>\n";
     $V.= "</form>\n";
     return $V;
   }
 }
 $NewPlugin = new admin_folder_delete;
diff --git a/src/www/ui/core-schema.dat b/src/www/ui/core-schema.dat
index f4cb263a..7b49b9fb 100644
--- a/src/www/ui/core-schema.dat
+++ b/src/www/ui/core-schema.dat
@@ -1,1845 +1,1849 @@
 <?php
 /* This file is generated by  */
 /* Do not manually edit this file */
 
   $Schema=array();
 
   $Schema["TABLE"]["agent"]["agent_pk"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_pk\" IS 'Primary key'";
   $Schema["TABLE"]["agent"]["agent_pk"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_pk\" int4 DEFAULT nextval('agent_agent_pk_seq'::regclass)";
   $Schema["TABLE"]["agent"]["agent_pk"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_pk\" SET NOT NULL, ALTER COLUMN \"agent_pk\" SET DEFAULT nextval('agent_agent_pk_seq'::regclass)";
 
   $Schema["TABLE"]["agent"]["agent_name"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_name\" IS 'display name'";
   $Schema["TABLE"]["agent"]["agent_name"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_name\" varchar(32)";
   $Schema["TABLE"]["agent"]["agent_name"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_name\" SET NOT NULL";
 
   $Schema["TABLE"]["agent"]["agent_rev"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_rev\" IS 'revision string'";
   $Schema["TABLE"]["agent"]["agent_rev"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_rev\" varchar(32)";
   $Schema["TABLE"]["agent"]["agent_rev"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_rev\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent"]["agent_desc"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_desc\" IS 'short description'";
   $Schema["TABLE"]["agent"]["agent_desc"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_desc\" varchar(255)";
   $Schema["TABLE"]["agent"]["agent_desc"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_desc\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent"]["agent_enabled"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_enabled\" IS 'true to enable, false to disable'";
   $Schema["TABLE"]["agent"]["agent_enabled"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_enabled\" bool DEFAULT true";
   $Schema["TABLE"]["agent"]["agent_enabled"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_enabled\" DROP NOT NULL, ALTER COLUMN \"agent_enabled\" SET DEFAULT true";
 
   $Schema["TABLE"]["agent"]["agent_parms"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_parms\" IS 'agent parsable parameters'";
   $Schema["TABLE"]["agent"]["agent_parms"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_parms\" text";
   $Schema["TABLE"]["agent"]["agent_parms"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_parms\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent"]["agent_ts"]["DESC"] = "COMMENT ON COLUMN \"agent\".\"agent_ts\" IS 'time record was added'";
   $Schema["TABLE"]["agent"]["agent_ts"]["ADD"] = "ALTER TABLE \"agent\" ADD COLUMN \"agent_ts\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["agent"]["agent_ts"]["ALTER"] = "ALTER TABLE \"agent\" ALTER COLUMN \"agent_ts\" DROP NOT NULL, ALTER COLUMN \"agent_ts\" SET DEFAULT now()";
 
 
   $Schema["TABLE"]["agent_runstatus"]["ars_pk"]["DESC"] = "";
   $Schema["TABLE"]["agent_runstatus"]["ars_pk"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"ars_pk\" int4 DEFAULT nextval('agent_runstatus_ars_pk_seq'::regclass)";
   $Schema["TABLE"]["agent_runstatus"]["ars_pk"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"ars_pk\" SET NOT NULL, ALTER COLUMN \"ars_pk\" SET DEFAULT nextval('agent_runstatus_ars_pk_seq'::regclass)";
 
   $Schema["TABLE"]["agent_runstatus"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["agent_runstatus"]["agent_fk"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["agent_runstatus"]["agent_fk"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["agent_runstatus"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["agent_runstatus"]["upload_fk"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["agent_runstatus"]["upload_fk"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["agent_runstatus"]["ars_complete"]["DESC"] = "COMMENT ON COLUMN \"agent_runstatus\".\"ars_complete\" IS 'true if the agent has completed with success (i.e. results are available), false if the agent has not completed running on this upload or the results are not usable (due to errors)'";
   $Schema["TABLE"]["agent_runstatus"]["ars_complete"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"ars_complete\" bool DEFAULT false";
   $Schema["TABLE"]["agent_runstatus"]["ars_complete"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"ars_complete\" SET NOT NULL, ALTER COLUMN \"ars_complete\" SET DEFAULT false";
 
   $Schema["TABLE"]["agent_runstatus"]["ars_status"]["DESC"] = "COMMENT ON COLUMN \"agent_runstatus\".\"ars_status\" IS 'status of run - on error exit, record error msg if possible'";
   $Schema["TABLE"]["agent_runstatus"]["ars_status"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"ars_status\" text";
   $Schema["TABLE"]["agent_runstatus"]["ars_status"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"ars_status\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent_runstatus"]["ars_starttime"]["DESC"] = "COMMENT ON COLUMN \"agent_runstatus\".\"ars_starttime\" IS 'time record was added.'";
   $Schema["TABLE"]["agent_runstatus"]["ars_starttime"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"ars_starttime\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["agent_runstatus"]["ars_starttime"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"ars_starttime\" SET NOT NULL, ALTER COLUMN \"ars_starttime\" SET DEFAULT now()";
 
   $Schema["TABLE"]["agent_runstatus"]["ars_endtime"]["DESC"] = "COMMENT ON COLUMN \"agent_runstatus\".\"ars_endtime\" IS 'time when agent completed'";
   $Schema["TABLE"]["agent_runstatus"]["ars_endtime"]["ADD"] = "ALTER TABLE \"agent_runstatus\" ADD COLUMN \"ars_endtime\" timestamptz";
   $Schema["TABLE"]["agent_runstatus"]["ars_endtime"]["ALTER"] = "ALTER TABLE \"agent_runstatus\" ALTER COLUMN \"ars_endtime\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["agent_wc"]["pfile_fk"]["DESC"] = "COMMENT ON COLUMN \"agent_wc\".\"pfile_fk\" IS 'pfile key'";
   $Schema["TABLE"]["agent_wc"]["pfile_fk"]["ADD"] = "ALTER TABLE \"agent_wc\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["agent_wc"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"agent_wc\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent_wc"]["wc_words"]["DESC"] = "COMMENT ON COLUMN \"agent_wc\".\"wc_words\" IS 'wc words'";
   $Schema["TABLE"]["agent_wc"]["wc_words"]["ADD"] = "ALTER TABLE \"agent_wc\" ADD COLUMN \"wc_words\" int4";
   $Schema["TABLE"]["agent_wc"]["wc_words"]["ALTER"] = "ALTER TABLE \"agent_wc\" ALTER COLUMN \"wc_words\" DROP NOT NULL";
 
   $Schema["TABLE"]["agent_wc"]["wc_lines"]["DESC"] = "COMMENT ON COLUMN \"agent_wc\".\"wc_lines\" IS 'wc lines'";
   $Schema["TABLE"]["agent_wc"]["wc_lines"]["ADD"] = "ALTER TABLE \"agent_wc\" ADD COLUMN \"wc_lines\" int4";
   $Schema["TABLE"]["agent_wc"]["wc_lines"]["ALTER"] = "ALTER TABLE \"agent_wc\" ALTER COLUMN \"wc_lines\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["ars_master"]["ars_pk"]["DESC"] = "";
   $Schema["TABLE"]["ars_master"]["ars_pk"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"ars_pk\" int4 DEFAULT nextval('nomos_ars_ars_pk_seq'::regclass)";
   $Schema["TABLE"]["ars_master"]["ars_pk"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"ars_pk\" SET NOT NULL, ALTER COLUMN \"ars_pk\" SET DEFAULT nextval('nomos_ars_ars_pk_seq'::regclass)";
 
   $Schema["TABLE"]["ars_master"]["agent_fk"]["DESC"] = "COMMENT ON COLUMN \"ars_master\".\"agent_fk\" IS 'nomos agent pk'";
   $Schema["TABLE"]["ars_master"]["agent_fk"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["ars_master"]["agent_fk"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ars_master"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["ars_master"]["upload_fk"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["ars_master"]["upload_fk"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ars_master"]["ars_success"]["DESC"] = "COMMENT ON COLUMN \"ars_master\".\"ars_success\" IS 'true if the scan completed successfully.  false if the scan in not complete or completed with errors'";
   $Schema["TABLE"]["ars_master"]["ars_success"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"ars_success\" bool DEFAULT false";
   $Schema["TABLE"]["ars_master"]["ars_success"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"ars_success\" SET NOT NULL, ALTER COLUMN \"ars_success\" SET DEFAULT false";
 
   $Schema["TABLE"]["ars_master"]["ars_status"]["DESC"] = "COMMENT ON COLUMN \"ars_master\".\"ars_status\" IS 'scan completion message (error msg, or \"success\")'";
   $Schema["TABLE"]["ars_master"]["ars_status"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"ars_status\" text";
   $Schema["TABLE"]["ars_master"]["ars_status"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"ars_status\" DROP NOT NULL";
 
   $Schema["TABLE"]["ars_master"]["ars_starttime"]["DESC"] = "COMMENT ON COLUMN \"ars_master\".\"ars_starttime\" IS 'time scan started'";
   $Schema["TABLE"]["ars_master"]["ars_starttime"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"ars_starttime\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["ars_master"]["ars_starttime"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"ars_starttime\" SET NOT NULL, ALTER COLUMN \"ars_starttime\" SET DEFAULT now()";
 
   $Schema["TABLE"]["ars_master"]["ars_endtime"]["DESC"] = "COMMENT ON COLUMN \"ars_master\".\"ars_endtime\" IS 'time scan completed'";
   $Schema["TABLE"]["ars_master"]["ars_endtime"]["ADD"] = "ALTER TABLE \"ars_master\" ADD COLUMN \"ars_endtime\" timestamptz";
   $Schema["TABLE"]["ars_master"]["ars_endtime"]["ALTER"] = "ALTER TABLE \"ars_master\" ALTER COLUMN \"ars_endtime\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["attachments"]["attachment_pk"]["DESC"] = "";
   $Schema["TABLE"]["attachments"]["attachment_pk"]["ADD"] = "ALTER TABLE \"attachments\" ADD COLUMN \"attachment_pk\" int4 DEFAULT nextval('attachments_attachment_pk_seq'::regclass)";
   $Schema["TABLE"]["attachments"]["attachment_pk"]["ALTER"] = "ALTER TABLE \"attachments\" ALTER COLUMN \"attachment_pk\" SET NOT NULL, ALTER COLUMN \"attachment_pk\" SET DEFAULT nextval('attachments_attachment_pk_seq'::regclass)";
 
   $Schema["TABLE"]["attachments"]["type"]["DESC"] = "COMMENT ON COLUMN \"attachments\".\"type\" IS '''c''=comment, ''f''=file'";
   $Schema["TABLE"]["attachments"]["type"]["ADD"] = "ALTER TABLE \"attachments\" ADD COLUMN \"type\" char(1)";
   $Schema["TABLE"]["attachments"]["type"]["ALTER"] = "ALTER TABLE \"attachments\" ALTER COLUMN \"type\" SET NOT NULL";
 
   $Schema["TABLE"]["attachments"]["text"]["DESC"] = "COMMENT ON COLUMN \"attachments\".\"text\" IS 'comment, or file name of uploaded file'";
   $Schema["TABLE"]["attachments"]["text"]["ADD"] = "ALTER TABLE \"attachments\" ADD COLUMN \"text\" text";
   $Schema["TABLE"]["attachments"]["text"]["ALTER"] = "ALTER TABLE \"attachments\" ALTER COLUMN \"text\" SET NOT NULL";
 
   $Schema["TABLE"]["attachments"]["pfile_fk"]["DESC"] = "COMMENT ON COLUMN \"attachments\".\"pfile_fk\" IS 'pfile_fk if type file'";
   $Schema["TABLE"]["attachments"]["pfile_fk"]["ADD"] = "ALTER TABLE \"attachments\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["attachments"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"attachments\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["attachments"]["server_fk"]["DESC"] = "";
   $Schema["TABLE"]["attachments"]["server_fk"]["ADD"] = "ALTER TABLE \"attachments\" ADD COLUMN \"server_fk\" int4";
   $Schema["TABLE"]["attachments"]["server_fk"]["ALTER"] = "ALTER TABLE \"attachments\" ALTER COLUMN \"server_fk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["bucket_ars"]["ars_pk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["ars_pk"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"ars_pk\" int4 DEFAULT nextval('nomos_ars_ars_pk_seq'::regclass)";
   $Schema["TABLE"]["bucket_ars"]["ars_pk"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"ars_pk\" SET NOT NULL, ALTER COLUMN \"ars_pk\" SET DEFAULT nextval('nomos_ars_ars_pk_seq'::regclass)";
 
   $Schema["TABLE"]["bucket_ars"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["agent_fk"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["bucket_ars"]["agent_fk"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_ars"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["upload_fk"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["bucket_ars"]["upload_fk"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_ars"]["ars_success"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["ars_success"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"ars_success\" bool DEFAULT false";
   $Schema["TABLE"]["bucket_ars"]["ars_success"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"ars_success\" SET NOT NULL, ALTER COLUMN \"ars_success\" SET DEFAULT false";
 
   $Schema["TABLE"]["bucket_ars"]["ars_status"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["ars_status"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"ars_status\" text";
   $Schema["TABLE"]["bucket_ars"]["ars_status"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"ars_status\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_ars"]["ars_starttime"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["ars_starttime"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"ars_starttime\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["bucket_ars"]["ars_starttime"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"ars_starttime\" SET NOT NULL, ALTER COLUMN \"ars_starttime\" SET DEFAULT now()";
 
   $Schema["TABLE"]["bucket_ars"]["ars_endtime"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["ars_endtime"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"ars_endtime\" timestamptz";
   $Schema["TABLE"]["bucket_ars"]["ars_endtime"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"ars_endtime\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_ars"]["nomosagent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["nomosagent_fk"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"nomosagent_fk\" int4";
   $Schema["TABLE"]["bucket_ars"]["nomosagent_fk"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"nomosagent_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_ars"]["bucketpool_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_ars"]["bucketpool_fk"]["ADD"] = "ALTER TABLE \"bucket_ars\" ADD COLUMN \"bucketpool_fk\" int4";
   $Schema["TABLE"]["bucket_ars"]["bucketpool_fk"]["ALTER"] = "ALTER TABLE \"bucket_ars\" ALTER COLUMN \"bucketpool_fk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["bucket_container"]["bucket_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_container"]["bucket_fk"]["ADD"] = "ALTER TABLE \"bucket_container\" ADD COLUMN \"bucket_fk\" int4";
   $Schema["TABLE"]["bucket_container"]["bucket_fk"]["ALTER"] = "ALTER TABLE \"bucket_container\" ALTER COLUMN \"bucket_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_container"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_container"]["agent_fk"]["ADD"] = "ALTER TABLE \"bucket_container\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["bucket_container"]["agent_fk"]["ALTER"] = "ALTER TABLE \"bucket_container\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_container"]["uploadtree_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_container"]["uploadtree_fk"]["ADD"] = "ALTER TABLE \"bucket_container\" ADD COLUMN \"uploadtree_fk\" int4";
   $Schema["TABLE"]["bucket_container"]["uploadtree_fk"]["ALTER"] = "ALTER TABLE \"bucket_container\" ALTER COLUMN \"uploadtree_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_container"]["bf_pk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_container"]["bf_pk"]["ADD"] = "ALTER TABLE \"bucket_container\" ADD COLUMN \"bf_pk\" int4 DEFAULT nextval('bucket_container_bf_pk_seq'::regclass)";
   $Schema["TABLE"]["bucket_container"]["bf_pk"]["ALTER"] = "ALTER TABLE \"bucket_container\" ALTER COLUMN \"bf_pk\" SET NOT NULL, ALTER COLUMN \"bf_pk\" SET DEFAULT nextval('bucket_container_bf_pk_seq'::regclass)";
 
   $Schema["TABLE"]["bucket_container"]["nomosagent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_container"]["nomosagent_fk"]["ADD"] = "ALTER TABLE \"bucket_container\" ADD COLUMN \"nomosagent_fk\" int4";
   $Schema["TABLE"]["bucket_container"]["nomosagent_fk"]["ALTER"] = "ALTER TABLE \"bucket_container\" ALTER COLUMN \"nomosagent_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["bucket_def"]["bucket_pk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_def"]["bucket_pk"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_pk\" int4 DEFAULT nextval('bucket_bucket_pk_seq'::regclass)";
   $Schema["TABLE"]["bucket_def"]["bucket_pk"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_pk\" SET NOT NULL, ALTER COLUMN \"bucket_pk\" SET DEFAULT nextval('bucket_bucket_pk_seq'::regclass)";
 
   $Schema["TABLE"]["bucket_def"]["bucket_name"]["DESC"] = "";
   $Schema["TABLE"]["bucket_def"]["bucket_name"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_name\" text";
   $Schema["TABLE"]["bucket_def"]["bucket_name"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_name\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_def"]["bucket_color"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_color\" IS 'color name or value.  eg \"red\" or \"#fe0922\", used to highlight reports, may also be ''url'''";
   $Schema["TABLE"]["bucket_def"]["bucket_color"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_color\" text DEFAULT 'yellow'::text";
   $Schema["TABLE"]["bucket_def"]["bucket_color"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_color\" SET NOT NULL, ALTER COLUMN \"bucket_color\" SET DEFAULT 'yellow'::text";
 
   $Schema["TABLE"]["bucket_def"]["bucket_reportorder"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_reportorder\" IS 'sort order (ascending) for reporting this bucket'";
   $Schema["TABLE"]["bucket_def"]["bucket_reportorder"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_reportorder\" int4 DEFAULT 50";
   $Schema["TABLE"]["bucket_def"]["bucket_reportorder"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_reportorder\" SET NOT NULL, ALTER COLUMN \"bucket_reportorder\" SET DEFAULT 50";
 
   $Schema["TABLE"]["bucket_def"]["bucket_evalorder"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_evalorder\" IS 'sort order (ascending) for evaluating this bucket relative to the others in the pool.'";
   $Schema["TABLE"]["bucket_def"]["bucket_evalorder"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_evalorder\" int4 DEFAULT 50";
   $Schema["TABLE"]["bucket_def"]["bucket_evalorder"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_evalorder\" SET NOT NULL, ALTER COLUMN \"bucket_evalorder\" SET DEFAULT 50";
 
   $Schema["TABLE"]["bucket_def"]["bucketpool_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_def"]["bucketpool_fk"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucketpool_fk\" int4";
   $Schema["TABLE"]["bucket_def"]["bucketpool_fk"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucketpool_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_def"]["bucket_type"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_type\" IS '1=MATCH_EVERY (aka STR-FILE) licenses in file line all match licenses in test file, 2=MATCH_ONLY (aka COMP-FILE) test file licenses are all contained in this file, 3=REGEX, 4=EXEC, 5=REGEX-FILE, 99=Not in any other bucket'";
   $Schema["TABLE"]["bucket_def"]["bucket_type"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_type\" int4";
   $Schema["TABLE"]["bucket_def"]["bucket_type"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_type\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_def"]["bucket_regex"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_regex\" IS 'if type=3, this is the regex, else null'";
   $Schema["TABLE"]["bucket_def"]["bucket_regex"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_regex\" text";
   $Schema["TABLE"]["bucket_def"]["bucket_regex"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_regex\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_def"]["bucket_filename"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"bucket_filename\" IS 'if type =1, 2, 4,5: this is the name of the file in /usr/local/share/fossology/{bucketpool name}'";
   $Schema["TABLE"]["bucket_def"]["bucket_filename"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"bucket_filename\" text";
   $Schema["TABLE"]["bucket_def"]["bucket_filename"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"bucket_filename\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_def"]["stopon"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"stopon\" IS 'if ''N'' continue evaluating buckets even if this one matches.  If ''Y'' stop bucket processing loop if this matches'";
   $Schema["TABLE"]["bucket_def"]["stopon"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"stopon\" char(1) DEFAULT 'N'::character(1)";
   $Schema["TABLE"]["bucket_def"]["stopon"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"stopon\" SET NOT NULL, ALTER COLUMN \"stopon\" SET DEFAULT 'N'::character(1)";
 
   $Schema["TABLE"]["bucket_def"]["applies_to"]["DESC"] = "COMMENT ON COLUMN \"bucket_def\".\"applies_to\" IS 'Bucket only applies to: ''1''=every file, ''2''=package'";
   $Schema["TABLE"]["bucket_def"]["applies_to"]["ADD"] = "ALTER TABLE \"bucket_def\" ADD COLUMN \"applies_to\" char(1) DEFAULT 1";
   $Schema["TABLE"]["bucket_def"]["applies_to"]["ALTER"] = "ALTER TABLE \"bucket_def\" ALTER COLUMN \"applies_to\" SET NOT NULL, ALTER COLUMN \"applies_to\" SET DEFAULT 1";
 
 
   $Schema["TABLE"]["bucket_file"]["bf_pk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_file"]["bf_pk"]["ADD"] = "ALTER TABLE \"bucket_file\" ADD COLUMN \"bf_pk\" int4 DEFAULT nextval('bucket_file_bf_pk_seq'::regclass)";
   $Schema["TABLE"]["bucket_file"]["bf_pk"]["ALTER"] = "ALTER TABLE \"bucket_file\" ALTER COLUMN \"bf_pk\" SET NOT NULL, ALTER COLUMN \"bf_pk\" SET DEFAULT nextval('bucket_file_bf_pk_seq'::regclass)";
 
   $Schema["TABLE"]["bucket_file"]["bucket_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_file"]["bucket_fk"]["ADD"] = "ALTER TABLE \"bucket_file\" ADD COLUMN \"bucket_fk\" int4";
   $Schema["TABLE"]["bucket_file"]["bucket_fk"]["ALTER"] = "ALTER TABLE \"bucket_file\" ALTER COLUMN \"bucket_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_file"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_file"]["pfile_fk"]["ADD"] = "ALTER TABLE \"bucket_file\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["bucket_file"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"bucket_file\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["bucket_file"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_file"]["agent_fk"]["ADD"] = "ALTER TABLE \"bucket_file\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["bucket_file"]["agent_fk"]["ALTER"] = "ALTER TABLE \"bucket_file\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["bucket_file"]["nomosagent_fk"]["DESC"] = "";
   $Schema["TABLE"]["bucket_file"]["nomosagent_fk"]["ADD"] = "ALTER TABLE \"bucket_file\" ADD COLUMN \"nomosagent_fk\" int4";
   $Schema["TABLE"]["bucket_file"]["nomosagent_fk"]["ALTER"] = "ALTER TABLE \"bucket_file\" ALTER COLUMN \"nomosagent_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["bucketpool"]["bucketpool_pk"]["DESC"] = "";
   $Schema["TABLE"]["bucketpool"]["bucketpool_pk"]["ADD"] = "ALTER TABLE \"bucketpool\" ADD COLUMN \"bucketpool_pk\" int4 DEFAULT nextval('bucketpool_bucketpool_pk_seq'::regclass)";
   $Schema["TABLE"]["bucketpool"]["bucketpool_pk"]["ALTER"] = "ALTER TABLE \"bucketpool\" ALTER COLUMN \"bucketpool_pk\" SET NOT NULL, ALTER COLUMN \"bucketpool_pk\" SET DEFAULT nextval('bucketpool_bucketpool_pk_seq'::regclass)";
 
   $Schema["TABLE"]["bucketpool"]["bucketpool_name"]["DESC"] = "COMMENT ON COLUMN \"bucketpool\".\"bucketpool_name\" IS 'Descriptive name'";
   $Schema["TABLE"]["bucketpool"]["bucketpool_name"]["ADD"] = "ALTER TABLE \"bucketpool\" ADD COLUMN \"bucketpool_name\" text";
   $Schema["TABLE"]["bucketpool"]["bucketpool_name"]["ALTER"] = "ALTER TABLE \"bucketpool\" ALTER COLUMN \"bucketpool_name\" SET NOT NULL";
 
   $Schema["TABLE"]["bucketpool"]["version"]["DESC"] = "COMMENT ON COLUMN \"bucketpool\".\"version\" IS '1, 2, 3, ...'";
   $Schema["TABLE"]["bucketpool"]["version"]["ADD"] = "ALTER TABLE \"bucketpool\" ADD COLUMN \"version\" int4 DEFAULT 1";
   $Schema["TABLE"]["bucketpool"]["version"]["ALTER"] = "ALTER TABLE \"bucketpool\" ALTER COLUMN \"version\" SET NOT NULL, ALTER COLUMN \"version\" SET DEFAULT 1";
 
   $Schema["TABLE"]["bucketpool"]["active"]["DESC"] = "COMMENT ON COLUMN \"bucketpool\".\"active\" IS 'N=inactive, Y=active'";
   $Schema["TABLE"]["bucketpool"]["active"]["ADD"] = "ALTER TABLE \"bucketpool\" ADD COLUMN \"active\" char(1) DEFAULT 'Y'::character(1)";
   $Schema["TABLE"]["bucketpool"]["active"]["ALTER"] = "ALTER TABLE \"bucketpool\" ALTER COLUMN \"active\" SET NOT NULL, ALTER COLUMN \"active\" SET DEFAULT 'Y'::character(1)";
 
   $Schema["TABLE"]["bucketpool"]["description"]["DESC"] = "COMMENT ON COLUMN \"bucketpool\".\"description\" IS 'Optional bucketpool description'";
   $Schema["TABLE"]["bucketpool"]["description"]["ADD"] = "ALTER TABLE \"bucketpool\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["bucketpool"]["description"]["ALTER"] = "ALTER TABLE \"bucketpool\" ALTER COLUMN \"description\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["clearing_decision"]["clearing_decision_pk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["clearing_decision_pk"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"clearing_decision_pk\" int4 DEFAULT nextval('clearing_decision_clearing_decision_pk_seq'::regclass)";
   $Schema["TABLE"]["clearing_decision"]["clearing_decision_pk"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"clearing_decision_pk\" SET NOT NULL, ALTER COLUMN \"clearing_decision_pk\" SET DEFAULT nextval('clearing_decision_clearing_decision_pk_seq'::regclass)";
 
   $Schema["TABLE"]["clearing_decision"]["uploadtree_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["uploadtree_fk"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"uploadtree_fk\" int4";
   $Schema["TABLE"]["clearing_decision"]["uploadtree_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"uploadtree_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_decision"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["pfile_fk"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["clearing_decision"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_decision"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["user_fk"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["clearing_decision"]["user_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_decision"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["group_fk"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["clearing_decision"]["group_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"group_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["clearing_decision"]["date_added"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision"]["date_added"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"date_added\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["clearing_decision"]["date_added"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"date_added\" SET NOT NULL, ALTER COLUMN \"date_added\" SET DEFAULT now()";
 
   $Schema["TABLE"]["clearing_decision"]["decision_type"]["DESC"] = "COMMENT ON COLUMN \"clearing_decision\".\"decision_type\" IS 'see Fossology/Lib/Data/DecisionTypes'";
   $Schema["TABLE"]["clearing_decision"]["decision_type"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"decision_type\" int4 DEFAULT 0";
   $Schema["TABLE"]["clearing_decision"]["decision_type"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"decision_type\" SET NOT NULL, ALTER COLUMN \"decision_type\" SET DEFAULT 0";
 
   $Schema["TABLE"]["clearing_decision"]["scope"]["DESC"] = "COMMENT ON COLUMN \"clearing_decision\".\"scope\" IS 'see Fossology/Lib/Data/DecisonScopes'";
   $Schema["TABLE"]["clearing_decision"]["scope"]["ADD"] = "ALTER TABLE \"clearing_decision\" ADD COLUMN \"scope\" int4 DEFAULT 1";
   $Schema["TABLE"]["clearing_decision"]["scope"]["ALTER"] = "ALTER TABLE \"clearing_decision\" ALTER COLUMN \"scope\" SET NOT NULL, ALTER COLUMN \"scope\" SET DEFAULT 1";
 
 
   $Schema["TABLE"]["clearing_decision_event"]["clearing_event_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision_event"]["clearing_event_fk"]["ADD"] = "ALTER TABLE \"clearing_decision_event\" ADD COLUMN \"clearing_event_fk\" int4";
   $Schema["TABLE"]["clearing_decision_event"]["clearing_event_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision_event\" ALTER COLUMN \"clearing_event_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_decision_event"]["clearing_decision_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_decision_event"]["clearing_decision_fk"]["ADD"] = "ALTER TABLE \"clearing_decision_event\" ADD COLUMN \"clearing_decision_fk\" int4";
   $Schema["TABLE"]["clearing_decision_event"]["clearing_decision_fk"]["ALTER"] = "ALTER TABLE \"clearing_decision_event\" ALTER COLUMN \"clearing_decision_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["clearing_event"]["clearing_event_pk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["clearing_event_pk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"clearing_event_pk\" int4 DEFAULT nextval('clearing_event_clearing_event_pk_seq'::regclass)";
   $Schema["TABLE"]["clearing_event"]["clearing_event_pk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"clearing_event_pk\" SET NOT NULL, ALTER COLUMN \"clearing_event_pk\" SET DEFAULT nextval('clearing_event_clearing_event_pk_seq'::regclass)";
 
   $Schema["TABLE"]["clearing_event"]["uploadtree_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["uploadtree_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"uploadtree_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["uploadtree_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"uploadtree_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["rf_fk"]["DESC"] = "COMMENT ON COLUMN \"clearing_event\".\"rf_fk\" IS 'refer to license_ref* (not only license_ref)'";
   $Schema["TABLE"]["clearing_event"]["rf_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"rf_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["rf_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"rf_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["removed"]["DESC"] = "COMMENT ON COLUMN \"clearing_event\".\"removed\" IS 'true: add license, false: remove license, null: only change comment'";
   $Schema["TABLE"]["clearing_event"]["removed"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"removed\" bool";
   $Schema["TABLE"]["clearing_event"]["removed"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"removed\" DROP NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["user_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["user_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["group_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["group_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["job_fk"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["job_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"job_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["job_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"job_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["type_fk"]["DESC"] = "COMMENT ON COLUMN \"clearing_event\".\"type_fk\" IS 'see Fossology/Lib/Data/LicenseEvent/ClearingEventTypes'";
   $Schema["TABLE"]["clearing_event"]["type_fk"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"type_fk\" int4";
   $Schema["TABLE"]["clearing_event"]["type_fk"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"type_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["comment"]["DESC"] = "COMMENT ON COLUMN \"clearing_event\".\"comment\" IS 'User comment'";
   $Schema["TABLE"]["clearing_event"]["comment"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"comment\" text";
   $Schema["TABLE"]["clearing_event"]["comment"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"comment\" DROP NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["reportinfo"]["DESC"] = "COMMENT ON COLUMN \"clearing_event\".\"reportinfo\" IS 'public comment'";
   $Schema["TABLE"]["clearing_event"]["reportinfo"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"reportinfo\" text";
   $Schema["TABLE"]["clearing_event"]["reportinfo"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"reportinfo\" DROP NOT NULL";
 
   $Schema["TABLE"]["clearing_event"]["date_added"]["DESC"] = "";
   $Schema["TABLE"]["clearing_event"]["date_added"]["ADD"] = "ALTER TABLE \"clearing_event\" ADD COLUMN \"date_added\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["clearing_event"]["date_added"]["ALTER"] = "ALTER TABLE \"clearing_event\" ALTER COLUMN \"date_added\" SET NOT NULL, ALTER COLUMN \"date_added\" SET DEFAULT now()";
 
 
   $Schema["TABLE"]["copyright"]["ct_pk"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["ct_pk"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"ct_pk\" int8 DEFAULT nextval('copyright_ct_pk_seq'::regclass)";
   $Schema["TABLE"]["copyright"]["ct_pk"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"ct_pk\" SET NOT NULL, ALTER COLUMN \"ct_pk\" SET DEFAULT nextval('copyright_ct_pk_seq'::regclass)";
 
   $Schema["TABLE"]["copyright"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["agent_fk"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"agent_fk\" int8";
   $Schema["TABLE"]["copyright"]["agent_fk"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["copyright"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["pfile_fk"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"pfile_fk\" int8";
   $Schema["TABLE"]["copyright"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["copyright"]["content"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["content"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"content\" text";
   $Schema["TABLE"]["copyright"]["content"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"content\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright"]["hash"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["hash"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"hash\" text";
   $Schema["TABLE"]["copyright"]["hash"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"hash\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright"]["type"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["type"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"type\" text";
   $Schema["TABLE"]["copyright"]["type"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"type\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright"]["copy_startbyte"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["copy_startbyte"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"copy_startbyte\" int4";
   $Schema["TABLE"]["copyright"]["copy_startbyte"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"copy_startbyte\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright"]["copy_endbyte"]["DESC"] = "";
   $Schema["TABLE"]["copyright"]["copy_endbyte"]["ADD"] = "ALTER TABLE \"copyright\" ADD COLUMN \"copy_endbyte\" int4";
   $Schema["TABLE"]["copyright"]["copy_endbyte"]["ALTER"] = "ALTER TABLE \"copyright\" ALTER COLUMN \"copy_endbyte\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["copyright_audit"]["ct_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["ct_fk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"ct_fk\" int4";
   $Schema["TABLE"]["copyright_audit"]["ct_fk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"ct_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_audit"]["oldtext"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["oldtext"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"oldtext\" text";
   $Schema["TABLE"]["copyright_audit"]["oldtext"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"oldtext\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_audit"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["user_fk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["copyright_audit"]["user_fk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"user_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_audit"]["date"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["date"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"date\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["copyright_audit"]["date"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"date\" SET NOT NULL, ALTER COLUMN \"date\" SET DEFAULT now()";
 
   $Schema["TABLE"]["copyright_audit"]["ca_pk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["ca_pk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"ca_pk\" int4 DEFAULT nextval('copyright_audit_ca_pk_seq'::regclass)";
   $Schema["TABLE"]["copyright_audit"]["ca_pk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"ca_pk\" SET NOT NULL, ALTER COLUMN \"ca_pk\" SET DEFAULT nextval('copyright_audit_ca_pk_seq'::regclass)";
 
   $Schema["TABLE"]["copyright_audit"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["upload_fk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["copyright_audit"]["upload_fk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"upload_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_audit"]["uploadtree_pk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["uploadtree_pk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"uploadtree_pk\" int4";
   $Schema["TABLE"]["copyright_audit"]["uploadtree_pk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"uploadtree_pk\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_audit"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_audit"]["pfile_fk"]["ADD"] = "ALTER TABLE \"copyright_audit\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["copyright_audit"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"copyright_audit\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["copyright_decision"]["copyright_decision_pk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["copyright_decision_pk"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"copyright_decision_pk\" int8 DEFAULT nextval('copyright_decision_pk_seq'::regclass)";
   $Schema["TABLE"]["copyright_decision"]["copyright_decision_pk"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"copyright_decision_pk\" SET NOT NULL, ALTER COLUMN \"copyright_decision_pk\" SET DEFAULT nextval('copyright_decision_pk_seq'::regclass)";
 
   $Schema["TABLE"]["copyright_decision"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["user_fk"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"user_fk\" int8";
   $Schema["TABLE"]["copyright_decision"]["user_fk"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["copyright_decision"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["pfile_fk"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"pfile_fk\" int8";
   $Schema["TABLE"]["copyright_decision"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["copyright_decision"]["clearing_decision_type_fk"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["clearing_decision_type_fk"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"clearing_decision_type_fk\" int8";
   $Schema["TABLE"]["copyright_decision"]["clearing_decision_type_fk"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"clearing_decision_type_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["copyright_decision"]["description"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["description"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["copyright_decision"]["description"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"description\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_decision"]["textfinding"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["textfinding"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"textfinding\" text";
   $Schema["TABLE"]["copyright_decision"]["textfinding"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"textfinding\" DROP NOT NULL";
 
   $Schema["TABLE"]["copyright_decision"]["comment"]["DESC"] = "";
   $Schema["TABLE"]["copyright_decision"]["comment"]["ADD"] = "ALTER TABLE \"copyright_decision\" ADD COLUMN \"comment\" text";
   $Schema["TABLE"]["copyright_decision"]["comment"]["ALTER"] = "ALTER TABLE \"copyright_decision\" ALTER COLUMN \"comment\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["ecc"]["ct_pk"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["ct_pk"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"ct_pk\" int8 DEFAULT nextval('ecc_ct_pk_seq'::regclass)";
   $Schema["TABLE"]["ecc"]["ct_pk"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"ct_pk\" SET NOT NULL, ALTER COLUMN \"ct_pk\" SET DEFAULT nextval('ecc_ct_pk_seq'::regclass)";
 
   $Schema["TABLE"]["ecc"]["agent_fk"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["agent_fk"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"agent_fk\" int8";
   $Schema["TABLE"]["ecc"]["agent_fk"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ecc"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["pfile_fk"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"pfile_fk\" int8";
   $Schema["TABLE"]["ecc"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ecc"]["content"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["content"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"content\" text";
   $Schema["TABLE"]["ecc"]["content"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"content\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc"]["hash"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["hash"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"hash\" text";
   $Schema["TABLE"]["ecc"]["hash"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"hash\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc"]["type"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["type"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"type\" text";
   $Schema["TABLE"]["ecc"]["type"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"type\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc"]["copy_startbyte"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["copy_startbyte"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"copy_startbyte\" int4";
   $Schema["TABLE"]["ecc"]["copy_startbyte"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"copy_startbyte\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc"]["copy_endbyte"]["DESC"] = "";
   $Schema["TABLE"]["ecc"]["copy_endbyte"]["ADD"] = "ALTER TABLE \"ecc\" ADD COLUMN \"copy_endbyte\" int4";
   $Schema["TABLE"]["ecc"]["copy_endbyte"]["ALTER"] = "ALTER TABLE \"ecc\" ALTER COLUMN \"copy_endbyte\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["ecc_decision"]["copyright_decision_pk"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["copyright_decision_pk"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"copyright_decision_pk\" int8 DEFAULT nextval('ecc_decision_pk_seq'::regclass)";
   $Schema["TABLE"]["ecc_decision"]["copyright_decision_pk"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"copyright_decision_pk\" SET NOT NULL, ALTER COLUMN \"copyright_decision_pk\" SET DEFAULT nextval('ecc_decision_pk_seq'::regclass)";
 
   $Schema["TABLE"]["ecc_decision"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["user_fk"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"user_fk\" int8";
   $Schema["TABLE"]["ecc_decision"]["user_fk"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ecc_decision"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["pfile_fk"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"pfile_fk\" int8";
   $Schema["TABLE"]["ecc_decision"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ecc_decision"]["clearing_decision_type_fk"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["clearing_decision_type_fk"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"clearing_decision_type_fk\" int8";
   $Schema["TABLE"]["ecc_decision"]["clearing_decision_type_fk"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"clearing_decision_type_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["ecc_decision"]["description"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["description"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["ecc_decision"]["description"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"description\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc_decision"]["textfinding"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["textfinding"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"textfinding\" text";
   $Schema["TABLE"]["ecc_decision"]["textfinding"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"textfinding\" DROP NOT NULL";
 
   $Schema["TABLE"]["ecc_decision"]["comment"]["DESC"] = "";
   $Schema["TABLE"]["ecc_decision"]["comment"]["ADD"] = "ALTER TABLE \"ecc_decision\" ADD COLUMN \"comment\" text";
   $Schema["TABLE"]["ecc_decision"]["comment"]["ALTER"] = "ALTER TABLE \"ecc_decision\" ALTER COLUMN \"comment\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["file_picker"]["file_picker_pk"]["DESC"] = "";
   $Schema["TABLE"]["file_picker"]["file_picker_pk"]["ADD"] = "ALTER TABLE \"file_picker\" ADD COLUMN \"file_picker_pk\" int4 DEFAULT nextval('file_picker_file_picker_pk_seq'::regclass)";
   $Schema["TABLE"]["file_picker"]["file_picker_pk"]["ALTER"] = "ALTER TABLE \"file_picker\" ALTER COLUMN \"file_picker_pk\" SET NOT NULL, ALTER COLUMN \"file_picker_pk\" SET DEFAULT nextval('file_picker_file_picker_pk_seq'::regclass)";
 
   $Schema["TABLE"]["file_picker"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["file_picker"]["user_fk"]["ADD"] = "ALTER TABLE \"file_picker\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["file_picker"]["user_fk"]["ALTER"] = "ALTER TABLE \"file_picker\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["file_picker"]["uploadtree_fk1"]["DESC"] = "";
   $Schema["TABLE"]["file_picker"]["uploadtree_fk1"]["ADD"] = "ALTER TABLE \"file_picker\" ADD COLUMN \"uploadtree_fk1\" int4";
   $Schema["TABLE"]["file_picker"]["uploadtree_fk1"]["ALTER"] = "ALTER TABLE \"file_picker\" ALTER COLUMN \"uploadtree_fk1\" SET NOT NULL";
 
   $Schema["TABLE"]["file_picker"]["uploadtree_fk2"]["DESC"] = "";
   $Schema["TABLE"]["file_picker"]["uploadtree_fk2"]["ADD"] = "ALTER TABLE \"file_picker\" ADD COLUMN \"uploadtree_fk2\" int4";
   $Schema["TABLE"]["file_picker"]["uploadtree_fk2"]["ALTER"] = "ALTER TABLE \"file_picker\" ALTER COLUMN \"uploadtree_fk2\" SET NOT NULL";
 
   $Schema["TABLE"]["file_picker"]["last_access_date"]["DESC"] = "";
   $Schema["TABLE"]["file_picker"]["last_access_date"]["ADD"] = "ALTER TABLE \"file_picker\" ADD COLUMN \"last_access_date\" date";
   $Schema["TABLE"]["file_picker"]["last_access_date"]["ALTER"] = "ALTER TABLE \"file_picker\" ALTER COLUMN \"last_access_date\" SET NOT NULL";
 
 
   $Schema["TABLE"]["folder"]["folder_pk"]["DESC"] = "";
   $Schema["TABLE"]["folder"]["folder_pk"]["ADD"] = "ALTER TABLE \"folder\" ADD COLUMN \"folder_pk\" int4 DEFAULT nextval('folder_folder_pk_seq'::regclass)";
   $Schema["TABLE"]["folder"]["folder_pk"]["ALTER"] = "ALTER TABLE \"folder\" ALTER COLUMN \"folder_pk\" SET NOT NULL, ALTER COLUMN \"folder_pk\" SET DEFAULT nextval('folder_folder_pk_seq'::regclass)";
 
   $Schema["TABLE"]["folder"]["folder_name"]["DESC"] = "";
   $Schema["TABLE"]["folder"]["folder_name"]["ADD"] = "ALTER TABLE \"folder\" ADD COLUMN \"folder_name\" text";
   $Schema["TABLE"]["folder"]["folder_name"]["ALTER"] = "ALTER TABLE \"folder\" ALTER COLUMN \"folder_name\" SET NOT NULL";
 
+  $Schema["TABLE"]["folder"]["user_fk"]["DESC"] = "";
+  $Schema["TABLE"]["folder"]["user_fk"]["ADD"] = "ALTER TABLE \"folder\" ADD COLUMN \"user_fk\" int4";
+  $Schema["TABLE"]["folder"]["user_fk"]["ALTER"] = "ALTER TABLE \"folder\" ALTER COLUMN \"user_fk\" DROP NOT NULL";
+
   $Schema["TABLE"]["folder"]["folder_desc"]["DESC"] = "";
   $Schema["TABLE"]["folder"]["folder_desc"]["ADD"] = "ALTER TABLE \"folder\" ADD COLUMN \"folder_desc\" text";
   $Schema["TABLE"]["folder"]["folder_desc"]["ALTER"] = "ALTER TABLE \"folder\" ALTER COLUMN \"folder_desc\" DROP NOT NULL";
 
   $Schema["TABLE"]["folder"]["folder_perm"]["DESC"] = "COMMENT ON COLUMN \"folder\".\"folder_perm\" IS 'future permission'";
   $Schema["TABLE"]["folder"]["folder_perm"]["ADD"] = "ALTER TABLE \"folder\" ADD COLUMN \"folder_perm\" int4";
   $Schema["TABLE"]["folder"]["folder_perm"]["ALTER"] = "ALTER TABLE \"folder\" ALTER COLUMN \"folder_perm\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["foldercontents"]["foldercontents_pk"]["DESC"] = "";
   $Schema["TABLE"]["foldercontents"]["foldercontents_pk"]["ADD"] = "ALTER TABLE \"foldercontents\" ADD COLUMN \"foldercontents_pk\" int4 DEFAULT nextval('foldercontents_foldercontents_pk_seq'::regclass)";
   $Schema["TABLE"]["foldercontents"]["foldercontents_pk"]["ALTER"] = "ALTER TABLE \"foldercontents\" ALTER COLUMN \"foldercontents_pk\" SET NOT NULL, ALTER COLUMN \"foldercontents_pk\" SET DEFAULT nextval('foldercontents_foldercontents_pk_seq'::regclass)";
 
   $Schema["TABLE"]["foldercontents"]["parent_fk"]["DESC"] = "COMMENT ON COLUMN \"foldercontents\".\"parent_fk\" IS 'parent folder_fk'";
   $Schema["TABLE"]["foldercontents"]["parent_fk"]["ADD"] = "ALTER TABLE \"foldercontents\" ADD COLUMN \"parent_fk\" int4";
   $Schema["TABLE"]["foldercontents"]["parent_fk"]["ALTER"] = "ALTER TABLE \"foldercontents\" ALTER COLUMN \"parent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["foldercontents"]["foldercontents_mode"]["DESC"] = "COMMENT ON COLUMN \"foldercontents\".\"foldercontents_mode\" IS '1<<0 child is folder_fk, 1<<1 child is upload_fk, 1<<2 child is an uploadtree_fk'";
   $Schema["TABLE"]["foldercontents"]["foldercontents_mode"]["ADD"] = "ALTER TABLE \"foldercontents\" ADD COLUMN \"foldercontents_mode\" int4";
   $Schema["TABLE"]["foldercontents"]["foldercontents_mode"]["ALTER"] = "ALTER TABLE \"foldercontents\" ALTER COLUMN \"foldercontents_mode\" SET NOT NULL";
 
   $Schema["TABLE"]["foldercontents"]["child_id"]["DESC"] = "";
   $Schema["TABLE"]["foldercontents"]["child_id"]["ADD"] = "ALTER TABLE \"foldercontents\" ADD COLUMN \"child_id\" int4";
   $Schema["TABLE"]["foldercontents"]["child_id"]["ALTER"] = "ALTER TABLE \"foldercontents\" ALTER COLUMN \"child_id\" SET NOT NULL";
 
 
   $Schema["TABLE"]["group_user_member"]["group_user_member_pk"]["DESC"] = "";
   $Schema["TABLE"]["group_user_member"]["group_user_member_pk"]["ADD"] = "ALTER TABLE \"group_user_member\" ADD COLUMN \"group_user_member_pk\" int4 DEFAULT nextval('group_user_member_group_user_member_pk_seq'::regclass)";
   $Schema["TABLE"]["group_user_member"]["group_user_member_pk"]["ALTER"] = "ALTER TABLE \"group_user_member\" ALTER COLUMN \"group_user_member_pk\" SET NOT NULL, ALTER COLUMN \"group_user_member_pk\" SET DEFAULT nextval('group_user_member_group_user_member_pk_seq'::regclass)";
 
   $Schema["TABLE"]["group_user_member"]["group_fk"]["DESC"] = "COMMENT ON COLUMN \"group_user_member\".\"group_fk\" IS 'Group user is a member of'";
   $Schema["TABLE"]["group_user_member"]["group_fk"]["ADD"] = "ALTER TABLE \"group_user_member\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["group_user_member"]["group_fk"]["ALTER"] = "ALTER TABLE \"group_user_member\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["group_user_member"]["user_fk"]["DESC"] = "COMMENT ON COLUMN \"group_user_member\".\"user_fk\" IS 'User foreign key'";
   $Schema["TABLE"]["group_user_member"]["user_fk"]["ADD"] = "ALTER TABLE \"group_user_member\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["group_user_member"]["user_fk"]["ALTER"] = "ALTER TABLE \"group_user_member\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["group_user_member"]["group_perm"]["DESC"] = "COMMENT ON COLUMN \"group_user_member\".\"group_perm\" IS 'Permission: 0=user, 1=admin.  Only Admins can add/remove/assign permissions to users.'";
   $Schema["TABLE"]["group_user_member"]["group_perm"]["ADD"] = "ALTER TABLE \"group_user_member\" ADD COLUMN \"group_perm\" int4";
   $Schema["TABLE"]["group_user_member"]["group_perm"]["ALTER"] = "ALTER TABLE \"group_user_member\" ALTER COLUMN \"group_perm\" SET NOT NULL";
 
 
   $Schema["TABLE"]["groups"]["group_pk"]["DESC"] = "";
   $Schema["TABLE"]["groups"]["group_pk"]["ADD"] = "ALTER TABLE \"groups\" ADD COLUMN \"group_pk\" int4 DEFAULT nextval('group_group_pk_seq'::regclass)";
   $Schema["TABLE"]["groups"]["group_pk"]["ALTER"] = "ALTER TABLE \"groups\" ALTER COLUMN \"group_pk\" SET NOT NULL, ALTER COLUMN \"group_pk\" SET DEFAULT nextval('group_group_pk_seq'::regclass)";
 
   $Schema["TABLE"]["groups"]["group_name"]["DESC"] = "";
   $Schema["TABLE"]["groups"]["group_name"]["ADD"] = "ALTER TABLE \"groups\" ADD COLUMN \"group_name\" varchar(64)";
   $Schema["TABLE"]["groups"]["group_name"]["ALTER"] = "ALTER TABLE \"groups\" ALTER COLUMN \"group_name\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["highlight"]["type"]["DESC"] = "COMMENT ON COLUMN \"highlight\".\"type\" IS 'Monk: full match ''M'', Diff ''M0'', DiffAdd ''M+'', DiffRemove ''M-'', DiffReplace ''MR''; Nomos License ''L'''";
   $Schema["TABLE"]["highlight"]["type"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"type\" char(2)";
   $Schema["TABLE"]["highlight"]["type"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"type\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight"]["start"]["DESC"] = "";
   $Schema["TABLE"]["highlight"]["start"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"start\" int8";
   $Schema["TABLE"]["highlight"]["start"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"start\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight"]["len"]["DESC"] = "";
   $Schema["TABLE"]["highlight"]["len"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"len\" int8";
   $Schema["TABLE"]["highlight"]["len"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"len\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight"]["fl_fk"]["DESC"] = "";
   $Schema["TABLE"]["highlight"]["fl_fk"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"fl_fk\" int8";
   $Schema["TABLE"]["highlight"]["fl_fk"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"fl_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight"]["rf_start"]["DESC"] = "";
   $Schema["TABLE"]["highlight"]["rf_start"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"rf_start\" int8";
   $Schema["TABLE"]["highlight"]["rf_start"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"rf_start\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight"]["rf_len"]["DESC"] = "";
   $Schema["TABLE"]["highlight"]["rf_len"]["ADD"] = "ALTER TABLE \"highlight\" ADD COLUMN \"rf_len\" int8";
   $Schema["TABLE"]["highlight"]["rf_len"]["ALTER"] = "ALTER TABLE \"highlight\" ALTER COLUMN \"rf_len\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["highlight_bulk"]["clearing_event_fk"]["DESC"] = "";
   $Schema["TABLE"]["highlight_bulk"]["clearing_event_fk"]["ADD"] = "ALTER TABLE \"highlight_bulk\" ADD COLUMN \"clearing_event_fk\" int8";
   $Schema["TABLE"]["highlight_bulk"]["clearing_event_fk"]["ALTER"] = "ALTER TABLE \"highlight_bulk\" ALTER COLUMN \"clearing_event_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight_bulk"]["lrb_fk"]["DESC"] = "";
   $Schema["TABLE"]["highlight_bulk"]["lrb_fk"]["ADD"] = "ALTER TABLE \"highlight_bulk\" ADD COLUMN \"lrb_fk\" int8";
   $Schema["TABLE"]["highlight_bulk"]["lrb_fk"]["ALTER"] = "ALTER TABLE \"highlight_bulk\" ALTER COLUMN \"lrb_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight_bulk"]["start"]["DESC"] = "";
   $Schema["TABLE"]["highlight_bulk"]["start"]["ADD"] = "ALTER TABLE \"highlight_bulk\" ADD COLUMN \"start\" int8";
   $Schema["TABLE"]["highlight_bulk"]["start"]["ALTER"] = "ALTER TABLE \"highlight_bulk\" ALTER COLUMN \"start\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight_bulk"]["len"]["DESC"] = "";
   $Schema["TABLE"]["highlight_bulk"]["len"]["ADD"] = "ALTER TABLE \"highlight_bulk\" ADD COLUMN \"len\" int8";
   $Schema["TABLE"]["highlight_bulk"]["len"]["ALTER"] = "ALTER TABLE \"highlight_bulk\" ALTER COLUMN \"len\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["highlight_keyword"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["highlight_keyword"]["pfile_fk"]["ADD"] = "ALTER TABLE \"highlight_keyword\" ADD COLUMN \"pfile_fk\" int8";
   $Schema["TABLE"]["highlight_keyword"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"highlight_keyword\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight_keyword"]["start"]["DESC"] = "";
   $Schema["TABLE"]["highlight_keyword"]["start"]["ADD"] = "ALTER TABLE \"highlight_keyword\" ADD COLUMN \"start\" int8";
   $Schema["TABLE"]["highlight_keyword"]["start"]["ALTER"] = "ALTER TABLE \"highlight_keyword\" ALTER COLUMN \"start\" DROP NOT NULL";
 
   $Schema["TABLE"]["highlight_keyword"]["len"]["DESC"] = "";
   $Schema["TABLE"]["highlight_keyword"]["len"]["ADD"] = "ALTER TABLE \"highlight_keyword\" ADD COLUMN \"len\" int8";
   $Schema["TABLE"]["highlight_keyword"]["len"]["ALTER"] = "ALTER TABLE \"highlight_keyword\" ALTER COLUMN \"len\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["job"]["job_pk"]["DESC"] = "";
   $Schema["TABLE"]["job"]["job_pk"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_pk\" int4 DEFAULT nextval('job_job_pk_seq'::regclass)";
   $Schema["TABLE"]["job"]["job_pk"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_pk\" SET NOT NULL, ALTER COLUMN \"job_pk\" SET DEFAULT nextval('job_job_pk_seq'::regclass)";
 
   $Schema["TABLE"]["job"]["job_queued"]["DESC"] = "";
   $Schema["TABLE"]["job"]["job_queued"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_queued\" timestamptz";
   $Schema["TABLE"]["job"]["job_queued"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_queued\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_priority"]["DESC"] = "";
   $Schema["TABLE"]["job"]["job_priority"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_priority\" int4 DEFAULT 0";
   $Schema["TABLE"]["job"]["job_priority"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_priority\" SET NOT NULL, ALTER COLUMN \"job_priority\" SET DEFAULT 0";
 
   $Schema["TABLE"]["job"]["job_email_notify"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_email_notify\" IS 'list of emails to notify on completion (format?)'";
   $Schema["TABLE"]["job"]["job_email_notify"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_email_notify\" text";
   $Schema["TABLE"]["job"]["job_email_notify"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_email_notify\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_name"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_name\" IS 'what to call this job, for the user'";
   $Schema["TABLE"]["job"]["job_name"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_name\" text";
   $Schema["TABLE"]["job"]["job_name"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_name\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_upload_fk"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_upload_fk\" IS 'upload this job applies to'";
   $Schema["TABLE"]["job"]["job_upload_fk"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_upload_fk\" int4";
   $Schema["TABLE"]["job"]["job_upload_fk"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_upload_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_folder_fk"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_folder_fk\" IS 'folder this job applies to'";
   $Schema["TABLE"]["job"]["job_folder_fk"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_folder_fk\" int4";
   $Schema["TABLE"]["job"]["job_folder_fk"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_folder_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_user_fk"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_user_fk\" IS 'Job submitted by this user'";
   $Schema["TABLE"]["job"]["job_user_fk"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_user_fk\" int4";
   $Schema["TABLE"]["job"]["job_user_fk"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_user_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["job"]["job_group_fk"]["DESC"] = "COMMENT ON COLUMN \"job\".\"job_group_fk\" IS 'Job submitted by this group'";
   $Schema["TABLE"]["job"]["job_group_fk"]["ADD"] = "ALTER TABLE \"job\" ADD COLUMN \"job_group_fk\" int4";
   $Schema["TABLE"]["job"]["job_group_fk"]["ALTER"] = "ALTER TABLE \"job\" ALTER COLUMN \"job_group_fk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["jobdepends"]["jdep_jq_fk"]["DESC"] = "COMMENT ON COLUMN \"jobdepends\".\"jdep_jq_fk\" IS 'jdep_jq_fk depends on jdep_jq_depends_fk'";
   $Schema["TABLE"]["jobdepends"]["jdep_jq_fk"]["ADD"] = "ALTER TABLE \"jobdepends\" ADD COLUMN \"jdep_jq_fk\" int4";
   $Schema["TABLE"]["jobdepends"]["jdep_jq_fk"]["ALTER"] = "ALTER TABLE \"jobdepends\" ALTER COLUMN \"jdep_jq_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobdepends"]["jdep_jq_depends_fk"]["DESC"] = "";
   $Schema["TABLE"]["jobdepends"]["jdep_jq_depends_fk"]["ADD"] = "ALTER TABLE \"jobdepends\" ADD COLUMN \"jdep_jq_depends_fk\" int4";
   $Schema["TABLE"]["jobdepends"]["jdep_jq_depends_fk"]["ALTER"] = "ALTER TABLE \"jobdepends\" ALTER COLUMN \"jdep_jq_depends_fk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["jobqueue"]["jq_pk"]["DESC"] = "";
   $Schema["TABLE"]["jobqueue"]["jq_pk"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_pk\" int4 DEFAULT nextval('jobqueue_jq_pk_seq'::regclass)";
   $Schema["TABLE"]["jobqueue"]["jq_pk"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_pk\" SET NOT NULL, ALTER COLUMN \"jq_pk\" SET DEFAULT nextval('jobqueue_jq_pk_seq'::regclass)";
 
   $Schema["TABLE"]["jobqueue"]["jq_job_fk"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_job_fk\" IS 'which user job this step supports'";
   $Schema["TABLE"]["jobqueue"]["jq_job_fk"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_job_fk\" int4";
   $Schema["TABLE"]["jobqueue"]["jq_job_fk"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_job_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_type"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_type\" IS 'agent.agent_name'";
   $Schema["TABLE"]["jobqueue"]["jq_type"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_type\" text";
   $Schema["TABLE"]["jobqueue"]["jq_type"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_type\" SET NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_args"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_args\" IS 'arbitrary text understood by the agent'";
   $Schema["TABLE"]["jobqueue"]["jq_args"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_args\" text";
   $Schema["TABLE"]["jobqueue"]["jq_args"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_args\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_starttime"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_starttime\" IS 'set this field to indicate job is in progress'";
   $Schema["TABLE"]["jobqueue"]["jq_starttime"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_starttime\" timestamptz";
   $Schema["TABLE"]["jobqueue"]["jq_starttime"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_starttime\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_endtime"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_endtime\" IS 'set this when job completed for whatever reason'";
   $Schema["TABLE"]["jobqueue"]["jq_endtime"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_endtime\" timestamptz";
   $Schema["TABLE"]["jobqueue"]["jq_endtime"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_endtime\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_endtext"]["DESC"] = "";
   $Schema["TABLE"]["jobqueue"]["jq_endtext"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_endtext\" text";
   $Schema["TABLE"]["jobqueue"]["jq_endtext"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_endtext\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_end_bits"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_end_bits\" IS 'bitmask(ok=0x1, fail=0x2, nonfatal=0x4)'";
   $Schema["TABLE"]["jobqueue"]["jq_end_bits"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_end_bits\" int2 DEFAULT 0";
   $Schema["TABLE"]["jobqueue"]["jq_end_bits"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_end_bits\" SET NOT NULL, ALTER COLUMN \"jq_end_bits\" SET DEFAULT 0";
 
   $Schema["TABLE"]["jobqueue"]["jq_schedinfo"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_schedinfo\" IS 'Field for information storage by job scheduler(s) presumably useful for cleanup after failures too'";
   $Schema["TABLE"]["jobqueue"]["jq_schedinfo"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_schedinfo\" text";
   $Schema["TABLE"]["jobqueue"]["jq_schedinfo"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_schedinfo\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_itemsprocessed"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_itemsprocessed\" IS 'sum of files processed by all agents'";
   $Schema["TABLE"]["jobqueue"]["jq_itemsprocessed"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_itemsprocessed\" int4 DEFAULT 0";
   $Schema["TABLE"]["jobqueue"]["jq_itemsprocessed"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_itemsprocessed\" DROP NOT NULL, ALTER COLUMN \"jq_itemsprocessed\" SET DEFAULT 0";
 
   $Schema["TABLE"]["jobqueue"]["jq_log"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_log\" IS 'Field that holds the name of the optional log file'";
   $Schema["TABLE"]["jobqueue"]["jq_log"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_log\" text";
   $Schema["TABLE"]["jobqueue"]["jq_log"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_log\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_runonpfile"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_runonpfile\" IS 'The column name for determining which host to run on'";
   $Schema["TABLE"]["jobqueue"]["jq_runonpfile"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_runonpfile\" text";
   $Schema["TABLE"]["jobqueue"]["jq_runonpfile"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_runonpfile\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_host"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_host\" IS 'Host to run job on.  May be null to let the scheduler decide.'";
   $Schema["TABLE"]["jobqueue"]["jq_host"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_host\" text";
   $Schema["TABLE"]["jobqueue"]["jq_host"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_host\" DROP NOT NULL";
 
   $Schema["TABLE"]["jobqueue"]["jq_cmd_args"]["DESC"] = "COMMENT ON COLUMN \"jobqueue\".\"jq_cmd_args\" IS 'command line arguments, i.e. \"-ab -u 123 -c /my/dir\"'";
   $Schema["TABLE"]["jobqueue"]["jq_cmd_args"]["ADD"] = "ALTER TABLE \"jobqueue\" ADD COLUMN \"jq_cmd_args\" varchar(1024)";
   $Schema["TABLE"]["jobqueue"]["jq_cmd_args"]["ALTER"] = "ALTER TABLE \"jobqueue\" ALTER COLUMN \"jq_cmd_args\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["license_file"]["fl_pk"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"fl_pk\" IS 'Primary Key'";
   $Schema["TABLE"]["license_file"]["fl_pk"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"fl_pk\" int8 DEFAULT nextval('license_file_fl_pk_seq'::regclass)";
   $Schema["TABLE"]["license_file"]["fl_pk"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"fl_pk\" SET NOT NULL, ALTER COLUMN \"fl_pk\" SET DEFAULT nextval('license_file_fl_pk_seq'::regclass)";
 
   $Schema["TABLE"]["license_file"]["rf_fk"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"rf_fk\" IS 'RefLicense fk, if NULL this file does not contain a license'";
   $Schema["TABLE"]["license_file"]["rf_fk"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"rf_fk\" int8";
   $Schema["TABLE"]["license_file"]["rf_fk"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"rf_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_file"]["agent_fk"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"agent_fk\" IS 'Agent fk that recorded this record'";
   $Schema["TABLE"]["license_file"]["agent_fk"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"agent_fk\" int4";
   $Schema["TABLE"]["license_file"]["agent_fk"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"agent_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["license_file"]["rf_match_pct"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"rf_match_pct\" IS 'match pct 1-100'";
   $Schema["TABLE"]["license_file"]["rf_match_pct"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"rf_match_pct\" int4";
   $Schema["TABLE"]["license_file"]["rf_match_pct"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"rf_match_pct\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_file"]["rf_timestamp"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"rf_timestamp\" IS 'record add time'";
   $Schema["TABLE"]["license_file"]["rf_timestamp"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"rf_timestamp\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["license_file"]["rf_timestamp"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"rf_timestamp\" SET NOT NULL, ALTER COLUMN \"rf_timestamp\" SET DEFAULT now()";
 
   $Schema["TABLE"]["license_file"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["license_file"]["pfile_fk"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["license_file"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["license_file"]["server_fk"]["DESC"] = "";
   $Schema["TABLE"]["license_file"]["server_fk"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"server_fk\" int4 DEFAULT 1";
   $Schema["TABLE"]["license_file"]["server_fk"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"server_fk\" SET NOT NULL, ALTER COLUMN \"server_fk\" SET DEFAULT 1";
 
   $Schema["TABLE"]["license_file"]["fl_ref_start_byte"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"fl_ref_start_byte\" IS 'byte offset of match in reference license'";
   $Schema["TABLE"]["license_file"]["fl_ref_start_byte"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"fl_ref_start_byte\" int4";
   $Schema["TABLE"]["license_file"]["fl_ref_start_byte"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"fl_ref_start_byte\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_file"]["fl_ref_end_byte"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"fl_ref_end_byte\" IS 'byte offset of match end in reference license'";
   $Schema["TABLE"]["license_file"]["fl_ref_end_byte"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"fl_ref_end_byte\" int4";
   $Schema["TABLE"]["license_file"]["fl_ref_end_byte"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"fl_ref_end_byte\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_file"]["fl_start_byte"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"fl_start_byte\" IS 'byte offset of license match in file'";
   $Schema["TABLE"]["license_file"]["fl_start_byte"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"fl_start_byte\" int4";
   $Schema["TABLE"]["license_file"]["fl_start_byte"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"fl_start_byte\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_file"]["fl_end_byte"]["DESC"] = "COMMENT ON COLUMN \"license_file\".\"fl_end_byte\" IS 'byte offset of end of license match in file'";
   $Schema["TABLE"]["license_file"]["fl_end_byte"]["ADD"] = "ALTER TABLE \"license_file\" ADD COLUMN \"fl_end_byte\" int4";
   $Schema["TABLE"]["license_file"]["fl_end_byte"]["ALTER"] = "ALTER TABLE \"license_file\" ALTER COLUMN \"fl_end_byte\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["license_map"]["license_map_pk"]["DESC"] = "";
   $Schema["TABLE"]["license_map"]["license_map_pk"]["ADD"] = "ALTER TABLE \"license_map\" ADD COLUMN \"license_map_pk\" int8 DEFAULT nextval('license_map_license_map_pk_seq'::regclass)";
   $Schema["TABLE"]["license_map"]["license_map_pk"]["ALTER"] = "ALTER TABLE \"license_map\" ALTER COLUMN \"license_map_pk\" SET NOT NULL, ALTER COLUMN \"license_map_pk\" SET DEFAULT nextval('license_map_license_map_pk_seq'::regclass)";
 
   $Schema["TABLE"]["license_map"]["rf_fk"]["DESC"] = "COMMENT ON COLUMN \"license_map\".\"rf_fk\" IS 'License'";
   $Schema["TABLE"]["license_map"]["rf_fk"]["ADD"] = "ALTER TABLE \"license_map\" ADD COLUMN \"rf_fk\" int4";
   $Schema["TABLE"]["license_map"]["rf_fk"]["ALTER"] = "ALTER TABLE \"license_map\" ALTER COLUMN \"rf_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["license_map"]["rf_parent"]["DESC"] = "COMMENT ON COLUMN \"license_map\".\"rf_parent\" IS 'self or generalization'";
   $Schema["TABLE"]["license_map"]["rf_parent"]["ADD"] = "ALTER TABLE \"license_map\" ADD COLUMN \"rf_parent\" int4";
   $Schema["TABLE"]["license_map"]["rf_parent"]["ALTER"] = "ALTER TABLE \"license_map\" ALTER COLUMN \"rf_parent\" SET NOT NULL";
 
   $Schema["TABLE"]["license_map"]["usage"]["DESC"] = "COMMENT ON COLUMN \"license_map\".\"usage\" IS '0: license, 1: family'";
   $Schema["TABLE"]["license_map"]["usage"]["ADD"] = "ALTER TABLE \"license_map\" ADD COLUMN \"usage\" int4";
   $Schema["TABLE"]["license_map"]["usage"]["ALTER"] = "ALTER TABLE \"license_map\" ALTER COLUMN \"usage\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["license_ref"]["rf_pk"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_pk\" IS 'Primary Key'";
   $Schema["TABLE"]["license_ref"]["rf_pk"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_pk\" int8 DEFAULT nextval('license_ref_rf_pk_seq'::regclass)";
   $Schema["TABLE"]["license_ref"]["rf_pk"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_pk\" SET NOT NULL, ALTER COLUMN \"rf_pk\" SET DEFAULT nextval('license_ref_rf_pk_seq'::regclass)";
 
   $Schema["TABLE"]["license_ref"]["rf_shortname"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_shortname\" IS 'GPL, APSL, MIT, ...'";
   $Schema["TABLE"]["license_ref"]["rf_shortname"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_shortname\" text";
   $Schema["TABLE"]["license_ref"]["rf_shortname"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_shortname\" SET NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_text"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_text\" IS 'reference License text, or regex'";
   $Schema["TABLE"]["license_ref"]["rf_text"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_text\" text";
   $Schema["TABLE"]["license_ref"]["rf_text"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_text\" SET NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_url"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_url\" IS 'URL of authoritative license text'";
   $Schema["TABLE"]["license_ref"]["rf_url"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_url\" text";
   $Schema["TABLE"]["license_ref"]["rf_url"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_url\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_add_date"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_add_date\" IS 'Date License added to this table'";
   $Schema["TABLE"]["license_ref"]["rf_add_date"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_add_date\" date";
   $Schema["TABLE"]["license_ref"]["rf_add_date"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_add_date\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_copyleft"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_copyleft\" IS 'Is license copyleft?'";
   $Schema["TABLE"]["license_ref"]["rf_copyleft"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_copyleft\" bit";
   $Schema["TABLE"]["license_ref"]["rf_copyleft"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_copyleft\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_OSIapproved"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_OSIapproved\" IS 'Is license OSI approved? '";
   $Schema["TABLE"]["license_ref"]["rf_OSIapproved"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_OSIapproved\" bit";
   $Schema["TABLE"]["license_ref"]["rf_OSIapproved"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_OSIapproved\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_fullname"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_fullname\" IS 'GNU General Public License, Apple Public Source License, ...'";
   $Schema["TABLE"]["license_ref"]["rf_fullname"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_fullname\" text";
   $Schema["TABLE"]["license_ref"]["rf_fullname"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_fullname\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_FSFfree"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_FSFfree\" IS 'Is license FSF free?'";
   $Schema["TABLE"]["license_ref"]["rf_FSFfree"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_FSFfree\" bit";
   $Schema["TABLE"]["license_ref"]["rf_FSFfree"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_FSFfree\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_GPLv2compatible"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_GPLv2compatible\" IS 'Is license GPL v2 compatible'";
   $Schema["TABLE"]["license_ref"]["rf_GPLv2compatible"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_GPLv2compatible\" bit";
   $Schema["TABLE"]["license_ref"]["rf_GPLv2compatible"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_GPLv2compatible\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_GPLv3compatible"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_GPLv3compatible\" IS 'Is license GPL v3 compatible'";
   $Schema["TABLE"]["license_ref"]["rf_GPLv3compatible"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_GPLv3compatible\" bit";
   $Schema["TABLE"]["license_ref"]["rf_GPLv3compatible"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_GPLv3compatible\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_notes"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_notes\" IS 'General notes (public)'";
   $Schema["TABLE"]["license_ref"]["rf_notes"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_notes\" text";
   $Schema["TABLE"]["license_ref"]["rf_notes"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_notes\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_Fedora"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_Fedora\" IS '\"Good\", \"Bad\", \"Unknown\"'";
   $Schema["TABLE"]["license_ref"]["rf_Fedora"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_Fedora\" text";
   $Schema["TABLE"]["license_ref"]["rf_Fedora"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_Fedora\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["marydone"]["DESC"] = "";
   $Schema["TABLE"]["license_ref"]["marydone"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"marydone\" bool DEFAULT false";
   $Schema["TABLE"]["license_ref"]["marydone"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"marydone\" SET NOT NULL, ALTER COLUMN \"marydone\" SET DEFAULT false";
 
   $Schema["TABLE"]["license_ref"]["rf_active"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_active\" IS 'change this to false if you don''t want this reference license to be used in new analyses (does  not apply to nomos agent)'";
   $Schema["TABLE"]["license_ref"]["rf_active"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_active\" bool DEFAULT true";
   $Schema["TABLE"]["license_ref"]["rf_active"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_active\" SET NOT NULL, ALTER COLUMN \"rf_active\" SET DEFAULT true";
 
   $Schema["TABLE"]["license_ref"]["rf_text_updatable"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_text_updatable\" IS 'true if the license text can be updated (eg written by nomos)'";
   $Schema["TABLE"]["license_ref"]["rf_text_updatable"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_text_updatable\" bool DEFAULT false";
   $Schema["TABLE"]["license_ref"]["rf_text_updatable"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_text_updatable\" SET NOT NULL, ALTER COLUMN \"rf_text_updatable\" SET DEFAULT false";
 
   $Schema["TABLE"]["license_ref"]["rf_md5"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_md5\" IS 'md5 of the license text, used to keep duplicates out of the system'";
   $Schema["TABLE"]["license_ref"]["rf_md5"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_md5\" char(32)";
   $Schema["TABLE"]["license_ref"]["rf_md5"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_md5\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_detector_type"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_detector_type\" IS '1 uses reference license, 2 nomos'";
   $Schema["TABLE"]["license_ref"]["rf_detector_type"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_detector_type\" int4";
   $Schema["TABLE"]["license_ref"]["rf_detector_type"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_detector_type\" SET NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_source"]["DESC"] = "";
   $Schema["TABLE"]["license_ref"]["rf_source"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_source\" text";
   $Schema["TABLE"]["license_ref"]["rf_source"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_source\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref"]["rf_risk"]["DESC"] = "COMMENT ON COLUMN \"license_ref\".\"rf_risk\" IS 'risk level'";
   $Schema["TABLE"]["license_ref"]["rf_risk"]["ADD"] = "ALTER TABLE \"license_ref\" ADD COLUMN \"rf_risk\" int4";
   $Schema["TABLE"]["license_ref"]["rf_risk"]["ALTER"] = "ALTER TABLE \"license_ref\" ALTER COLUMN \"rf_risk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["license_candidate"]["group_fk"]["DESC"] = "COMMENT ON COLUMN \"license_candidate\".\"group_fk\" IS 'group seeing this candidate'";
   $Schema["TABLE"]["license_candidate"]["group_fk"]["ADD"] = "ALTER TABLE \"license_candidate\" ADD COLUMN \"group_fk\" int8";
   $Schema["TABLE"]["license_candidate"]["group_fk"]["ALTER"] = "ALTER TABLE \"license_candidate\" ALTER COLUMN \"group_fk\" DROP NOT NULL";
 
   
   $Schema["TABLE"]["license_ref_bulk"]["lrb_pk"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"lrb_pk\" IS 'Primary Key'";
   $Schema["TABLE"]["license_ref_bulk"]["lrb_pk"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"lrb_pk\" int8 DEFAULT nextval('license_ref_bulk_lrb_pk_seq'::regclass)";
   $Schema["TABLE"]["license_ref_bulk"]["lrb_pk"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"lrb_pk\" SET NOT NULL, ALTER COLUMN \"lrb_pk\" SET DEFAULT nextval('license_ref_bulk_lrb_pk_seq'::regclass)";
 
   $Schema["TABLE"]["license_ref_bulk"]["user_fk"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"user_fk\" IS 'user who made this bulk scan'";
   $Schema["TABLE"]["license_ref_bulk"]["user_fk"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"user_fk\" int8";
   $Schema["TABLE"]["license_ref_bulk"]["user_fk"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["license_ref_bulk"]["group_fk"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"group_fk\" IS 'group id'";
   $Schema["TABLE"]["license_ref_bulk"]["group_fk"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"group_fk\" int8";
   $Schema["TABLE"]["license_ref_bulk"]["group_fk"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"group_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref_bulk"]["rf_text"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"rf_text\" IS 'text searched by nulk scan'";
   $Schema["TABLE"]["license_ref_bulk"]["rf_text"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"rf_text\" text";
   $Schema["TABLE"]["license_ref_bulk"]["rf_text"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"rf_text\" SET NOT NULL";
 
   $Schema["TABLE"]["license_ref_bulk"]["upload_fk"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"upload_fk\" IS 'upload id'";
   $Schema["TABLE"]["license_ref_bulk"]["upload_fk"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"upload_fk\" int8";
   $Schema["TABLE"]["license_ref_bulk"]["upload_fk"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"upload_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["license_ref_bulk"]["uploadtree_fk"]["DESC"] = "COMMENT ON COLUMN \"license_ref_bulk\".\"uploadtree_fk\" IS 'file from which the decision was made'";
   $Schema["TABLE"]["license_ref_bulk"]["uploadtree_fk"]["ADD"] = "ALTER TABLE \"license_ref_bulk\" ADD COLUMN \"uploadtree_fk\" int8";
   $Schema["TABLE"]["license_ref_bulk"]["uploadtree_fk"]["ALTER"] = "ALTER TABLE \"license_ref_bulk\" ALTER COLUMN \"uploadtree_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["license_set_bulk"]["rf_fk"]["DESC"] = "COMMENT ON COLUMN \"license_set_bulk\".\"rf_fk\" IS 'reference to license_ref* (not only license_ref)'";
   $Schema["TABLE"]["license_set_bulk"]["rf_fk"]["ADD"] = "ALTER TABLE \"license_set_bulk\" ADD COLUMN \"rf_fk\" int8";
   $Schema["TABLE"]["license_set_bulk"]["rf_fk"]["ALTER"] = "ALTER TABLE \"license_set_bulk\" ALTER COLUMN \"rf_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["license_set_bulk"]["removing"]["DESC"] = "COMMENT ON COLUMN \"license_set_bulk\".\"removing\" IS 'true if removing, false if adding'";
   $Schema["TABLE"]["license_set_bulk"]["removing"]["ADD"] = "ALTER TABLE \"license_set_bulk\" ADD COLUMN \"removing\" bool DEFAULT false";
   $Schema["TABLE"]["license_set_bulk"]["removing"]["ALTER"] = "ALTER TABLE \"license_set_bulk\" ALTER COLUMN \"removing\" SET NOT NULL, ALTER COLUMN \"removing\" SET DEFAULT false";
 
   $Schema["TABLE"]["license_set_bulk"]["lrb_fk"]["DESC"] = "";
   $Schema["TABLE"]["license_set_bulk"]["lrb_fk"]["ADD"] = "ALTER TABLE \"license_set_bulk\" ADD COLUMN \"lrb_fk\" int8";
   $Schema["TABLE"]["license_set_bulk"]["lrb_fk"]["ALTER"] = "ALTER TABLE \"license_set_bulk\" ALTER COLUMN \"lrb_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["mimetype"]["mimetype_pk"]["DESC"] = "";
   $Schema["TABLE"]["mimetype"]["mimetype_pk"]["ADD"] = "ALTER TABLE \"mimetype\" ADD COLUMN \"mimetype_pk\" int4 DEFAULT nextval('mimetype_mimetype_pk_seq'::regclass)";
   $Schema["TABLE"]["mimetype"]["mimetype_pk"]["ALTER"] = "ALTER TABLE \"mimetype\" ALTER COLUMN \"mimetype_pk\" SET NOT NULL, ALTER COLUMN \"mimetype_pk\" SET DEFAULT nextval('mimetype_mimetype_pk_seq'::regclass)";
 
   $Schema["TABLE"]["mimetype"]["mimetype_name"]["DESC"] = "";
   $Schema["TABLE"]["mimetype"]["mimetype_name"]["ADD"] = "ALTER TABLE \"mimetype\" ADD COLUMN \"mimetype_name\" text";
   $Schema["TABLE"]["mimetype"]["mimetype_name"]["ALTER"] = "ALTER TABLE \"mimetype\" ALTER COLUMN \"mimetype_name\" SET NOT NULL";
 
 
   $Schema["TABLE"]["package"]["package_pk"]["DESC"] = "";
   $Schema["TABLE"]["package"]["package_pk"]["ADD"] = "ALTER TABLE \"package\" ADD COLUMN \"package_pk\" int4 DEFAULT nextval('package_package_pk_seq'::regclass)";
   $Schema["TABLE"]["package"]["package_pk"]["ALTER"] = "ALTER TABLE \"package\" ALTER COLUMN \"package_pk\" SET NOT NULL, ALTER COLUMN \"package_pk\" SET DEFAULT nextval('package_package_pk_seq'::regclass)";
 
   $Schema["TABLE"]["package"]["package_name"]["DESC"] = "";
   $Schema["TABLE"]["package"]["package_name"]["ADD"] = "ALTER TABLE \"package\" ADD COLUMN \"package_name\" text";
   $Schema["TABLE"]["package"]["package_name"]["ALTER"] = "ALTER TABLE \"package\" ALTER COLUMN \"package_name\" SET NOT NULL";
 
 
   $Schema["TABLE"]["perm_upload"]["perm_upload_pk"]["DESC"] = "";
   $Schema["TABLE"]["perm_upload"]["perm_upload_pk"]["ADD"] = "ALTER TABLE \"perm_upload\" ADD COLUMN \"perm_upload_pk\" int4 DEFAULT nextval('perm_upload_perm_upload_pk_seq'::regclass)";
   $Schema["TABLE"]["perm_upload"]["perm_upload_pk"]["ALTER"] = "ALTER TABLE \"perm_upload\" ALTER COLUMN \"perm_upload_pk\" SET NOT NULL, ALTER COLUMN \"perm_upload_pk\" SET DEFAULT nextval('perm_upload_perm_upload_pk_seq'::regclass)";
 
   $Schema["TABLE"]["perm_upload"]["perm"]["DESC"] = "COMMENT ON COLUMN \"perm_upload\".\"perm\" IS 'permission PERM_NONE, PERM_READ, PERM_WRITE, PERM_ADMIN'";
   $Schema["TABLE"]["perm_upload"]["perm"]["ADD"] = "ALTER TABLE \"perm_upload\" ADD COLUMN \"perm\" int4";
   $Schema["TABLE"]["perm_upload"]["perm"]["ALTER"] = "ALTER TABLE \"perm_upload\" ALTER COLUMN \"perm\" SET NOT NULL";
 
   $Schema["TABLE"]["perm_upload"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["perm_upload"]["upload_fk"]["ADD"] = "ALTER TABLE \"perm_upload\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["perm_upload"]["upload_fk"]["ALTER"] = "ALTER TABLE \"perm_upload\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["perm_upload"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["perm_upload"]["group_fk"]["ADD"] = "ALTER TABLE \"perm_upload\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["perm_upload"]["group_fk"]["ALTER"] = "ALTER TABLE \"perm_upload\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["pfile"]["pfile_pk"]["DESC"] = "";
   $Schema["TABLE"]["pfile"]["pfile_pk"]["ADD"] = "ALTER TABLE \"pfile\" ADD COLUMN \"pfile_pk\" int4 DEFAULT nextval('pfile_pfile_pk_seq'::regclass)";
   $Schema["TABLE"]["pfile"]["pfile_pk"]["ALTER"] = "ALTER TABLE \"pfile\" ALTER COLUMN \"pfile_pk\" SET NOT NULL, ALTER COLUMN \"pfile_pk\" SET DEFAULT nextval('pfile_pfile_pk_seq'::regclass)";
 
   $Schema["TABLE"]["pfile"]["pfile_md5"]["DESC"] = "";
   $Schema["TABLE"]["pfile"]["pfile_md5"]["ADD"] = "ALTER TABLE \"pfile\" ADD COLUMN \"pfile_md5\" char(32)";
   $Schema["TABLE"]["pfile"]["pfile_md5"]["ALTER"] = "ALTER TABLE \"pfile\" ALTER COLUMN \"pfile_md5\" SET NOT NULL";
 
   $Schema["TABLE"]["pfile"]["pfile_sha1"]["DESC"] = "";
   $Schema["TABLE"]["pfile"]["pfile_sha1"]["ADD"] = "ALTER TABLE \"pfile\" ADD COLUMN \"pfile_sha1\" char(40)";
   $Schema["TABLE"]["pfile"]["pfile_sha1"]["ALTER"] = "ALTER TABLE \"pfile\" ALTER COLUMN \"pfile_sha1\" SET NOT NULL";
 
   $Schema["TABLE"]["pfile"]["pfile_size"]["DESC"] = "";
   $Schema["TABLE"]["pfile"]["pfile_size"]["ADD"] = "ALTER TABLE \"pfile\" ADD COLUMN \"pfile_size\" int8";
   $Schema["TABLE"]["pfile"]["pfile_size"]["ALTER"] = "ALTER TABLE \"pfile\" ALTER COLUMN \"pfile_size\" SET NOT NULL";
 
   $Schema["TABLE"]["pfile"]["pfile_mimetypefk"]["DESC"] = "COMMENT ON COLUMN \"pfile\".\"pfile_mimetypefk\" IS 'NULL is treated as application/octet-stream'";
   $Schema["TABLE"]["pfile"]["pfile_mimetypefk"]["ADD"] = "ALTER TABLE \"pfile\" ADD COLUMN \"pfile_mimetypefk\" int4";
   $Schema["TABLE"]["pfile"]["pfile_mimetypefk"]["ALTER"] = "ALTER TABLE \"pfile\" ALTER COLUMN \"pfile_mimetypefk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["pkg_deb"]["pkg_name"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"pkg_name\" IS 'the name of the package'";
   $Schema["TABLE"]["pkg_deb"]["pkg_name"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"pkg_name\" text";
   $Schema["TABLE"]["pkg_deb"]["pkg_name"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"pkg_name\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["pkg_arch"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"pkg_arch\" IS 'debian machine architecture'";
   $Schema["TABLE"]["pkg_deb"]["pkg_arch"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"pkg_arch\" text";
   $Schema["TABLE"]["pkg_deb"]["pkg_arch"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"pkg_arch\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["version"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"version\" IS 'the version number of a package'";
   $Schema["TABLE"]["pkg_deb"]["version"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"version\" text";
   $Schema["TABLE"]["pkg_deb"]["version"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"version\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["section"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"section\" IS 'this field specifies an application area into which the package has been classified'";
   $Schema["TABLE"]["pkg_deb"]["section"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"section\" text";
   $Schema["TABLE"]["pkg_deb"]["section"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"section\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["priority"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"priority\" IS 'this field represents how important that it is that the user have the package installed'";
   $Schema["TABLE"]["pkg_deb"]["priority"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"priority\" text";
   $Schema["TABLE"]["pkg_deb"]["priority"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"priority\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["installed_size"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"installed_size\" IS 'an estimate of the total amount of disk space required to install the named package'";
   $Schema["TABLE"]["pkg_deb"]["installed_size"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"installed_size\" int4";
   $Schema["TABLE"]["pkg_deb"]["installed_size"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"installed_size\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["maintainer"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"maintainer\" IS 'the package maintainer''s name and email address'";
   $Schema["TABLE"]["pkg_deb"]["maintainer"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"maintainer\" text";
   $Schema["TABLE"]["pkg_deb"]["maintainer"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"maintainer\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["homepage"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"homepage\" IS 'the URL of the web site for this package'";
   $Schema["TABLE"]["pkg_deb"]["homepage"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"homepage\" text";
   $Schema["TABLE"]["pkg_deb"]["homepage"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"homepage\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["source"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"source\" IS 'this field identifies the source package name.'";
   $Schema["TABLE"]["pkg_deb"]["source"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"source\" text";
   $Schema["TABLE"]["pkg_deb"]["source"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"source\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["description"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"description\" IS 'a description of the binary package'";
   $Schema["TABLE"]["pkg_deb"]["description"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["pkg_deb"]["description"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"description\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["pfile_fk"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"pfile_fk\" IS 'key of pfile record that package refer to'";
   $Schema["TABLE"]["pkg_deb"]["pfile_fk"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["pkg_deb"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["pkg_pk"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"pkg_pk\" IS 'package primary key'";
   $Schema["TABLE"]["pkg_deb"]["pkg_pk"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"pkg_pk\" int4 DEFAULT nextval('pkg_deb_pkg_pk_seq'::regclass)";
   $Schema["TABLE"]["pkg_deb"]["pkg_pk"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"pkg_pk\" SET NOT NULL, ALTER COLUMN \"pkg_pk\" SET DEFAULT nextval('pkg_deb_pkg_pk_seq'::regclass)";
 
   $Schema["TABLE"]["pkg_deb"]["summary"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"summary\" IS 'short description'";
   $Schema["TABLE"]["pkg_deb"]["summary"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"summary\" text";
   $Schema["TABLE"]["pkg_deb"]["summary"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"summary\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["format"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"format\" IS 'specifies a format revision for the file'";
   $Schema["TABLE"]["pkg_deb"]["format"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"format\" text";
   $Schema["TABLE"]["pkg_deb"]["format"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"format\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["uploaders"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"uploaders\" IS 'names and email addresses of co-maintainers of the package'";
   $Schema["TABLE"]["pkg_deb"]["uploaders"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"uploaders\" text";
   $Schema["TABLE"]["pkg_deb"]["uploaders"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"uploaders\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_deb"]["standards_version"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb\".\"standards_version\" IS 'the most recent version of the standards'";
   $Schema["TABLE"]["pkg_deb"]["standards_version"]["ADD"] = "ALTER TABLE \"pkg_deb\" ADD COLUMN \"standards_version\" text";
   $Schema["TABLE"]["pkg_deb"]["standards_version"]["ALTER"] = "ALTER TABLE \"pkg_deb\" ALTER COLUMN \"standards_version\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["pkg_deb_req"]["req_pk"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb_req\".\"req_pk\" IS 'pkg debian require primary key'";
   $Schema["TABLE"]["pkg_deb_req"]["req_pk"]["ADD"] = "ALTER TABLE \"pkg_deb_req\" ADD COLUMN \"req_pk\" int4 DEFAULT nextval('pkg_deb_req_req_pk_seq'::regclass)";
   $Schema["TABLE"]["pkg_deb_req"]["req_pk"]["ALTER"] = "ALTER TABLE \"pkg_deb_req\" ALTER COLUMN \"req_pk\" SET NOT NULL, ALTER COLUMN \"req_pk\" SET DEFAULT nextval('pkg_deb_req_req_pk_seq'::regclass)";
 
   $Schema["TABLE"]["pkg_deb_req"]["pkg_fk"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb_req\".\"pkg_fk\" IS 'key of pkg record that require refer to'";
   $Schema["TABLE"]["pkg_deb_req"]["pkg_fk"]["ADD"] = "ALTER TABLE \"pkg_deb_req\" ADD COLUMN \"pkg_fk\" int4";
   $Schema["TABLE"]["pkg_deb_req"]["pkg_fk"]["ALTER"] = "ALTER TABLE \"pkg_deb_req\" ALTER COLUMN \"pkg_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_deb_req"]["req_value"]["DESC"] = "COMMENT ON COLUMN \"pkg_deb_req\".\"req_value\" IS 'pkg debian require'";
   $Schema["TABLE"]["pkg_deb_req"]["req_value"]["ADD"] = "ALTER TABLE \"pkg_deb_req\" ADD COLUMN \"req_value\" text";
   $Schema["TABLE"]["pkg_deb_req"]["req_value"]["ALTER"] = "ALTER TABLE \"pkg_deb_req\" ALTER COLUMN \"req_value\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["pkg_rpm"]["pkg_name"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pkg_name\" IS 'the name of the package'";
   $Schema["TABLE"]["pkg_rpm"]["pkg_name"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pkg_name\" text";
   $Schema["TABLE"]["pkg_rpm"]["pkg_name"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pkg_name\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["pkg_alias"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pkg_alias\" IS 'the alias of the package'";
   $Schema["TABLE"]["pkg_rpm"]["pkg_alias"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pkg_alias\" text";
   $Schema["TABLE"]["pkg_rpm"]["pkg_alias"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pkg_alias\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["pkg_arch"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pkg_arch\" IS 'a shorthand name describing the type of computer hardware the packaged software is meant to run on'";
   $Schema["TABLE"]["pkg_rpm"]["pkg_arch"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pkg_arch\" text";
   $Schema["TABLE"]["pkg_rpm"]["pkg_arch"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pkg_arch\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["version"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"version\" IS 'the version number of the software, as specified by the software''s original creator'";
   $Schema["TABLE"]["pkg_rpm"]["version"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"version\" text";
   $Schema["TABLE"]["pkg_rpm"]["version"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"version\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["rpm_filename"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"rpm_filename\" IS 'filename of rpm'";
   $Schema["TABLE"]["pkg_rpm"]["rpm_filename"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"rpm_filename\" text";
   $Schema["TABLE"]["pkg_rpm"]["rpm_filename"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"rpm_filename\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["license"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"license\" IS 'license type can be GPL, Freeware, Commercial, or other common type'";
   $Schema["TABLE"]["pkg_rpm"]["license"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"license\" text";
   $Schema["TABLE"]["pkg_rpm"]["license"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"license\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["pkg_group"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pkg_group\" IS 'categorize the software'";
   $Schema["TABLE"]["pkg_rpm"]["pkg_group"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pkg_group\" text";
   $Schema["TABLE"]["pkg_rpm"]["pkg_group"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pkg_group\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["packager"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"packager\" IS 'the name and contact information for the individual responsible for building the package'";
   $Schema["TABLE"]["pkg_rpm"]["packager"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"packager\" text";
   $Schema["TABLE"]["pkg_rpm"]["packager"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"packager\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["release"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"release\" IS 'the number of times a package consisting of this software has been packaged'";
   $Schema["TABLE"]["pkg_rpm"]["release"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"release\" text";
   $Schema["TABLE"]["pkg_rpm"]["release"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"release\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["build_date"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"build_date\" IS 'the time the package was created'";
   $Schema["TABLE"]["pkg_rpm"]["build_date"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"build_date\" text";
   $Schema["TABLE"]["pkg_rpm"]["build_date"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"build_date\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["vendor"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"vendor\" IS 'the organization responsible for building this package'";
   $Schema["TABLE"]["pkg_rpm"]["vendor"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"vendor\" text";
   $Schema["TABLE"]["pkg_rpm"]["vendor"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"vendor\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["url"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"url\" IS 'url resource'";
   $Schema["TABLE"]["pkg_rpm"]["url"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"url\" text";
   $Schema["TABLE"]["pkg_rpm"]["url"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"url\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["source_rpm"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"source_rpm\" IS 'the package file containing the source code and other files used to create the binary package file. the package is source rpm, this field will be NULL'";
   $Schema["TABLE"]["pkg_rpm"]["source_rpm"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"source_rpm\" text";
   $Schema["TABLE"]["pkg_rpm"]["source_rpm"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"source_rpm\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["summary"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"summary\" IS 'a concise description of the packaged software'";
   $Schema["TABLE"]["pkg_rpm"]["summary"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"summary\" text";
   $Schema["TABLE"]["pkg_rpm"]["summary"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"summary\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["description"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"description\" IS 'a verbose description of the packaged software'";
   $Schema["TABLE"]["pkg_rpm"]["description"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["pkg_rpm"]["description"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"description\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["pfile_fk"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pfile_fk\" IS 'key of pfile record that package refer to'";
   $Schema["TABLE"]["pkg_rpm"]["pfile_fk"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["pkg_rpm"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm"]["pkg_pk"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm\".\"pkg_pk\" IS 'package primary key'";
   $Schema["TABLE"]["pkg_rpm"]["pkg_pk"]["ADD"] = "ALTER TABLE \"pkg_rpm\" ADD COLUMN \"pkg_pk\" int4 DEFAULT nextval('pkg_rpm_pkg_pk_seq'::regclass)";
   $Schema["TABLE"]["pkg_rpm"]["pkg_pk"]["ALTER"] = "ALTER TABLE \"pkg_rpm\" ALTER COLUMN \"pkg_pk\" SET NOT NULL, ALTER COLUMN \"pkg_pk\" SET DEFAULT nextval('pkg_rpm_pkg_pk_seq'::regclass)";
 
 
   $Schema["TABLE"]["pkg_rpm_req"]["pkg_fk"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm_req\".\"pkg_fk\" IS 'key of pkg record that require refer to'";
   $Schema["TABLE"]["pkg_rpm_req"]["pkg_fk"]["ADD"] = "ALTER TABLE \"pkg_rpm_req\" ADD COLUMN \"pkg_fk\" int4";
   $Schema["TABLE"]["pkg_rpm_req"]["pkg_fk"]["ALTER"] = "ALTER TABLE \"pkg_rpm_req\" ALTER COLUMN \"pkg_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm_req"]["req_value"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm_req\".\"req_value\" IS 'pkg rpm require'";
   $Schema["TABLE"]["pkg_rpm_req"]["req_value"]["ADD"] = "ALTER TABLE \"pkg_rpm_req\" ADD COLUMN \"req_value\" text";
   $Schema["TABLE"]["pkg_rpm_req"]["req_value"]["ALTER"] = "ALTER TABLE \"pkg_rpm_req\" ALTER COLUMN \"req_value\" DROP NOT NULL";
 
   $Schema["TABLE"]["pkg_rpm_req"]["req_pk"]["DESC"] = "COMMENT ON COLUMN \"pkg_rpm_req\".\"req_pk\" IS 'pkg rpm require primary key'";
   $Schema["TABLE"]["pkg_rpm_req"]["req_pk"]["ADD"] = "ALTER TABLE \"pkg_rpm_req\" ADD COLUMN \"req_pk\" int4 DEFAULT nextval('pkg_rpm_req_req_pk_seq'::regclass)";
   $Schema["TABLE"]["pkg_rpm_req"]["req_pk"]["ALTER"] = "ALTER TABLE \"pkg_rpm_req\" ALTER COLUMN \"req_pk\" SET NOT NULL, ALTER COLUMN \"req_pk\" SET DEFAULT nextval('pkg_rpm_req_req_pk_seq'::regclass)";
 
 
   $Schema["TABLE"]["report_cache"]["report_cache_pk"]["DESC"] = "";
   $Schema["TABLE"]["report_cache"]["report_cache_pk"]["ADD"] = "ALTER TABLE \"report_cache\" ADD COLUMN \"report_cache_pk\" int4 DEFAULT nextval('report_cache_report_cache_pk_seq'::regclass)";
   $Schema["TABLE"]["report_cache"]["report_cache_pk"]["ALTER"] = "ALTER TABLE \"report_cache\" ALTER COLUMN \"report_cache_pk\" SET NOT NULL, ALTER COLUMN \"report_cache_pk\" SET DEFAULT nextval('report_cache_report_cache_pk_seq'::regclass)";
 
   $Schema["TABLE"]["report_cache"]["report_cache_tla"]["DESC"] = "COMMENT ON COLUMN \"report_cache\".\"report_cache_tla\" IS 'time last accessed'";
   $Schema["TABLE"]["report_cache"]["report_cache_tla"]["ADD"] = "ALTER TABLE \"report_cache\" ADD COLUMN \"report_cache_tla\" timestamp DEFAULT now()";
   $Schema["TABLE"]["report_cache"]["report_cache_tla"]["ALTER"] = "ALTER TABLE \"report_cache\" ALTER COLUMN \"report_cache_tla\" SET NOT NULL, ALTER COLUMN \"report_cache_tla\" SET DEFAULT now()";
 
   $Schema["TABLE"]["report_cache"]["report_cache_key"]["DESC"] = "COMMENT ON COLUMN \"report_cache\".\"report_cache_key\" IS 'http GET args'";
   $Schema["TABLE"]["report_cache"]["report_cache_key"]["ADD"] = "ALTER TABLE \"report_cache\" ADD COLUMN \"report_cache_key\" text";
   $Schema["TABLE"]["report_cache"]["report_cache_key"]["ALTER"] = "ALTER TABLE \"report_cache\" ALTER COLUMN \"report_cache_key\" SET NOT NULL";
 
   $Schema["TABLE"]["report_cache"]["report_cache_value"]["DESC"] = "COMMENT ON COLUMN \"report_cache\".\"report_cache_value\" IS 'report to output'";
   $Schema["TABLE"]["report_cache"]["report_cache_value"]["ADD"] = "ALTER TABLE \"report_cache\" ADD COLUMN \"report_cache_value\" text";
   $Schema["TABLE"]["report_cache"]["report_cache_value"]["ALTER"] = "ALTER TABLE \"report_cache\" ALTER COLUMN \"report_cache_value\" SET NOT NULL";
 
   $Schema["TABLE"]["report_cache"]["report_cache_uploadfk"]["DESC"] = "";
   $Schema["TABLE"]["report_cache"]["report_cache_uploadfk"]["ADD"] = "ALTER TABLE \"report_cache\" ADD COLUMN \"report_cache_uploadfk\" int4";
   $Schema["TABLE"]["report_cache"]["report_cache_uploadfk"]["ALTER"] = "ALTER TABLE \"report_cache\" ALTER COLUMN \"report_cache_uploadfk\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["report_cache_user"]["report_cache_user_pk"]["DESC"] = "";
   $Schema["TABLE"]["report_cache_user"]["report_cache_user_pk"]["ADD"] = "ALTER TABLE \"report_cache_user\" ADD COLUMN \"report_cache_user_pk\" int4 DEFAULT nextval('report_cache_user_report_cache_user_pk_seq'::regclass)";
   $Schema["TABLE"]["report_cache_user"]["report_cache_user_pk"]["ALTER"] = "ALTER TABLE \"report_cache_user\" ALTER COLUMN \"report_cache_user_pk\" SET NOT NULL, ALTER COLUMN \"report_cache_user_pk\" SET DEFAULT nextval('report_cache_user_report_cache_user_pk_seq'::regclass)";
 
   $Schema["TABLE"]["report_cache_user"]["user_fk"]["DESC"] = "";
   $Schema["TABLE"]["report_cache_user"]["user_fk"]["ADD"] = "ALTER TABLE \"report_cache_user\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["report_cache_user"]["user_fk"]["ALTER"] = "ALTER TABLE \"report_cache_user\" ALTER COLUMN \"user_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["report_cache_user"]["cache_on"]["DESC"] = "";
   $Schema["TABLE"]["report_cache_user"]["cache_on"]["ADD"] = "ALTER TABLE \"report_cache_user\" ADD COLUMN \"cache_on\" char(1) DEFAULT 'Y'::character(1)";
   $Schema["TABLE"]["report_cache_user"]["cache_on"]["ALTER"] = "ALTER TABLE \"report_cache_user\" ALTER COLUMN \"cache_on\" DROP NOT NULL, ALTER COLUMN \"cache_on\" SET DEFAULT 'Y'::character(1)";
 
 
   $Schema["TABLE"]["reportgen"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["reportgen"]["upload_fk"]["ADD"] = "ALTER TABLE \"reportgen\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["reportgen"]["upload_fk"]["ALTER"] = "ALTER TABLE \"reportgen\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["reportgen"]["job_fk"]["DESC"] = "";
   $Schema["TABLE"]["reportgen"]["job_fk"]["ADD"] = "ALTER TABLE \"reportgen\" ADD COLUMN \"job_fk\" int4";
   $Schema["TABLE"]["reportgen"]["job_fk"]["ALTER"] = "ALTER TABLE \"reportgen\" ALTER COLUMN \"job_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["reportgen"]["filepath"]["DESC"] = "";
   $Schema["TABLE"]["reportgen"]["filepath"]["ADD"] = "ALTER TABLE \"reportgen\" ADD COLUMN \"filepath\" text";
   $Schema["TABLE"]["reportgen"]["filepath"]["ALTER"] = "ALTER TABLE \"reportgen\" ALTER COLUMN \"filepath\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["sysconfig"]["sysconfig_pk"]["DESC"] = "";
   $Schema["TABLE"]["sysconfig"]["sysconfig_pk"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"sysconfig_pk\" int4 DEFAULT nextval('sysconfig_sysconfig_pk_seq'::regclass)";
   $Schema["TABLE"]["sysconfig"]["sysconfig_pk"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"sysconfig_pk\" SET NOT NULL, ALTER COLUMN \"sysconfig_pk\" SET DEFAULT nextval('sysconfig_sysconfig_pk_seq'::regclass)";
 
   $Schema["TABLE"]["sysconfig"]["variablename"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"variablename\" IS 'Name of configuration variable'";
   $Schema["TABLE"]["sysconfig"]["variablename"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"variablename\" varchar(30)";
   $Schema["TABLE"]["sysconfig"]["variablename"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"variablename\" SET NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["conf_value"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"conf_value\" IS 'value of config variable'";
   $Schema["TABLE"]["sysconfig"]["conf_value"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"conf_value\" text";
   $Schema["TABLE"]["sysconfig"]["conf_value"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"conf_value\" DROP NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["ui_label"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"ui_label\" IS 'Label that appears on user interface to prompt for variable'";
   $Schema["TABLE"]["sysconfig"]["ui_label"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"ui_label\" varchar(60)";
   $Schema["TABLE"]["sysconfig"]["ui_label"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"ui_label\" SET NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["vartype"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"vartype\" IS 'variable type.  1=int, 2=text, 3=textarea'";
   $Schema["TABLE"]["sysconfig"]["vartype"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"vartype\" int4";
   $Schema["TABLE"]["sysconfig"]["vartype"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"vartype\" SET NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["group_name"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"group_name\" IS 'Name of this variables group in the user interface'";
   $Schema["TABLE"]["sysconfig"]["group_name"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"group_name\" varchar(20)";
   $Schema["TABLE"]["sysconfig"]["group_name"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"group_name\" SET NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["group_order"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"group_order\" IS 'The order this variable appears in the user interface group'";
   $Schema["TABLE"]["sysconfig"]["group_order"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"group_order\" int4";
   $Schema["TABLE"]["sysconfig"]["group_order"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"group_order\" DROP NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["description"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"description\" IS 'Description of variable to document how/where the variable value is used.'";
   $Schema["TABLE"]["sysconfig"]["description"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"description\" text";
   $Schema["TABLE"]["sysconfig"]["description"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"description\" SET NOT NULL";
 
   $Schema["TABLE"]["sysconfig"]["validation_function"]["DESC"] = "COMMENT ON COLUMN \"sysconfig\".\"validation_function\" IS 'Name of function to validate input. Not currently implemented.'";
   $Schema["TABLE"]["sysconfig"]["validation_function"]["ADD"] = "ALTER TABLE \"sysconfig\" ADD COLUMN \"validation_function\" varchar(40) DEFAULT NULL::character varying";
   $Schema["TABLE"]["sysconfig"]["validation_function"]["ALTER"] = "ALTER TABLE \"sysconfig\" ALTER COLUMN \"validation_function\" DROP NOT NULL, ALTER COLUMN \"validation_function\" SET DEFAULT NULL::character varying";
 
 
   $Schema["TABLE"]["tag"]["tag_pk"]["DESC"] = "";
   $Schema["TABLE"]["tag"]["tag_pk"]["ADD"] = "ALTER TABLE \"tag\" ADD COLUMN \"tag_pk\" int4 DEFAULT nextval('tags_tag_pk_seq'::regclass)";
   $Schema["TABLE"]["tag"]["tag_pk"]["ALTER"] = "ALTER TABLE \"tag\" ALTER COLUMN \"tag_pk\" SET NOT NULL, ALTER COLUMN \"tag_pk\" SET DEFAULT nextval('tags_tag_pk_seq'::regclass)";
 
   $Schema["TABLE"]["tag"]["tag"]["DESC"] = "";
   $Schema["TABLE"]["tag"]["tag"]["ADD"] = "ALTER TABLE \"tag\" ADD COLUMN \"tag\" varchar(32)";
   $Schema["TABLE"]["tag"]["tag"]["ALTER"] = "ALTER TABLE \"tag\" ALTER COLUMN \"tag\" SET NOT NULL";
 
   $Schema["TABLE"]["tag"]["tag_desc"]["DESC"] = "COMMENT ON COLUMN \"tag\".\"tag_desc\" IS 'tag description'";
   $Schema["TABLE"]["tag"]["tag_desc"]["ADD"] = "ALTER TABLE \"tag\" ADD COLUMN \"tag_desc\" text";
   $Schema["TABLE"]["tag"]["tag_desc"]["ALTER"] = "ALTER TABLE \"tag\" ALTER COLUMN \"tag_desc\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["tag_file"]["tag_file_pk"]["DESC"] = "";
   $Schema["TABLE"]["tag_file"]["tag_file_pk"]["ADD"] = "ALTER TABLE \"tag_file\" ADD COLUMN \"tag_file_pk\" int4 DEFAULT nextval('tags_file_tag_file_pk_seq'::regclass)";
   $Schema["TABLE"]["tag_file"]["tag_file_pk"]["ALTER"] = "ALTER TABLE \"tag_file\" ALTER COLUMN \"tag_file_pk\" SET NOT NULL, ALTER COLUMN \"tag_file_pk\" SET DEFAULT nextval('tags_file_tag_file_pk_seq'::regclass)";
 
   $Schema["TABLE"]["tag_file"]["tag_fk"]["DESC"] = "";
   $Schema["TABLE"]["tag_file"]["tag_fk"]["ADD"] = "ALTER TABLE \"tag_file\" ADD COLUMN \"tag_fk\" int4";
   $Schema["TABLE"]["tag_file"]["tag_fk"]["ALTER"] = "ALTER TABLE \"tag_file\" ALTER COLUMN \"tag_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_file"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["tag_file"]["pfile_fk"]["ADD"] = "ALTER TABLE \"tag_file\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["tag_file"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"tag_file\" ALTER COLUMN \"pfile_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_file"]["tag_file_date"]["DESC"] = "";
   $Schema["TABLE"]["tag_file"]["tag_file_date"]["ADD"] = "ALTER TABLE \"tag_file\" ADD COLUMN \"tag_file_date\" timestamptz";
   $Schema["TABLE"]["tag_file"]["tag_file_date"]["ALTER"] = "ALTER TABLE \"tag_file\" ALTER COLUMN \"tag_file_date\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_file"]["tag_file_text"]["DESC"] = "";
   $Schema["TABLE"]["tag_file"]["tag_file_text"]["ADD"] = "ALTER TABLE \"tag_file\" ADD COLUMN \"tag_file_text\" text";
   $Schema["TABLE"]["tag_file"]["tag_file_text"]["ALTER"] = "ALTER TABLE \"tag_file\" ALTER COLUMN \"tag_file_text\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["tag_manage"]["tag_manage_pk"]["DESC"] = "COMMENT ON COLUMN \"tag_manage\".\"tag_manage_pk\" IS 'primary key'";
   $Schema["TABLE"]["tag_manage"]["tag_manage_pk"]["ADD"] = "ALTER TABLE \"tag_manage\" ADD COLUMN \"tag_manage_pk\" int4 DEFAULT nextval('tag_manage_tag_manage_pk_seq'::regclass)";
   $Schema["TABLE"]["tag_manage"]["tag_manage_pk"]["ALTER"] = "ALTER TABLE \"tag_manage\" ALTER COLUMN \"tag_manage_pk\" SET NOT NULL, ALTER COLUMN \"tag_manage_pk\" SET DEFAULT nextval('tag_manage_tag_manage_pk_seq'::regclass)";
 
   $Schema["TABLE"]["tag_manage"]["upload_fk"]["DESC"] = "COMMENT ON COLUMN \"tag_manage\".\"upload_fk\" IS 'upload id, foreign key'";
   $Schema["TABLE"]["tag_manage"]["upload_fk"]["ADD"] = "ALTER TABLE \"tag_manage\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["tag_manage"]["upload_fk"]["ALTER"] = "ALTER TABLE \"tag_manage\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_manage"]["is_disabled"]["DESC"] = "COMMENT ON COLUMN \"tag_manage\".\"is_disabled\" IS '1: disabled, 0: enabled'";
   $Schema["TABLE"]["tag_manage"]["is_disabled"]["ADD"] = "ALTER TABLE \"tag_manage\" ADD COLUMN \"is_disabled\" bool";
   $Schema["TABLE"]["tag_manage"]["is_disabled"]["ALTER"] = "ALTER TABLE \"tag_manage\" ALTER COLUMN \"is_disabled\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_pk"]["DESC"] = "";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_pk"]["ADD"] = "ALTER TABLE \"tag_uploadtree\" ADD COLUMN \"tag_uploadtree_pk\" int4 DEFAULT nextval('tags_uploadtree_tag_uploadtree_pk_seq'::regclass)";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_pk"]["ALTER"] = "ALTER TABLE \"tag_uploadtree\" ALTER COLUMN \"tag_uploadtree_pk\" SET NOT NULL, ALTER COLUMN \"tag_uploadtree_pk\" SET DEFAULT nextval('tags_uploadtree_tag_uploadtree_pk_seq'::regclass)";
 
   $Schema["TABLE"]["tag_uploadtree"]["tag_fk"]["DESC"] = "";
   $Schema["TABLE"]["tag_uploadtree"]["tag_fk"]["ADD"] = "ALTER TABLE \"tag_uploadtree\" ADD COLUMN \"tag_fk\" int4";
   $Schema["TABLE"]["tag_uploadtree"]["tag_fk"]["ALTER"] = "ALTER TABLE \"tag_uploadtree\" ALTER COLUMN \"tag_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_uploadtree"]["uploadtree_fk"]["DESC"] = "";
   $Schema["TABLE"]["tag_uploadtree"]["uploadtree_fk"]["ADD"] = "ALTER TABLE \"tag_uploadtree\" ADD COLUMN \"uploadtree_fk\" int4";
   $Schema["TABLE"]["tag_uploadtree"]["uploadtree_fk"]["ALTER"] = "ALTER TABLE \"tag_uploadtree\" ALTER COLUMN \"uploadtree_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_date"]["DESC"] = "";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_date"]["ADD"] = "ALTER TABLE \"tag_uploadtree\" ADD COLUMN \"tag_uploadtree_date\" timestamptz";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_date"]["ALTER"] = "ALTER TABLE \"tag_uploadtree\" ALTER COLUMN \"tag_uploadtree_date\" SET NOT NULL";
 
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_text"]["DESC"] = "";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_text"]["ADD"] = "ALTER TABLE \"tag_uploadtree\" ADD COLUMN \"tag_uploadtree_text\" text";
   $Schema["TABLE"]["tag_uploadtree"]["tag_uploadtree_text"]["ALTER"] = "ALTER TABLE \"tag_uploadtree\" ALTER COLUMN \"tag_uploadtree_text\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["upload"]["upload_pk"]["DESC"] = "";
   $Schema["TABLE"]["upload"]["upload_pk"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_pk\" int4 DEFAULT nextval('upload_upload_pk_seq'::regclass)";
   $Schema["TABLE"]["upload"]["upload_pk"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_pk\" SET NOT NULL, ALTER COLUMN \"upload_pk\" SET DEFAULT nextval('upload_upload_pk_seq'::regclass)";
 
   $Schema["TABLE"]["upload"]["upload_desc"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"upload_desc\" IS 'description of file'";
   $Schema["TABLE"]["upload"]["upload_desc"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_desc\" text";
   $Schema["TABLE"]["upload"]["upload_desc"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_desc\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["upload_filename"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"upload_filename\" IS 'user visible upload name must be identical to the top uploadtree rec (parent = null) for this upload'";
   $Schema["TABLE"]["upload"]["upload_filename"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_filename\" text";
   $Schema["TABLE"]["upload"]["upload_filename"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_filename\" SET NOT NULL";
 
   $Schema["TABLE"]["upload"]["user_fk"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"user_fk\" IS 'who uploaded this file FUTURE'";
   $Schema["TABLE"]["upload"]["user_fk"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"user_fk\" int4";
   $Schema["TABLE"]["upload"]["user_fk"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"user_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["upload_mode"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"upload_mode\" IS '1 upload complete, 1<<1 gold (devel only), 1<<2 wget, 1<<3 web upload, 1<<4 discovery ; 1<<5 ununpack complete without fatal errors; 1<<6 adj2nest successful'";
   $Schema["TABLE"]["upload"]["upload_mode"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_mode\" int4";
   $Schema["TABLE"]["upload"]["upload_mode"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_mode\" SET NOT NULL";
 
   $Schema["TABLE"]["upload"]["upload_ts"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"upload_ts\" IS 'record (upload) creation time'";
   $Schema["TABLE"]["upload"]["upload_ts"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_ts\" timestamptz DEFAULT now()";
   $Schema["TABLE"]["upload"]["upload_ts"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_ts\" SET NOT NULL, ALTER COLUMN \"upload_ts\" SET DEFAULT now()";
 
   $Schema["TABLE"]["upload"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload"]["pfile_fk"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["upload"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["upload_origin"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"upload_origin\" IS 'original filename or directory name or URL, depending on upload_mode'";
   $Schema["TABLE"]["upload"]["upload_origin"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"upload_origin\" text";
   $Schema["TABLE"]["upload"]["upload_origin"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"upload_origin\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["uploadtree_tablename"]["DESC"] = "";
   $Schema["TABLE"]["upload"]["uploadtree_tablename"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"uploadtree_tablename\" varchar(18) DEFAULT 'uploadtree_a'::character varying";
   $Schema["TABLE"]["upload"]["uploadtree_tablename"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"uploadtree_tablename\" SET NOT NULL, ALTER COLUMN \"uploadtree_tablename\" SET DEFAULT 'uploadtree_a'::character varying";
 
   $Schema["TABLE"]["upload"]["expire_date"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"expire_date\" IS 'expiration date'";
   $Schema["TABLE"]["upload"]["expire_date"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"expire_date\" date";
   $Schema["TABLE"]["upload"]["expire_date"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"expire_date\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["expire_action"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"expire_action\" IS '''a'' archive, ''d'' delete'";
   $Schema["TABLE"]["upload"]["expire_action"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"expire_action\" char(1)";
   $Schema["TABLE"]["upload"]["expire_action"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"expire_action\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload"]["public_perm"]["DESC"] = "COMMENT ON COLUMN \"upload\".\"public_perm\" IS 'permission PERM_NONE, PERM_READ, PERM_WRITE, PERM_ADMIN'";
   $Schema["TABLE"]["upload"]["public_perm"]["ADD"] = "ALTER TABLE \"upload\" ADD COLUMN \"public_perm\" int4";
   $Schema["TABLE"]["upload"]["public_perm"]["ALTER"] = "ALTER TABLE \"upload\" ALTER COLUMN \"public_perm\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["upload_clearing"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing"]["upload_fk"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["upload_clearing"]["upload_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_clearing"]["group_fk"]["DESC"] = "COMMENT ON COLUMN \"upload_clearing\".\"group_fk\" IS 'who is working at upload'";
   $Schema["TABLE"]["upload_clearing"]["group_fk"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["upload_clearing"]["group_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_clearing"]["assignee"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing"]["assignee"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"assignee\" int4 DEFAULT 1";
   $Schema["TABLE"]["upload_clearing"]["assignee"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"assignee\" DROP NOT NULL, ALTER COLUMN \"assignee\" SET DEFAULT 1";
 
   $Schema["TABLE"]["upload_clearing"]["status_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing"]["status_fk"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"status_fk\" int4 DEFAULT 1";
   $Schema["TABLE"]["upload_clearing"]["status_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"status_fk\" DROP NOT NULL, ALTER COLUMN \"status_fk\" SET DEFAULT 1";
 
   $Schema["TABLE"]["upload_clearing"]["status_comment"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing"]["status_comment"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"status_comment\" text";
   $Schema["TABLE"]["upload_clearing"]["status_comment"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"status_comment\" DROP NOT NULL";
 
   $Schema["TABLE"]["upload_clearing"]["priority"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing"]["priority"]["ADD"] = "ALTER TABLE \"upload_clearing\" ADD COLUMN \"priority\" float8";
   $Schema["TABLE"]["upload_clearing"]["priority"]["ALTER"] = "ALTER TABLE \"upload_clearing\" ALTER COLUMN \"priority\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["upload_clearing_license"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing_license"]["upload_fk"]["ADD"] = "ALTER TABLE \"upload_clearing_license\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["upload_clearing_license"]["upload_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing_license\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_clearing_license"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing_license"]["group_fk"]["ADD"] = "ALTER TABLE \"upload_clearing_license\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["upload_clearing_license"]["group_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing_license\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_clearing_license"]["rf_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_clearing_license"]["rf_fk"]["ADD"] = "ALTER TABLE \"upload_clearing_license\" ADD COLUMN \"rf_fk\" int8";
   $Schema["TABLE"]["upload_clearing_license"]["rf_fk"]["ALTER"] = "ALTER TABLE \"upload_clearing_license\" ALTER COLUMN \"rf_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["upload_packages"]["package_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_packages"]["package_fk"]["ADD"] = "ALTER TABLE \"upload_packages\" ADD COLUMN \"package_fk\" int4";
   $Schema["TABLE"]["upload_packages"]["package_fk"]["ALTER"] = "ALTER TABLE \"upload_packages\" ALTER COLUMN \"package_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_packages"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_packages"]["upload_fk"]["ADD"] = "ALTER TABLE \"upload_packages\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["upload_packages"]["upload_fk"]["ALTER"] = "ALTER TABLE \"upload_packages\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
 
   $Schema["TABLE"]["upload_reuse"]["upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_reuse"]["upload_fk"]["ADD"] = "ALTER TABLE \"upload_reuse\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["upload_reuse"]["upload_fk"]["ALTER"] = "ALTER TABLE \"upload_reuse\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_reuse"]["reused_upload_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_reuse"]["reused_upload_fk"]["ADD"] = "ALTER TABLE \"upload_reuse\" ADD COLUMN \"reused_upload_fk\" int4";
   $Schema["TABLE"]["upload_reuse"]["reused_upload_fk"]["ALTER"] = "ALTER TABLE \"upload_reuse\" ALTER COLUMN \"reused_upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_reuse"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_reuse"]["group_fk"]["ADD"] = "ALTER TABLE \"upload_reuse\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["upload_reuse"]["group_fk"]["ALTER"] = "ALTER TABLE \"upload_reuse\" ALTER COLUMN \"group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_reuse"]["reused_group_fk"]["DESC"] = "";
   $Schema["TABLE"]["upload_reuse"]["reused_group_fk"]["ADD"] = "ALTER TABLE \"upload_reuse\" ADD COLUMN \"reused_group_fk\" int4";
   $Schema["TABLE"]["upload_reuse"]["reused_group_fk"]["ALTER"] = "ALTER TABLE \"upload_reuse\" ALTER COLUMN \"reused_group_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["upload_reuse"]["reuse_mode"]["DESC"] = "";
   $Schema["TABLE"]["upload_reuse"]["reuse_mode"]["ADD"] = "ALTER TABLE \"upload_reuse\" ADD COLUMN \"reuse_mode\" int4 DEFAULT 0";
   $Schema["TABLE"]["upload_reuse"]["reuse_mode"]["ALTER"] = "ALTER TABLE \"upload_reuse\" ALTER COLUMN \"reuse_mode\" SET NOT NULL, ALTER COLUMN \"reuse_mode\" SET DEFAULT 0";
 
 
   $Schema["TABLE"]["uploadtree"]["uploadtree_pk"]["DESC"] = "";
   $Schema["TABLE"]["uploadtree"]["uploadtree_pk"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"uploadtree_pk\" int4 DEFAULT nextval('uploadtree_uploadtree_pk_seq'::regclass)";
   $Schema["TABLE"]["uploadtree"]["uploadtree_pk"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"uploadtree_pk\" SET NOT NULL, ALTER COLUMN \"uploadtree_pk\" SET DEFAULT nextval('uploadtree_uploadtree_pk_seq'::regclass)";
 
   $Schema["TABLE"]["uploadtree"]["parent"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"parent\" IS 'uploadtree parent'";
   $Schema["TABLE"]["uploadtree"]["parent"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"parent\" int4";
   $Schema["TABLE"]["uploadtree"]["parent"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"parent\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["realparent"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"realparent\" IS 'uploadtree non-artifact parent'";
   $Schema["TABLE"]["uploadtree"]["realparent"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"realparent\" int4";
   $Schema["TABLE"]["uploadtree"]["realparent"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"realparent\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["upload_fk"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"upload_fk\" IS 'original uploaded file'";
   $Schema["TABLE"]["uploadtree"]["upload_fk"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"upload_fk\" int4";
   $Schema["TABLE"]["uploadtree"]["upload_fk"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"upload_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["pfile_fk"]["DESC"] = "";
   $Schema["TABLE"]["uploadtree"]["pfile_fk"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"pfile_fk\" int4";
   $Schema["TABLE"]["uploadtree"]["pfile_fk"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"pfile_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["ufile_mode"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"ufile_mode\" IS 'container=1<<29, artifact=1<<28, project=1<<27, replica(same pfile)=1<<26, package<<25,directory=1<<18 (directory doesn''t seem to be used), note: wget and POST names are NOT considered artifacts.  Can tell directories as containers with no pfile.'";
   $Schema["TABLE"]["uploadtree"]["ufile_mode"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"ufile_mode\" int4";
   $Schema["TABLE"]["uploadtree"]["ufile_mode"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"ufile_mode\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["lft"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"lft\" IS 'nested set left edge'";
   $Schema["TABLE"]["uploadtree"]["lft"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"lft\" int4";
   $Schema["TABLE"]["uploadtree"]["lft"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"lft\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["rgt"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"rgt\" IS 'nested set right edge'";
   $Schema["TABLE"]["uploadtree"]["rgt"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"rgt\" int4";
   $Schema["TABLE"]["uploadtree"]["rgt"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"rgt\" DROP NOT NULL";
 
   $Schema["TABLE"]["uploadtree"]["ufile_name"]["DESC"] = "COMMENT ON COLUMN \"uploadtree\".\"ufile_name\" IS 'file name'";
   $Schema["TABLE"]["uploadtree"]["ufile_name"]["ADD"] = "ALTER TABLE \"uploadtree\" ADD COLUMN \"ufile_name\" text";
   $Schema["TABLE"]["uploadtree"]["ufile_name"]["ALTER"] = "ALTER TABLE \"uploadtree\" ALTER COLUMN \"ufile_name\" DROP NOT NULL";
 
 
   $Schema["TABLE"]["users"]["user_pk"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_pk"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_pk\" int4 DEFAULT nextval('users_user_pk_seq'::regclass)";
   $Schema["TABLE"]["users"]["user_pk"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_pk\" SET NOT NULL, ALTER COLUMN \"user_pk\" SET DEFAULT nextval('users_user_pk_seq'::regclass)";
 
   $Schema["TABLE"]["users"]["user_name"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_name"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_name\" text";
   $Schema["TABLE"]["users"]["user_name"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_name\" SET NOT NULL";
 
   $Schema["TABLE"]["users"]["root_folder_fk"]["DESC"] = "COMMENT ON COLUMN \"users\".\"root_folder_fk\" IS 'root folder for this user'";
   $Schema["TABLE"]["users"]["root_folder_fk"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"root_folder_fk\" int4";
   $Schema["TABLE"]["users"]["root_folder_fk"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"root_folder_fk\" SET NOT NULL";
 
   $Schema["TABLE"]["users"]["user_desc"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_desc"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_desc\" text";
   $Schema["TABLE"]["users"]["user_desc"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_desc\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["user_seed"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_seed"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_seed\" text";
   $Schema["TABLE"]["users"]["user_seed"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_seed\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["user_pass"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_pass"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_pass\" text";
   $Schema["TABLE"]["users"]["user_pass"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_pass\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["user_perm"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_perm"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_perm\" int4";
   $Schema["TABLE"]["users"]["user_perm"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_perm\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["user_email"]["DESC"] = "";
   $Schema["TABLE"]["users"]["user_email"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_email\" text";
   $Schema["TABLE"]["users"]["user_email"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_email\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["email_notify"]["DESC"] = "COMMENT ON COLUMN \"users\".\"email_notify\" IS 'Email notification flag'";
   $Schema["TABLE"]["users"]["email_notify"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"email_notify\" varchar(1) DEFAULT 'y'::character varying";
   $Schema["TABLE"]["users"]["email_notify"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"email_notify\" DROP NOT NULL, ALTER COLUMN \"email_notify\" SET DEFAULT 'y'::character varying";
 
   $Schema["TABLE"]["users"]["user_agent_list"]["DESC"] = "COMMENT ON COLUMN \"users\".\"user_agent_list\" IS 'list of user agents to automatically run on upload'";
   $Schema["TABLE"]["users"]["user_agent_list"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"user_agent_list\" text";
   $Schema["TABLE"]["users"]["user_agent_list"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"user_agent_list\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["default_bucketpool_fk"]["DESC"] = "";
   $Schema["TABLE"]["users"]["default_bucketpool_fk"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"default_bucketpool_fk\" int4";
   $Schema["TABLE"]["users"]["default_bucketpool_fk"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"default_bucketpool_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["ui_preference"]["DESC"] = "COMMENT ON COLUMN \"users\".\"ui_preference\" IS 'ui preference for the user, either simple or original'";
   $Schema["TABLE"]["users"]["ui_preference"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"ui_preference\" varchar DEFAULT 'simple'::character varying";
   $Schema["TABLE"]["users"]["ui_preference"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"ui_preference\" DROP NOT NULL, ALTER COLUMN \"ui_preference\" SET DEFAULT 'simple'::character varying";
 
   $Schema["TABLE"]["users"]["new_upload_group_fk"]["DESC"] = "COMMENT ON COLUMN \"users\".\"new_upload_group_fk\" IS 'group given new_upload_perm on new uploads'";
   $Schema["TABLE"]["users"]["new_upload_group_fk"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"new_upload_group_fk\" int4";
   $Schema["TABLE"]["users"]["new_upload_group_fk"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"new_upload_group_fk\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["new_upload_perm"]["DESC"] = "COMMENT ON COLUMN \"users\".\"new_upload_perm\" IS 'permission given to new_upload_group on new uploads'";
   $Schema["TABLE"]["users"]["new_upload_perm"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"new_upload_perm\" int4";
   $Schema["TABLE"]["users"]["new_upload_perm"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"new_upload_perm\" DROP NOT NULL";
 
   $Schema["TABLE"]["users"]["group_fk"]["DESC"] = "";
   $Schema["TABLE"]["users"]["group_fk"]["ADD"] = "ALTER TABLE \"users\" ADD COLUMN \"group_fk\" int4";
   $Schema["TABLE"]["users"]["group_fk"]["ALTER"] = "ALTER TABLE \"users\" ALTER COLUMN \"group_fk\" DROP NOT NULL";
 
 
 
   $Schema["VIEW"]["license_file_ref"] = "CREATE VIEW \"license_file_ref\" AS SELECT license_ref.rf_fullname, license_ref.rf_shortname, license_ref.rf_pk, license_file.fl_end_byte, license_file.rf_match_pct, license_file.rf_timestamp, license_file.fl_start_byte, license_file.fl_ref_end_byte, license_file.fl_ref_start_byte, license_file.fl_pk, license_file.agent_fk, license_file.pfile_fk FROM (license_file JOIN license_ref ON ((license_file.rf_fk = license_ref.rf_pk)));";
   $Schema["VIEW"]["uploadtree_tag_file_inner"] = "CREATE VIEW \"uploadtree_tag_file_inner\" AS SELECT uploadtree.pfile_fk, uploadtree.uploadtree_pk, uploadtree.parent, uploadtree.upload_fk, uploadtree.ufile_mode, uploadtree.lft, uploadtree.rgt, uploadtree.ufile_name, tag_file.tag_file_pk, tag_file.tag_fk, tag_file.tag_file_date, tag_file.tag_file_text FROM (uploadtree JOIN tag_file USING (pfile_fk));";
   $Schema["VIEW"]["folderlist"] = "CREATE VIEW \"folderlist\" AS SELECT folder.folder_pk, folder.folder_name AS name, folder.folder_desc AS description, foldercontents.parent_fk AS parent, foldercontents.foldercontents_mode, NULL::timestamp with time zone AS ts, NULL::integer AS upload_pk, NULL::integer AS pfile_fk, NULL::integer AS ufile_mode FROM folder, foldercontents WHERE ((foldercontents.foldercontents_mode = 1) AND (foldercontents.child_id = folder.folder_pk)) UNION ALL SELECT NULL::integer AS folder_pk, uploadtree.ufile_name AS name, upload.upload_desc AS description, foldercontents.parent_fk AS parent, foldercontents.foldercontents_mode, upload.upload_ts AS ts, upload.upload_pk, uploadtree.pfile_fk, uploadtree.ufile_mode FROM ((upload JOIN uploadtree ON (((upload.upload_pk = uploadtree.upload_fk) AND (uploadtree.parent IS NULL)))) JOIN foldercontents ON (((foldercontents.foldercontents_mode = 2) AND (foldercontents.child_id = upload.upload_pk))));";
   $Schema["VIEW"]["runstat_up_agent"] = "CREATE VIEW \"runstat_up_agent\" AS SELECT agent_runstatus.ars_status, agent_runstatus.ars_complete, agent_runstatus.ars_pk, agent_runstatus.ars_starttime AS ars_ts, agent_runstatus.agent_fk, agent.agent_desc, agent.agent_name, agent.agent_parms, agent.agent_enabled AS agent_enable, agent.agent_pk, agent.agent_ts, agent.agent_rev, upload.upload_desc, upload.upload_filename, upload.pfile_fk, upload.upload_pk FROM ((agent_runstatus JOIN agent ON ((agent_runstatus.agent_fk = agent.agent_pk))) JOIN upload ON ((agent_runstatus.upload_fk = upload.upload_pk)));";
 
   $Schema["SEQUENCE"]["sysconfig_sysconfig_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"sysconfig_sysconfig_pk_seq\"";
   $Schema["SEQUENCE"]["sysconfig_sysconfig_pk_seq"]["UPDATE"] = "SELECT setval('sysconfig_sysconfig_pk_seq',(SELECT greatest(1,max(sysconfig_pk)) val FROM sysconfig))";
 
   $Schema["SEQUENCE"]["jobqueue_jq_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"jobqueue_jq_pk_seq\"";
   $Schema["SEQUENCE"]["jobqueue_jq_pk_seq"]["UPDATE"] = "SELECT setval('jobqueue_jq_pk_seq',(SELECT greatest(1,max(jq_pk)) val FROM jobqueue))";
 
   $Schema["SEQUENCE"]["uploadtree_uploadtree_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"uploadtree_uploadtree_pk_seq\"";
   $Schema["SEQUENCE"]["uploadtree_uploadtree_pk_seq"]["UPDATE"] = "SELECT setval('uploadtree_uploadtree_pk_seq',(SELECT greatest(1,max(uploadtree_pk)) val FROM uploadtree))";
 
   $Schema["SEQUENCE"]["agent_agent_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"agent_agent_pk_seq\"";
   $Schema["SEQUENCE"]["agent_agent_pk_seq"]["UPDATE"] = "SELECT setval('agent_agent_pk_seq',(SELECT greatest(1,max(agent_pk)) val FROM agent))";
 
   $Schema["SEQUENCE"]["agent_runstatus_ars_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"agent_runstatus_ars_pk_seq\"";
   $Schema["SEQUENCE"]["agent_runstatus_ars_pk_seq"]["UPDATE"] = "SELECT setval('agent_runstatus_ars_pk_seq',(SELECT greatest(1,max(ars_pk)) val FROM agent_runstatus))";
 
   $Schema["SEQUENCE"]["nomos_ars_ars_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"nomos_ars_ars_pk_seq\"";
   $Schema["SEQUENCE"]["nomos_ars_ars_pk_seq"]["UPDATE"] = "SELECT setval('nomos_ars_ars_pk_seq',(SELECT greatest(1,max(ars_pk)) val FROM bucket_ars))";
 
   $Schema["SEQUENCE"]["attachments_attachment_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"attachments_attachment_pk_seq\"";
   $Schema["SEQUENCE"]["attachments_attachment_pk_seq"]["UPDATE"] = "SELECT setval('attachments_attachment_pk_seq',(SELECT greatest(1,max(attachment_pk)) val FROM attachments))";
 
   $Schema["SEQUENCE"]["tag_manage_tag_manage_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"tag_manage_tag_manage_pk_seq\"";
   $Schema["SEQUENCE"]["tag_manage_tag_manage_pk_seq"]["UPDATE"] = "SELECT setval('tag_manage_tag_manage_pk_seq',(SELECT greatest(1,max(tag_manage_pk)) val FROM tag_manage))";
 
   $Schema["SEQUENCE"]["bucket_bucket_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"bucket_bucket_pk_seq\"";
   $Schema["SEQUENCE"]["bucket_bucket_pk_seq"]["UPDATE"] = "SELECT setval('bucket_bucket_pk_seq',(SELECT greatest(1,max(bucket_pk)) val FROM bucket_def))";
 
   $Schema["SEQUENCE"]["bucket_container_bf_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"bucket_container_bf_pk_seq\"";
   $Schema["SEQUENCE"]["bucket_container_bf_pk_seq"]["UPDATE"] = "SELECT setval('bucket_container_bf_pk_seq',(SELECT greatest(1,max(bf_pk)) val FROM bucket_container))";
 
   $Schema["SEQUENCE"]["bucket_file_bf_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"bucket_file_bf_pk_seq\"";
   $Schema["SEQUENCE"]["bucket_file_bf_pk_seq"]["UPDATE"] = "SELECT setval('bucket_file_bf_pk_seq',(SELECT greatest(1,max(bf_pk)) val FROM bucket_file))";
 
   $Schema["SEQUENCE"]["bucketpool_bucketpool_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"bucketpool_bucketpool_pk_seq\"";
   $Schema["SEQUENCE"]["bucketpool_bucketpool_pk_seq"]["UPDATE"] = "SELECT setval('bucketpool_bucketpool_pk_seq',(SELECT greatest(1,max(bucketpool_pk)) val FROM bucketpool))";
 
   $Schema["SEQUENCE"]["perm_upload_perm_upload_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"perm_upload_perm_upload_pk_seq\"";
   $Schema["SEQUENCE"]["perm_upload_perm_upload_pk_seq"]["UPDATE"] = "SELECT setval('perm_upload_perm_upload_pk_seq',(SELECT greatest(1,max(perm_upload_pk)) val FROM perm_upload))";
 
   $Schema["SEQUENCE"]["copyright_ct_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"copyright_ct_pk_seq\"";
   $Schema["SEQUENCE"]["copyright_ct_pk_seq"]["UPDATE"] = "SELECT setval('copyright_ct_pk_seq',(SELECT greatest(1,max(ct_pk)) val FROM copyright))";
 
   $Schema["SEQUENCE"]["license_file_fl_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"license_file_fl_pk_seq\"";
   $Schema["SEQUENCE"]["license_file_fl_pk_seq"]["UPDATE"] = "SELECT setval('license_file_fl_pk_seq',(SELECT greatest(1,max(fl_pk)) val FROM license_file))";
 
   $Schema["SEQUENCE"]["folder_folder_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"folder_folder_pk_seq\"";
   $Schema["SEQUENCE"]["folder_folder_pk_seq"]["UPDATE"] = "SELECT setval('folder_folder_pk_seq',(SELECT greatest(1,max(folder_pk)) val FROM folder))";
 
   $Schema["SEQUENCE"]["foldercontents_foldercontents_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"foldercontents_foldercontents_pk_seq\"";
   $Schema["SEQUENCE"]["foldercontents_foldercontents_pk_seq"]["UPDATE"] = "SELECT setval('foldercontents_foldercontents_pk_seq',(SELECT greatest(1,max(foldercontents_pk)) val FROM foldercontents))";
 
   $Schema["SEQUENCE"]["package_package_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"package_package_pk_seq\"";
   $Schema["SEQUENCE"]["package_package_pk_seq"]["UPDATE"] = "SELECT setval('package_package_pk_seq',(SELECT greatest(1,max(package_pk)) val FROM package))";
 
   $Schema["SEQUENCE"]["upload_upload_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"upload_upload_pk_seq\"";
   $Schema["SEQUENCE"]["upload_upload_pk_seq"]["UPDATE"] = "SELECT setval('upload_upload_pk_seq',(SELECT greatest(1,max(upload_pk)) val FROM upload))";
 
   $Schema["SEQUENCE"]["group_group_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"group_group_pk_seq\"";
   $Schema["SEQUENCE"]["group_group_pk_seq"]["UPDATE"] = "SELECT setval('group_group_pk_seq',(SELECT greatest(1,max(group_pk)) val FROM groups))";
 
   $Schema["SEQUENCE"]["group_user_member_group_user_member_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"group_user_member_group_user_member_pk_seq\"";
   $Schema["SEQUENCE"]["group_user_member_group_user_member_pk_seq"]["UPDATE"] = "SELECT setval('group_user_member_group_user_member_pk_seq',(SELECT greatest(1,max(group_user_member_pk)) val FROM group_user_member))";
 
   $Schema["SEQUENCE"]["job_job_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"job_job_pk_seq\"";
   $Schema["SEQUENCE"]["job_job_pk_seq"]["UPDATE"] = "SELECT setval('job_job_pk_seq',(SELECT greatest(1,max(job_pk)) val FROM job))";
 
   $Schema["SEQUENCE"]["license_ref_rf_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"license_ref_rf_pk_seq\"";
   $Schema["SEQUENCE"]["license_ref_rf_pk_seq"]["UPDATE"] = "SELECT setval('license_ref_rf_pk_seq',(SELECT greatest(1,max(rf_pk)) val FROM license_ref))";
 
   $Schema["SEQUENCE"]["license_ref_bulk_lrb_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"license_ref_bulk_lrb_pk_seq\"";
   $Schema["SEQUENCE"]["license_ref_bulk_lrb_pk_seq"]["UPDATE"] = "SELECT setval('license_ref_bulk_lrb_pk_seq',(SELECT greatest(1,max(lrb_pk)) val FROM license_ref_bulk))";
 
   $Schema["SEQUENCE"]["mimetype_mimetype_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"mimetype_mimetype_pk_seq\"";
   $Schema["SEQUENCE"]["mimetype_mimetype_pk_seq"]["UPDATE"] = "SELECT setval('mimetype_mimetype_pk_seq',(SELECT greatest(1,max(mimetype_pk)) val FROM mimetype))";
 
   $Schema["SEQUENCE"]["pfile_pfile_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"pfile_pfile_pk_seq\"";
   $Schema["SEQUENCE"]["pfile_pfile_pk_seq"]["UPDATE"] = "SELECT setval('pfile_pfile_pk_seq',(SELECT greatest(1,max(pfile_pk)) val FROM pfile))";
 
   $Schema["SEQUENCE"]["pkg_deb_pkg_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"pkg_deb_pkg_pk_seq\"";
   $Schema["SEQUENCE"]["pkg_deb_pkg_pk_seq"]["UPDATE"] = "SELECT setval('pkg_deb_pkg_pk_seq',(SELECT greatest(1,max(pkg_pk)) val FROM pkg_deb))";
 
   $Schema["SEQUENCE"]["pkg_deb_req_req_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"pkg_deb_req_req_pk_seq\"";
   $Schema["SEQUENCE"]["pkg_deb_req_req_pk_seq"]["UPDATE"] = "SELECT setval('pkg_deb_req_req_pk_seq',(SELECT greatest(1,max(req_pk)) val FROM pkg_deb_req))";
 
   $Schema["SEQUENCE"]["pkg_rpm_pkg_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"pkg_rpm_pkg_pk_seq\"";
   $Schema["SEQUENCE"]["pkg_rpm_pkg_pk_seq"]["UPDATE"] = "SELECT setval('pkg_rpm_pkg_pk_seq',(SELECT greatest(1,max(pkg_pk)) val FROM pkg_rpm))";
 
   $Schema["SEQUENCE"]["pkg_rpm_req_req_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"pkg_rpm_req_req_pk_seq\"";
   $Schema["SEQUENCE"]["pkg_rpm_req_req_pk_seq"]["UPDATE"] = "SELECT setval('pkg_rpm_req_req_pk_seq',(SELECT greatest(1,max(req_pk)) val FROM pkg_rpm_req))";
 
   $Schema["SEQUENCE"]["report_cache_report_cache_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"report_cache_report_cache_pk_seq\"";
   $Schema["SEQUENCE"]["report_cache_report_cache_pk_seq"]["UPDATE"] = "SELECT setval('report_cache_report_cache_pk_seq',(SELECT greatest(1,max(report_cache_pk)) val FROM report_cache))";
 
   $Schema["SEQUENCE"]["report_cache_user_report_cache_user_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"report_cache_user_report_cache_user_pk_seq\"";
   $Schema["SEQUENCE"]["report_cache_user_report_cache_user_pk_seq"]["UPDATE"] = "SELECT setval('report_cache_user_report_cache_user_pk_seq',(SELECT greatest(1,max(report_cache_user_pk)) val FROM report_cache_user))";
 
   $Schema["SEQUENCE"]["tags_tag_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"tags_tag_pk_seq\"";
   $Schema["SEQUENCE"]["tags_tag_pk_seq"]["UPDATE"] = "SELECT setval('tags_tag_pk_seq',(SELECT greatest(1,max(tag_pk)) val FROM tag))";
 
   $Schema["SEQUENCE"]["tags_file_tag_file_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"tags_file_tag_file_pk_seq\"";
   $Schema["SEQUENCE"]["tags_file_tag_file_pk_seq"]["UPDATE"] = "SELECT setval('tags_file_tag_file_pk_seq',(SELECT greatest(1,max(tag_file_pk)) val FROM tag_file))";
 
   $Schema["SEQUENCE"]["tags_uploadtree_tag_uploadtree_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"tags_uploadtree_tag_uploadtree_pk_seq\"";
   $Schema["SEQUENCE"]["tags_uploadtree_tag_uploadtree_pk_seq"]["UPDATE"] = "SELECT setval('tags_uploadtree_tag_uploadtree_pk_seq',(SELECT greatest(1,max(tag_uploadtree_pk)) val FROM tag_uploadtree))";
 
   $Schema["SEQUENCE"]["users_user_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"users_user_pk_seq\"";
   $Schema["SEQUENCE"]["users_user_pk_seq"]["UPDATE"] = "SELECT setval('users_user_pk_seq',(SELECT greatest(1,max(user_pk)) val FROM users))";
 
   $Schema["SEQUENCE"]["file_picker_file_picker_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"file_picker_file_picker_pk_seq\"";
   $Schema["SEQUENCE"]["file_picker_file_picker_pk_seq"]["UPDATE"] = "SELECT setval('file_picker_file_picker_pk_seq',(SELECT greatest(1,max(file_picker_pk)) val FROM file_picker))";
 
   $Schema["SEQUENCE"]["clearing_decision_license_events_clearing_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"clearing_decision_license_events_clearing_pk_seq\"";
 
   $Schema["SEQUENCE"]["clearing_event_clearing_event_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"clearing_event_clearing_event_pk_seq\"";
   $Schema["SEQUENCE"]["clearing_event_clearing_event_pk_seq"]["UPDATE"] = "SELECT setval('clearing_event_clearing_event_pk_seq',(SELECT greatest(1,max(clearing_event_pk)) val FROM clearing_event))";
 
   $Schema["SEQUENCE"]["clearing_decision_clearing_decision_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"clearing_decision_clearing_decision_pk_seq\"";
   $Schema["SEQUENCE"]["clearing_decision_clearing_decision_pk_seq"]["UPDATE"] = "SELECT setval('clearing_decision_clearing_decision_pk_seq',(SELECT greatest(1,max(clearing_decision_pk)) val FROM clearing_decision))";
 
   $Schema["SEQUENCE"]["copyright_audit_ca_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"copyright_audit_ca_pk_seq\"";
   $Schema["SEQUENCE"]["copyright_audit_ca_pk_seq"]["UPDATE"] = "SELECT setval('copyright_audit_ca_pk_seq',(SELECT greatest(1,max(ca_pk)) val FROM copyright_audit))";
 
   $Schema["SEQUENCE"]["license_map_license_map_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"license_map_license_map_pk_seq\"";
   $Schema["SEQUENCE"]["license_map_license_map_pk_seq"]["UPDATE"] = "SELECT setval('license_map_license_map_pk_seq',(SELECT greatest(1,max(license_map_pk)) val FROM license_map))";
 
   $Schema["SEQUENCE"]["copyright_decision_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"copyright_decision_pk_seq\"";
   $Schema["SEQUENCE"]["copyright_decision_pk_seq"]["UPDATE"] = "SELECT setval('copyright_decision_pk_seq',(SELECT greatest(1,max(copyright_decision_pk)) val FROM copyright_decision))";
 
   $Schema["SEQUENCE"]["ecc_ct_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"ecc_ct_pk_seq\"";
   $Schema["SEQUENCE"]["ecc_ct_pk_seq"]["UPDATE"] = "SELECT setval('ecc_ct_pk_seq',(SELECT greatest(1,max(ct_pk)) val FROM ecc))";
 
   $Schema["SEQUENCE"]["ecc_decision_pk_seq"]["CREATE"] = "CREATE SEQUENCE \"ecc_decision_pk_seq\"";
   $Schema["SEQUENCE"]["ecc_decision_pk_seq"]["UPDATE"] = "SELECT setval('ecc_decision_pk_seq',(SELECT greatest(1,max(copyright_decision_pk)) val FROM ecc_decision))";
 
 
   $Schema["CONSTRAINT"]["FileLicense_pkey"] = "ALTER TABLE \"license_file\" ADD CONSTRAINT \"FileLicense_pkey\" PRIMARY KEY (\"fl_pk\");";
   $Schema["CONSTRAINT"]["agent_pkey"] = "ALTER TABLE \"agent\" ADD CONSTRAINT \"agent_pkey\" PRIMARY KEY (\"agent_pk\");";
   $Schema["CONSTRAINT"]["agent_runstatus_pkey"] = "ALTER TABLE \"agent_runstatus\" ADD CONSTRAINT \"agent_runstatus_pkey\" PRIMARY KEY (\"ars_pk\");";
   $Schema["CONSTRAINT"]["attachments_pkey"] = "ALTER TABLE \"attachments\" ADD CONSTRAINT \"attachments_pkey\" PRIMARY KEY (\"attachment_pk\");";
   $Schema["CONSTRAINT"]["bucket_ars_pkey"] = "ALTER TABLE \"bucket_ars\" ADD CONSTRAINT \"bucket_ars_pkey\" PRIMARY KEY (\"ars_pk\");";
   $Schema["CONSTRAINT"]["bucket_container_pkey"] = "ALTER TABLE \"bucket_container\" ADD CONSTRAINT \"bucket_container_pkey\" PRIMARY KEY (\"bf_pk\");";
   $Schema["CONSTRAINT"]["bucket_file_pkey"] = "ALTER TABLE \"bucket_file\" ADD CONSTRAINT \"bucket_file_pkey\" PRIMARY KEY (\"bf_pk\");";
   $Schema["CONSTRAINT"]["bucket_pkey"] = "ALTER TABLE \"bucket_def\" ADD CONSTRAINT \"bucket_pkey\" PRIMARY KEY (\"bucket_pk\");";
   $Schema["CONSTRAINT"]["bucketpool_pkey"] = "ALTER TABLE \"bucketpool\" ADD CONSTRAINT \"bucketpool_pkey\" PRIMARY KEY (\"bucketpool_pk\");";
   $Schema["CONSTRAINT"]["clearing_decision_pkey"] = "ALTER TABLE \"clearing_decision\" ADD CONSTRAINT \"clearing_decision_pkey\" PRIMARY KEY (\"clearing_decision_pk\");";
   $Schema["CONSTRAINT"]["clearing_event_pkey"] = "ALTER TABLE \"clearing_event\" ADD CONSTRAINT \"clearing_event_pkey\" PRIMARY KEY (\"clearing_event_pk\");";
   $Schema["CONSTRAINT"]["copyright_decision_pkey"] = "ALTER TABLE \"copyright_decision\" ADD CONSTRAINT \"copyright_decision_pkey\" PRIMARY KEY (\"copyright_decision_pk\");";
   $Schema["CONSTRAINT"]["copyright_pkey"] = "ALTER TABLE \"copyright\" ADD CONSTRAINT \"copyright_pkey\" PRIMARY KEY (\"ct_pk\");";
   $Schema["CONSTRAINT"]["ecc_decision_pkey"] = "ALTER TABLE \"ecc_decision\" ADD CONSTRAINT \"ecc_decision_pkey\" PRIMARY KEY (\"copyright_decision_pk\");";
   $Schema["CONSTRAINT"]["ecc_pkey"] = "ALTER TABLE \"ecc\" ADD CONSTRAINT \"ecc_pkey\" PRIMARY KEY (\"ct_pk\");";
   $Schema["CONSTRAINT"]["file_picker_pkey"] = "ALTER TABLE \"file_picker\" ADD CONSTRAINT \"file_picker_pkey\" PRIMARY KEY (\"file_picker_pk\");";
   $Schema["CONSTRAINT"]["folder_pkey"] = "ALTER TABLE \"folder\" ADD CONSTRAINT \"folder_pkey\" PRIMARY KEY (\"folder_pk\");";
   $Schema["CONSTRAINT"]["foldercontents_pkey"] = "ALTER TABLE \"foldercontents\" ADD CONSTRAINT \"foldercontents_pkey\" PRIMARY KEY (\"foldercontents_pk\");";
   $Schema["CONSTRAINT"]["group_pkey"] = "ALTER TABLE \"groups\" ADD CONSTRAINT \"group_pkey\" PRIMARY KEY (\"group_pk\");";
   $Schema["CONSTRAINT"]["group_user_member_pkey"] = "ALTER TABLE \"group_user_member\" ADD CONSTRAINT \"group_user_member_pkey\" PRIMARY KEY (\"group_user_member_pk\");";
   $Schema["CONSTRAINT"]["job_pkey"] = "ALTER TABLE \"job\" ADD CONSTRAINT \"job_pkey\" PRIMARY KEY (\"job_pk\");";
   $Schema["CONSTRAINT"]["jobqueue_pkey"] = "ALTER TABLE \"jobqueue\" ADD CONSTRAINT \"jobqueue_pkey\" PRIMARY KEY (\"jq_pk\");";
   $Schema["CONSTRAINT"]["license_candidate_fkey"] = "ALTER TABLE \"license_candidate\" ADD CONSTRAINT \"license_candidate_fkey\" FOREIGN KEY (\"group_fk\") REFERENCES \"groups\" (\"group_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["license_map_pkpk"] = "ALTER TABLE \"license_map\" ADD CONSTRAINT \"license_map_pkpk\" PRIMARY KEY (\"license_map_pk\");";
   $Schema["CONSTRAINT"]["license_ref_bulk_pkey"] = "ALTER TABLE \"license_ref_bulk\" ADD CONSTRAINT \"license_ref_bulk_pkey\" PRIMARY KEY (\"lrb_pk\");";
   $Schema["CONSTRAINT"]["license_set_bulk_fkey"] = "ALTER TABLE \"license_set_bulk\" ADD CONSTRAINT \"license_set_bulk_fkey\" FOREIGN KEY (\"lrb_fk\") REFERENCES \"license_ref_bulk\" (\"lrb_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["mimetype_pk"] = "ALTER TABLE \"mimetype\" ADD CONSTRAINT \"mimetype_pk\" PRIMARY KEY (\"mimetype_pk\");";
   $Schema["CONSTRAINT"]["nomos_ars_pkey"] = "ALTER TABLE \"ars_master\" ADD CONSTRAINT \"nomos_ars_pkey\" PRIMARY KEY (\"ars_pk\");";
   $Schema["CONSTRAINT"]["package_pkey"] = "ALTER TABLE \"package\" ADD CONSTRAINT \"package_pkey\" PRIMARY KEY (\"package_pk\");";
   $Schema["CONSTRAINT"]["perm_upload_pkey"] = "ALTER TABLE \"perm_upload\" ADD CONSTRAINT \"perm_upload_pkey\" PRIMARY KEY (\"perm_upload_pk\");";
   $Schema["CONSTRAINT"]["pfile_pkey"] = "ALTER TABLE \"pfile\" ADD CONSTRAINT \"pfile_pkey\" PRIMARY KEY (\"pfile_pk\");";
   $Schema["CONSTRAINT"]["pkg_deb_pkey"] = "ALTER TABLE \"pkg_deb\" ADD CONSTRAINT \"pkg_deb_pkey\" PRIMARY KEY (\"pkg_pk\");";
   $Schema["CONSTRAINT"]["pkg_deb_req_pkey"] = "ALTER TABLE \"pkg_deb_req\" ADD CONSTRAINT \"pkg_deb_req_pkey\" PRIMARY KEY (\"req_pk\");";
   $Schema["CONSTRAINT"]["pkg_rpm_pkey"] = "ALTER TABLE \"pkg_rpm\" ADD CONSTRAINT \"pkg_rpm_pkey\" PRIMARY KEY (\"pkg_pk\");";
   $Schema["CONSTRAINT"]["pkg_rpm_req_pkey"] = "ALTER TABLE \"pkg_rpm_req\" ADD CONSTRAINT \"pkg_rpm_req_pkey\" PRIMARY KEY (\"req_pk\");";
   $Schema["CONSTRAINT"]["report_cache_pkey"] = "ALTER TABLE \"report_cache\" ADD CONSTRAINT \"report_cache_pkey\" PRIMARY KEY (\"report_cache_pk\");";
   $Schema["CONSTRAINT"]["report_cache_user_pkey"] = "ALTER TABLE \"report_cache_user\" ADD CONSTRAINT \"report_cache_user_pkey\" PRIMARY KEY (\"report_cache_user_pk\");";
   $Schema["CONSTRAINT"]["rf_pkpk"] = "ALTER TABLE \"license_ref\" ADD CONSTRAINT \"rf_pkpk\" PRIMARY KEY (\"rf_pk\");";
   $Schema["CONSTRAINT"]["sysconfig_pkey"] = "ALTER TABLE \"sysconfig\" ADD CONSTRAINT \"sysconfig_pkey\" PRIMARY KEY (\"sysconfig_pk\");";
   $Schema["CONSTRAINT"]["tag_manage_pkey"] = "ALTER TABLE \"tag_manage\" ADD CONSTRAINT \"tag_manage_pkey\" PRIMARY KEY (\"tag_manage_pk\");";
   $Schema["CONSTRAINT"]["tags_file_pkey"] = "ALTER TABLE \"tag_file\" ADD CONSTRAINT \"tags_file_pkey\" PRIMARY KEY (\"tag_file_pk\");";
   $Schema["CONSTRAINT"]["tags_pkey"] = "ALTER TABLE \"tag\" ADD CONSTRAINT \"tags_pkey\" PRIMARY KEY (\"tag_pk\");";
   $Schema["CONSTRAINT"]["tags_uploadtree_pkey"] = "ALTER TABLE \"tag_uploadtree\" ADD CONSTRAINT \"tags_uploadtree_pkey\" PRIMARY KEY (\"tag_uploadtree_pk\");";
   $Schema["CONSTRAINT"]["ufile_rel_pkey"] = "ALTER TABLE \"uploadtree\" ADD CONSTRAINT \"ufile_rel_pkey\" PRIMARY KEY (\"uploadtree_pk\");";
   $Schema["CONSTRAINT"]["upload_clearing_pkey"] = "ALTER TABLE \"upload_clearing\" ADD CONSTRAINT \"upload_clearing_pkey\" PRIMARY KEY (\"upload_fk\",\"group_fk\");";
   $Schema["CONSTRAINT"]["upload_pkey_idx"] = "ALTER TABLE \"upload\" ADD CONSTRAINT \"upload_pkey_idx\" PRIMARY KEY (\"upload_pk\");";
   $Schema["CONSTRAINT"]["uploadtree_a_pkey"] = "ALTER TABLE \"uploadtree_a\" ADD CONSTRAINT \"uploadtree_a_pkey\" PRIMARY KEY (\"uploadtree_pk\");";
   $Schema["CONSTRAINT"]["user_pkey"] = "ALTER TABLE \"users\" ADD CONSTRAINT \"user_pkey\" PRIMARY KEY (\"user_pk\");";
   $Schema["CONSTRAINT"]["agent_unique_name_rev"] = "ALTER TABLE \"agent\" ADD CONSTRAINT \"agent_unique_name_rev\" UNIQUE (\"agent_name\",\"agent_rev\");";
   $Schema["CONSTRAINT"]["agent_wc_pfile_fk_key"] = "ALTER TABLE \"agent_wc\" ADD CONSTRAINT \"agent_wc_pfile_fk_key\" UNIQUE (\"pfile_fk\");";
   $Schema["CONSTRAINT"]["ars_unique"] = "ALTER TABLE \"agent_runstatus\" ADD CONSTRAINT \"ars_unique\" UNIQUE (\"agent_fk\",\"upload_fk\");";
   $Schema["CONSTRAINT"]["bucket_file_bucket_fk_key"] = "ALTER TABLE \"bucket_file\" ADD CONSTRAINT \"bucket_file_bucket_fk_key\" UNIQUE (\"bucket_fk\",\"pfile_fk\",\"agent_fk\",\"nomosagent_fk\");";
   $Schema["CONSTRAINT"]["bucketpool_bucketpool_name_key1"] = "ALTER TABLE \"bucketpool\" ADD CONSTRAINT \"bucketpool_bucketpool_name_key1\" UNIQUE (\"bucketpool_name\",\"version\");";
   $Schema["CONSTRAINT"]["dirmodemask"] = "ALTER TABLE \"mimetype\" ADD CONSTRAINT \"dirmodemask\" UNIQUE (\"mimetype_name\");";
   $Schema["CONSTRAINT"]["file_picker_user_fk_key"] = "ALTER TABLE \"file_picker\" ADD CONSTRAINT \"file_picker_user_fk_key\" UNIQUE (\"user_fk\",\"uploadtree_fk1\",\"uploadtree_fk2\");";
   $Schema["CONSTRAINT"]["group_group_name_key"] = "ALTER TABLE \"groups\" ADD CONSTRAINT \"group_group_name_key\" UNIQUE (\"group_name\");";
   $Schema["CONSTRAINT"]["md5_sha1_size"] = "ALTER TABLE \"pfile\" ADD CONSTRAINT \"md5_sha1_size\" UNIQUE (\"pfile_md5\",\"pfile_sha1\",\"pfile_size\");";
   $Schema["CONSTRAINT"]["perm_upload_upload_fk_group_fk_key"] = "ALTER TABLE \"perm_upload\" ADD CONSTRAINT \"perm_upload_upload_fk_group_fk_key\" UNIQUE (\"upload_fk\",\"group_fk\");";
   $Schema["CONSTRAINT"]["pkg_deb_pfile_fk_key"] = "ALTER TABLE \"pkg_deb\" ADD CONSTRAINT \"pkg_deb_pfile_fk_key\" UNIQUE (\"pfile_fk\");";
   $Schema["CONSTRAINT"]["report_cache_report_cache_key_key"] = "ALTER TABLE \"report_cache\" ADD CONSTRAINT \"report_cache_report_cache_key_key\" UNIQUE (\"report_cache_key\");";
   $Schema["CONSTRAINT"]["rf_md5unique"] = "ALTER TABLE \"license_ref\" ADD CONSTRAINT \"rf_md5unique\" UNIQUE (\"rf_md5\");";
   $Schema["CONSTRAINT"]["sysconfig_variablename_key"] = "ALTER TABLE \"sysconfig\" ADD CONSTRAINT \"sysconfig_variablename_key\" UNIQUE (\"variablename\");";
   $Schema["CONSTRAINT"]["user_user_name_key"] = "ALTER TABLE \"users\" ADD CONSTRAINT \"user_user_name_key\" UNIQUE (\"user_name\");";
   $Schema["CONSTRAINT"]["bf_bucket_agent_fk"] = "ALTER TABLE \"bucket_file\" ADD CONSTRAINT \"bf_bucket_agent_fk\" FOREIGN KEY (\"agent_fk\") REFERENCES \"agent\" (\"agent_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["bucket_container_agent_fk_fkey"] = "ALTER TABLE \"bucket_container\" ADD CONSTRAINT \"bucket_container_agent_fk_fkey\" FOREIGN KEY (\"agent_fk\") REFERENCES \"agent\" (\"agent_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["bucket_container_nomosagent_pk_fkey"] = "ALTER TABLE \"bucket_container\" ADD CONSTRAINT \"bucket_container_nomosagent_pk_fkey\" FOREIGN KEY (\"nomosagent_fk\") REFERENCES \"agent\" (\"agent_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["bucketpool_fk"] = "ALTER TABLE \"bucket_def\" ADD CONSTRAINT \"bucketpool_fk\" FOREIGN KEY (\"bucketpool_fk\") REFERENCES \"bucketpool\" (\"bucketpool_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["clearing_decision_pfile_fk_fkey"] = "ALTER TABLE \"clearing_decision\" ADD CONSTRAINT \"clearing_decision_pfile_fk_fkey\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["clearing_decision_user_fk_fkey"] = "ALTER TABLE \"clearing_decision\" ADD CONSTRAINT \"clearing_decision_user_fk_fkey\" FOREIGN KEY (\"user_fk\") REFERENCES \"users\" (\"user_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["copyright_pfile_fk_fkey"] = "ALTER TABLE \"copyright\" ADD CONSTRAINT \"copyright_pfile_fk_fkey\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["ecc_decision_user_fk"] = "ALTER TABLE \"ecc_decision\" ADD CONSTRAINT \"ecc_decision_user_fk\" FOREIGN KEY (\"user_fk\") REFERENCES \"users\" (\"user_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["group_user_member_group_fk_fkey"] = "ALTER TABLE \"group_user_member\" ADD CONSTRAINT \"group_user_member_group_fk_fkey\" FOREIGN KEY (\"group_fk\") REFERENCES \"groups\" (\"group_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["group_user_member_user_fk_fkey"] = "ALTER TABLE \"group_user_member\" ADD CONSTRAINT \"group_user_member_user_fk_fkey\" FOREIGN KEY (\"user_fk\") REFERENCES \"users\" (\"user_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["jdep_depends_jq_fk"] = "ALTER TABLE \"jobdepends\" ADD CONSTRAINT \"jdep_depends_jq_fk\" FOREIGN KEY (\"jdep_jq_depends_fk\") REFERENCES \"jobqueue\" (\"jq_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["jdep_jq_fk"] = "ALTER TABLE \"jobdepends\" ADD CONSTRAINT \"jdep_jq_fk\" FOREIGN KEY (\"jdep_jq_fk\") REFERENCES \"jobqueue\" (\"jq_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["job_job_folder_fk_fkey"] = "ALTER TABLE \"job\" ADD CONSTRAINT \"job_job_folder_fk_fkey\" FOREIGN KEY (\"job_folder_fk\") REFERENCES \"folder\" (\"folder_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["jobqueue_job_fk"] = "ALTER TABLE \"jobqueue\" ADD CONSTRAINT \"jobqueue_job_fk\" FOREIGN KEY (\"jq_job_fk\") REFERENCES \"job\" (\"job_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["license_map_rf_fkfk"] = "ALTER TABLE \"license_map\" ADD CONSTRAINT \"license_map_rf_fkfk\" FOREIGN KEY (\"rf_fk\") REFERENCES \"license_ref\" (\"rf_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["mimetype_fk"] = "ALTER TABLE \"pfile\" ADD CONSTRAINT \"mimetype_fk\" FOREIGN KEY (\"pfile_mimetypefk\") REFERENCES \"mimetype\" (\"mimetype_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["nomos_ars_agent_fk_fkey"] = "ALTER TABLE \"ars_master\" ADD CONSTRAINT \"nomos_ars_agent_fk_fkey\" FOREIGN KEY (\"agent_fk\") REFERENCES \"agent\" (\"agent_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["nomos_ars_upload_fk_fkey"] = "ALTER TABLE \"ars_master\" ADD CONSTRAINT \"nomos_ars_upload_fk_fkey\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["nomosagentpk"] = "ALTER TABLE \"bucket_file\" ADD CONSTRAINT \"nomosagentpk\" FOREIGN KEY (\"nomosagent_fk\") REFERENCES \"agent\" (\"agent_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["perm_upload_fkidx"] = "ALTER TABLE \"perm_upload\" ADD CONSTRAINT \"perm_upload_fkidx\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE CASCADE ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["perm_upload_group_fkidx"] = "ALTER TABLE \"perm_upload\" ADD CONSTRAINT \"perm_upload_group_fkidx\" FOREIGN KEY (\"group_fk\") REFERENCES \"groups\" (\"group_pk\") ON UPDATE CASCADE ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["pfile_fk"] = "ALTER TABLE \"license_file\" ADD CONSTRAINT \"pfile_fk\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["pkg_deb_pfile_fk_fkey"] = "ALTER TABLE \"pkg_deb\" ADD CONSTRAINT \"pkg_deb_pfile_fk_fkey\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["pkg_rpm_pfile_fk_fkey"] = "ALTER TABLE \"pkg_rpm\" ADD CONSTRAINT \"pkg_rpm_pfile_fk_fkey\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["tag_manage_upload_fk_fkey"] = "ALTER TABLE \"tag_manage\" ADD CONSTRAINT \"tag_manage_upload_fk_fkey\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["tags_file_pfile_fk_fkey"] = "ALTER TABLE \"tag_file\" ADD CONSTRAINT \"tags_file_pfile_fk_fkey\" FOREIGN KEY (\"pfile_fk\") REFERENCES \"pfile\" (\"pfile_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["tags_file_tag_fk_fkey"] = "ALTER TABLE \"tag_file\" ADD CONSTRAINT \"tags_file_tag_fk_fkey\" FOREIGN KEY (\"tag_fk\") REFERENCES \"tag\" (\"tag_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["tags_uploadtree_tag_fk_fkey"] = "ALTER TABLE \"tag_uploadtree\" ADD CONSTRAINT \"tags_uploadtree_tag_fk_fkey\" FOREIGN KEY (\"tag_fk\") REFERENCES \"tag\" (\"tag_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["upload_packages_package_fk"] = "ALTER TABLE \"upload_packages\" ADD CONSTRAINT \"upload_packages_package_fk\" FOREIGN KEY (\"package_fk\") REFERENCES \"package\" (\"package_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["upload_packages_upload_fk"] = "ALTER TABLE \"upload_packages\" ADD CONSTRAINT \"upload_packages_upload_fk\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["upload_reuse_reused_upload_fk"] = "ALTER TABLE \"upload_reuse\" ADD CONSTRAINT \"upload_reuse_reused_upload_fk\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["upload_reuse_upload_fk"] = "ALTER TABLE \"upload_reuse\" ADD CONSTRAINT \"upload_reuse_upload_fk\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["uploadtree_uploadfk"] = "ALTER TABLE \"uploadtree\" ADD CONSTRAINT \"uploadtree_uploadfk\" FOREIGN KEY (\"upload_fk\") REFERENCES \"upload\" (\"upload_pk\") ON UPDATE NO ACTION ON DELETE CASCADE;";
   $Schema["CONSTRAINT"]["users_default_bucketpool_pk_fkey"] = "ALTER TABLE \"users\" ADD CONSTRAINT \"users_default_bucketpool_pk_fkey\" FOREIGN KEY (\"default_bucketpool_fk\") REFERENCES \"bucketpool\" (\"bucketpool_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["users_group_id_fkey"] = "ALTER TABLE \"users\" ADD CONSTRAINT \"users_group_id_fkey\" FOREIGN KEY (\"group_fk\") REFERENCES \"groups\" (\"group_pk\") ON UPDATE NO ACTION ON DELETE NO ACTION;";
   $Schema["CONSTRAINT"]["users_new_upload_group_fk_fkey"] = "ALTER TABLE \"users\" ADD CONSTRAINT \"users_new_upload_group_fk_fkey\" FOREIGN KEY (\"new_upload_group_fk\") REFERENCES \"groups\" (\"group_pk\") ON UPDATE CASCADE ON DELETE RESTRICT;";
 
   $Schema["INDEX"]["bucket_container"]["bucketcontainer_uploadtree"] = "CREATE INDEX bucketcontainer_uploadtree ON bucket_container USING btree (uploadtree_fk);";
 
   $Schema["INDEX"]["bucket_file"]["pfile_idx"] = "CREATE INDEX pfile_idx ON bucket_file USING btree (pfile_fk);";
 
   $Schema["INDEX"]["clearing_decision"]["clearing_decision_pfile_fk_scope_idx"] = "CREATE INDEX clearing_decision_pfile_fk_scope_idx ON clearing_decision USING btree (pfile_fk, scope);";
   $Schema["INDEX"]["clearing_decision"]["clearing_decision_uploadtree_fk_idx"] = "CREATE INDEX clearing_decision_uploadtree_fk_idx ON clearing_decision USING btree (uploadtree_fk);";
   $Schema["INDEX"]["clearing_decision"]["clearing_decision_group_fk_idx"] = "CREATE INDEX clearing_decision_group_fk_idx ON clearing_decision USING btree (group_fk);";
 
   $Schema["INDEX"]["clearing_decision_event"]["clearing_decision_event_clearing_fk_idx"] = "CREATE INDEX clearing_decision_event_clearing_fk_idx ON clearing_decision_event USING btree (clearing_decision_fk);";
 
   $Schema["INDEX"]["clearing_event"]["clearing_event_job_fk_idx"] = "CREATE INDEX clearing_event_job_fk_idx ON clearing_event USING btree (job_fk);";
   $Schema["INDEX"]["clearing_event"]["clearing_event_uploadtree_fk_idx"] = "CREATE INDEX clearing_event_uploadtree_fk_idx ON clearing_event USING btree (uploadtree_fk);";
   $Schema["INDEX"]["clearing_event"]["clearing_event_uploadtree_group_fk_idx"] = "CREATE INDEX clearing_event_uploadtree_group_fk_idx ON clearing_event USING btree (uploadtree_fk, group_fk, date_added);";
 
   $Schema["INDEX"]["copyright"]["agent_fk_idx"] = "CREATE INDEX agent_fk_idx ON copyright USING btree (agent_fk);";
   $Schema["INDEX"]["copyright"]["copyright_pfile_fk_index"] = "CREATE INDEX copyright_pfile_fk_index ON copyright USING btree (pfile_fk);";
 
   $Schema["INDEX"]["copyright_decision"]["copyright_decision_clearing_decision_type_fk_index"] = "CREATE INDEX copyright_decision_clearing_decision_type_fk_index ON copyright_decision USING btree (clearing_decision_type_fk);";
   $Schema["INDEX"]["copyright_decision"]["copyright_decision_pfile_fk_index"] = "CREATE INDEX copyright_decision_pfile_fk_index ON copyright_decision USING btree (pfile_fk);";
   $Schema["INDEX"]["copyright_decision"]["copyright_decision_user_fk_index"] = "CREATE INDEX copyright_decision_user_fk_index ON copyright_decision USING btree (user_fk);";
 
   $Schema["INDEX"]["ecc"]["ecc_agent_fk_index"] = "CREATE INDEX ecc_agent_fk_index ON ecc USING btree (agent_fk);";
   $Schema["INDEX"]["ecc"]["ecc_hash_index"] = "CREATE INDEX ecc_hash_index ON ecc USING btree (hash);";
   $Schema["INDEX"]["ecc"]["ecc_pfile_fk_index"] = "CREATE INDEX ecc_pfile_fk_index ON ecc USING btree (pfile_fk);";
 
   $Schema["INDEX"]["ecc_decision"]["ecc_decision_clearing_decision_type_fk_index"] = "CREATE INDEX ecc_decision_clearing_decision_type_fk_index ON ecc_decision USING btree (clearing_decision_type_fk);";
   $Schema["INDEX"]["ecc_decision"]["ecc_decision_pfile_fk_index"] = "CREATE INDEX ecc_decision_pfile_fk_index ON ecc_decision USING btree (pfile_fk);";
   $Schema["INDEX"]["ecc_decision"]["ecc_decision_user_fk_index"] = "CREATE INDEX ecc_decision_user_fk_index ON ecc_decision USING btree (user_fk);";
 
   $Schema["INDEX"]["highlight"]["highlight_fl_fk_idx"] = "CREATE INDEX highlight_fl_fk_idx ON highlight USING btree (fl_fk);";
 
   $Schema["INDEX"]["highlight_keyword"]["highlight_keyword_pfile_fk_idx"] = "CREATE INDEX highlight_keyword_pfile_fk_idx ON highlight_keyword USING btree (pfile_fk);";
 
   $Schema["INDEX"]["highlight_bulk"]["highlight_bulk_clearing_event_fk_idx"] = "CREATE INDEX highlight_bulk_clearing_event_fk_idx ON highlight_bulk USING btree (clearing_event_fk);";
   $Schema["INDEX"]["highlight_bulk"]["highlight_bulk_lrb_fk_idx"] = "CREATE INDEX highlight_bulk_lrb_fk_idx ON highlight_bulk USING btree (lrb_fk);";
 
   $Schema["INDEX"]["license_file"]["fl_rf_fk"] = "CREATE INDEX fl_rf_fk ON license_file USING btree (rf_fk);";
   $Schema["INDEX"]["license_file"]["lf_pfile_fk"] = "CREATE INDEX lf_pfile_fk ON license_file USING btree (pfile_fk);";
   $Schema["INDEX"]["license_file"]["lf_agent_fk"] = "CREATE INDEX lf_agent_fk ON license_file USING btree (agent_fk);";
 
   $Schema["INDEX"]["license_ref"]["rf_shortname_idx"] = "CREATE INDEX rf_shortname_idx ON license_ref USING btree (rf_shortname);";
 
   $Schema["INDEX"]["license_ref_bulk"]["license_ref_bulk_uploadtree_fk_idx"] = "CREATE INDEX license_ref_bulk_uploadtree_fk_idx ON license_ref_bulk USING btree (uploadtree_fk);";
   $Schema["INDEX"]["license_ref_bulk"]["license_ref_bulk_group_fk_idx"] = "CREATE INDEX license_ref_bulk_group_fk_idx ON license_ref_bulk USING btree (group_fk);";
 
   $Schema["INDEX"]["license_set_bulk"]["license_set_bulk_lrb_fk_idx"] = "CREATE INDEX license_set_bulk_lrb_fk_idx ON license_set_bulk USING btree (lrb_fk);";
 
   $Schema["INDEX"]["perm_upload"]["group_fk_idx"] = "CREATE INDEX group_fk_idx ON perm_upload USING btree (group_fk);";
   $Schema["INDEX"]["perm_upload"]["upload_fk_idx"] = "CREATE INDEX upload_fk_idx ON perm_upload USING btree (upload_fk);";
 
   $Schema["INDEX"]["pfile"]["pfile_mimetypefk_idx"] = "CREATE INDEX pfile_mimetypefk_idx ON pfile USING btree (pfile_mimetypefk);";
 
   $Schema["INDEX"]["report_cache"]["report_cache_createdts"] = "CREATE INDEX report_cache_createdts ON report_cache USING btree (report_cache_tla);";
 
   $Schema["INDEX"]["uploadtree"]["lft_idx"] = "CREATE INDEX lft_idx ON uploadtree USING btree (lft);";
   $Schema["INDEX"]["uploadtree"]["parent"] = "CREATE INDEX parent ON uploadtree USING btree (parent);";
   $Schema["INDEX"]["uploadtree"]["projtree_projid_idx"] = "CREATE INDEX projtree_projid_idx ON uploadtree USING btree (upload_fk);";
   $Schema["INDEX"]["uploadtree"]["uploadtree_pfile_fk_idx"] = "CREATE INDEX uploadtree_pfile_fk_idx ON uploadtree USING btree (pfile_fk);";
 
   $Schema["INDEX"]["uploadtree_a"]["uploadtree_a_lft_idx"] = "CREATE INDEX uploadtree_a_lft_idx ON uploadtree_a USING btree (lft);";
   $Schema["INDEX"]["uploadtree_a"]["uploadtree_a_parent_idx"] = "CREATE INDEX uploadtree_a_parent_idx ON uploadtree_a USING btree (parent);";
   $Schema["INDEX"]["uploadtree_a"]["uploadtree_a_pfile_fk_idx"] = "CREATE INDEX uploadtree_a_pfile_fk_idx ON uploadtree_a USING btree (pfile_fk);";
   $Schema["INDEX"]["uploadtree_a"]["uploadtree_a_upload_fk_idx"] = "CREATE INDEX uploadtree_a_upload_fk_idx ON uploadtree_a USING btree (upload_fk);";
   $Schema["INDEX"]["uploadtree_a"]["uploadtree_a_upload_fk_lft_idx"] = "CREATE INDEX uploadtree_a_upload_fk_lft_idx ON uploadtree_a USING btree (upload_fk, lft);";
 
   $Schema["CLUSTER"]["upload_pkey_idx"] = "ALTER TABLE \"upload\" CLUSTER ON \"upload_pkey_idx\";";
   $Schema["CLUSTER"]["ufile_rel_pkey"] = "ALTER TABLE \"uploadtree\" CLUSTER ON \"ufile_rel_pkey\";";
   $Schema["CLUSTER"]["highlight_keyword_pfile_fk_idx"] = "ALTER TABLE \"highlight_keyword\" CLUSTER ON \"highlight_keyword_pfile_fk_idx\";";
   $Schema["CLUSTER"]["clearing_decision_pkey"] = "ALTER TABLE \"clearing_decision\" CLUSTER ON \"clearing_decision_pkey\";";
 
   $Schema["INHERITS"]["uploadtree_a"] = "uploadtree";
   $Schema["INHERITS"]["readmeoss_ars"] = "ars_master";
   $Schema["INHERITS"]["decider_ars"] = "ars_master";
   $Schema["INHERITS"]["reuser_ars"] = "ars_master";
   $Schema["INHERITS"]["deciderjob_ars"] = "ars_master";
   $Schema["INHERITS"]["ununpack_ars"] = "ars_master";
   $Schema["INHERITS"]["nomos_ars"] = "ars_master";
   $Schema["INHERITS"]["monk_ars"] = "ars_master";
   $Schema["INHERITS"]["license_candidate"] = "license_ref";