ui.sql 462 B

1234567891011121314151617
  1. CREATE DATABASE `saas_ui` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  2. use `saas_ui`;
  3. create table `ui_page`(
  4. id int unsigned primary key not null auto_increment,
  5. description varchar(500) not null,
  6. xtype varchar(50),
  7. layout json
  8. );
  9. create table `ui_form`(
  10. id int unsigned primary key not null auto_increment,
  11. page_id varchar(100) not null,
  12. field_name varchar(100) not null,
  13. field_desc varchar(100) not null,
  14. field_order int not null
  15. );