Fix email.

[stg.git] / projects / stargazer / inst / var / 00-alter-01.sql

diff --git a/projects/stargazer/inst/var/00-alter-01.sql b/projects/stargazer/inst/var/00-alter-01.sql
index f76ae5f8494ba33ba16ce454e98d1e30b2fc3eb5..3e9dd8f834ee0e9a6cd7f83a112ad571e2608ce0 100644 (file)
--- a/projects/stargazer/inst/var/00-alter-01.sql
+++ b/projects/stargazer/inst/var/00-alter-01.sql
@@ -7,15 +7,15 @@ alter table tb_users add disabled_detail_stat dm_bool;
 drop procedure sp_add_user;
 
 set term !! ;
 drop procedure sp_add_user;
 
 set term !! ;

-create procedure sp_add_user(name varchar(32), dirs integer)                             
-as  
+create procedure sp_add_user(name varchar(32), dirs integer)
+as

 declare variable pk_user integer;
 declare variable pk_user integer;

-declare variable pk_stat integer;                                                        
-begin                                                                                    
-    pk_user = gen_id(gn_pk_user, 1);                                                     
+declare variable pk_stat integer;
+begin
+    pk_user = gen_id(gn_pk_user, 1);

     insert into tb_users(pk_user, fk_tariff, fk_tariff_change, fk_corporation, address, always_online, credit, credit_expire, disabled, disabled_detail_stat, email, grp, note, passive, passwd, phone, name, real_name) values (:pk_user, NULL, NULL, NULL, '', 0, 0, 'now', 0, 0, '', '_', '', 0, '', '', :name, '');
     insert into tb_users(pk_user, fk_tariff, fk_tariff_change, fk_corporation, address, always_online, credit, credit_expire, disabled, disabled_detail_stat, email, grp, note, passive, passwd, phone, name, real_name) values (:pk_user, NULL, NULL, NULL, '', 0, 0, 'now', 0, 0, '', '_', '', 0, '', '', :name, '');

-    pk_stat = gen_id(gn_pk_stat, 1);                                                     
-    insert into tb_stats values (:pk_stat, :pk_user, 0, 0, 'now', 0, 'now', 0, 'now');   
+    pk_stat = gen_id(gn_pk_stat, 1);
+    insert into tb_stats values (:pk_stat, :pk_user, 0, 0, 'now', 0, 'now', 0, 'now');

     while (dirs > 0) do
     begin
         insert into tb_stats_traffic (fk_stat, dir_num, upload, download) values (:pk_stat, :dirs - 1, 0, 0);
     while (dirs > 0) do
     begin
         insert into tb_stats_traffic (fk_stat, dir_num, upload, download) values (:pk_stat, :dirs - 1, 0, 0);