ui-dt-datetime.sql

国外的一套开源CRM

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'Date Time Field'
 ,'Date time field<BR><BR>Translates to an < INPUT type=TEXT > HTML tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'ALIGN'
 ,'Text Alignment'
 ,'Text alignment<BR><BR>Translates to ALIGN attribute of HTML < INPUT > tag.<BR>Value can be TOP, MIDDLE, or BOTTOM.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'ANCHOR_HREF_DEF'
 ,'Anchor (Link) Reference Definition'
 ,'Anchor (Link) Reference Definition<BR><BR>If this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.<BR><BR>Contents must be a semicolon-delimited list of attribute names from the listed entity.<BR>Literal strings may also be embedded with quotes around them.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'ANCHOR_TARGET'
 ,'Anchor (Link) Target'
 ,'Anchor (Link) Target<BR><BR>If this parameter and the ANCHOR_HREF_DEF parameter are set, the field will be displayed as an HTML < A > tag when in read-only mode, and the value of this parameter will be used as the value for the TARGET attribute of the < A > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'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 (
  'DATETIME'
 ,'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 (
  'DATETIME'
 ,'DISPLAY_MASK'
 ,'Display Mask'
 ,'Display mask<BR><BR>Determines how the time will be displayed.<BR><BR>Examples:<BR>HH24:MI:SS<BR>H:MI AM<BR>HH AM'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'DATETIME'
 ,'MAXLENGTH'
 ,'Maximum Length'
 ,'Maximum data length<BR><BR>Translates to MAXLENGTH attribute of HTML < INPUT > tag'
);

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