|
Last change
on this file was 46, checked in by chronos, 11 years ago |
- Opraveno: SQL aktualizace 40 plus chybějící tabulka MeasureMethod.
- Opraveno: Neplatné ukázkové konfigurační soubory.
|
|
File size:
394 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `MeasureMethod` (
|
|---|
| 2 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 3 | `Name` varchar(255) NOT NULL,
|
|---|
| 4 | PRIMARY KEY (`Id`)
|
|---|
| 5 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
|
|---|
| 6 |
|
|---|
| 7 | ALTER TABLE `Measure` ADD `Method` INT NULL ,
|
|---|
| 8 | ADD INDEX ( `Method` ) ;
|
|---|
| 9 |
|
|---|
| 10 | ALTER TABLE `Measure` ADD FOREIGN KEY ( `Method` ) REFERENCES `MeasureMethod` (
|
|---|
| 11 | `Id`
|
|---|
| 12 | ) ON DELETE RESTRICT ON UPDATE RESTRICT ;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
