Changeset 37 for trunk/SQL


Ignore:
Timestamp:
May 5, 2019, 5:17:06 PM (6 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/SQL/Update.php

    r34 r37  
    1414
    1515ALTER TABLE `MeetItem` ADD `TimeImport` DATETIME NULL AFTER `Link`;
     16
     17-- rev 35
     18CREATE TABLE `Movie` (
     19  `Id` int(11) NOT NULL,
     20  `NameCz` varchar(255) NOT NULL,
     21  `NameEn` varchar(255) NOT NULL,
     22  `Year` int(11) NOT NULL,
     23  `Imdb` varchar(255) NOT NULL,
     24  `Csfd` varchar(255) NOT NULL
     25) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     26
     27ALTER TABLE `Movie`
     28  ADD PRIMARY KEY (`Id`),
     29  ADD KEY `Year` (`Year`);
     30
     31ALTER TABLE `Movie`
     32  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
Note: See TracChangeset for help on using the changeset viewer.