23 lines
1.0 KiB
SQL
23 lines
1.0 KiB
SQL
CREATE TABLE IF NOT EXISTS company_settings (
|
|
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
company_name VARCHAR(255) NOT NULL DEFAULT '',
|
|
company_email VARCHAR(255) NOT NULL DEFAULT '',
|
|
company_phone VARCHAR(50) NOT NULL DEFAULT '',
|
|
company_website VARCHAR(255) NOT NULL DEFAULT '',
|
|
company_address TEXT NOT NULL DEFAULT '',
|
|
updated_by UUID REFERENCES users(id),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
INSERT INTO company_settings (company_name, company_email, company_phone, company_website, company_address)
|
|
VALUES ('Coastal IT Solutions', 'info@coastalit.com', '(555) 123-4567', 'https://coastalit.com', '123 Business Ave, Suite 100, San Francisco, CA 94105')
|
|
ON CONFLICT DO NOTHING;
|
|
|
|
CREATE TABLE IF NOT EXISTS user_preferences (
|
|
user_id UUID PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
|
|
timezone VARCHAR(100) NOT NULL DEFAULT 'america-los_angeles',
|
|
date_format VARCHAR(10) NOT NULL DEFAULT 'mdy',
|
|
items_per_page INTEGER NOT NULL DEFAULT 20,
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|