Query

billing.db — voucher_generation_se...

SQL

CREATE TABLE voucher_generation_settings  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  setting_key TEXT NOT NULL UNIQUE,
  setting_value TEXT NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
setting_key TEXT Rename | Drop
setting_value TEXT Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_voucher_generation_settings_key setting_key SQL 
CREATE INDEX idx_voucher_generation_settings_key
ON voucher_generation_settings(setting_key)
Drop
sqlite_autoindex_voucher_generation_settings_1 setting_key ✓ SQL
-- no sql found --
 Drop

Triggers

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