Changeset 417 for trunk/sql

Timestamp:

Oct 8, 2012, 9:36:55 AM (13 years ago)

Author:

chronos

Message:

• Odstraněno: Starý soubor style.php pro generování kostry stránky.

Location:

trunk/sql/updates

Files:

• 402.sql (modified) (1 diff)
• 406.sql (modified) (1 diff)
• 407.sql (modified) (1 diff)
• 408.sql (modified) (1 diff)
• 409.sql (modified) (1 diff)
• 410.sql (modified) (1 diff)
• 411.sql (modified) (1 diff)

trunk/sql/updates/402.sql

@@ +1 @@
+CREATE TABLE IF NOT EXISTS `SystemVersion` (
+  `Rev402` bit(1) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
 ALTER TABLE `FinanceOperation` ADD `BankAccount` INT NULL COMMENT 'FinanceBankAccount',
 ADD `Treasury` INT NULL COMMENT 'FinanceTreasury';

trunk/sql/updates/406.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev402 Rev406 bit;
+
 ALTER TABLE `PermissionGroupAssignment` ADD `AssignedGroup` INT NULL ,
 ADD `AssignedOperation` INT NULL ,

trunk/sql/updates/407.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev406 Rev407 bit;
+
 RENAME TABLE `finance_monthly_overall` TO `FinanceMonthlyOverall` ;
 

trunk/sql/updates/408.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev407 Rev408 bit;
+
 RENAME TABLE `network_segments` TO `NetworkSegment` ;
 

trunk/sql/updates/409.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev408 Rev409 bit;
+
 RENAME TABLE `finance_groups` TO `FinanceGroup` ;
 RENAME TABLE `hosts_topology` TO `NetworkTopology` ;

trunk/sql/updates/410.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev409 Rev410 bit;
+
 CREATE TABLE IF NOT EXISTS `UserCustomerRel` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,

trunk/sql/updates/411.sql

@@ +1 @@
+ALTER TABLE SystemVersion CHANGE COLUMN Rev410 Rev411 bit;
+
 ALTER TABLE `NetworkDomainAlias` ADD UNIQUE (`Name` , `Target`);
 ALTER TABLE `TV` ADD UNIQUE (`ShortName`);