Changeset 51 for trunk/SQL

Timestamp:

Jan 2, 2020, 12:34:24 AM (5 years ago)

Author:

chronos

Message:

• Added: New section Events to import dance events from various dance clubs and dance schools.

Location:

trunk/SQL

Files:

• Structure.sql (modified) (1 diff)
• Update.php (modified) (1 diff)

trunk/SQL/Structure.sql

@@ -44 +44 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+-- Export dat nebyl vybrán.
+
+-- Exportování struktury pro tabulka tanec.Event
+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;
+
+-- Export dat nebyl vybrán.
+
+-- Exportování struktury pro tabulka tanec.EventSource
+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;
 
 -- Export dat nebyl vybrán.

trunk/SQL/Update.php

@@ -56 +56 @@
 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;