From c417a5b619eb85706a1782c5b0943cb8b28bd7a1 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Tue, 17 Feb 2009 19:06:23 +0000 Subject: remove all the very old create and upgrade sql files, these were outdated by migrations 6 months ago. --- OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql | 24 ---------------------- 1 file changed, 24 deletions(-) delete mode 100644 OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql (limited to 'OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql') diff --git a/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql b/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql deleted file mode 100644 index 3ef7bc9..0000000 --- a/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql +++ /dev/null @@ -1,24 +0,0 @@ -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for agents --- ---------------------------- -CREATE TABLE `agents` ( - `UUID` varchar(36) NOT NULL, - `sessionID` varchar(36) NOT NULL, - `secureSessionID` varchar(36) NOT NULL, - `agentIP` varchar(16) NOT NULL, - `agentPort` int(11) NOT NULL, - `agentOnline` tinyint(4) NOT NULL, - `loginTime` int(11) NOT NULL, - `logoutTime` int(11) NOT NULL, - `currentRegion` varchar(36) NOT NULL, - `currentHandle` bigint(20) unsigned NOT NULL, - `currentPos` varchar(64) NOT NULL, - PRIMARY KEY (`UUID`), - UNIQUE KEY `session` (`sessionID`), - UNIQUE KEY `ssession` (`secureSessionID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; - --- ---------------------------- --- Records --- ---------------------------- -- cgit v1.1