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/CreateUsersTable.sql | 35 ----------------------- 1 file changed, 35 deletions(-) delete mode 100644 OpenSim/Data/MySQL/Resources/CreateUsersTable.sql (limited to 'OpenSim/Data/MySQL/Resources/CreateUsersTable.sql') diff --git a/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql b/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql deleted file mode 100644 index d9e8ae2..0000000 --- a/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql +++ /dev/null @@ -1,35 +0,0 @@ -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for users --- ---------------------------- -CREATE TABLE `users` ( - `UUID` varchar(36) NOT NULL default '', - `username` varchar(32) NOT NULL, - `lastname` varchar(32) NOT NULL, - `passwordHash` varchar(32) NOT NULL, - `passwordSalt` varchar(32) NOT NULL, - `homeRegion` bigint(20) unsigned default NULL, - `homeLocationX` float default NULL, - `homeLocationY` float default NULL, - `homeLocationZ` float default NULL, - `homeLookAtX` float default NULL, - `homeLookAtY` float default NULL, - `homeLookAtZ` float default NULL, - `created` int(11) NOT NULL, - `lastLogin` int(11) NOT NULL, - `userInventoryURI` varchar(255) default NULL, - `userAssetURI` varchar(255) default NULL, - `profileCanDoMask` int(10) unsigned default NULL, - `profileWantDoMask` int(10) unsigned default NULL, - `profileAboutText` text, - `profileFirstText` text, - `profileImage` varchar(36) default NULL, - `profileFirstImage` varchar(36) default NULL, - `webLoginKey` varchar(36) default NULL, - PRIMARY KEY (`UUID`), - UNIQUE KEY `usernames` (`username`,`lastname`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; - --- ---------------------------- --- Records --- ---------------------------- -- cgit v1.1