Changeset 40 for trunk/SQL/Update.php

Timestamp:

May 5, 2019, 11:48:18 PM (6 years ago)

Author:

chronos

Message:

• Added: New table DanceFigure to represent various dancing figures.

File:

• trunk/SQL/Update.php (modified) (1 diff)

trunk/SQL/Update.php

@@ -31 +31 @@
 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`);