source: trunk/SQL/Update.php

ALTER TABLE `MeetItem` ADD `Link` VARCHAR(255) NOT NULL AFTER `Location`;

UPDATE `MeetItem` SET `Age`=0 WHERE `Age`="";
ALTER TABLE `MeetItem` CHANGE `Age` `Age` INT NULL DEFAULT NULL;
UPDATE `MeetItem` SET `Age`=NULL WHERE `Age`=0;
UPDATE `MeetItem` SET `Height`=0 WHERE `Height`="";
ALTER TABLE `MeetItem` CHANGE `Height` `Height` INT NULL DEFAULT NULL;
UPDATE `MeetItem` SET `Height`=NULL WHERE `Height`=0;
UPDATE `MeetItem` SET `Weight`=0 WHERE `Weight`="";
ALTER TABLE `MeetItem` CHANGE `Weight` `Weight` INT NULL DEFAULT NULL;
UPDATE `MeetItem` SET `Weight`=NULL WHERE `Weight`=0;

ALTER TABLE `MeetItem` CHANGE `Date` `Time` DATETIME NOT NULL;

ALTER TABLE `MeetItem` ADD `TimeImport` DATETIME NULL AFTER `Link`;

-- rev 35
CREATE TABLE `Movie` (
  `Id` int(11) NOT NULL,
  `NameCz` varchar(255) NOT NULL,
  `NameEn` varchar(255) NOT NULL,
  `Year` int(11) NOT NULL,
  `Imdb` varchar(255) NOT NULL,
  `Csfd` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `Movie`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `Year` (`Year`);

ALTER TABLE `Movie`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

CREATE TABLE `DanceFigure` (
  `Id` int(11) NOT NULL,
  `NameCz` varchar(255) NOT NULL,
  `NameEn` varchar(255) NOT NULL,
  `Dance` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `DanceFigure`
  ADD PRIMARY KEY (`Id`),
  ADD UNIQUE KEY `Id` (`Id`),
  ADD KEY `Dance` (`Dance`);

ALTER TABLE `DanceFigure`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `DanceFigure`
  ADD CONSTRAINT `DanceFigure_ibfk_1` FOREIGN KEY (`Dance`) REFERENCES `Dance` (`Id`);

ALTER TABLE `MeetItem`
  ADD COLUMN `RemoteId` VARCHAR(255) NULL DEFAULT NULL AFTER `TimeImport`;

-- rev 48
ALTER TABLE `MeetItem`
  ADD COLUMN `Hidden` INT NULL DEFAULT '0' AFTER `RemoteId`;

-- rev 51
CREATE TABLE IF NOT EXISTS `Event` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TimeFrom` datetime DEFAULT NULL,
  `TimeTo` datetime DEFAULT NULL,
  `Source` int(11) DEFAULT NULL,
  `Link` varchar(255) DEFAULT NULL,
  `Hidden` int(11) DEFAULT 0,
  `Description` text DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Price` int(11) DEFAULT NULL,
  `Location` varchar(255) DEFAULT NULL,
  `TimeImport` datetime DEFAULT NULL,
  `RemoteId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `Source` (`Source`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `EventSource` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Method` varchar(255) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

ALTER TABLE `MeetSource` ADD `Enabled` int(11) NOT NULL DEFAULT 1;

-- rev 65
ALTER TABLE `Dance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `DanceFigure` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `DanceGroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `Event` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `EventSource` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `MeetItem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `MeetSource` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `Movie` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `Music` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `Resource` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 
ALTER TABLE `ResourceGroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `School` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

-- rev 66
ALTER TABLE `MeetSource` ADD `InsertURL` VARCHAR(255) NOT NULL AFTER `Enabled`;