Changeset 37 for trunk/SQL/Update.php

Timestamp:

May 5, 2019, 5:17:06 PM (5 years ago)

Author:

chronos

Message:

• Modified: Application made using classes System and Application.
• Modified: Used Common package for better code reuse.
• Modified: Application made modular. Web sections converted to application modules. They will register pages in main application object.

File:

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

trunk/SQL/Update.php

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