|
Last change
on this file was 50, checked in by chronos, 9 years ago |
- Modified: Show graph, table and other controls horizontally centered.
- Added: Check for existence of config file.
- Added: Check if database is accessible.
|
|
File size:
1000 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `measure` (
|
|---|
| 2 | `Id` int(11) NOT NULL auto_increment,
|
|---|
| 3 | `Name` varchar(255) collate utf8_general_ci NOT NULL,
|
|---|
| 4 | `Description` varchar(255) collate utf8_general_ci NOT NULL,
|
|---|
| 5 | `Divider` int(11) NOT NULL default '1',
|
|---|
| 6 | `Unit` varchar(16) collate utf8_general_ci NOT NULL,
|
|---|
| 7 | `Continuity` tinyint(1) NOT NULL default '0',
|
|---|
| 8 | `Period` int(11) NOT NULL default '60',
|
|---|
| 9 | `OldName` varchar(32) collate utf8_general_ci NOT NULL,
|
|---|
| 10 | `PermissionView` varchar(255) collate utf8_general_ci NOT NULL default 'all',
|
|---|
| 11 | `PermissionAdd` varchar(255) collate utf8_general_ci NOT NULL default 'localhost.localdomain',
|
|---|
| 12 | `Info` varchar(255) collate utf8_general_ci NOT NULL,
|
|---|
| 13 | `Enabled` int(11) NOT NULL default '1',
|
|---|
| 14 | `Cumulative` int(11) NOT NULL default '0',
|
|---|
| 15 | `DataTable` varchar(32) collate utf8_general_ci NOT NULL default 'data',
|
|---|
| 16 | `DataType` varchar(32) collate utf8_general_ci NOT NULL,
|
|---|
| 17 | PRIMARY KEY (`Id`)
|
|---|
| 18 | ) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
