query.properties

cms是开源的框架

	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH LIKE ? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE LIKE ?) \
UNION \
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	CMS_${PROJECT}_PROPERTIES, \
	CMS_${PROJECT}_STRUCTURE, \
	CMS_${PROJECT}_RESOURCES \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID = ? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID = CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH LIKE ? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE LIKE ?) \
ORDER BY RESOURCE_PATH DESC

C_RESOURCES_GET_RESOURCE_IN_PROJECT_WITH_STATE=\
SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE (\
	CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID) \
	AND CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED = ? \
	AND \
	(\
		(\
			CMS_${PROJECT}_RESOURCES.RESOURCE_STATE=? \
			AND CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE<=?\
		)\
		OR \
		(\
			CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE=? \
			AND CMS_${PROJECT}_RESOURCES.RESOURCE_STATE<=?\
		)\
	) \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC


C_RESOURCES_GET_RESOURCE_IN_PROJECT_WITHOUT_STATE=\
SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED = ? \
	AND \
	(\
		CMS_${PROJECT}_RESOURCES.RESOURCE_STATE<>? \
		OR CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE<>?\
	)\
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC	
	
	
C_RESOURCES_GET_RESOURCE_IN_PROJECT_IGNORE_STATE=\
SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED = ? \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC	
		
		
C_RESOURCE_REPLACE=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_TYPE=?,\
	RESOURCE_SIZE=? \
WHERE \
	RESOURCE_ID=?


C_RESOURCES_UPDATE_SIBLING_COUNT=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	SIBLING_COUNT=? \
WHERE \
	RESOURCE_ID=?
	
	
C_RESOURCES_UPDATE_FLAGS=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_FLAGS=? \
WHERE \
	RESOURCE_ID=?
	
	
C_RESOURCES_UPDATE_RESOURCE_STATE=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_STATE=?, \
    	PROJECT_LASTMODIFIED=? \
WHERE \
	RESOURCE_ID=?
	
	
C_RESOURCES_UPDATE_RESOURCE_STATELASTMODIFIED=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_STATE=?, \
        DATE_LASTMODIFIED=?, \
        USER_LASTMODIFIED=?, \
        PROJECT_LASTMODIFIED=? \
WHERE \
	RESOURCE_ID=?	

	
C_RESOURCES_UPDATE_STRUCTURE_STATE=\
UPDATE \
	CMS_${PROJECT}_STRUCTURE \
SET \
	STRUCTURE_STATE=? \
WHERE \
	STRUCTURE_ID=?
	
	
C_RESOURCES_UPDATE_RELEASE_EXPIRED=\
UPDATE \
	CMS_${PROJECT}_STRUCTURE \
SET \
	DATE_RELEASED=?, \
    	DATE_EXPIRED=? \
WHERE \
	STRUCTURE_ID=?	
	

C_RESOURCES_READ_RESOURCE_STATE=\
SELECT \
	CMS_${PROJECT}_RESOURCES.RESOURCE_STATE \
FROM \
	CMS_${PROJECT}_RESOURCES \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID=?
		
	
C_RESOURCES_COUNT_SIBLINGS=\
SELECT \
	COUNT(CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID) \
FROM \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=?

	
C_RESOURCES_DELETE_BY_RESOURCEID=\
DELETE FROM \
	CMS_${PROJECT}_RESOURCES \
WHERE \
	RESOURCE_ID=?
	
		
C_STRUCTURE_DELETE_BY_STRUCTUREID=\
DELETE FROM \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	STRUCTURE_ID=?


C_RESOURCES_UPDATE_PROJECT_LASTMODIFIED=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	PROJECT_LASTMODIFIED=? \
WHERE \
	RESOURCE_ID=?	


C_RESOURCES_BACKUP_MAXTAG=\
SELECT \
	MAX(PUBLISH_TAG) \
FROM \
	CMS_BACKUP_PROJECTS


C_RESOURCES_BACKUP_MAXTAG_RESOURCE=\
SELECT \
	MAX(PUBLISH_TAG) \
FROM \
	CMS_BACKUP_STRUCTURE


C_RESOURCES_BACKUP_MAXVER=\
SELECT \
	MAX(VERSION_ID) \
FROM \
	CMS_BACKUP_STRUCTURE \
WHERE \
	RESOURCE_PATH = ?


C_RESOURCES_PROJECTVIEW=\
SELECT \
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED,\
	${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED=? \
		AND ${C_JOIN_STRUCTURE_RESOURCE}

C_HISTORY_RESOURCE_MAX_BACKUP_VERSION=\
SELECT \
	MAX(CMS_BACKUP_STRUCTURE.VERSION_ID) \
FROM \
	CMS_BACKUP_STRUCTURE \
WHERE \
	CMS_BACKUP_STRUCTURE.RESOURCE_ID=? \

#
# General subtree selection statement
#
C_RESOURCES_READ_TREE=\
SELECT ${C_RESOURCES_SELECT_ATTRIBS},CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM ${C_RESOURCES_SELECT_TABLES} \
WHERE ${C_JOIN_RESOURCE_STRUCTURE}

#
# Selection criteria
#
C_RESOURCES_SELECT_BY_PROJECT_LASTMODIFIED=\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED=?
C_RESOURCES_SELECT_BY_PATH_PREFIX=\
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH LIKE ? ESCAPE '|'
C_RESOURCES_SELECT_BY_PARENT_UUID=\
	CMS_${PROJECT}_STRUCTURE.PARENT_ID = ?	
C_RESOURCES_SELECT_BY_RESOURCE_TYPE=\
	CMS_${PROJECT}_RESOURCES.RESOURCE_TYPE=?
C_RESOURCES_SELECT_BY_RESOURCE_STATE=\
	((CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE=? AND CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE >= CMS_${PROJECT}_RESOURCES.RESOURCE_STATE) OR \
	(CMS_${PROJECT}_RESOURCES.RESOURCE_STATE=? AND CMS_${PROJECT}_RESOURCES.RESOURCE_STATE >= CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE))
C_RESOURCES_SELECT_BY_DATE_LASTMODIFIED_AFTER=\
	CMS_${PROJECT}_RESOURCES.DATE_LASTMODIFIED >= ?
C_RESOURCES_SELECT_BY_DATE_LASTMODIFIED_BEFORE=\
	CMS_${PROJECT}_RESOURCES.DATE_LASTMODIFIED <= ?
C_STRUCTURE_SELECT_BY_DATE_EXPIRED_AFTER=\
	(CMS_${PROJECT}_STRUCTURE.DATE_EXPIRED != 0) AND (CMS_${PROJECT}_STRUCTURE.DATE_EXPIRED >= ?)
C_STRUCTURE_SELECT_BY_DATE_EXPIRED_BEFORE=\
	(CMS_${PROJECT}_STRUCTURE.DATE_EXPIRED != 0) AND (CMS_${PROJECT}_STRUCTURE.DATE_EXPIRED <= ?)
C_STRUCTURE_SELECT_BY_DATE_RELEASED_AFTER=\
	(CMS_${PROJECT}_STRUCTURE.DATE_RELEASED != 0) AND (CMS_${PROJECT}_STRUCTURE.DATE_RELEASED >= ?)
C_STRUCTURE_SELECT_BY_DATE_RELEASED_BEFORE=\
	(CMS_${PROJECT}_STRUCTURE.DATE_RELEASED != 0) AND (CMS_${PROJECT}_STRUCTURE.DATE_RELEASED <= ?)
C_RESOURCES_SELECT_ONLY_FOLDERS=\
	CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE = -1
C_RESOURCES_SELECT_ONLY_FILES=\
	CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE > -1
#
# Resources order
#
C_RESOURCES_ORDER_BY_PATH=\
	ORDER BY CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH

#
# Files
#
C_CONTENT_ID=CONTENT_ID

C_FILE_CONTENT=FILE_CONTENT


C_CONTENTS_WRITE=\
INSERT INTO CMS_${PROJECT}_CONTENTS (\
	CONTENT_ID,\
	RESOURCE_ID,\
	FILE_CONTENT) \
VALUES \
	(?,?,?)


C_CONTENTS_WRITE_BACKUP=\
INSERT INTO CMS_BACKUP_CONTENTS (\
	CONTENT_ID,\
	RESOURCE_ID,\
	FILE_CONTENT,\
	PUBLISH_TAG,\
	VERSION_ID,\
	BACKUP_ID) \
VALUES \
	(?,?,?,?,?,?)


C_CONTENTS_UPDATE=\
UPDATE \
	CMS_${PROJECT}_CONTENTS \
SET \
	FILE_CONTENT=? \
WHERE \
	RESOURCE_ID=?


C_FILES_READ=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_CONTENTS.CONTENT_ID,\
	CMS_${PROJECT}_CONTENTS.FILE_CONTENT,\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES},\
	CMS_${PROJECT}_CONTENTS \
WHERE \
	${C_JOIN_RESOURCE_FILE} \
	AND ${C_JOIN_STRUCTURE_RESOURCE} \
	AND CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID=?  \
ORDER BY \
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED DESC
	
	
C_FILES_READ_BACKUP=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS_BACKUP},\
	CMS_BACKUP_CONTENTS.CONTENT_ID,\
	CMS_BACKUP_CONTENTS.FILE_CONTENT,\
	CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_BACKUP},\
	CMS_BACKUP_CONTENTS \
WHERE \
	CMS_BACKUP_STRUCTURE.RESOURCE_PATH=? \
	AND CMS_BACKUP_STRUCTURE.PUBLISH_TAG=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE_BACKUP} \
	AND ${C_JOIN_RESOURCE_FILE_BACKUP}


C_FILE_CONTENT_DELETE=\
DELETE FROM \
	CMS_${PROJECT}_CONTENTS \
WHERE \
	RESOURCE_ID=?


#
# Propertydefinitions
#
C_PROPERTYDEF_ID=PROPERTYDEF_ID
C_PROPERTYDEF_NAME=PROPERTYDEF_NAME
C_PROPERTYDEF_PROPERTYDEF_MAPPING_TYPE=PROPERTYDEF_MAPPING_TYPE


C_PROPERTYDEF_READ=\
SELECT \
	* \
FROM \
	CMS_${PROJECT}_PROPERTYDEF \
WHERE \
	PROPERTYDEF_NAME=?	
	
C_PROPERTYDEF_READ_BACKUP=\
SELECT \
	* \
FROM \
	CMS_BACKUP_PROPERTYDEF \
WHERE \
	PROPERTYDEF_NAME=?
	
C_PROPERTYDEF_READALL=\
SELECT \
	* \
FROM \
	CMS_${PROJECT}_PROPERTYDEF	
	
C_PROPERTYDEF_CREATE=\
INSERT INTO CMS_${PROJECT}_PROPERTYDEF \
VALUES \
	(?,?)
	
	
C_PROPERTYDEF_CREATE_BACKUP=\
INSERT INTO CMS_BACKUP_PROPERTYDEF \
VALUES \
	(?,?)
	
	
C_PROPERTYDEF_DELETE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTYDEF \
WHERE \
	PROPERTYDEF_ID=?
	
	
C_PROPERTYDEF_DELETE_BACKUP=\
DELETE FROM \
	CMS_BACKUP_PROPERTYDEF \
WHERE \
	PROPERTYDEF_ID=?


#
# Properties
#
C_PROPERTY_VALUE=PROPERTY_VALUE
C_PROPERTY_RESOURCE_ID=RESOURCE_ID


C_PROPERTIES_READALL_COUNT=\
SELECT \
	COUNT(*) \
FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	PROPERTYDEF_ID=?

	
C_PROPERTIES_UPDATE=\
UPDATE \
	CMS_${PROJECT}_PROPERTIES \
SET \
	PROPERTY_VALUE=? \
WHERE \
	PROPERTY_MAPPING_ID=? \
	AND PROPERTY_MAPPING_TYPE=? \
	AND PROPERTYDEF_ID=?

	
C_PROPERTIES_CREATE=\
INSERT INTO CMS_${PROJECT}_PROPERTIES \
	(PROPERTY_ID,\
	PROPERTYDEF_ID,\
	PROPERTY_MAPPING_ID,\
	PROPERTY_MAPPING_TYPE,\
	PROPERTY_VALUE) \
VALUES \
	(?,?,?,?,?)
	
	
C_PROPERTIES_CREATE_BACKUP=\
INSERT INTO CMS_BACKUP_PROPERTIES \
	(BACKUP_ID,\
	PROPERTY_ID,\
	PROPERTYDEF_ID,\
	PROPERTY_MAPPING_ID,\
	PROPERTY_MAPPING_TYPE,\
	PROPERTY_VALUE,\
	PUBLISH_TAG,\
	VERSION_ID) \
VALUES \
	(?,?,?,?,?,?,?,?)


C_PROPERTIES_READ=\
SELECT \
	CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_${PROJECT}_PROPERTYDEF,\
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_NAME=? \
    AND CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_ID \
	AND \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
			OR \
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=?\
	)
                     
                     
C_PROPERTIES_READALL=\
SELECT \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_NAME,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_${PROJECT}_PROPERTYDEF,\
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
			OR \
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=?\
	) \
	AND \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_ID\
	)                     
                     
                     
C_PROPERTIES_READALL_BACKUP=\
SELECT \
	CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_NAME, \
	CMS_BACKUP_PROPERTIES.PROPERTY_VALUE,\
	CMS_BACKUP_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_BACKUP_PROPERTIES,\
	CMS_BACKUP_PROPERTYDEF \
WHERE \
	CMS_BACKUP_PROPERTIES.PROPERTYDEF_ID=CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_ID \
	AND \
	(\
		CMS_BACKUP_PROPERTIES.PROPERTY_MAPPING_ID=? \
		OR CMS_BACKUP_PROPERTIES.PROPERTY_MAPPING_ID=?\
	) \
	AND CMS_BACKUP_PROPERTIES.PUBLISH_TAG=?
                            
	
C_PROPERTIES_DELETE_ALL_STRUCTURE_AND_RESOURCE_VALUES=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	(\
		PROPERTY_MAPPING_ID=? \
		AND PROPERTY_MAPPING_TYPE=?\
	) \
	OR \
	(\
		PROPERTY_MAPPING_ID=? \
		AND PROPERTY_MAPPING_TYPE=?\
	)
	
	
C_PROPERTIES_DELETE_ALL_VALUES_FOR_MAPPING_TYPE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	PROPERTY_MAPPING_ID=? \
	AND PROPERTY_MAPPING_TYPE=?
	
	
C_PROPERTIES_DELETEALL_BACKUP=\
DELETE FROM \
	CMS_BACKUP_PROPERTIES \
WHERE \
	BACKUP_ID=? \
	AND PUBLISH_TAG=? \
	AND \
	(\
		(\
			PROPERTY_MAPPING_ID=? \
			AND PROPERTY_MAPPING_TYPE=?\
		) \
		OR \
		(\
			PROPERTY_MAPPING_ID=? \
			AND PROPERTY_MAPPING_TYPE=?\
		)\
	)


C_PROPERTIES_DELETE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	PROPERTYDEF_ID=?  \
	AND PROPERTY_MAPPING_ID=? \
	AND PROPERTY_MAPPING_TYPE=?
	

#
# Groups
#
C_GROUPS_GROUP_ID=GROUP_ID
C_GROUPS_PARENT_GROUP_ID=PARENT_GROUP_ID
C_GROUPS_GROUP_NAME=GROUP_NAME
C_GROUPS_GROUP_DESCRIPTION=GROUP_DESCRIPTION
C_GROUPS_GROUP_FLAGS=GROUP_FLAGS


C_GROUPS_READGROUP=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	GROUP_NAME=?
	
	
C_GROUPS_READGROUP2=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	GROUP_ID=?
	
	
C_GROUPS_CREATEGROUP=\
INSERT INTO CMS_GROUPS \
VALUES \
	(?,?,?,?,?)
	
	
C_GROUPS_WRITEGROUP=\
UPDATE \
	CMS_GROUPS \
SET \
	GROUP_DESCRIPTION=?,\
	GROUP_FLAGS=?,\
	PARENT_GROUP_ID=? \
WHERE \
	GROUP_ID=?
	
	
C_GROUPS_DELETEGROUP=\
DELETE FROM \
	CMS_GROUPS \
WHERE \
	GROUP_NAME=?
	
	
C_GROUPS_GETGROUPS=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
ORDER BY \
	GROUP_NAME
	
	
C_GROUPS_GETCHILD=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	PARENT_GROUP_ID=?
	
	
C_GROUPS_GETGROUPSOFUSER=\
SELECT \
	* \
FROM \
	CMS_GROUPS G,\
	CMS_GROUPUSERS GU \
WHERE \
	GU.USER_ID=? \
                         AND G.GROUP_ID=GU.GROUP_ID
	
	
C_GROUPS_ADDUSERTOGROUP=\
INSERT INTO CMS_GROUPUSERS \
	(GROUP_ID,\
	USER_ID,\
	GROUPUSER_FLAGS) \
VALUES \
	(?,?,?)
	
	
C_GROUPS_USERINGROUP=\
SELECT \
	* \
FROM \
	CMS_GROUPUSERS \
WHERE \
	GROUP_ID=? \
	AND USER_ID=?
	
	
C_GROUPS_GETUSERSOFGROUP=\
SELECT \
	U.USER_INFO,\
	U.USER_ID,\
	U.USER_NAME,\
	U.USER_PASSWORD,\
	U.USER_DESCRIPTION,\
	U.USER_FIRSTNAME,\
	U.USER_LASTNAME,\
	U.USER_EMAIL,\
	U.USER_LASTLOGIN,\
	U.USER_FLAGS,\
	U.USER_ADDRESS,\
	U.USER_TYPE \
FROM \
	CMS_GROUPS G, \
	CMS_USERS U, \
	CMS_GROUPUSERS GU \
WHERE \
	G.GROUP_NAME=? \
    AND U.USER_ID=GU.USER_ID \
    AND GU.GROUP_ID=G.GROUP_ID \
    AND U.USER_TYPE IN (?, 2)  \
ORDER BY \
	USER_NAME

	
C_GROUPS_REMOVEUSERFROMGROUP=\
DELETE FROM \
	CMS_GROUPUSERS \
WHERE \
	GROUP_ID=? \
	AND USER_ID=?


#
# Users
#
C_USERS_USER_ID=USER_ID
C_USERS_USER_NAME=USER_NAME
C_USERS_USER_PASSWORD=USER_PASSWORD
C_USERS_USER_DESCRIPTION=USER_DESCRIPTION
C_USERS_USER_FIRSTNAME=USER_FIRSTNAME
C_USERS_USER_LASTNAME=USER_LASTNAME
C_USERS_USER_LASTLOGIN=USER_LASTLOGIN
C_USERS_USER_FLAGS=USER_FLAGS
C_USERS_USER_INFO=USER_INFO
C_USERS_USER_ADDRESS=USER_ADDRESS
C_USERS_USER_TYPE=USER_TYPE
C_USERS_USER_EMAIL=USER_EMAIL



C_USERS_ADD=\
INSERT INTO CMS_USERS \
	(USER_ID,\
	USER_NAME,\
	USER_PASSWORD,\
	USER_DESCRIPTION,\
	USER_FIRSTNAME,\
	USER_LASTNAME,\
	USER_EMAIL,\
	USER_LASTLOGIN,\
	USER_FLAGS,\
	USER_INFO,\
	USER_ADDRESS,\
	USER_TYPE) \