Changeset 51 for trunk/SQL/Structure.sql
- Timestamp:
- Jan 2, 2020, 12:34:24 AM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/SQL/Structure.sql
r50 r51 44 44 PRIMARY KEY (`Id`) 45 45 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; 46 47 -- Export dat nebyl vybrán. 48 49 -- Exportování struktury pro tabulka tanec.Event 50 CREATE TABLE IF NOT EXISTS `Event` ( 51 `Id` int(11) NOT NULL AUTO_INCREMENT, 52 `TimeFrom` datetime DEFAULT NULL, 53 `TimeTo` datetime DEFAULT NULL, 54 `Source` int(11) DEFAULT NULL, 55 `Link` varchar(255) DEFAULT NULL, 56 `Hidden` int(11) DEFAULT 0, 57 `Description` text DEFAULT NULL, 58 `Title` varchar(255) DEFAULT NULL, 59 `Price` int(11) DEFAULT NULL, 60 `Location` varchar(255) DEFAULT NULL, 61 `TimeImport` datetime DEFAULT NULL, 62 `RemoteId` varchar(255) DEFAULT NULL, 63 PRIMARY KEY (`Id`), 64 KEY `Source` (`Source`) 65 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4; 66 67 -- Export dat nebyl vybrán. 68 69 -- Exportování struktury pro tabulka tanec.EventSource 70 CREATE TABLE IF NOT EXISTS `EventSource` ( 71 `Id` int(11) NOT NULL AUTO_INCREMENT, 72 `Name` varchar(255) DEFAULT NULL, 73 `Method` varchar(255) DEFAULT NULL, 74 `URL` varchar(255) DEFAULT NULL, 75 PRIMARY KEY (`Id`) 76 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; 46 77 47 78 -- Export dat nebyl vybrán.
Note:
See TracChangeset
for help on using the changeset viewer.