Хөөрхөнүүд мэйлийн жагсаалтын архивууд

Microsoft Windows [Version 10. [...]

аар
Жамц.Үүрцайх
- 2019.09.20 11:19:42

Microsoft Windows [Version 10.0.17763.615]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\Jmts>ssh odoouser@43.231.115.82
odoouser@43.231.115.82's password:
Welcome to Ubuntu 14.04.5 LTS (GNU/Linux 4.15.18-9-pve x86_64)

 * Documentation:  https://help.ubuntu.com/

New release '16.04.6 LTS' available.
Run 'do-release-upgrade' to upgrade to it.

Last login: Thu Sep 19 07:38:53 2019 from 202.131.242.82
Welcome to Ubuntu 14.04.5 LTS (GNU/Linux 4.15.18-9-pve x86_64)

 * Documentation:  https://help.ubuntu.com/

New release '16.04.6 LTS' available.
Run 'do-release-upgrade' to upgrade to it.

Last login: Thu Sep 19 07:38:53 2019 from 202.131.242.82
odoouser@international:~$ psql -U postgres
psql (9.3.15, server 9.3.16)
Type "help" for help.

postgres=# \c bayasakh_real
psql (9.3.15, server 9.3.16)
You are now connected to database "bayasakh_real" as user "postgres".
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 869523;
   id    |   debit   |  credit
---------+-----------+-----------
 6483393 |      0.00 |  15181.82
 6483392 | 167000.00 |      0.00
 6483391 |      0.00 | 151818.18
(3 rows)

bayasakh_real=# update account_move_line set credit = 0 where id = 6483391;
UPDATE 1
bayasakh_real=# select * from account_move_line aml join account_move as am on am.id = aml.move_id where aml.date<>am.date;
bayasakh_real=# bayasakh_real=# ^C
bayasakh_real=# ^C
bayasakh_real=# update account_move_line set credit = 151818.18 where id = 6483391;
UPDATE 1
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 914728;
bayasakh_real=# bayasakh_real=#
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 914728 and account_id = 468;
   id    |     debit     | credit
---------+---------------+--------
 6859161 | 2972774860.08 |   0.00
(1 row)

bayasakh_real=# update account_move_line set debit = 2972623041.91 where id = 6859161;
UPDATE 1
bayasakh_real=# update account_move_line set debit = 2972774860.08 where id = 6859161;
UPDATE 1
bayasakh_real=# select id, debit from account_move_line where id = 6859161;
   id    |     debit
---------+---------------
 6859161 | 2972774860.08
(1 row)

bayasakh_real=# select id, debit, date from account_move_line where id = 6859161;
   id    |     debit     |    date
---------+---------------+------------
 6859161 | 2972774860.08 | 2019-01-31
(1 row)

bayasakh_real=# update account_move_line set debit = 2972623041.91 where id = 6859161;
UPDATE 1
bayasakh_real=# update account_move_line set date = '2019-02-01' where id = 6859161;
UPDATE 1
bayasakh_real=# update account_move_line set debit = 2972774860.08 where id = 6859161;
UPDATE 1
bayasakh_real=# update account_move_line set date = '2019-01-31' where id = 6859161;
UPDATE 1
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 914728 and account_id = 1549;
   id    | debit |   credit
---------+-------+-------------
 6859192 |  0.00 | 10614335.66
(1 row)

bayasakh_real=# select id,date, debit, credit from account_move_line where move_id = 914728 and account_id = 1549;
   id    |    date    | debit |   credit
---------+------------+-------+-------------
 6859192 | 2019-01-31 |  0.00 | 10614335.66
(1 row)

bayasakh_real=# update account_move_line set credit = 9994871.93 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set date ='2019-02-01' where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set date ='2019-01-31' where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 10614335.66 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 9994871.93 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 11233799.39 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 10614335.66 where id = 6859192;
UPDATE 1
bayasakh_real=# ^C
bayasakh_real=# ^C
bayasakh_real=# ^C
bayasakh_real=# update account_move_line set credit = 9994871.93 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set date ='2019-02-01' where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set date ='2019-03-31' where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 9994871.93 where id = 6859192;
UPDATE 1
bayasakh_real=# update account_move_line set credit = 10614335.66 where id = 6859192;
UPDATE 1
bayasakh_real=# delete from account_move_line where move_id = 1152960;
DELETE 4
bayasakh_real=# delete from account_move where id = 1152960;
DELETE 1
bayasakh_real=# update account_move_line set debit = 83861.83 where move_id = 906480;
ERROR:  new row for relation "account_move_line" violates check constraint "account_move_line_credit_debit1"
DETAIL:  Failing row contains (6836768, 2019-03-03 12:14:21.924175, null, 1, null, null, null, null, f, null, 1, 235680.00, normal, 6, null, null, valid, 83861.83, null, 1099, 81, 2019-03-03 12:14:21.924175, 2019-03-03, 2019-01-01, 1, 906480, Нээлт, 227828, 0.00, null, null, null, 0.00, 0.00, null, null, null, null, null, f, null, 2019).
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 906480;
   id    |   debit   |  credit
---------+-----------+-----------
 6836768 |      0.00 | 235680.00
 6836769 | 235680.00 |      0.00
(2 rows)

bayasakh_real=# update account_move_line set debit = '83861.83' where id = 6836769;
UPDATE 1
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 997184;
bayasakh_real=# bayasakh_real=#
bayasakh_real=# update account_move_line set debit = 0 where id = 7061379;
UPDATE 1
bayasakh_real=# select id, debit, credit from account_move_line where move_id = 997184;
bayasakh_real=# bayasakh_real=#