Changeset 499 for trunk/admin/Updates.php

Timestamp:

Mar 3, 2013, 11:27:30 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Tabulky pro evidenci importu plateb z účtu a pro seznam měn.

File:

• trunk/admin/Updates.php (modified) (2 diffs)

trunk/admin/Updates.php

@@ -76 +76 @@
 }
 
+function UpdateTo499($Manager)
+{
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `Currency` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Code` varchar(3) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `Symbol` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+
+INSERT INTO `Currency` (`Id`, `Code`, `Name`, `Symbol`) VALUES
+(1, 'CZK', 'Česká koruna', 'Kč'),
+(2, 'EUR', 'Euro', '€'),
+(3, 'USD', 'Americký dolar', '$'),
+(4, 'CNY', 'Čínský jüan', '¥');");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `FinanceBankImport` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `BankAccount` int(11) NOT NULL,
+  `Time` date NOT NULL,
+  `Identification` varchar(255) NOT NULL,
+  `AccountNumber` varchar(255) NOT NULL,
+  `VariableSymbol` varchar(255) NOT NULL,
+  `ConstantSymbol` varchar(255) NOT NULL,
+  `SpecificSymbol` varchar(255) NOT NULL,
+  `Value` decimal(10,0) NOT NULL,
+  `Currency` int(11) NOT NULL,
+  `Description` varchar(255) NOT NULL,
+  `OffsetAccountName` varchar(255) NOT NULL,
+  `FinanceOperation` int(11) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `FinanceOperation` (`FinanceOperation`),
+  KEY `Currency` (`Currency`),
+  KEY `BankAccount` (`BankAccount`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+ALTER TABLE `FinanceBankImport`
+  ADD CONSTRAINT `FinanceBankImport_ibfk_3` FOREIGN KEY (`FinanceOperation`) REFERENCES `FinanceOperation` (`Id`),
+  ADD CONSTRAINT `FinanceBankImport_ibfk_1` FOREIGN KEY (`BankAccount`) REFERENCES `FinanceBankAccount` (`Id`),
+  ADD CONSTRAINT `FinanceBankImport_ibfk_2` FOREIGN KEY (`Currency`) REFERENCES `Currency` (`Id`);");
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`)".
+  "VALUES (NULL , 'Měny', '2', 'Currency', '');");
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+    "VALUES (NULL , 'Import z účtu', '2', 'FinanceBankImport', '');");
+}
+
 $Updates = array(
         491 => array('Revision' => 493, 'Function' => 'UpdateTo493'),
@@ -81 +126 @@
   494 => array('Revision' => 495, 'Function' => 'UpdateTo495'),
   495 => array('Revision' => 497, 'Function' => 'UpdateTo497'),
-  497 => array('Revision' => 497, 'Function' => 'UpdateTo498'),
+  497 => array('Revision' => 498, 'Function' => 'UpdateTo498'),
+  498 => array('Revision' => 499, 'Function' => 'UpdateTo499'),
 );