Query

billing.db — voucher_online_settings

SQL

CREATE TABLE voucher_online_settings  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  package_id TEXT NOT NULL UNIQUE,
  profile TEXT NOT NULL,
  enabled INTEGER NOT NULL DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  agent_price DECIMAL(10,2) DEFAULT 0.00,
  commission_amount DECIMAL(10,2) DEFAULT 0.00,
  is_active BOOLEAN DEFAULT 1,
  price INTEGER DEFAULT 0,
  name TEXT,
  digits INTEGER DEFAULT 5,
  duration INTEGER DEFAULT 24,
  duration_type TEXT DEFAULT 'hours'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
package_id TEXT Rename | Drop
profile TEXT Rename | Drop
enabled INTEGER Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop
agent_price DECIMAL(10,2) ✓ Rename | Drop
commission_amount DECIMAL(10,2) ✓ Rename | Drop
is_active BOOLEAN ✓ Rename | Drop
price INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
digits INTEGER ✓ Rename | Drop
duration INTEGER ✓ Rename | Drop
duration_type TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_voucher_online_settings_package package_id SQL 
CREATE INDEX idx_voucher_online_settings_package
ON voucher_online_settings(package_id)
Drop
sqlite_autoindex_voucher_online_settings_1 package_id ✓ SQL
-- no sql found --
 Drop

Triggers

Name SQL Drop?
update_voucher_online_settings_updated_at SQL 
CREATE TRIGGER update_voucher_online_settings_updated_at
    AFTER UPDATE ON voucher_online_settings
    FOR EACH ROW
BEGIN
    UPDATE voucher_online_settings SET updated_at = CURRENT_TIMESTAMP WHERE id = NEW.id;
END
Drop