opensim-development – Blame information for rev 1
?pathlinks?
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | eva | 1 | :VERSION 1 # ------------------------------- |
| 2 | |||
| 3 | begin; |
||
| 4 | |||
| 5 | CREATE TABLE IF NOT EXISTS `classifieds` ( |
||
| 6 | `classifieduuid` char(36) NOT NULL, |
||
| 7 | `creatoruuid` char(36) NOT NULL, |
||
| 8 | `creationdate` int(20) NOT NULL, |
||
| 9 | `expirationdate` int(20) NOT NULL, |
||
| 10 | `category` varchar(20) NOT NULL, |
||
| 11 | `name` varchar(255) NOT NULL, |
||
| 12 | `description` text NOT NULL, |
||
| 13 | `parceluuid` char(36) NOT NULL, |
||
| 14 | `parentestate` int(11) NOT NULL, |
||
| 15 | `snapshotuuid` char(36) NOT NULL, |
||
| 16 | `simname` varchar(255) NOT NULL, |
||
| 17 | `posglobal` varchar(255) NOT NULL, |
||
| 18 | `parcelname` varchar(255) NOT NULL, |
||
| 19 | `classifiedflags` int(8) NOT NULL, |
||
| 20 | `priceforlisting` int(5) NOT NULL, |
||
| 21 | PRIMARY KEY (`classifieduuid`) |
||
| 22 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
| 23 | |||
| 24 | |||
| 25 | CREATE TABLE IF NOT EXISTS `usernotes` ( |
||
| 26 | `useruuid` varchar(36) NOT NULL, |
||
| 27 | `targetuuid` varchar(36) NOT NULL, |
||
| 28 | `notes` text NOT NULL, |
||
| 29 | UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`) |
||
| 30 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
| 31 | |||
| 32 | |||
| 33 | CREATE TABLE IF NOT EXISTS `userpicks` ( |
||
| 34 | `pickuuid` varchar(36) NOT NULL, |
||
| 35 | `creatoruuid` varchar(36) NOT NULL, |
||
| 36 | `toppick` enum('true','false') NOT NULL, |
||
| 37 | `parceluuid` varchar(36) NOT NULL, |
||
| 38 | `name` varchar(255) NOT NULL, |
||
| 39 | `description` text NOT NULL, |
||
| 40 | `snapshotuuid` varchar(36) NOT NULL, |
||
| 41 | `user` varchar(255) NOT NULL, |
||
| 42 | `originalname` varchar(255) NOT NULL, |
||
| 43 | `simname` varchar(255) NOT NULL, |
||
| 44 | `posglobal` varchar(255) NOT NULL, |
||
| 45 | `sortorder` int(2) NOT NULL, |
||
| 46 | `enabled` enum('true','false') NOT NULL, |
||
| 47 | PRIMARY KEY (`pickuuid`) |
||
| 48 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
| 49 | |||
| 50 | |||
| 51 | CREATE TABLE IF NOT EXISTS `userprofile` ( |
||
| 52 | `useruuid` varchar(36) NOT NULL, |
||
| 53 | `profilePartner` varchar(36) NOT NULL, |
||
| 54 | `profileAllowPublish` binary(1) NOT NULL, |
||
| 55 | `profileMaturePublish` binary(1) NOT NULL, |
||
| 56 | `profileURL` varchar(255) NOT NULL, |
||
| 57 | `profileWantToMask` int(3) NOT NULL, |
||
| 58 | `profileWantToText` text NOT NULL, |
||
| 59 | `profileSkillsMask` int(3) NOT NULL, |
||
| 60 | `profileSkillsText` text NOT NULL, |
||
| 61 | `profileLanguages` text NOT NULL, |
||
| 62 | `profileImage` varchar(36) NOT NULL, |
||
| 63 | `profileAboutText` text NOT NULL, |
||
| 64 | `profileFirstImage` varchar(36) NOT NULL, |
||
| 65 | `profileFirstText` text NOT NULL, |
||
| 66 | PRIMARY KEY (`useruuid`) |
||
| 67 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
| 68 | |||
| 69 | commit; |
||
| 70 | |||
| 71 | :VERSION 2 # ------------------------------- |
||
| 72 | |||
| 73 | begin; |
||
| 74 | CREATE TABLE IF NOT EXISTS `userdata` ( |
||
| 75 | `UserId` char(36) NOT NULL, |
||
| 76 | `TagId` varchar(64) NOT NULL, |
||
| 77 | `DataKey` varchar(255), |
||
| 78 | `DataVal` varchar(255), |
||
| 79 | PRIMARY KEY (`UserId`,`TagId`) |
||
| 80 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
| 81 | |||
| 82 | commit; |
||
| 83 | |||
| 84 | :VERSION 3 # ------------------------------- |
||
| 85 | begin; |
||
| 86 | CREATE TABLE IF NOT EXISTS `usersettings` ( |
||
| 87 | `useruuid` varchar(36) NOT NULL, |
||
| 88 | `imviaemail` enum('true','false') NOT NULL, |
||
| 89 | `visible` enum('true','false') NOT NULL, |
||
| 90 | `email` varchar(254) NOT NULL, |
||
| 91 | PRIMARY KEY (`useruuid`) |
||
| 92 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
| 93 | commit; |