fxgl_v3_pcweb_table_define.sql 2.9 KB

123456789101112131415161718192021
  1. insert into TableDefine (TableKey, TableType, TableName, TabelMenu, Remark) values ('table_pcweb_test', 2, '', '', '');
  2. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  3. values (seq_TableColumnConfig.Nextval, 'table_pcweb_test', 'rolename', '角色名称', '120', 10, 1, '1', '', '', 'rolename', 0, 0, '');
  4. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  5. values (seq_TableColumnConfig.Nextval, 'table_pcweb_test', 'modifiername', '创建人', '120', 20, 1, '1', '', '', 'modifiername', 0, 0, '');
  6. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  7. values (seq_TableColumnConfig.Nextval, 'table_pcweb_test', 'modifytime', '创建时间', '120', 30, 1, '1', '', '', 'modifytime', 0, 0, '');
  8. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  9. values (seq_TableColumnConfig.Nextval, 'table_pcweb_test', 'rolestatus', '状态', '120', 40, 1, '1', '', '', 'rolestatus', 0, 0, '');
  10. insert into TableDefine (TableKey, TableType, TableName, TabelMenu, Remark) values ('table_pcweb_testddd', 2, '', '', '');
  11. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  12. values (seq_TableColumnConfig.Nextval, 'table_pcweb_testddd', 'rolename', '角色名称', '120', 10, 1, '1', '', '', 'rolename', 0, 0, '');
  13. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  14. values (seq_TableColumnConfig.Nextval, 'table_pcweb_testddd', 'modifiername', '创建人', '120', 20, 1, '1', '', '', 'modifiername', 0, 0, '');
  15. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  16. values (seq_TableColumnConfig.Nextval, 'table_pcweb_testddd', 'modifytime', '创建时间', '120', 30, 1, '1', '', '', 'modifytime', 0, 0, '');
  17. insert into TableColumnConfig (AutoID, TableKey, ColumnField, ColumnTitle, ColumnWidth, OrderIndex, IsShow, AlignType, FormatterType, FormatterString, Remark, NeedSummary, SummaryType, GroupName)
  18. values (seq_TableColumnConfig.Nextval, 'table_pcweb_testddd', 'rolestatus', '状态', '120', 40, 1, '1', '', '', 'rolestatus', 0, 0, '');