Sign in
apache
/
spamassassin
/
c10ab632886dc135934645f866dccb82e1401a6e
/
.
/
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
);