国外的一套开源CRM

源代码在线查看: ui-e-uiusagehistory.sql

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

相关代码

				-- Insert UiEntity
				INSERT INTO UI_ENTITY (
				  ENTITY_ID
				 ,ENTITY_NAME
				 ,TABLE_NAME
				 ,EXT_TABLE_NAME
				 ,DESCRIPTION
				) VALUES (
				  '10010'
				 ,'UiUsageHistory'
				 ,'ui_usage_history'
				 ,''
				 ,'UI Usage History'
				);
				
				-- Insert UiAttribute
				INSERT INTO UI_ATTRIBUTE (
				  ATTRIBUTE_ID
				 ,ENTITY_ID
				 ,ATTRIBUTE_NAME
				 ,DESCRIPTION
				 ,COLUMN_NAME
				 ,DISPLAY_OBJECT_ID
				 ,MAX_LENGTH
				 ,EDIT_MASK
				 ,DISPLAY_LOGIC
				 ,IS_MANDATORY
				 ,IS_READ_ONLY
				 ,IS_VISIBLE
				 ,IS_SEARCHABLE
				 ,IS_EXTENSION
				 ,DISPLAY_ORDER
				 ,DISPLAY_LABEL
				 ,DISPLAY_LENGTH
				 ,COL_SPAN
				 ,ROW_SPAN
				) VALUES (
				  '10080'
				 ,'10010'
				 ,'usageHistoryId'
				 ,'Usage History ID'
				 ,'usage_history_id'
				 ,'1'
				 ,'20'
				 ,''
				 ,''
				 ,'Y'
				 ,'N'
				 ,'N'
				 ,'N'
				 ,'N'
				 ,'1'
				 ,'Usage History ID'
				 ,'20'
				 ,'1'
				 ,'1'
				);
				
				-- Insert UiAttribute
				INSERT INTO UI_ATTRIBUTE (
				  ATTRIBUTE_ID
				 ,ENTITY_ID
				 ,ATTRIBUTE_NAME
				 ,DESCRIPTION
				 ,COLUMN_NAME
				 ,DISPLAY_OBJECT_ID
				 ,MAX_LENGTH
				 ,EDIT_MASK
				 ,DISPLAY_LOGIC
				 ,IS_MANDATORY
				 ,IS_READ_ONLY
				 ,IS_VISIBLE
				 ,IS_SEARCHABLE
				 ,IS_EXTENSION
				 ,DISPLAY_ORDER
				 ,DISPLAY_LABEL
				 ,DISPLAY_LENGTH
				 ,COL_SPAN
				 ,ROW_SPAN
				) VALUES (
				  '10081'
				 ,'10010'
				 ,'partyId'
				 ,'Party Id'
				 ,'party_id'
				 ,'1'
				 ,'20'
				 ,''
				 ,''
				 ,'N'
				 ,'N'
				 ,'Y'
				 ,'Y'
				 ,'N'
				 ,'2'
				 ,'Party Id'
				 ,'20'
				 ,'1'
				 ,'1'
				);
				
				-- Insert UiAttribute
				INSERT INTO UI_ATTRIBUTE (
				  ATTRIBUTE_ID
				 ,ENTITY_ID
				 ,ATTRIBUTE_NAME
				 ,DESCRIPTION
				 ,COLUMN_NAME
				 ,DISPLAY_OBJECT_ID
				 ,MAX_LENGTH
				 ,EDIT_MASK
				 ,DISPLAY_LOGIC
				 ,IS_MANDATORY
				 ,IS_READ_ONLY
				 ,IS_VISIBLE
				 ,IS_SEARCHABLE
				 ,IS_EXTENSION
				 ,DISPLAY_ORDER
				 ,DISPLAY_LABEL
				 ,DISPLAY_LENGTH
				 ,COL_SPAN
				 ,ROW_SPAN
				) VALUES (
				  '10082'
				 ,'10010'
				 ,'description'
				 ,'description'
				 ,'description'
				 ,'2'
				 ,'40'
				 ,''
				 ,''
				 ,'N'
				 ,'N'
				 ,'Y'
				 ,'Y'
				 ,'N'
				 ,'3'
				 ,'description'
				 ,'40'
				 ,'1'
				 ,'1'
				);
				
				-- Insert UiAttribute
				INSERT INTO UI_ATTRIBUTE (
				  ATTRIBUTE_ID
				 ,ENTITY_ID
				 ,ATTRIBUTE_NAME
				 ,DESCRIPTION
				 ,COLUMN_NAME
				 ,DISPLAY_OBJECT_ID
				 ,MAX_LENGTH
				 ,EDIT_MASK
				 ,DISPLAY_LOGIC
				 ,IS_MANDATORY
				 ,IS_READ_ONLY
				 ,IS_VISIBLE
				 ,IS_SEARCHABLE
				 ,IS_EXTENSION
				 ,DISPLAY_ORDER
				 ,DISPLAY_LABEL
				 ,DISPLAY_LENGTH
				 ,COL_SPAN
				 ,ROW_SPAN
				) VALUES (
				  '10083'
				 ,'10010'
				 ,'url'
				 ,'url'
				 ,'url'
				 ,'34'
				 ,'255'
				 ,''
				 ,''
				 ,'N'
				 ,'N'
				 ,'Y'
				 ,'Y'
				 ,'N'
				 ,'4'
				 ,'url'
				 ,'255'
				 ,'1'
				 ,'1'
				);
				
				-- Insert UiAttribute
				INSERT INTO UI_ATTRIBUTE (
				  ATTRIBUTE_ID
				 ,ENTITY_ID
				 ,ATTRIBUTE_NAME
				 ,DESCRIPTION
				 ,COLUMN_NAME
				 ,DISPLAY_OBJECT_ID
				 ,MAX_LENGTH
				 ,EDIT_MASK
				 ,DISPLAY_LOGIC
				 ,IS_MANDATORY
				 ,IS_READ_ONLY
				 ,IS_VISIBLE
				 ,IS_SEARCHABLE
				 ,IS_EXTENSION
				 ,DISPLAY_ORDER
				 ,DISPLAY_LABEL
				 ,DISPLAY_LENGTH
				 ,COL_SPAN
				 ,ROW_SPAN
				) VALUES (
				  '10085'
				 ,'10010'
				 ,'timestamp'
				 ,'timestamp'
				 ,'timestamp'
				 ,'17'
				 ,'20'
				 ,''
				 ,''
				 ,'N'
				 ,'N'
				 ,'Y'
				 ,'Y'
				 ,'N'
				 ,'6'
				 ,'timestamp'
				 ,'20'
				 ,'1'
				 ,'1'
				);
				
							

相关资源