ui-do-10012.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 196 行

-- Insert UiDisplayObject
INSERT INTO UI_DISPLAY_OBJECT (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  '10012'
 ,'SELECT'
 ,'Select - System'
 ,'Select System Codes'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'CLASS'
 ,'selectBox'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'DISABLED'
 ,'N'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'EMPTY_FIRST'
 ,'Y'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY'
 ,'Code'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_DISPLAY_DEF'
 ,'codeValue'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_FIND_DEF'
 ,'codeTypeId:"SYSTEM"'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_FIND_METHOD'
 ,'ATTRIBUTE_MATCH'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_ORDER_DEF'
 ,'codeId'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_PK_FIND_DEF'
 ,'codeTypeId:"SYSTEM";codeId:#currentField'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'ENTITY_VALUE_DEF'
 ,'codeId'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'EVENT_HANDLING'
 ,''
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'FILL_METHOD'
 ,'ENTITY'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'FIXED_VALUES'
 ,''
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '10012'
 ,'SELECT'
 ,'SIZE'
 ,''
);