schema.sql 791 B

12345678910111213141516171819202122
  1. create table IF NOT EXISTS `EL_TABLE`
  2. (
  3. `id` bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
  4. `application_name` varchar(32) NOT NULL,
  5. `chain_name` varchar(32) NOT NULL,
  6. `el_data` varchar(1024) NOT NULL,
  7. `route` varchar(1024),
  8. `namespace` varchar(32),
  9. PRIMARY KEY (`id`)
  10. );
  11. create table IF NOT EXISTS `script_node_table`
  12. (
  13. `id` bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
  14. `application_name` varchar(32) NOT NULL,
  15. `script_node_id` varchar(32) NOT NULL,
  16. `script_node_name` varchar(32) NOT NULL,
  17. `script_node_type` varchar(32) NOT NULL,
  18. `script_node_data` varchar(1024) NOT NULL,
  19. `script_language` varchar(1024) NOT NULL,
  20. PRIMARY KEY (`id`)
  21. );