CREATE TABLE "LXA"."USERS"
(
"U_ID" NUMBER(*,0) NOT NULL ENABLE,
"U_NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"U_PWD" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"U_IP" VARCHAR2(50 BYTE),
"U_STATE" VARCHAR2(50 BYTE),
"U_GENDER" VARCHAR2(50 BYTE),
"U_EMAIL" VARCHAR2(50 BYTE),
"U_LAST_LOGIN" DATE,
"U_LAST_EXIT" DATE,
"U_REMARKE" VARCHAR2(3000 BYTE),
"U_SIGNATURE" VARCHAR2(100 BYTE),
"U_HEAD_IMG" VARCHAR2(100 BYTE),
"U_TYPE" VARCHAR2(50 BYTE),
"U_BIRTHDAY" DATE,
CONSTRAINT "PK_USERS" PRIMARY KEY ("U_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE
)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "USERS" ;
COMMENT ON COLUMN "LXA"."USERS"."U_ID"
IS
'用户ID';
COMMENT ON COLUMN "LXA"."USERS"."U_NAME"
IS
'用户名';
COMMENT ON COLUMN "LXA"."USERS"."U_PWD"
IS
'密码';
COMMENT ON COLUMN "LXA"."USERS"."U_IP"
IS
'IP地址';
COMMENT ON COLUMN "LXA"."USERS"."U_STATE"
IS
'用户状态';
COMMENT ON COLUMN "LXA"."USERS"."U_GENDER"
IS
'性别';
COMMENT ON COLUMN "LXA"."USERS"."U_EMAIL"
IS
'电子邮件';
COMMENT ON COLUMN "LXA"."USERS"."U_LAST_LOGIN"
IS
'最后一次登录';
COMMENT ON COLUMN "LXA"."USERS"."U_LAST_EXIT"
IS
'最后一次退出';
COMMENT ON COLUMN "LXA"."USERS"."U_REMARKE"
IS
'备用';
COMMENT ON COLUMN "LXA"."USERS"."U_SIGNATURE"
IS
'个性签名';
COMMENT ON COLUMN "LXA"."USERS"."U_HEAD_IMG"
IS
'头像';
COMMENT ON COLUMN "LXA"."USERS"."U_TYPE"
IS
'类型';
COMMENT ON COLUMN "LXA"."USERS"."U_BIRTHDAY"
IS
'生日';
MyQQ 2014 + 服务端+客户端源码【含数据库】
4星 · 超过85%的资源 需积分: 49 115 浏览量
2014-01-28
05:52:32
上传
评论 5
收藏 3.14MB ZIP 举报
lsu66666601
- 粉丝: 3
- 资源: 9