/app/code/community/Devinc/Groupdeals/sql/groupdeals_setup/mysql4-install-0.1.0.php

https://bitbucket.org/acidel/buykoala · PHP · 128 lines · 110 code · 15 blank · 3 comment · 0 complexity · f74e147c5ea656c5805fca2fb3d263d0 MD5 · raw file 

    

  1. <?php


    2. 

  2. $installer = $this;


    3. 

  3. 


    4. 

  4. // Create attribute set and deal attributes


    5. 

  5. Mage::getModel('groupdeals/groupdeals')->createAttributeSet();


    6. 

  6. 


    7. 

  7. // Add tables


    8. 

  8. $installer->startSetup();


    9. 

  9. 


    10. 

  10. $installer->run("


    11. 

  11. 


    12. 

  12. DROP TABLE IF EXISTS {$installer->getTable('groupdeals')};


    13. 

  13. CREATE TABLE {$installer->getTable('groupdeals')} (


    14. 

  14.   `groupdeals_id` int(11) unsigned NOT NULL auto_increment,


    15. 

  15.   `product_id` int(11) NOT NULL,


    16. 

  16.   `merchant_id` int(11) NOT NULL,


    17. 

  17.   `country_id` varchar(255) NOT NULL default '',


    18. 

  18.   `region` varchar(255) NOT NULL default '',


    19. 

  19.   `city` varchar(255) NOT NULL default '',


    20. 

  20.   `date_from` date NULL,


    21. 

  21.   `date_to` date NULL,


    22. 

  22.   `time_from` varchar(255) NOT NULL default '',


    23. 

  23.   `time_to` varchar(255) NOT NULL default '',


    24. 

  24.   `minimum_qty` int(11) NOT NULL,


    25. 

  25.   `sold_qty` int(11) NOT NULL,


    26. 

  26.   `maximum_qty` int(11) NOT NULL,


    27. 

  27.   `coupon_barcode` text NOT NULL default '',


    28. 

  28.   `coupon_merchant_address` int(11) NOT NULL,


    29. 

  29.   `coupon_merchant_contact` int(11) NOT NULL,


    30. 

  30.   `coupon_number` int(11) NOT NULL,


    31. 

  31.   `coupon_expiration_date` date NULL,


    32. 

  32.   PRIMARY KEY (`groupdeals_id`)


    33. 

  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    34. 

  34. 


    35. 

  35. DROP TABLE IF EXISTS {$installer->getTable('groupdeals_merchants')};


    36. 

  36. CREATE TABLE {$installer->getTable('groupdeals_merchants')} (


    37. 

  37.   `merchants_id` int(11) unsigned NOT NULL auto_increment,


    38. 

  38.   `name` text NOT NULL default '',


    39. 

  39.   `description` text NOT NULL default '',


    40. 

  40.   `website` text NOT NULL default '',


    41. 

  41.   `email` text NOT NULL default '',


    42. 

  42.   `facebook` text NOT NULL default '',


    43. 

  43.   `twitter` text NOT NULL default '',


    44. 

  44.   `phone` text NOT NULL default '',


    45. 

  45.   `mobile` text NOT NULL default '',


    46. 

  46.   `business_hours` text NOT NULL default '',


    47. 

  47.   `address` text NOT NULL default '',


    48. 

  48.   `redeem` text NOT NULL default '',


    49. 

  49.   `paypal_email` varchar(255) NOT NULL default '',


    50. 

  50.   `authorize_info` text NOT NULL default '',


    51. 

  51.   `bank_info` text NOT NULL default '',


    52. 

  52.   `other` text NOT NULL default '',


    53. 

  53.   `status` int(11) NOT NULL,


    54. 

  54.   PRIMARY KEY (`merchants_id`)


    55. 

  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    56. 

  56. 


    57. 

  57. DROP TABLE IF EXISTS {$installer->getTable('groupdeals_subscribers')};


    58. 

  58. CREATE TABLE {$installer->getTable('groupdeals_subscribers')} (


    59. 

  59.   `subscriber_id` int(11) unsigned NOT NULL auto_increment,


    60. 

  60.   `store_id` int(11) NOT NULL,


    61. 

  61.   `email` varchar(255) NOT NULL default '',


    62. 

  62.   `city` varchar(255) NOT NULL default '',


    63. 

  63.   PRIMARY KEY (`subscriber_id`)


    64. 

  64. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    65. 

  65. 


    66. 

  66. DROP TABLE IF EXISTS {$installer->getTable('groupdeals_notifications')};


    67. 

  67. CREATE TABLE {$installer->getTable('groupdeals_notifications')} (


    68. 

  68.   `notification_id` int(11) unsigned NOT NULL auto_increment,


    69. 

  69.   `groupdeals_id` int(11) NOT NULL,


    70. 

  70.   `website_id` int(11) NOT NULL,


    71. 

  71.   `type` varchar(255) NOT NULL default '',


    72. 

  72.   `unnotified_subscriber_ids` text NOT NULL default '',


    73. 

  73.   `notified_subscriber_ids` text NOT NULL default '',


    74. 

  74.   `status` varchar(255) NOT NULL default '',


    75. 

  75.   PRIMARY KEY (`notification_id`)


    76. 

  76. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    77. 

  77. 


    78. 

  78. DROP TABLE IF EXISTS {$installer->getTable('groupdeals_coupons')};


    79. 

  79. CREATE TABLE {$installer->getTable('groupdeals_coupons')} (


    80. 

  80.   `coupon_id` int(11) unsigned NOT NULL auto_increment,


    81. 

  81.   `groupdeals_id` int(11) NOT NULL,


    82. 

  82.   `order_id` int(11) NOT NULL,


    83. 

  83.   `coupon_code` varchar(255) NOT NULL default '',


    84. 

  84.   `status` varchar(255) NOT NULL default '',


    85. 

  85.   PRIMARY KEY (`coupon_id`)


    86. 

  86. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    87. 

  87. 


    88. 

  88.     ");


    89. 

  89. 


    90. 

  90. //Create configuration


    91. 

  91. $installer->setConfigData('groupdeals/configuration/enabled',				1);


    92. 

  92. $installer->setConfigData('groupdeals/configuration/header_links',			1);


    93. 

  93. $installer->setConfigData('groupdeals/configuration/homepage_deals',	    '');


    94. 

  94. $installer->setConfigData('groupdeals/configuration/sidedeals_number',	    '3');


    95. 

  95. $installer->setConfigData('groupdeals/configuration/pdf_attachment',	    1);


    96. 

  96. $installer->setConfigData('groupdeals/configuration/countdown_type',	    1);


    97. 

  97. 


    98. 

  98. $installer->setConfigData('groupdeals/countdown_configuration/display_days',	    0);


    99. 

  99. $installer->setConfigData('groupdeals/countdown_configuration/bg_main',	   		'#F6F6F6');


    100. 

  100. $installer->setConfigData('groupdeals/countdown_configuration/bg_color',	   		'#333333');


    101. 

  101. $installer->setConfigData('groupdeals/countdown_configuration/alpha',	   			'70');


    102. 

  102. $installer->setConfigData('groupdeals/countdown_configuration/textcolor',	   		'#FFFFFF');


    103. 

  103. $installer->setConfigData('groupdeals/countdown_configuration/txt_color',	   		'#333333');


    104. 

  104. $installer->setConfigData('groupdeals/countdown_configuration/sec_text',	   		'SECONDS');


    105. 

  105. $installer->setConfigData('groupdeals/countdown_configuration/min_text',	   		'MINUTES');


    106. 

  106. $installer->setConfigData('groupdeals/countdown_configuration/hour_text',	   		'HOURS');


    107. 

  107. $installer->setConfigData('groupdeals/countdown_configuration/days_text',	   		'DAYS');


    108. 

  108. 


    109. 

  109. $installer->setConfigData('groupdeals/js_countdown_configuration/bg_main',	  	    '#F6F6F6');


    110. 

  110. $installer->setConfigData('groupdeals/js_countdown_configuration/textcolor',		'#333333');


    111. 

  111. $installer->setConfigData('groupdeals/js_countdown_configuration/days_text',		'day(s)');


    112. 

  112. 


    113. 

  113. $installer->setConfigData('groupdeals/notifications/email_sender',	   				'general');


    114. 

  114. $installer->setConfigData('groupdeals/notifications/email_new_deal',	   			1);


    115. 

  115. $installer->setConfigData('groupdeals/notifications/email_new_deal_template',	    'groupdeals_notifications_email_new_deal_template');


    116. 

  116. $installer->setConfigData('groupdeals/notifications/email_limit_met',	   			1);


    117. 

  117. $installer->setConfigData('groupdeals/notifications/email_limit_met_template',	   	'groupdeals_notifications_email_limit_met_template');


    118. 

  118. $installer->setConfigData('groupdeals/notifications/email_deal_over',	   			1);


    119. 

  119. $installer->setConfigData('groupdeals/notifications/email_deal_over_template',	   	'groupdeals_notifications_email_deal_over_template');


    120. 

  120. 


    121. 

  121. $installer->setConfigData('system/cron/schedule_generate_every',	   			1);


    122. 

  122. $installer->setConfigData('system/cron/schedule_ahead_for',	   					1);


    123. 

  123. $installer->setConfigData('system/cron/schedule_lifetime',	   					30);


    124. 

  124. $installer->setConfigData('system/cron/history_cleanup_every',	   				120);


    125. 

  125. $installer->setConfigData('system/cron/history_success_lifetime',	   			120);


    126. 

  126. $installer->setConfigData('system/cron/history_failure_lifetime',	   			120);


    127. 

  127. 


    128. 

  128. $installer->endSetup();
    129.