Changeset 570 for trunk/phpbms/install

Timestamp:

06/03/09 19:08:38 (3 years ago)

Author:

nate

Message:

• Files now uses uuid files correctly.
• Initial implementation of uuids for attachments.

Location:

trunk/phpbms/install

Files:

• files.sql (modified) (2 diffs)
• generateuuids.php (modified) (2 diffs)
• updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/files.sql

@@ -1 @@
-INSERT INTO `files` (`id`, `uuid`, `name`, `description`, `file`, `type`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `roleid`, `custom1`, `custom2`, `custom3`, `custom4`, `custom5`, `custom6`, `custom7`, `custom8`) VALUES ('1', '', 'logo.png', 'Company Logo Used in PDF reports', '‰PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0\0\0]\0\0\0ŸS°\0\0\0gAMA\0\0¯È7Šé\0\0\0tEXtSoftware\0Adobe ImageReadyqÉe<\0\0\0`PLTE666ÑÑѶ¶¶óó󪪪kkk   rrrœœœÅÅŎŽŽèèèÛÛۄ„„¿¿¿|||XXXÞÞÞðððˆˆˆÉÉÉââ╕•€€€KKK&&&QQQPPP%%%bbbcccÿÿÿV\"l\0\0\0ØIDATxÚb \0@£A\0\0D£påΡ\0D£pà”®¡\04ˆÃA‘‘‘‰˜±I#€<^inT)&1^v99YYv^.f°@\0a†ƒ /¿¬
+INSERT INTO `files` (`id`, `uuid`, `name`, `description`, `file`, `type`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `roleid`, `custom1`, `custom2`, `custom3`, `custom4`, `custom5`, `custom6`, `custom7`, `custom8`) VALUES ('1', 'file:ad761197-e5a2-3fdf-f330-d1508f10813e', 'logo.png', 'Company Logo Used in PDF reports', '‰PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0\0\0]\0\0\0ŸS°\0\0\0gAMA\0\0¯È7Šé\0\0\0tEXtSoftware\0Adobe ImageReadyqÉe<\0\0\0`PLTE666ÑÑѶ¶¶óó󪪪kkk   rrrœœœÅÅŎŽŽèèèÛÛۄ„„¿¿¿|||XXXÞÞÞðððˆˆˆÉÉÉââ╕•€€€KKK&&&QQQPPP%%%bbbcccÿÿÿV\"l\0\0\0ØIDATxÚb \0@£A\0\0D£påΡ\0D£pà”®¡\04ˆÃA‘‘‘‰˜±I#€<^inT)&1^v99YYv^.f°@\0a†ƒ /¿¬
 X#%á I~8°\0] +t*‚#ËÏ&‚¬†WVVN®‚ÝV~šŽ¬Bœ›
 \"\n0àgj Žp\0«’“
@@ -122 +122 @@
 ܀€\0Â(­Uº
 H•B=óÄ u¶±*€\0\ZYóÜšå0\0 Ñy
-\0 Ñp€\0€\0\Z\r\00\0tP|O;ë\0\0\0\0IEND®B`‚', 'image/png', 1, NOW(), 1, NOW(), '90', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+\0 Ñp€\0€\0\Z\r\00\0tP|O;ë\0\0\0\0IEND®B`‚', 'image/png', 1, NOW(), 1, NOW(), 'Admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

trunk/phpbms/install/generateuuids.php

@@ -110 +110 @@
         $this->roleList[0] = "";
 
+        $this->tabledefList = $this->generateUUIDList("tabledefs");
+        //
+        //$this->moduleList= $this->generateUUIDList("modules");
+
         $menuList = $this->generateUUIDList("menu");
         $menuList[0] = "";
@@ -128 +132 @@
         //$this->updateFields("usersearches", array("tabledefid"=>$this->tabledefList, "userid"=>$this->userList, "roleid"=>$this->roleList));
         //$this->updateFields("relationships", array("fromtableid"=>$this->tabledefList, "totableid"=>$this->tabledefList));
+
+        //$this->updateFields("files", array("roleid"=>$this->roleList));
         //$this->updateFields("menu", array("parentid"=>$menuList, "roleid"=>$this->roleList));
         //$this->updateFields("smartsearches", array("tabledefid"=>$this->tabledefList, "moduleid"=>$this->moduleList));

trunk/phpbms/install/updatev0.98.sql

@@ -232 +232 @@
 --end usersearches ALTER--
 
+--files UPDATE--
+UPDATE `files` SET
+    `uuid`='file:ad761197-e5a2-3fdf-f330-d1508f10813e',
+    `roleid` = 'Admin'
+WHERE
+    `id`='1';
+--end files UPDATE--
 --menu INSERT--
 DELETE FROM `menu`;