ui-dt-checkbox.sql

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

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'Check Box'
 ,'Individual true/false check box<BR><BR>Translates to an < INPUT type=CHECKBOX > HTML tag, and is used to specify true or false'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'CHECKED_DISPLAY'
 ,'Checked Display Value'
 ,'Checked Display Value<BR><BR>Value to be displayed in readonly mode when the checkbox is checked.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'CHECKED_VALUE'
 ,'Checked Value'
 ,'Checked Value<BR><BR>Value to be stored in the database when the checkbox is checked.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'CLASS'
 ,'Class'
 ,'Style class<BR><BR>Defines what style from the style sheet to assign to the CLASS attribute of the < INPUT > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'DISABLED'
 ,'Disabled'
 ,'Disabled<BR><BR>Translates to DISABLED attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'READONLY'
 ,'Read Only'
 ,'Read only<BR><BR>Translates to READONLY attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'SIZE'
 ,'Size'
 ,'Field size<BR>Translates to SIZE attribute of HTML < INPUT > tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'UNCHECKED_DISPLAY'
 ,'Unchecked Display Value'
 ,'Checked Display Value<BR><BR>Value to be displayed in readonly mode when the checkbox is not checked.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'CHECKBOX'
 ,'UNCHECKED_VALUE'
 ,'Unchecked Value'
 ,'Unchecked Value<BR><BR>Value to be stored in the database when the checkbox is not checked.'
);