TABLE USER Clause Samples

TABLE USER. The table User registers a user for the domain. This is the common place to register users both for FTP and mail servers. A user registered here can then have accounts defined for FTP and Mail servers. CREATE TABLE USER ( DOMAIN_KEY INT NOT NULL, // Primary Key USER_KEY INT NOT NULL, // Primary Key PREVIOUS_RECORD INT NOT NULL, ALTER_TIME TIMESTAMP NOT NULL, STATUS INT NOT NULL, NAME CHAR(32) NOT NULL, PASSWORD CHAR(16) NOT NULL)