From 0a02dd287d109ed229c10a12382fc5e41157276a Mon Sep 17 00:00:00 2001 From: MW Date: Fri, 22 Jun 2007 18:52:27 +0000 Subject: Imported Share folder from trunk --- share/sql/mysql-inventoryfolders.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 share/sql/mysql-inventoryfolders.sql (limited to 'share/sql/mysql-inventoryfolders.sql') diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql new file mode 100644 index 0000000..c30239e --- /dev/null +++ b/share/sql/mysql-inventoryfolders.sql @@ -0,0 +1,9 @@ +CREATE TABLE `inventoryfolders` ( + `folderID` varchar(36) NOT NULL default '', + `agentID` varchar(36) default NULL, + `parentFolderID` varchar(36) default NULL, + `folderName` varchar(64) default NULL, + PRIMARY KEY (`folderID`), + KEY `owner` (`agentID`), + KEY `parent` (`parentFolderID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.1