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