· 8 years ago · May 02, 2018, 07:30 PM
1function myplugin_install(){
2 global $wpdb;
3 $table_name = $wpdb->prefix . "vehicles";
4
5 $sql = "CREATE TABLE IF NOT EXISTS $table_name
6 (
7 id INT UNSIGNED NOT NULL AUTO_INCREMENT,
8 description VARCHAR(25) NOT NULL,
9 PRIMARY KEY (id)
10 );
11 ";
12
13 $sql .= "CREATE TABLE IF NOT EXISTS $table_name1
14 (
15 ...
16 )";
17
18 $sql .= "CREATE TABLE IF NOT EXISTS $table_nameX
19 (
20 id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
21 art_alarmierung VARCHAR(25) NOT NULL ,
22 PRIMARY KEY (id)
23 );";
24
25require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
26dbDelta($sql);
27echo $wpdb->last_error;
28
29}
30
31function myplugin_install(){
32 global $wpdb;
33 $table_name = $wpdb->prefix . "vehicles";
34 require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
35
36 $sql = "CREATE TABLE IF NOT EXISTS $table_name
37 (
38 id INT UNSIGNED NOT NULL AUTO_INCREMENT,
39 description VARCHAR(25) NOT NULL,
40 PRIMARY KEY (id)
41 );
42 ";
43 dbDelta($sql);
44
45 $sql2 = "CREATE TABLE IF NOT EXISTS $table_name1
46 (
47 ...
48 )";
49 dbDelta($sql2);
50
51 $sql3 = "CREATE TABLE IF NOT EXISTS $table_nameX
52 (
53 id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
54 art_alarmierung VARCHAR(25) NOT NULL ,
55 PRIMARY KEY (id)
56 );";
57
58 dbDelta($sql3);
59
60}