ui-do-41.sql

国外的一套开源CRM

-- Insert UiDisplayObject
INSERT INTO UI_DISPLAY_OBJECT (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'Checkbox - Standard'
 ,'Standard Check Box'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'CHECKED_DISPLAY'
 ,'Yes'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'CHECKED_VALUE'
 ,'Y'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'CLASS'
 ,'checkBox'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'DISABLED'
 ,''
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'READONLY'
 ,''
);

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

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'UNCHECKED_DISPLAY'
 ,'No'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '41'
 ,'CHECKBOX'
 ,'UNCHECKED_VALUE'
 ,'N'
);