国外的一套开源CRM

源代码在线查看: ui-do-6.sql

软件大小: 44839 K
上传用户: nihao464667180
关键词: CRM 开源
下载地址: 免注册下载 普通下载 VIP

相关代码

				-- Insert UiDisplayObject
				INSERT INTO UI_DISPLAY_OBJECT (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'Select - Ownership Type'
				 ,'Ownership Type Select Box'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'CLASS'
				 ,'selectBox'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'DISABLED'
				 ,'N'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'EMPTY_FIRST'
				 ,'Y'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY'
				 ,'OwnershipType'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_DISPLAY_DEF'
				 ,'ownershipTypeName'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_FIND_DEF'
				 ,''
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_FIND_METHOD'
				 ,'ALL'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_ORDER_DEF'
				 ,'ownershipTypeName'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_PK_FIND_DEF'
				 ,'ownershipTypeId:#currentField'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'ENTITY_VALUE_DEF'
				 ,'ownershipTypeId'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'EVENT_HANDLING'
				 ,''
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'FILL_METHOD'
				 ,'ENTITY'
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'FIXED_VALUES'
				 ,''
				);
				
				-- Insert UiDisplayObjectAttrib
				INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
				  DISPLAY_OBJECT_ID
				 ,DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,ATTRIBUTE_VALUE
				) VALUES (
				  '6'
				 ,'SELECT'
				 ,'SIZE'
				 ,''
				);
				
							

相关资源