Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $installer = $this;
- $installer->startSetup();
- $table = $installer->getConnection()
- ->newTable($installer->getTable('module_learning/basedata'))
- ->addColumn('ticket_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
- 'identity' => true,
- 'unsigned' => true,
- 'nullable' => false,
- 'primary' => true,
- ), 'Id')
- ->addColumn('title', Varien_Db_Ddl_Table::TYPE_VARCHAR, null, array(
- 'nullable' => false,
- ), 'Title')
- ->addColumn('description', Varien_Db_Ddl_Table::TYPE_TEXT, null, array(
- 'nullable' => false,
- ), 'Description');
- $installer->getConnection()->createTable($table);
- $table = $installer->getConnection()
- ->newTable($installer->getTable('module_learning/comment'))
- ->addColumn('comment_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
- 'identity' => true,
- 'unsigned' => true,
- 'nullable' => false,
- 'primary' => true,
- ), 'Id')
- ->addColumn('comment', Varien_Db_Ddl_Table::TYPE_VARCHAR, null, array(
- 'nullable' => false,
- ), 'Comment');
- $installer->getConnection()->createTable($table);
- $installer->endSetup();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement