Query

billing.db — packages

SQL

CREATE TABLE packages  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  speed TEXT NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  tax_rate DECIMAL(5,2) DEFAULT 11.00,
  description TEXT,
  pppoe_profile TEXT DEFAULT 'default',
  is_active BOOLEAN DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  image_filename TEXT NULL,
  status TEXT DEFAULT 'active'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
name TEXT Rename | Drop
speed TEXT Rename | Drop
price DECIMAL(10,2) Rename | Drop
tax_rate DECIMAL(5,2) ✓ Rename | Drop
description TEXT ✓ Rename | Drop
pppoe_profile TEXT ✓ Rename | Drop
is_active BOOLEAN ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
image_filename TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_packages_image_filename image_filename SQL 
CREATE INDEX idx_packages_image_filename
ON packages(image_filename)
Drop
idx_packages_status status SQL 
CREATE INDEX idx_packages_status
ON packages(status)
Drop