-- Seed data for Cylinder Management
INSERT INTO customers (name, address) VALUES ('Saurabh','Indore'), ('Ramesh','Mumbai'), ('Acme Ltd','Pune');

INSERT INTO cylinders (serial, status, location) VALUES
('CYL-1001','available','factory'),
('CYL-1002','available','factory'),
('CYL-1003','available','factory'),
('CYL-1004','available','factory'),
('CYL-1005','available','factory');

-- Example movement (assign 2 cylinders to customer 1)
-- INSERT INTO movement_groups (customer_id, action, movement_date, notes) VALUES (1,'assign', '2025-09-12', 'Initial assignment');
-- INSERT INTO movement_items (group_id, cylinder_id) VALUES (1,1),(1,2);
-- UPDATE cylinders SET status='assigned', location='customer:1' WHERE id IN (1,2);