Changeset 275 for trunk/sql

Timestamp:

Jan 24, 2010, 8:05:10 AM (16 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ě.

Location:

trunk/sql/updates

Files:

• 266.sql (modified) (1 diff)
• 272.sql (modified) (2 diffs)

trunk/sql/updates/266.sql

@@ -1 @@
-CREATE TABLE `NetworkMangleSubgroup` (
-`Id` INT NOT NULL AUTO_INCREMENT ,
-`AddressRange` VARCHAR( 255 ) NOT NULL ,
-PRIMARY KEY ( `Id` ) ;
-
-ALTER TABLE `NetworkMangleSubgroup` ADD INDEX ( `AddressRange` ) ;
+CREATE TABLE IF NOT EXISTS `NetworkMangleSubgroup` (
+  `Id` int(11) NOT NULL auto_increment,
+  `AddressRange` varchar(255) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`Id`),
+  KEY `AddressRange` (`AddressRange`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;
 
 INSERT INTO `NetworkMangleSubgroup` (

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` ;