Changeset 441 for trunk/sql/updates/50.sql

Timestamp:

Oct 13, 2012, 6:54:59 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Prohlížení Záznamů systému do Správy dat.

File:

• trunk/sql/updates/50.sql (moved) (moved from trunk/sql/updates/50_is_finance_charge.sql ) (1 diff)

trunk/sql/updates/50.sql

@@ -1 +1 @@
 ALTER TABLE `finance_charge` ADD `BaseTariffPrice` INT( 11 ) DEFAULT '0' NOT NULL AFTER `base_speed_element` ;
+ALTER TABLE `finance_charge` ADD `TopTariffPrice` INT( 11 ) DEFAULT '0' NOT NULL AFTER `BaseTariffPrice` ;
 
-ALTER TABLE `finance_charge` ADD `TopTariffPrice` INT( 11 ) DEFAULT '0' NOT NULL AFTER `BaseTariffPrice` ;
+ALTER TABLE `finance_monthly_overall` ADD `BaseTariffPrice` INT( 11 ) DEFAULT '0' NOT NULL AFTER `total_paid` ;
+ALTER TABLE `finance_monthly_overall` ADD `TopTariffPrice` INT( 11 ) DEFAULT '0' NOT NULL AFTER `BaseTariffPrice` ;
+
+UPDATE users SET role=2 WHERE role=0;
+
+CREATE TABLE IF NOT EXISTS `users_roles` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Description` varchar(128) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
+
+INSERT INTO `users_roles` (`Id`, `Description`) VALUES
+(1, 'Uživatel'),
+(2, 'Zástupce za domácnost');