Feature #35
Updated by Cyber Collie 14 days ago
* [ ] The checks on inserts need to be relaxed to allow inserting questions to be inserted as children of proposals and disputes disputes. * [ ] prohibit Inserting questions as children of questions is still prohibited. * [ ] prohibit Also inserting proposals as children of proposals was not prohibited until now, but should be. * [ ] add column discussion_elements.question_count * integer There also needs to be a new row in discussion_elements that counts tracks the number amount of child questions a discussion children of an element has * count of the that is incremented whenever a question. This column should be named "question_count". It should be counted up when a new question is inserted * inserted. ``` sql ALTER TABLE `polarity`.`discussion_elements` ADD COLUMN `question_count` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `proposal_count`; ``` * [ ] discussion_elements.question_count This new value also needs to be sent to the client, client when a discussion is fetched fetching discussions and when searching.