dokeos_main_corp.sql 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. INSERT INTO settings_current
  2. (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext)
  3. VALUES
  4. ('search_enabled',NULL,'radio','Tools','false','EnableSearchTitle','EnableSearchComment',NULL,NULL),
  5. ('search_prefilter_prefix',NULL, NULL,'Search','','SearchPrefilterPrefix','SearchPrefilterPrefixComment',NULL,NULL),
  6. ('search_show_unlinked_results',NULL,'radio','Search','true','SearchShowUnlinkedResultsTitle','SearchShowUnlinkedResultsComment',NULL,NULL);
  7. INSERT INTO settings_options
  8. (variable, value, display_text)
  9. VALUES
  10. ('search_enabled', 'true', 'Yes'),
  11. ('search_enabled', 'false', 'No'),
  12. ('search_show_unlinked_results', 'true', 'SearchShowUnlinkedResults'),
  13. ('search_show_unlinked_results', 'false', 'SearchHideUnlinkedResults');
  14. -- specific fields tables
  15. CREATE TABLE specific_field (
  16. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  17. code char(1) NOT NULL,
  18. name VARCHAR( 200 ) NOT NULL
  19. );
  20. CREATE TABLE specific_field_values (
  21. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  22. course_code VARCHAR( 40 ) NOT NULL ,
  23. tool_id VARCHAR( 100 ) NOT NULL ,
  24. ref_id INT NOT NULL ,
  25. field_id INT NOT NULL ,
  26. value VARCHAR( 200 ) NOT NULL
  27. );
  28. ALTER TABLE specific_field ADD CONSTRAINT unique_specific_field__code UNIQUE (code);
  29. -- search engine references to map dokeos resources
  30. CREATE TABLE search_engine_ref (
  31. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  32. course_code VARCHAR( 40 ) NOT NULL,
  33. tool_id VARCHAR( 100 ) NOT NULL,
  34. ref_id_high_level INT NOT NULL,
  35. ref_id_second_level INT NULL,
  36. search_did INT NOT NULL
  37. );
  38. INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext) VALUES ('allow_message_tool', NULL, 'radio', 'Tools', 'false', 'AllowMessageToolTitle', 'AllowMessageToolComment', NULL, NULL);
  39. INSERT INTO settings_options (variable, value, display_text) VALUES ('allow_message_tool', 'true', 'Yes');
  40. INSERT INTO settings_options (variable, value, display_text) VALUES ('allow_message_tool', 'false', 'No');