0_1_99-userattributesdatabase.sql

来自「这是linux下ssl vpn的实现程序」· SQL 代码 · 共 28 行

//
// User Attributes
//

DROP TABLE USER_ATTRIBUTES IF EXISTS;
CREATE CACHED TABLE USER_ATTRIBUTES
(
   USERNAME VARCHAR(2147483647) not null,
   ATTRIBUTE_NAME VARCHAR(2147483647) not null,
   ATTRIBUTE_VALUE VARCHAR(2147483647),
   CONSTRAINT USER_ATTRIBUTES_PK PRIMARY KEY (USERNAME,ATTRIBUTE_NAME)
);

DROP TABLE USER_ATTRIBUTE_DEFINITION IF EXISTS;
CREATE CACHED TABLE USER_ATTRIBUTE_DEFINITION
(
   NAME VARCHAR(255) PRIMARY KEY,
   VISIBILITY TINYINT not null,
   TYPE TINYINT not null,
   SORT_ORDER INTEGER not null,
   TEXT_LABEL VARCHAR(255) not null,
   TEXT_DESCRIPTION VARCHAR(65535) not null,
   TYPE_META VARCHAR(255) not null,
   CATEGORY INTEGER not null,
   CATEGORY_LABEL VARCHAR(255) not null,
   DEFAULT_VALUE VARCHAR(255) not null,
   HIDDEN TINYINT
);