REM $Id: virtual_users.sql,v 1.1 2004/10/24 20:51:55 jonz Exp $

CREATE TABLE DSPAM_VIRTUAL_USER_IDS (
  USER_ID NUMBER(5) PRIMARY KEY,
  USERNAME VARCHAR(128)
)
/

CREATE UNIQUE INDEX ID_VIRTUAL_USER_IDS_01 ON DSPAM_VIRTUAL_USER_IDS(USERNAME);

CREATE SEQUENCE VIRTUAL_USER
  START WITH 1
  INCREMENT BY 1
  ORDER
/