国外的一套开源CRM

				-- Insert UiDisplayType
				INSERT INTO UI_DISPLAY_TYPE (
				  DISPLAY_TYPE_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'Time Field'
				 ,'Time fieldTranslates to an < INPUT type=TEXT > HTML tag.'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'ALIGN'
				 ,'Text Alignment'
				 ,'Text alignmentTranslates to ALIGN attribute of HTML < INPUT > tag.Value can be TOP, MIDDLE, or BOTTOM.'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'ANCHOR_HREF_DEF'
				 ,'Anchor (Link) Reference Definition'
				 ,'Anchor (Link) Reference DefinitionIf this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.Contents must be a semicolon-delimited list of attribute names from the listed entity.Literal strings may also be embedded with quotes around them.Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag."#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 (
				  'TIME'
				 ,'ANCHOR_TARGET'
				 ,'Anchor (Link) Target'
				 ,'Anchor (Link) TargetIf 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 (
				  'TIME'
				 ,'CLASS'
				 ,'Class'
				 ,'Style classDefines 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 (
				  'TIME'
				 ,'DISABLED'
				 ,'Disabled'
				 ,'DisabledTranslates to DISABLED attribute of HTML < INPUT > tag.Value should be Y or N.'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'DISPLAY_MASK'
				 ,'Display Mask'
				 ,'Display maskDetermines how the date and time will be displayed.Examples:MM/DD/YYYY HH24:MI:SSMon D, YYYY H:MI AMM/D/YY HH AM'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'MAXLENGTH'
				 ,'Maximum Length'
				 ,'Maximum data lengthTranslates to MAXLENGTH attribute of HTML < INPUT > tag'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'READONLY'
				 ,'Read Only'
				 ,'Read onlyTranslates to READONLY attribute of HTML < INPUT > tag.Value should be Y or N.'
				);
				
				-- Insert UiDisplayAttrib
				INSERT INTO UI_DISPLAY_ATTRIB (
				  DISPLAY_TYPE_ID
				 ,DISPLAY_ATTRIB_ID
				 ,NAME
				 ,DESCRIPTION
				) VALUES (
				  'TIME'
				 ,'SIZE'
				 ,'Field Size'
				 ,'Field sizeTranslates to SIZE attribute of HTML < INPUT > tag'
				);