25 lines
845 B
SQL
25 lines
845 B
SQL
-- Migration: Add service_listings table
|
|
-- Run this against the fuelprices database to enable the service companies feature.
|
|
--
|
|
-- psql -h 192.168.1.204 -U <user> -d fuelprices -f migrate_service_listings.sql
|
|
|
|
CREATE TABLE IF NOT EXISTS service_listings (
|
|
id SERIAL PRIMARY KEY,
|
|
company_name VARCHAR(255) NOT NULL,
|
|
is_active BOOLEAN DEFAULT true,
|
|
twenty_four_hour BOOLEAN DEFAULT false,
|
|
emergency_service BOOLEAN DEFAULT false,
|
|
town VARCHAR(100),
|
|
county_id INTEGER NOT NULL,
|
|
phone VARCHAR(20),
|
|
website VARCHAR(255),
|
|
email VARCHAR(255),
|
|
description TEXT,
|
|
licensed_insured BOOLEAN DEFAULT false,
|
|
service_area VARCHAR(255),
|
|
years_experience INTEGER,
|
|
user_id INTEGER NOT NULL,
|
|
created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
|
|
last_edited TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
|
|
);
|