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