From 781187e16f27fe140b241481d4879e6de631ade8 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Wed, 23 Jan 2008 20:42:50 +0000 Subject: put the number in front of the migrations to make them easier to deal with --- .../Data.SQLite/Resources/UserStore_001.sql | 37 ---------------------- 1 file changed, 37 deletions(-) delete mode 100644 OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql (limited to 'OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql') diff --git a/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql deleted file mode 100644 index 070e340..0000000 --- a/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql +++ /dev/null @@ -1,37 +0,0 @@ -BEGIN TRANSACTION; - -CREATE TABLE users( - UUID varchar(255) primary key, - username varchar(255), - surname varchar(255), - passwordHash varchar(255), - passwordSalt varchar(255), - homeRegionX integer, - homeRegionY integer, - homeLocationX float, - homeLocationY float, - homeLocationZ float, - homeLookAtX float, - homeLookAtY float, - homeLookAtZ float, - created integer, - lastLogin integer, - rootInventoryFolderID varchar(255), - userInventoryURI varchar(255), - userAssetURI varchar(255), - profileCanDoMask integer, - profileWantDoMask integer, - profileAboutText varchar(255), - profileFirstText varchar(255), - profileImage varchar(255), - profileFirstImage varchar(255), - webLoginKey text default '00000000-0000-0000-0000-000000000000'); - -CREATE TABLE userfriends( - ownerID varchar(255), - friendID varchar(255), - friendPerms integer, - ownerPerms integer, - datetimestamp integer); - -COMMIT; -- cgit v1.1