
ALTER TABLE `was_openai_author`
ADD `is_text_output` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
AFTER `author_model`;


INSERT INTO `was_openai_author` (`openai_article_type_id`, `author_order`, `author_name`, `author_description`, `author_thumbnail`, `author_prompt`, `author_prompt_seo`, `author_prompt_first`, `author_prompt_next`, `author_prompt_last`, `author_membership_level`, `author_model`, `is_text_output`)
SELECT
  `openai_article_type_id`,
  `author_order`,
  CONCAT(`author_name`, ' (Html)') AS author_name,
  `author_description`,
  `author_thumbnail`,
  `author_prompt`,
  `author_prompt_seo`,
  'Write article section 1. Ensure to write considering the author persona detailed above.  Ensure to write considering the author persona and style. Provide advice and be a guide. The output should be formatted in HTML. The allowed HTML tags are <h1>. <h2>, <h3>, <b>, <i>, <li>, <ul>, <ol>, <a>, <p>, <br>. ' AS `author_prompt_first`,
  'Now write article section {{current}}.  Ensure to write considering the author persona and style. Consider all previously written sections to avoid repeating phrases. Provide advice and be a guide. The output should be formatted in HTML. The allowed HTML tags are <h1>. <h2>, <h3>, <b>, <i>, <li>, <ul>, <ol>, <a>, <p>, <br>. ' AS `author_prompt_next`,
  'Now write article section {{last}}, which is the last section of this article. Ensure to write considering the author persona and style. Consider all previously written sections to avoid repeating phrases. Provide advice and be a guide. The output should be formatted in HTML. The allowed HTML tags are <h1>. <h2>, <h3>, <b>, <i>, <li>, <ul>, <ol>, <a>, <p>, <br>. ' AS `author_prompt_last`,
  `author_membership_level`,
  `author_model`,
  1 AS `is_text_output`
FROM
  was_openai_author a
WHERE
  a.openai_article_type_id = 1;


ALTER TABLE `was_openai_article_content_section`
ADD `section_text` TEXT NULL DEFAULT NULL
AFTER `section_heading`;
