CREATE TABLE IF NOT EXISTS member(
id INTEGER AUTO_INCREMENT PRIMARY KEY,
active BOOL DEFAULT 'FALSE' NOT NULL,
login VARCHAR(50) UNIQUE,
first VARCHAR(50),
last VARCHAR(50),
email VARCHAR(50),
acctype INTEGER NOT NULL REFERENCES plan(id),
sstat INTEGER DEFAULT 0 NOT NULL,
news BOOL,
passwd VARCHAR(50),
subscr_id VARCHAR(100)
) TYPE=InnoDB;