<?php
$installer = $this;
$installer->startSetup();
$installer->run("\r\n\r\nDROP TABLE IF EXISTS {$this->getTable('luckydraw_code')};\r\nDROP TABLE IF EXISTS {$this->getTable('luckydraw_program')};\r\n\r\nCREATE TABLE {$this->getTable('luckydraw_program')} (\r\n `program_id` int(10) unsigned NOT NULL auto_increment,\r\n `name` varchar(255) NOT NULL default '',\r\n `short_description` text NULL,\r\n `award_image` varchar(255) NULL,\r\n `description` mediumtext NULL,\r\n `url_key` varchar(255) NULL,\r\n `status` smallint(5) default '0',\r\n `created_time` datetime NULL,\r\n `start_time` datetime NULL,\r\n `end_time` datetime NULL,\r\n `code_length` smallint(5) default '5',\r\n `min_user` smallint(5) default '0',\r\n `auto_prize` tinyint(1) default '0',\r\n `prize_code` varchar(255) default '',\r\n `prize_days` int(10) default '0',\r\n `credit_rate` decimal(12,4) NOT NULL default '0',\r\n `term_condition` mediumtext NULL,\r\n `store_ids` text NULL,\r\n PRIMARY KEY (`program_id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE {$this->getTable('luckydraw_code')} (\r\n `code_id` int(10) unsigned NOT NULL auto_increment,\r\n `program_id` int(10) unsigned NOT NULL,\r\n `customer_id` int(10) unsigned NOT NULL,\r\n `refer_user` int(10) unsigned NOT NULL,\r\n `refer_email` varchar(255) NULL,\r\n `name` varchar(255) NULL,\r\n `email` varchar(255) NULL,\r\n `address_id` int(10) unsigned NULL,\r\n `order_id` int(10) unsigned NOT NULL,\r\n `order_increment_id` varchar(127) NULL,\r\n `draw_code` varchar(255) NULL,\r\n `created_time` datetime NULL,\r\n `expired_time` datetime NULL,\r\n `status` smallint(5) default '0',\r\n `is_prize` tinyint(1) default '0',\r\n `credit_rate` decimal(12,4) NOT NULL default '0',\r\n PRIMARY KEY (`code_id`),\r\n INDEX (`program_id`),\r\n FOREIGN KEY (`program_id`)\r\n REFERENCES {$this->getTable('luckydraw_program')} (`program_id`)\r\n ON DELETE CASCADE\r\n ON UPDATE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n ");
try {
$installer->run("\r\n\tALTER TABLE {$this->getTable('sales/order')}\r\n\t\tADD COLUMN `luckydraw_discount` decimal(12,4) default NULL,\r\n\t\tADD COLUMN `base_luckydraw_discount` decimal(12,4) default NULL;\r\n\t");
} catch (Exception $e) {
}
try {
$setup = new Mage_Customer_Model_Entity_Setup();
$setup->addAttribute('customer', 'national_id', array('group' => 'General', 'type' => 'varchar', 'input' => 'text', 'label' => 'National Identification', 'visible' => 1, 'required' => 0, 'visible_on_front' => 1, 'sort_order' => 120));
$setup->getConnection()->insertMultiple($setup->getTable('customer/form_attribute'), array(array('form_code' => 'adminhtml_customer', 'attribute_id' => $setup->getAttributeId('customer', 'national_id'))));
} catch (Exception $e) {
}
$installer->endSetup();
