Posted By

Garciat on 12/23/08


Tagged


Versions (?)

EPF


 / Published in: XML
 

  1. <install>
  2. <![CDATA[
  3. if(!defined('EXT_CUR_VERSION'))
  4. {
  5. $query = array(
  6. 'FIELDS' => array(
  7. 'entry_id' => array(
  8. 'datatype' => 'SERIAL',
  9. 'allow_null' => false
  10. ),
  11. 'field_id' => array(
  12. 'datatype' => 'INT(10) UNSIGNED',
  13. 'allow_null' => false
  14. ),
  15. 'user_id' => array(
  16. 'datatype' => 'INT(10) UNSIGNED',
  17. 'allow_null' => false
  18. ),
  19. 'value' => array(
  20. 'datatype' => 'TEXT',
  21. 'allow_null' => true
  22. )
  23. )
  24. );
  25. $forum_db->create_table('epf_entries', $schema) or error(__FILE__, __LINE__);
  26.  
  27. $query = array(
  28. 'FIELDS' => array(
  29. 'field_id' => array(
  30. 'datatype' => 'SERIAL',
  31. 'allow_null' => false
  32. ),
  33. 'field_type' => array(
  34. 'datatype' => 'SMALLINT(10)',
  35. 'allow_null' => false
  36. ),
  37. 'field_name' => array(
  38. 'datatype' => 'VARCHAR(255)',
  39. 'allow_null' => false
  40. ),
  41. 'field_position' => array(
  42. 'datatype' => 'INT(11)',
  43. 'allow_null' => false
  44. )
  45. 'field_options' => array(
  46. 'datatype' => 'TEXT',
  47. 'allow_null' => true
  48. )
  49. )
  50. );
  51. $forum_db->create_table('epf_fields', $schema) or error(__FILE__, __LINE__);
  52. }
  53. ]]>
  54. </install>
  55.  
  56. <uninstall>
  57. <![CDATA[
  58. $forum_db->drop_table('epf_entries') or error(__FILE__, __LINE__);
  59. $forum_db->drop_table('epf_fields') or error(__FILE__, __LINE__);
  60. @unlink(PUN_CACHE_DIR.'cache_epf.php');
  61. ]]>
  62. </uninstall>

Report this snippet  

You need to login to post a comment.