Changeset 275 for trunk/sql/updates/272.sql

Timestamp:

Jan 24, 2010, 8:05:10 AM (15 years ago)

Author:

george

Message:

• Upraveno: Nově rozšířená tabulka dokladových řad pro podporu oddělených účetních roků.
• Opraveno: Nové volání funkcí pro IPv4 ze skriptů generování nastavení sítě.

File:

• trunk/sql/updates/272.sql (modified) (2 diffs)

trunk/sql/updates/272.sql

@@ -1 +1 @@
 ALTER TABLE `NetworkDomainAlias` ADD `Comment` VARCHAR( 255 ) NOT NULL ;
-
-ALTER TABLE `DocumentLine` ADD `Year` INT NOT NULL AFTER `Name` ;
-UPDATE DocumentLine SET Year = 2009;
 
 CREATE TABLE IF NOT EXISTS `NetworkInterfacePortable` (
@@ -13 +10 @@
   KEY `NetworkInterface` (`NetworkInterface`),
   KEY `Update` (`Update`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+
+DROP TABLE IF EXISTS `DocumentLineSequence`;
+CREATE TABLE IF NOT EXISTS `DocumentLineSequence` (
+  `Id` int(11) NOT NULL auto_increment,
+  `DocumentLine` int(11) NOT NULL,
+  `FinanceYear` int(11) NOT NULL,
+  `NextNumber` int(11) NOT NULL,
+  `YearPrefix` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`),
+  KEY `DocumentLine` (`DocumentLine`),
+  KEY `FinanceYear` (`FinanceYear`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+
+INSERT INTO DocumentLineSequence (SELECT "" AS Id, Id AS DocumentLine, 3 AS FinanceYear, NextNumber, 0 AS YearPrefix FROM `DocumentLine`);
+INSERT INTO DocumentLineSequence (SELECT "" AS Id, Id AS DocumentLine, 4 AS FinanceYear, 1 AS NextNumber, 1 AS YearPrefix FROM `DocumentLine`);
+
+ALTER TABLE `DocumentLine` DROP `NextNumber` ;