• Home
• io.github.forsyde
• forsyde-io-java-sdf3
• 0.7.4
• source code
• create_task_views.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.create_task_views.sql Maven / Gradle / Ivy

CREATE VIEW IF NOT EXISTS `tasks` AS
SELECT `vertex_id`, v.`type_name`, t.`super_type_name` FROM _vertexes AS v
  JOIN super_types AS t ON v.type_name = t.super_type_name
WHERE
  v.`type_name` = t.`type_name` AND
  t.`super_type_name` = 'AbstractOrdering'