Context Navigation

6.sql

Last change on this file was 5, checked in by chronos, 12 years ago
Added: Required packages.
File size: 739 bytes

Line
1	ALTER TABLE `User` ADD `PersonalId` INT NOT NULL AFTER `Id` ;
2	ALTER TABLE `User` CHANGE `Note` `Note` TEXT NOT NULL ;
3	ALTER TABLE `Terminal` CHANGE `Addreess` `Address` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ;
4	ALTER TABLE `Terminal` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
5	ALTER TABLE `User` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
6	ALTER TABLE `Log` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
7	ALTER TABLE `Attendance` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
8	ALTER TABLE `Passage` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
9	ALTER TABLE `Operation` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
10	ALTER TABLE `Holiday` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;

Note: See TracBrowser for help on using the repository browser.