|
Last change
on this file was 40, checked in by george, 15 years ago |
- Upraveno: Struktura souborů projektu přepracována na systém MVC.
|
|
File size:
1002 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE IF NOT EXISTS `measure` (
|
|---|
| 2 | `Id` int(11) NOT NULL auto_increment,
|
|---|
| 3 | `Name` varchar(255) collate latin2_czech_cs NOT NULL,
|
|---|
| 4 | `Description` varchar(255) collate latin2_czech_cs NOT NULL,
|
|---|
| 5 | `Divider` int(11) NOT NULL default '1',
|
|---|
| 6 | `Unit` varchar(16) collate latin2_czech_cs NOT NULL,
|
|---|
| 7 | `Continuity` tinyint(1) NOT NULL default '0',
|
|---|
| 8 | `Period` int(11) NOT NULL default '60',
|
|---|
| 9 | `OldName` varchar(32) collate latin2_czech_cs NOT NULL,
|
|---|
| 10 | `PermissionView` varchar(255) collate latin2_czech_cs NOT NULL default 'all',
|
|---|
| 11 | `PermissionAdd` varchar(255) collate latin2_czech_cs NOT NULL default 'localhost.localdomain',
|
|---|
| 12 | `Info` varchar(255) collate latin2_czech_cs NOT NULL,
|
|---|
| 13 | `Enabled` int(11) NOT NULL default '1',
|
|---|
| 14 | `Cumulative` int(11) NOT NULL default '0',
|
|---|
| 15 | `DataTable` varchar(32) collate latin2_czech_cs NOT NULL default 'data',
|
|---|
| 16 | `DataType` varchar(32) collate latin2_czech_cs NOT NULL,
|
|---|
| 17 | PRIMARY KEY (`Id`)
|
|---|
| 18 | ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
