ForestAdmin/lumber

View on GitHub
test-fixtures/mssql/customers.sql

Summary

Maintainability
Test Coverage
CREATE TABLE [dbo].customers (
  id BIGINT IDENTITY(1,1) NOT NULL,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  is_active BIT DEFAULT 1 NOT NULL,
  paying BIT DEFAULT 0 NOT NULL,
  created_at DATETIME NOT NULL,
  updated_at DATETIME NOT NULL,
  CONSTRAINT pk_customers PRIMARY KEY (id)
);