aboutsummaryrefslogtreecommitdiff
path: root/Västgöta.wiki
blob: a72bdff19a2c30296f182ae2fc10f33c8faeed62 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
[[Västgöta/veckomamil]]

== Rödback ==

{{{sqlite3
UPDATE acquisitions SET amount = amount - 60 WHERE id = 299;

UPDATE money SET amount = amount + 60 * 250 WHERE id = 3;

UPDATE stock SET active = active - 60 WHERE product_id = 146;
}}}


| Stock  | Money    | Acquisitions |
|--------|----------|--------------|
| Before |          |              |
| 240    | -1010.00 | 265          |
|--------|----------|--------------|
| After  |          |              |
| 180    | -860.00  | 205          |