X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/641204dfbdb9fc870cdd2e7f9e3169a44693e7bf..9c340da9ffa670c20c3658a2be43d35868a9f5d9:/projects/stargazer/inst/var/00-base-00.postgresql.sql?ds=sidebyside diff --git a/projects/stargazer/inst/var/00-base-00.postgresql.sql b/projects/stargazer/inst/var/00-base-00.postgresql.sql index 5ec01be4..6d4b5c47 100644 --- 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. * - * * При занесении IP адресса в БД выполнять приведение к - * знаковуму целому!!! - * ***************************************************************************** */ @@ -595,7 +592,7 @@ BEGIN RAISE EXCEPTION 'User % not found', _login; RETURN -1; END IF; - + 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); +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)