From 2511a10c99bb5cf3debfead718dc2c507aca9fca Mon Sep 17 00:00:00 2001 From: Adam Frisby Date: Thu, 31 May 2007 10:56:33 +0000 Subject: Small spot of renaming... --- releng/dist/SQL/mysql-inventoryfolders.sql | 9 +++++++++ releng/dist/SQL/mysql-inventoryfolders.txt | 9 --------- releng/dist/SQL/mysql-inventoryitems.sql | 14 ++++++++++++++ releng/dist/SQL/mysql-inventoryitems.txt | 14 -------------- releng/dist/SQL/mysql-logs.sql | 10 ++++++++++ releng/dist/SQL/mysql-logs.txt | 10 ---------- 6 files changed, 33 insertions(+), 33 deletions(-) create mode 100644 releng/dist/SQL/mysql-inventoryfolders.sql delete mode 100644 releng/dist/SQL/mysql-inventoryfolders.txt create mode 100644 releng/dist/SQL/mysql-inventoryitems.sql delete mode 100644 releng/dist/SQL/mysql-inventoryitems.txt create mode 100644 releng/dist/SQL/mysql-logs.sql delete mode 100644 releng/dist/SQL/mysql-logs.txt (limited to 'releng/dist') diff --git a/releng/dist/SQL/mysql-inventoryfolders.sql b/releng/dist/SQL/mysql-inventoryfolders.sql new file mode 100644 index 0000000..c30239e --- /dev/null +++ b/releng/dist/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; diff --git a/releng/dist/SQL/mysql-inventoryfolders.txt b/releng/dist/SQL/mysql-inventoryfolders.txt deleted file mode 100644 index c30239e..0000000 --- a/releng/dist/SQL/mysql-inventoryfolders.txt +++ /dev/null @@ -1,9 +0,0 @@ -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; diff --git a/releng/dist/SQL/mysql-inventoryitems.sql b/releng/dist/SQL/mysql-inventoryitems.sql new file mode 100644 index 0000000..6e90005 --- /dev/null +++ b/releng/dist/SQL/mysql-inventoryitems.sql @@ -0,0 +1,14 @@ +CREATE TABLE `inventoryitems` ( + `inventoryID` varchar(36) NOT NULL default '', + `assetID` varchar(36) default NULL, + `type` int(11) default NULL, + `parentFolderID` varchar(36) default NULL, + `avatarID` varchar(36) default NULL, + `inventoryName` varchar(64) default NULL, + `inventoryDescription` varchar(64) default NULL, + `inventoryNextPermissions` int(10) unsigned default NULL, + `inventoryCurrentPermissions` int(10) unsigned default NULL, + PRIMARY KEY (`inventoryID`), + KEY `owner` (`avatarID`), + KEY `folder` (`parentFolderID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/releng/dist/SQL/mysql-inventoryitems.txt b/releng/dist/SQL/mysql-inventoryitems.txt deleted file mode 100644 index 6e90005..0000000 --- a/releng/dist/SQL/mysql-inventoryitems.txt +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE `inventoryitems` ( - `inventoryID` varchar(36) NOT NULL default '', - `assetID` varchar(36) default NULL, - `type` int(11) default NULL, - `parentFolderID` varchar(36) default NULL, - `avatarID` varchar(36) default NULL, - `inventoryName` varchar(64) default NULL, - `inventoryDescription` varchar(64) default NULL, - `inventoryNextPermissions` int(10) unsigned default NULL, - `inventoryCurrentPermissions` int(10) unsigned default NULL, - PRIMARY KEY (`inventoryID`), - KEY `owner` (`avatarID`), - KEY `folder` (`parentFolderID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/releng/dist/SQL/mysql-logs.sql b/releng/dist/SQL/mysql-logs.sql new file mode 100644 index 0000000..05c19e8 --- /dev/null +++ b/releng/dist/SQL/mysql-logs.sql @@ -0,0 +1,10 @@ +CREATE TABLE `logs` ( + `logID` int(10) unsigned NOT NULL auto_increment, + `target` varchar(36) default NULL, + `server` varchar(64) default NULL, + `method` varchar(64) default NULL, + `arguments` varchar(255) default NULL, + `priority` int(11) default NULL, + `message` text, + PRIMARY KEY (`logID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file diff --git a/releng/dist/SQL/mysql-logs.txt b/releng/dist/SQL/mysql-logs.txt deleted file mode 100644 index 05c19e8..0000000 --- a/releng/dist/SQL/mysql-logs.txt +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE `logs` ( - `logID` int(10) unsigned NOT NULL auto_increment, - `target` varchar(36) default NULL, - `server` varchar(64) default NULL, - `method` varchar(64) default NULL, - `arguments` varchar(255) default NULL, - `priority` int(11) default NULL, - `message` text, - PRIMARY KEY (`logID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file -- cgit v1.1