· 9 years ago · Dec 19, 2016, 02:23 PM
1<?php
2 $installer = $this; //Getting Installer Class Object In A Variable
3 $installer->startSetup();
4 $installer->run("
5 -- DROP TABLE IF EXISTS {$this->getTable('optfirst_reviewmycompany')};
6 CREATE TABLE {$this->getTable('optfirst_reviewmycompany')} (
7 `id_optfirst_reviewmycompany` int(11) unsigned NOT NULL auto_increment,
8 `facebook` varchar(255) NOT NULL default '',
9 `twitter` varchar(255) NOT NULL default '',
10 `google` varchar(255) NOT NULL default '',
11 `linkedin` varchar(255) NOT NULL default '',
12 `yelp` varchar(255) NOT NULL default '',
13 `piintrest` varchar(255) NOT NULL default '',
14 `gmaps` varchar(255) NOT NULL default '',
15 `bing` varchar(255) NOT NULL default '',
16 `coc` varchar(255) NOT NULL default '',
17 `city_search` varchar(255) NOT NULL default '',
18 `ezlocal` varchar(255) NOT NULL default '',
19 `local` varchar(255) NOT NULL default '',
20 `mcircle` varchar(255) NOT NULL default '',
21 `show_me_local` varchar(255) NOT NULL default '',
22 `superpages` varchar(255) NOT NULL default '',
23 `topix` varchar(255) NOT NULL default '',
24 `uscity` varchar(255) NOT NULL default '',
25 `where_to_app` varchar(255) NOT NULL default '',
26 `yellow_bot` varchar(255) NOT NULL default '',
27 `yellow_wise` varchar(255) NOT NULL default '',
28 PRIMARY KEY (`id_optfirst_reviewmycompany`)
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30 ");
31 $installer->endSetup();
32 ?>