phantomknight287/saturn

public

The operating system for your freelance business.

Code Issues0 Pull requests0

saturndrizzle0040_tidy_risque.sql

Staging (#68)90eccbb4 months ago6 lines · 572 B

1	ALTER TABLE "settings" RENAME COLUMN "member_rate" TO "pay_rate";--> statement-breakpoint
2	ALTER TABLE "settings" RENAME COLUMN "currency
3	ALTER TABLE "settings" ADD COLUMN
4	ALTER TABLE "settings" ADD COLUMN
5	ALTER TABLE "settings" ADD COLUMN
6	ALTER TABLE "settings" ADD COLUMN

"

TO

"

pay_currency

"

;

--

> statement-breakpoint

"

billing_rate

"

integer

;

--

> statement-breakpoint

"

billing_currency

"

text

DEFAULT

'

USD

'

NOT NULL

;

--

> statement-breakpoint

"

billing_frequency

"

"

billing_frequency

"

DEFAULT

'

hourly

'

;

--

> statement-breakpoint

"

pay_frequency

"

"

billing_frequency

"

DEFAULT

'

hourly

'

;