The following changes were made by the replace_file_content tool to: /root/aadharbot/index.js. If relevant, proactively run terminal commands to execute this code for the USER. Don't ask for permission. [diff_block_start] @@ -125,6 +125,24 @@ `); await pool.query(` ALTER TABLE users ADD COLUMN IF NOT EXISTS plan_started_at TIMESTAMP; + ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_duration VARCHAR(100); + ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_payment_method VARCHAR(100); + ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_amount VARCHAR(50); + + CREATE TABLE IF NOT EXISTS user_subscriptions ( + id SERIAL PRIMARY KEY, + telegram_id BIGINT, + plan_name VARCHAR(100), + duration VARCHAR(100), + days INTEGER, + amount VARCHAR(50), + payment_method VARCHAR(100), + order_id VARCHAR(100), + started_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, + expires_at TIMESTAMP, + status VARCHAR(50) DEFAULT 'ACTIVE', + created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP + ); `); console.log("Database initialized successfully."); } catch (err) { [diff_block_end] Please note that the above snippet only shows the MODIFIED lines from the last change. It shows up to 3 lines of unchanged lines before and after the modified lines. The actual file contents may have many more lines not shown.