File size: 617 Bytes
369b6c9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- Per-feature one-time credits for the Work Programme & Cash Flow tools (50 AED each).
ALTER TABLE qto_users ADD COLUMN IF NOT EXISTS programme_credits INT DEFAULT 0;
ALTER TABLE qto_users ADD COLUMN IF NOT EXISTS cashflow_credits INT DEFAULT 0;

-- Saved history for the module tools (feature = 'programme' | 'cashflow').
CREATE TABLE IF NOT EXISTS qto_module_projects (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  feature VARCHAR(20) NOT NULL,
  name VARCHAR(255) NOT NULL,
  date VARCHAR(32),
  config_data LONGTEXT,
  summary_data LONGTEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);