xHGJjMEt

1register_activation_hook( __FILE__, 'createTable' );
2	
3function createTable(){
4
5
6    $link = mysql_connect('localhost', 'user', 'pass');
7    if (!$link) {
8        die( 'Could not connect: ' . mysql_error() );
9    }
10    mysql_select_db (db_name); 
11
12    $sql = "CREATE TABLE IF NOT EXISTS UsersExtra (
13      user_id INT NOT NULL,
14      first_name VARCHAR(25) NOT NULL,
15      last_name VARCHAR(25) NOT NULL,
16      address VARCHAR(80) NOT NULL,
17      city VARCHAR(30) NOT NULL,
18      province CHAR(2) NOT NULL,
19      postcode CHAR(7) NOT NULL,
20      interests TEXT NULL,
21      bio TEXT NULL,
22      signature TEXT NULL,
23      skills TEXT NULL,
24      PRIMARY KEY (user_id),
25      FULLTEXT KEY (interests, skills)
26    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
27
28    mysql_query($sql) or die( mysql_error() );
29    mysql_close($link);
30
31}
32	
33<?php
34function createTable(){
35    global $wpdb;
36    $query = "CREATE TABLE IF NOT EXISTS " . $wpdb->prefix ."UsersExtra (
37        user_id INT NOT NULL,
38        first_name VARCHAR(25) NOT NULL,
39        last_name VARCHAR(25) NOT NULL,
40        address VARCHAR(80) NOT NULL,
41        city VARCHAR(30) NOT NULL,
42        province CHAR(2) NOT NULL,
43        postcode CHAR(7) NOT NULL,
44        interests TEXT NULL,
45        bio TEXT NULL,
46        signature TEXT NULL,
47        skills TEXT NULL,
48        PRIMARY KEY (user_id),
49        FULLTEXT KEY (interests, skills)
50    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
51    $wpdb->query($query);
52}
53register_activation_hook(__FILE__, 'createTable');