`subject` VARCHAR(255) NOT NULL DEFAULT 'missing',
`mode` ENUM('add','sub') NOT NULL DEFAULT 'add',
`points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
+`recorded` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
INDEX (`userid`),
PRIMARY KEY (`id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Member points booking table'");