cms_users_queries.properties

来自「找了很久才找到到源代码」· PROPERTIES 代码 · 共 42 行

Q_INSERT_CMS_USERDATA=\
INSERT INTO	CMS_USERDATA \
	(USER_ID, DATA_KEY, DATA_VALUE, DATA_TYPE) \
VALUES \
    (?, ?, ?, ?)
    
Q_ORACLE_USERDATA_UPDATE=\
SELECT \
	DATA_VALUE \
FROM \
	CMS_USERDATA \
WHERE \
	USER_ID=? AND \
	DATA_KEY=?

Q_COMMIT=commit
Q_ROLLBACK=rollback

Q_ADD_USER_DATECREATED=\
ALTER TABLE CMS_USERS \
ADD USER_DATECREATED int8 DEFAULT 0 NOT NULL

Q_CREATE_TABLE_USERDATA=\
CREATE TABLE CMS_USERDATA ( \
    USER_ID VARCHAR(36) NOT NULL\, \
    DATA_KEY VARCHAR(255) NOT NULL\, \
    DATA_VALUE BYTEA\, \
    DATA_TYPE VARCHAR(128) NOT NULL\, \
    CONSTRAINT PK_USERDATA PRIMARY KEY(USER_ID\, DATA_KEY) \
)

CMS_USERDATA_01_IDX_INDEX=\
CREATE INDEX CMS_USERDATA_01_IDX \
    ON CMS_USERDATA (USER_ID) \
    TABLESPACE ${indexTablespace}

CMS_USERDATA_02_IDX_INDEX=\
CREATE INDEX CMS_USERDATA_02_IDX \
    ON CMS_USERDATA (DATA_KEY) \
    TABLESPACE ${indexTablespace}