ＩＢＭ网上商城　项目源码ｄｏｃ

-- 数据库名称: SHOP -- 数据库管理器版本: DB2/NT Version 9.5.0 ---表的 DDL 语句 "XIONGYU "."USER"--- CREATE TABLE "XIONGYU "."USER" ( "USERID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 INCREMENT BY +1 MINVALUE +1 MAXVALUE +9223372036854775807 NO CYCLE NO CACHE NO ORDER ) , "USERNAME" VARCHAR(32) NOT NULL , "PASSWORD" VARCHAR(32) NOT NULL , "NICKNAME" VARCHAR(32) , "BONUSPOINT" BIGINT NOT NULL WITH DEFAULT 100 , "MEMBERCLASS" VARCHAR(10) NOT NULL WITH DEFAULT 'common' ) IN "USERSPACE1" ; -- 表上主键的 DDL 语句 "XIONGYU "."USER" ALTER TABLE "XIONGYU "."USER" ADD CONSTRAINT "CONST_PK" PRIMARY KEY("USERID");