📘 คู่มือสำหรับการตั้งค่าระบบ
Friend Group Inventory

// Database configuration define('DB_HOST', 'localhost'); define('DB_USER', 'root'); define('DB_PASS', '********'); define('DB_NAME', 'friend_group_inventory');

CREATE TABLE inventory_lots ( lot_id INT PRIMARY KEY AUTO_INCREMENT, product_id INT NOT NULL, branch_id INT NOT NULL, lot_number VARCHAR(50) NOT NULL, quantity INT NOT NULL DEFAULT 0, original_quantity INT NOT NULL, cost_price DECIMAL(10,2) DEFAULT NULL, expiry_date DATE DEFAULT NULL, manufacture_date DATE DEFAULT NULL, received_date DATETIME DEFAULT NOW(), import_batch_id INT DEFAULT NULL, reference_no VARCHAR(50) DEFAULT NULL, notes TEXT DEFAULT NULL, is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT NOW(), updated_at TIMESTAMP DEFAULT NOW() ON UPDATE NOW(), INDEX idx_product (product_id), INDEX idx_branch (branch_id), INDEX idx_lot (lot_number), INDEX idx_expiry (expiry_date), FOREIGN KEY (product_id) REFERENCES products(product_id), FOREIGN KEY (branch_id) REFERENCES branches(branch_id), FOREIGN KEY (import_batch_id) REFERENCES import_batches(batch_id) );