CREATE TABLE ADMINISTRATOR.IBMUSER ("USERID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERNAME" VARCHAR (20) , "USERPWD" VARCHAR (20) , "USERSEX" VARCHAR (10) , "USEREMAIL" VARCHAR (30) , "USERPHONE" VARCHAR (20) , "USERADD" VARCHAR (100) , "MSNOICQ" VARCHAR (20) , "DATEBIRTH" DATE , "USERPIC" VARCHAR (20) , "USERSIGN" VARCHAR (100) , "POSTNUM" INTEGER WITH DEFAULT 0, "VISITNUM" INTEGER WITH DEFAULT 0, "USERCLASS" VARCHAR (10) WITH DEFAULT 'one' , "REGDATE" TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP, "IFONLINE" VARCHAR (10) , "CERTIFY" VARCHAR (50) WITH DEFAULT '1', PRIMARY KEY (USERID) ) DATA CAPTURE NONE