Commits

Anonymous committed a401192

Updated sql scripts to use the correct quote characters for MySQL

Comments (0)

Files changed (2)

Umbraco.Hive.Providers.Wordpress/Scripts/categories_view.sql

-CREATE VIEW 'wordpress'.'categories' AS
+CREATE VIEW `wordpress`.`categories` AS
 SELECT wp_terms.*, wp_term_taxonomy.parent, wp_term_taxonomy.count FROM wp_terms INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id WHERE wp_term_taxonomy.taxonomy = 'category'

Umbraco.Hive.Providers.Wordpress/Scripts/posts_view.sql

-CREATE VIEW 'wordpress'.'posts' AS
+CREATE VIEW `wordpress`.`posts` AS
 SELECT wp_posts.*, wp_users.display_name AS author FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE wp_posts.post_type = 'post' AND wp_posts.post_status = 'publish'