Sign in
apache
/
spamassassin
/
refs/tags/sa-update_3.4.4_20210719083050
/
.
/
sql
/
userpref_pg.sql
blob: e4d15956875000083ae3d855d5648b33e84fe9f1 [
file
] [
log
] [
blame
]
CREATE
TABLE
userpref
(
prefid bigserial
NOT
NULL
unique
primary
key
,
username varchar
(
100
)
NOT
NULL
,
preference varchar
(
50
)
NOT
NULL
,
value varchar
(
255
)
NOT
NULL
);
CREATE
INDEX
userpref_username_idx
ON
userpref
(
username
);