- Timestamp:
- May 5, 2019, 11:48:18 PM (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/SQL/Update.php
r37 r40 31 31 ALTER TABLE `Movie` 32 32 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; 33 34 CREATE TABLE `DanceFigure` ( 35 `Id` int(11) NOT NULL, 36 `NameCz` varchar(255) NOT NULL, 37 `NameEn` varchar(255) NOT NULL, 38 `Dance` int(11) NOT NULL 39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 40 41 ALTER TABLE `DanceFigure` 42 ADD PRIMARY KEY (`Id`), 43 ADD UNIQUE KEY `Id` (`Id`), 44 ADD KEY `Dance` (`Dance`); 45 46 ALTER TABLE `DanceFigure` 47 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT; 48 49 ALTER TABLE `DanceFigure` 50 ADD CONSTRAINT `DanceFigure_ibfk_1` FOREIGN KEY (`Dance`) REFERENCES `Dance` (`Id`);
Note:
See TracChangeset
for help on using the changeset viewer.