53fe204eed
MyISAM isn't properly replicated using row based replication. With the advances in clustering, these systems are becoming more prevalent and MyISAM isn't up to the task anymore.
87 lines
2.7 KiB
Plaintext
87 lines
2.7 KiB
Plaintext
:VERSION 5 # -------------------------------
|
|
|
|
begin;
|
|
|
|
CREATE TABLE IF NOT EXISTS `classifieds` (
|
|
`classifieduuid` char(36) NOT NULL,
|
|
`creatoruuid` char(36) NOT NULL,
|
|
`creationdate` int(20) NOT NULL,
|
|
`expirationdate` int(20) NOT NULL,
|
|
`category` varchar(20) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text NOT NULL,
|
|
`parceluuid` char(36) NOT NULL,
|
|
`parentestate` int(11) NOT NULL,
|
|
`snapshotuuid` char(36) NOT NULL,
|
|
`simname` varchar(255) NOT NULL,
|
|
`posglobal` varchar(255) NOT NULL,
|
|
`parcelname` varchar(255) NOT NULL,
|
|
`classifiedflags` int(8) NOT NULL,
|
|
`priceforlisting` int(5) NOT NULL,
|
|
PRIMARY KEY (`classifieduuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `usernotes` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`targetuuid` varchar(36) NOT NULL,
|
|
`notes` text NOT NULL,
|
|
UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `userpicks` (
|
|
`pickuuid` varchar(36) NOT NULL,
|
|
`creatoruuid` varchar(36) NOT NULL,
|
|
`toppick` enum('true','false') NOT NULL,
|
|
`parceluuid` varchar(36) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text NOT NULL,
|
|
`snapshotuuid` varchar(36) NOT NULL,
|
|
`user` varchar(255) NOT NULL,
|
|
`originalname` varchar(255) NOT NULL,
|
|
`simname` varchar(255) NOT NULL,
|
|
`posglobal` varchar(255) NOT NULL,
|
|
`sortorder` int(2) NOT NULL,
|
|
`enabled` enum('true','false') NOT NULL,
|
|
`gatekeeper` varchar(255),
|
|
PRIMARY KEY (`pickuuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `userprofile` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`profilePartner` varchar(36) NOT NULL,
|
|
`profileAllowPublish` binary(1) NOT NULL,
|
|
`profileMaturePublish` binary(1) NOT NULL,
|
|
`profileURL` varchar(255) NOT NULL,
|
|
`profileWantToMask` int(3) NOT NULL,
|
|
`profileWantToText` text NOT NULL,
|
|
`profileSkillsMask` int(3) NOT NULL,
|
|
`profileSkillsText` text NOT NULL,
|
|
`profileLanguages` text NOT NULL,
|
|
`profileImage` varchar(36) NOT NULL,
|
|
`profileAboutText` text NOT NULL,
|
|
`profileFirstImage` varchar(36) NOT NULL,
|
|
`profileFirstText` text NOT NULL,
|
|
PRIMARY KEY (`useruuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE IF NOT EXISTS `userdata` (
|
|
`UserId` char(36) NOT NULL,
|
|
`TagId` varchar(64) NOT NULL,
|
|
`DataKey` varchar(255),
|
|
`DataVal` varchar(255),
|
|
PRIMARY KEY (`UserId`,`TagId`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE IF NOT EXISTS `usersettings` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`imviaemail` enum('true','false') NOT NULL,
|
|
`visible` enum('true','false') NOT NULL,
|
|
`email` varchar(254) NOT NULL,
|
|
PRIMARY KEY (`useruuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
commit;
|