11 lines
223 B
SQL
11 lines
223 B
SQL
-- Default sort policy for each domain
|
|
|
|
CREATE TYPE sortPolicy AS ENUM (
|
|
'score-desc',
|
|
'creationdate-desc',
|
|
'creationdate-asc'
|
|
);
|
|
|
|
ALTER TABLE domains
|
|
ADD defaultSortPolicy sortPolicy NOT NULL DEFAULT 'score-desc';
|