Changes between Version 9 and Version 10 of OtherTopics

Timestamp:

02/27/26 06:20:07 (3 weeks ago)

Author:

221181

Comment:

--

OtherTopics

@@ -147 +147 @@
 {{{
 SET search_path TO stock_management;
-TRUNCATE sale, purchase_order, product RESTART IDENTITY CASCADE;
+TRUNCATE purchase_order, product RESTART IDENTITY CASCADE;
 
 -- 10.000 производи
@@ -153 +153 @@
 SELECT 'Product ' || i, 'Desc', 'SKU-' || i, (random() * 100)::numeric(12,2), 1, 1 FROM generate_series(1, 10000) AS i;
 
--- 250.000 продажби
-INSERT INTO sale (date_time, total_amount, user_id, customer_id, warehouse_id)
-SELECT NOW() - (random() * interval '365 days'), (random() * 5000)::numeric(15,2), 1, 1, 1 FROM generate_series(1, 250000) AS i;
-
 -- 50.000 нарачки
 INSERT INTO purchase_order (order_date, expected_delivery_date, status, supplier_id, warehouse_id)