Sign in
apache
/
spamassassin
/
9b0e8d394bb8a6f86891e6168f631a36474cfdeb
/
.
/
sql
/
userpref_pg.sql
blob: a50b6f3711b601c95991736efaa5206c98a42484 [
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
(
100
)
NOT
NULL
);
CREATE
INDEX
userpref_username_idx
ON
userpref
(
username
);