[TOC] ## 表 ## 创建表与索引 ``` CREATE TABLE hs_user_tree ( TREE_ID varchar(50) NOT NULL DEFAULT '' , DEPT_ID varchar(50) NOT NULL DEFAULT '' , DEPT_CODE varchar(100) NOT NULL DEFAULT '' , USER_ID varchar(50) NOT NULL DEFAULT '' , USER_NAME varchar(50) NOT NULL DEFAULT '' , POSITION_ID varchar(50) DEFAULT '' , USER_ORDER_ID int DEFAULT '10000' , PRIMARY KEY (TREE_ID) ) ; CREATE INDEX IDX_TREE_USER_ID ON "HS_USER_TREE" USING BTREE(USER_ID) TABLESPACE SYS_DEFAULT; CREATE INDEX IDX_USER_ID ON "HS_USER_TREE" USING HASH(USER_ID) TABLESPACE SYS_DEFAULT; ```