Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?php
  2.  
  3. $installer = $this;
  4.  
  5. $installer->startSetup();
  6.  
  7. $table = $installer->getConnection()
  8. ->newTable($installer->getTable('module_learning/basedata'))
  9. ->addColumn('ticket_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
  10. 'identity' => true,
  11. 'unsigned' => true,
  12. 'nullable' => false,
  13. 'primary' => true,
  14. ), 'Id')
  15. ->addColumn('title', Varien_Db_Ddl_Table::TYPE_VARCHAR, null, array(
  16. 'nullable' => false,
  17. ), 'Title')
  18. ->addColumn('description', Varien_Db_Ddl_Table::TYPE_TEXT, null, array(
  19. 'nullable' => false,
  20. ), 'Description');
  21. $installer->getConnection()->createTable($table);
  22.  
  23. $table = $installer->getConnection()
  24. ->newTable($installer->getTable('module_learning/comment'))
  25. ->addColumn('comment_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
  26. 'identity' => true,
  27. 'unsigned' => true,
  28. 'nullable' => false,
  29. 'primary' => true,
  30. ), 'Id')
  31. ->addColumn('comment', Varien_Db_Ddl_Table::TYPE_VARCHAR, null, array(
  32. 'nullable' => false,
  33. ), 'Comment');
  34. $installer->getConnection()->createTable($table);
  35.  
  36. $installer->endSetup();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement