QGcMS6Lb

1register_activation_hook( __FILE__,array( 'Horse_Exchange_Activator', 'activate' )  );
2
3
4class Horse_Exchange_Activator {
5
6
7
8    /**
9
10     * Short Description. (use period)
11
12     *
13
14     * Long Description.
15
16     *
17
18     * @since    1.0.0
19
20     */
21
22
23
24    public static function activate() {
25
26
27    global $table_prefix, $wpdb;
28
29    $tblname = 'winners_horses';
30    $wp_track_table = $table_prefix . "$tblname ";
31
32    #Check to see if the table exists already, if not, then create it
33
34    if($wpdb->get_var( "show tables like '$wp_track_table'" ) != $wp_track_table) 
35    {
36
37        $sql = "CREATE TABLE `". $wp_track_table . "` ( ";
38        $sql .= "  `id`  int(11)   NOT NULL auto_increment, ";
39        $sql .= "  `horse`  varchar(255)   NOT NULL, ";
40        $sql .= "  `event_name` varchar(255)   NOT NULL, "; 
41        $sql .= "  `cloth` varchar(255)   NOT NULL, "; 
42        $sql .= "  `posted` varchar(255)   NOT NULL, "; 
43        $sql .= ") ENGINE=MyISAM DEFAULT CHARSET=latin1 ; ";
44        require_once( ABSPATH . '/wp-admin/includes/upgrade.php' );
45        dbDelta($sql);
46
47
48
49    }
50
51
52
53}