Changeset 50 for branches/old/sql/23_measure.sql

Timestamp:

Feb 20, 2015, 8:54:42 AM (10 years ago)

Author:

chronos

Message:

• Modified: Show graph, table and other controls horizontally centered.
• Added: Check for existence of config file.
• Added: Check if database is accessible.

File:

• branches/old/sql/23_measure.sql (modified) (1 diff)

branches/old/sql/23_measure.sql

@@ -1 +1 @@
 CREATE TABLE IF NOT EXISTS `measure` (
   `Id` int(11) NOT NULL auto_increment,
-  `Name` varchar(255) collate latin2_czech_cs NOT NULL,
-  `Description` varchar(255) collate latin2_czech_cs NOT NULL,
+  `Name` varchar(255) collate utf8_general_ci NOT NULL,
+  `Description` varchar(255) collate utf8_general_ci NOT NULL,
   `Divider` int(11) NOT NULL default '1',
-  `Unit` varchar(16) collate latin2_czech_cs NOT NULL,
+  `Unit` varchar(16) collate utf8_general_ci NOT NULL,
   `Continuity` tinyint(1) NOT NULL default '0',
   `Period` int(11) NOT NULL default '60',
-  `OldName` varchar(32) collate latin2_czech_cs NOT NULL,
-  `PermissionView` varchar(255) collate latin2_czech_cs NOT NULL default 'all',
-  `PermissionAdd` varchar(255) collate latin2_czech_cs NOT NULL default 'localhost.localdomain',
-  `Info` varchar(255) collate latin2_czech_cs NOT NULL,
+  `OldName` varchar(32) collate utf8_general_ci NOT NULL,
+  `PermissionView` varchar(255) collate utf8_general_ci NOT NULL default 'all',
+  `PermissionAdd` varchar(255) collate utf8_general_ci NOT NULL default 'localhost.localdomain',
+  `Info` varchar(255) collate utf8_general_ci NOT NULL,
   `Enabled` int(11) NOT NULL default '1',
   `Cumulative` int(11) NOT NULL default '0',
-  `DataTable` varchar(32) collate latin2_czech_cs NOT NULL default 'data',
-  `DataType` varchar(32) collate latin2_czech_cs NOT NULL,
+  `DataTable` varchar(32) collate utf8_general_ci NOT NULL default 'data',
+  `DataType` varchar(32) collate utf8_general_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
+) ENGINE=InnoDb  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;