Changeset 507 for trunk/sql/updates/479.sql

Timestamp:

Apr 1, 2013, 7:14:59 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Generování nastavení sítě. Generování front Queue nyní pracuje s přiřazením služeb k zařízením a podsítím.
• Opraveno: Zjišťování adresáře souborů na disku dle id adresáře.

File:

• trunk/sql/updates/479.sql (modified) (1 diff)

trunk/sql/updates/479.sql

@@ -46 +46 @@
 -- Transform data from FinanceTariff
 INSERT INTO Service (SELECT Id AS Id, Name, `Group` AS Category, Price, MemberCount AS CustomerCount, 
-ReplaceId, Public, SpeedMax AS InternetSpeedMax, SpeedMin AS InternetSpeedMin, 
+ReplaceId, Public, SpeedMin AS InternetSpeedMin, SpeedMax AS InternetSpeedMax,
 UploadAsymmetry, 0 AS Memory, 0 AS MemorySwap, 0 AS Storage, 0 AS CPUCount FROM FinanceTariff);
 
-INSERT INTO ServiceCustomerRel (SELECT NULL AS Id, InternetTariffCurrentMonth AS Serice, Id AS Customer, 0 AS Period FROM `Member`);
-INSERT INTO ServiceCustomerRel (SELECT NULL AS Id, InternetTariffNextMonth AS Serice, Id AS Customer, 1 AS Period FROM `Member`);
+INSERT INTO ServiceCustomerRel (SELECT NULL AS Id, InternetTariffCurrentMonth AS Service, Id AS Customer, 0 AS Period FROM `Member`);
+INSERT INTO ServiceCustomerRel (SELECT NULL AS Id, InternetTariffNextMonth AS Service, Id AS Customer, 1 AS Period FROM `Member`);
 
 ALTER TABLE `Member` DROP FOREIGN KEY `Member_ibfk_25` ;