Remove TravisCI file as well.

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

diff --git a/projects/stargazer/inst/var/00-base-00.sql b/projects/stargazer/inst/var/00-base-00.sql
index 4047bc1fda1f53331d739cbeab12155e76232a4b..f8785795b6da15257a7f08770e6ab6e9ff218506 100644 (file)
--- a/projects/stargazer/inst/var/00-base-00.sql
+++ b/projects/stargazer/inst/var/00-base-00.sql
@@ -31,9 +31,6 @@
  *          1 - down - считается по download
  *          2 - max - считается по максимальному среди upload/download
  *          3 - up+down - считается по сумме upload и download
  *          1 - down - считается по download
  *          2 - max - считается по максимальному среди upload/download
  *          3 - up+down - считается по сумме upload и download

- *        Как альтернативу этому полю можно сделать еще одну таблицу - типов
- *        подсчета трафика. И в этом поле хранить ссылку на эту таблицу.
- *        Вопрос только "А надо ли это?"

  *
  *      * dm_ip. IP адресс в виде четырех байтового целого числа со знаком.
  *        Выполнять приведение к знаковуму целому при занесении IP в БД!!!
  *
  *      * dm_ip. IP адресс в виде четырех байтового целого числа со знаком.
  *        Выполнять приведение к знаковуму целому при занесении IP в БД!!!


@@ -57,7 +54,7 @@
  * CREATE DATABASE 'localhost:/var/stg/stargazer.fdb' USER 'stg' PASSWORD '123456' DEFAULT CHARACTER SET UTF8;
  */
 
  * CREATE DATABASE 'localhost:/var/stg/stargazer.fdb' USER 'stg' PASSWORD '123456' DEFAULT CHARACTER SET UTF8;
  */
 

- 
+

 
 /*
  *****************************************************************************
 
 /*
  *****************************************************************************


@@ -99,15 +96,15 @@ CREATE DOMAIN dm_phone AS VARCHAR(256) DEFAULT '';
 CREATE DOMAIN dm_user_name AS VARCHAR(256) DEFAULT '';
 CREATE DOMAIN dm_service_comment AS VARCHAR(256) DEFAULT '';
 CREATE DOMAIN dm_service_name AS VARCHAR(32) DEFAULT '';
 CREATE DOMAIN dm_user_name AS VARCHAR(256) DEFAULT '';
 CREATE DOMAIN dm_service_comment AS VARCHAR(256) DEFAULT '';
 CREATE DOMAIN dm_service_name AS VARCHAR(32) DEFAULT '';

-/* TODO: why 0-31? Which is default? */
+

 CREATE DOMAIN dm_pay_day AS SMALLINT NOT NULL
     CHECK ( VALUE BETWEEN 0 AND 31 );
 CREATE DOMAIN dm_period AS INTEGER NOT NULL;
 CREATE DOMAIN dm_counter AS SMALLINT NOT NULL;
 CREATE DOMAIN dm_pay_day AS SMALLINT NOT NULL
     CHECK ( VALUE BETWEEN 0 AND 31 );
 CREATE DOMAIN dm_period AS INTEGER NOT NULL;
 CREATE DOMAIN dm_counter AS SMALLINT NOT NULL;

-/* Is it needded? */
+

 CREATE DOMAIN dm_message_ver AS INTEGER NOT NULL;
 CREATE DOMAIN dm_message_type AS INTEGER NOT NULL;
 CREATE DOMAIN dm_message_ver AS INTEGER NOT NULL;
 CREATE DOMAIN dm_message_type AS INTEGER NOT NULL;

-/*----------------*/
+

 CREATE DOMAIN dm_message AS VARCHAR(256) NOT NULL;
 CREATE DOMAIN dm_user_data AS VARCHAR(256) NOT NULL;
 CREATE DOMAIN dm_session_event_type AS CHAR(1) NOT NULL
 CREATE DOMAIN dm_message AS VARCHAR(256) NOT NULL;
 CREATE DOMAIN dm_user_data AS VARCHAR(256) NOT NULL;
 CREATE DOMAIN dm_session_event_type AS CHAR(1) NOT NULL


@@ -278,7 +275,7 @@ CREATE TABLE tb_users_data
 (
     pk_user_data dm_id PRIMARY KEY,
     fk_user dm_id,
 (
     pk_user_data dm_id PRIMARY KEY,
     fk_user dm_id,

-    num dm_num, /* data_id dm_id renamed */
+    num dm_num,

     data dm_user_data,
 
     FOREIGN KEY (fk_user) REFERENCES tb_users (pk_user)
     data dm_user_data,
 
     FOREIGN KEY (fk_user) REFERENCES tb_users (pk_user)


@@ -407,16 +404,6 @@ BEGIN
 END !!
 SET TERM ; !!
 
 END !!
 SET TERM ; !!
 

-/*set term !! ;
-create trigger tr_tariff_bi for tb_tariffs active
-before insert position 0
-as
-begin
-    if (new.pk_tariff is null)
-    then new.pk_tariff = gen_id(gn_pk_tariff, 1);
-end !!
-set term ; !!*/
-

 set term !! ;
 create trigger tr_tariff_param_bi for tb_tariffs_params active
 before insert position 0
 set term !! ;
 create trigger tr_tariff_param_bi for tb_tariffs_params active
 before insert position 0


@@ -437,16 +424,6 @@ begin
 end !!
 set term ; !!
 
 end !!
 set term ; !!
 

-/*set term !! ;
-create trigger tr_user_bi for tb_users active
-before insert position 0
-as
-begin
-    if (new.pk_user is null)
-    then new.pk_user = gen_id(gn_pk_user, 1);
-end !!
-set term ; !!*/
-

 set term !! ;
 create trigger tr_detail_stat_bi for tb_detail_stats active
 before insert position 0
 set term !! ;
 create trigger tr_detail_stat_bi for tb_detail_stats active
 before insert position 0


@@ -477,26 +454,6 @@ begin
 end !!
 set term ; !!
 
 end !!
 set term ; !!
 

-/*set term !! ;
-create trigger tr_message_bi for tb_messages active
-before insert position 0
-as
-begin
-    if (new.pk_message is null)
-    then new.pk_message = gen_id(gn_pk_message, 1);
-end !!
-set term ; !!*/
-
-/*set term !! ;
-create trigger tr_stat_bi for tb_stats active
-before insert position 0
-as
-begin
-    if (new.pk_stat is null)
-    then new.pk_stat = gen_id(gn_pk_stat, 1);
-end !!
-set term ; !!*/
-

 set term !! ;
 create trigger tr_stat_traffic_bi for tb_stats_traffic active
 before insert position 0
 set term !! ;
 create trigger tr_stat_traffic_bi for tb_stats_traffic active
 before insert position 0


@@ -527,16 +484,6 @@ begin
 end !!
 set term ; !!
 
 end !!
 set term ; !!
 

-/*set term !! ;
-create trigger tr_session_log_bi for tb_sessions_log active
-before insert position 0
-as
-begin
-    if (new.pk_session_log is null)
-    then new.pk_session_log = gen_id(gn_pk_session_log, 1);
-end !!
-set term ; !!*/
-

 set term !! ;
 create trigger tr_session_data_bi for tb_sessions_data active
 before insert position 0
 set term !! ;
 create trigger tr_session_data_bi for tb_sessions_data active
 before insert position 0


@@ -579,7 +526,7 @@ set term ; !!
 set term !! ;
 create procedure sp_add_message(pk_message integer, login varchar(32), ver integer, msg_type integer, last_send_time integer, creation_time integer, show_time integer, repeat integer, repeat_period integer, msg_text varchar(256))
 returns(res integer)
 set term !! ;
 create procedure sp_add_message(pk_message integer, login varchar(32), ver integer, msg_type integer, last_send_time integer, creation_time integer, show_time integer, repeat integer, repeat_period integer, msg_text varchar(256))
 returns(res integer)

-as  
+as

 begin
     if (:pk_message is null) then
     begin
 begin
     if (:pk_message is null) then
     begin


@@ -589,7 +536,7 @@ begin
                                        :ver,
                                        :msg_type,
                                        :last_send_time,
                                        :ver,
                                        :msg_type,
                                        :last_send_time,

-                                       :creation_time, 
+                                       :creation_time,

                                        :show_time,
                                        :repeat,
                                        :repeat_period,
                                        :show_time,
                                        :repeat,
                                        :repeat_period,


@@ -635,8 +582,8 @@ begin
     insert into tb_tariffs (pk_tariff, name, fee, free, passive_cost, traff_type) values (:pk_tariff, :name, 0, 0, 0, 0);
     while (dirs > 0) do
     begin
     insert into tb_tariffs (pk_tariff, name, fee, free, passive_cost, traff_type) values (:pk_tariff, :name, 0, 0, 0, 0);
     while (dirs > 0) do
     begin

-        insert into tb_tariffs_params (fk_tariff, dir_num, price_day_a, 
-                                       price_day_b, price_night_a, price_night_b, 
+        insert into tb_tariffs_params (fk_tariff, dir_num, price_day_a,
+                                       price_day_b, price_night_a, price_night_b,

                                        threshold, time_day_begins, time_day_ends)
                    values (:pk_tariff, :dirs - 1, 0, 0, 0, 0, 0, '0:0', '0:0');
        dirs = dirs - 1;
                                        threshold, time_day_begins, time_day_ends)
                    values (:pk_tariff, :dirs - 1, 0, 0, 0, 0, 0, '0:0', '0:0');
        dirs = dirs - 1;


@@ -728,4 +675,3 @@ set term ; !!
 insert into tb_admins values(0, 'admin', 'geahonjehjfofnhammefahbbbfbmpkmkmmefahbbbfbmpkmkmmefahbbbfbmpkmk', 1, 1, 1, 1, 1, 1, 1, 1, 1);
 
 /* EOF */
 insert into tb_admins values(0, 'admin', 'geahonjehjfofnhammefahbbbfbmpkmkmmefahbbbfbmpkmkmmefahbbbfbmpkmk', 1, 1, 1, 1, 1, 1, 1, 1, 1);
 
 /* EOF */

-