|
Last change
on this file was 51, checked in by chronos, 9 years ago |
- Modify: If measure not found then use default one.
|
|
File size:
416 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `data` (
|
|---|
| 2 | `time` datetime NOT NULL default '0000-00-00 00:00:00',
|
|---|
| 3 | `measure` smallint(11) NOT NULL default '0',
|
|---|
| 4 | `min` int(11) NOT NULL default '0',
|
|---|
| 5 | `avg` int(11) NOT NULL default '0',
|
|---|
| 6 | `max` int(11) NOT NULL default '0',
|
|---|
| 7 | `continuity` tinyint(1) NOT NULL default '0',
|
|---|
| 8 | `level` tinyint(4) NOT NULL default '0',
|
|---|
| 9 | KEY `time` (`time`)
|
|---|
| 10 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
