Changeset 70 for trunk/Modules/Measure

Timestamp:

Jun 30, 2016, 9:24:21 PM (8 years ago)

Author:

chronos

Message:

• Added: Missing Measure Page file.
• Added: Measure module table SQL create and remove.

Location:

trunk/Modules/Measure

Files:

• Measure.php (modified) (1 diff)
• Page.php (added)

trunk/Modules/Measure/Measure.php

@@ -19 +19 @@
   {
     $this->System->RegisterPage('', 'PageMain');
+  }
+  
+  function DoInstall()
+  {
+   $this->Database->query('CREATE TABLE IF NOT EXISTS `Measure` (
+  `Id` int(11) NOT NULL auto_increment,
+  `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 utf8_general_ci NOT NULL,
+  `Continuity` tinyint(1) NOT NULL default 0,
+  `Period` int(11) NOT NULL default 60,
+  `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 utf8_general_ci NOT NULL default "data",
+  `DataType` varchar(32) collate utf8_general_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;');
+   }
+  
+  function DoUninstall()
+  {
+    $this->Database->query('DROP TABLE IF EXISTS `Measure`');
+  }
+  
+  function DoUpgrade()
+  {
+   
   }
 }