Remove TravisCI file as well.

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

diff --git a/projects/stargazer/inst/var/00-base-00.postgresql.sql b/projects/stargazer/inst/var/00-base-00.postgresql.sql
index 5ec01be42aa7c4d273c6ddd26590955425c7153f..6d4b5c4738073ee67bdb91b127fcbeac7ca8e512 100644 (file)
--- a/projects/stargazer/inst/var/00-base-00.postgresql.sql
+++ b/projects/stargazer/inst/var/00-base-00.postgresql.sql
@@ -33,9 +33,6 @@
  *      * dm_session_event_type. Указывает тип записи в логе о сессии.
  *        'c' - connect, 'd' - disconnect.
  *
  *      * dm_session_event_type. Указывает тип записи в логе о сессии.
  *        'c' - connect, 'd' - disconnect.
  *

- *      * При занесении IP адресса в БД выполнять приведение к
- *        знаковуму целому!!!
- *

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


@@ -595,7 +592,7 @@ BEGIN
         RAISE EXCEPTION 'User % not found', _login;
         RETURN -1;
     END IF;
         RAISE EXCEPTION 'User % not found', _login;
         RETURN -1;
     END IF;

-    
+

     INSERT INTO tb_sessions_log
         (fk_user,
          event_time,
     INSERT INTO tb_sessions_log
         (fk_user,
          event_time,


@@ -631,6 +628,15 @@ VALUES
     ('admin',
      'geahonjehjfofnhammefahbbbfbmpkmkmmefahbbbfbmpkmkmmefahbbbfbmpkmk',
      1, 1, 1, 1, 1, 1, 1, 1, 1);
     ('admin',
      'geahonjehjfofnhammefahbbbfbmpkmkmmefahbbbfbmpkmkmmefahbbbfbmpkmk',
      1, 1, 1, 1, 1, 1, 1, 1, 1);

+INSERT INTO tb_admins
+    (login, passwd,
+     chg_conf, chg_password, chg_stat,
+     chg_cash, usr_add_del, chg_tariff,
+     chg_admin, chg_service, chg_corporation)
+VALUES
+    ('@stargazer',
+     '',
+     0, 0, 0, 0, 0, 0, 0, 0, 0);

 
 INSERT INTO tb_info
     (version)
 
 INSERT INTO tb_info
     (version)