⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 ui-e-userlogin.sql

📁 国外的一套开源CRM
💻 SQL
字号:
-- Insert UiEntity
INSERT INTO UI_ENTITY (
  ENTITY_ID
 ,ENTITY_NAME
 ,TABLE_NAME
 ,EXT_TABLE_NAME
 ,DESCRIPTION
) VALUES (
  '13'
 ,'UserLogin'
 ,'USER_LOGIN'
 ,''
 ,'User Login'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '117'
 ,'13'
 ,'userLoginId'
 ,'user Login ID (User Login)'
 ,'USER_LOGIN_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'1'
 ,'User Login ID'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '118'
 ,'13'
 ,'partyId'
 ,'Party ID (User Login)'
 ,'PARTY_ID'
 ,'10'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'N'
 ,''
 ,''
 ,'1'
 ,'Party ID'
 ,'0'
 ,'1'
 ,'2'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '119'
 ,'13'
 ,'currentPassword'
 ,'Password'
 ,'CURRENT_PASSWORD'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'3'
 ,'Password'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '120'
 ,'13'
 ,'passwordHint'
 ,'Password Hint'
 ,'PASSWORD_HINT'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'4'
 ,'Password Hint'
 ,'0'
 ,'1'
 ,'1'
);

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -