|
Last change
on this file was 69, checked in by george, 15 years ago |
- Rozpracovaná verze.
- Přeorganizována struktura souborů projektu.
- Názvy přepány na stejné s prvním velkým písmenem.
- Uživatelské podsložky přesunuty do podsložky Application, systémové do podsložky Base.
- Použití koncepce Model-View-Controller.
|
|
File size:
652 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `History` (
|
|---|
| 2 | `Time` int(11) NOT NULL,
|
|---|
| 3 | `Period` int(11) NOT NULL,
|
|---|
| 4 | `Measure` int(11) NOT NULL,
|
|---|
| 5 | `Server` int(11) NOT NULL,
|
|---|
| 6 | `Minimum` double NOT NULL,
|
|---|
| 7 | `Average` double NOT NULL,
|
|---|
| 8 | `Maximum` double NOT NULL,
|
|---|
| 9 | UNIQUE KEY `Time_2` (`Time`,`Period`,`Measure`,`Server`),
|
|---|
| 10 | KEY `Time` (`Time`),
|
|---|
| 11 | KEY `Measure` (`Measure`),
|
|---|
| 12 | KEY `Server` (`Server`),
|
|---|
| 13 | KEY `Period` (`Period`)
|
|---|
| 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|---|
| 15 |
|
|---|
| 16 | ALTER TABLE `Task` CHANGE `TimeCreate` `TimeCreate` DATETIME NULL ,
|
|---|
| 17 | CHANGE `TimeStart` `TimeStart` DATETIME NULL ,
|
|---|
| 18 | CHANGE `TimeEnd` `TimeEnd` DATETIME NULL ;
|
|---|
| 19 |
|
|---|
| 20 | ALTER TABLE `Task` ADD `Error` TEXT NOT NULL ;
|
|---|
| 21 |
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
