Discussion :

[yanis97]

J'essaye de créer les tables suivantes dans une base WORDPRESS mais il n'ya que la dernière table qui est créee dans MYSQL ?
Je pense que ma syntaxe est correcte :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
function lp_birt_register_sql() {
	global $wpdb;
 
	if ( !empty($wpdb->charset) )
		$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
 
	//creation  des tables
	$sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_clients (
		`customerNumber` int(20) NOT NULL auto_increment,
  `customerName` VARCHAR(50) NOT NULL,
  `contactLastName` VARCHAR(50) NOT NULL,
  `contactFirstName` VARCHAR(50) NOT NULL,
  `phone` VARCHAR(50) NOT NULL,
  `addressLine1` VARCHAR(50) NOT NULL,
  `addressLine2` VARCHAR(50) NULL,
  `city` VARCHAR(50) NOT NULL,
  `state` VARCHAR(50) NULL,
  `postalCode` VARCHAR(15) NULL,
  `country` VARCHAR(50) NOT NULL,
  `salesRepEmployeeNumber` INTEGER NULL,
  `creditLimit` DOUBLE NULL,
  PRIMARY KEY `customerNumber` (`customerNumber`)
	) {$charset_collate};";
 
	$sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_employes (
	`employeeNumber` int(20) NOT NULL auto_increment,
  `lastName` VARCHAR(50) NOT NULL,
  `firstName` VARCHAR(50) NOT NULL,
  `extension` VARCHAR(10) NOT NULL,
  `email` VARCHAR(100) NOT NULL,
  `officeCode` VARCHAR(10) NOT NULL,
  `reportsTo` INTEGER NULL,
  `jobTitle` VARCHAR(50) NOT NULL,
  PRIMARY KEY `employeeNumber` (`employeeNumber`)
		) {$charset_collate};";
 
 $sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_garage (
	`officeCode` VARCHAR(10) NOT NULL,
  `city` VARCHAR(50) NOT NULL,
  `phone` VARCHAR(50) NOT NULL,
  `addressLine1` VARCHAR(50) NOT NULL,
  `addressLine2` VARCHAR(50) NULL,
  `state` VARCHAR(50) NULL,
  `country` VARCHAR(50) NOT NULL,
  `postalCode` VARCHAR(15) NOT NULL,
  `territory` VARCHAR(10) NOT NULL,
  PRIMARY KEY `officeCode` (`officeCode`)
		) {$charset_collate};";
 
	$sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_detailcommandes (
    `orderNumber` int(20) NOT NULL auto_increment,
  `productCode` VARCHAR(15) NOT NULL,
  `quantityOrdered` INTEGER NOT NULL,
  `priceEach` DOUBLE NOT NULL,
  `orderLineNumber` SMALLINT NOT NULL,
  PRIMARY KEY `orderNumber` (`orderNumber`)
  PRIMARY KEY `productCode` (`productCode`)
   ) {$charset_collate};";
 
   $sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_commandes (
   `orderNumber` int(20) NOT NULL auto_increment,
  `orderDate` DATETIME NOT NULL,
  `requiredDate` DATETIME NOT NULL,
  `shippedDate` DATETIME NULL,
  `status` VARCHAR(15) NOT NULL,
  `comments` TEXT NULL,
  `customerNumber` INTEGER NOT NULL,
  PRIMARY KEY `orderNumber` (`orderNumber`)
     ) {$charset_collate};";
 
  $sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_payements (
   `customerNumber` int(20) NOT NULL auto_increment,
  `checkNumber` VARCHAR(50) NOT NULL,
  `paymentDate` DATETIME NOT NULL,
  `amount` DOUBLE NOT NULL,
  PRIMARY KEY `customerNumber` (`customerNumber`)
  PRIMARY KEY `checkNumber` (`checkNumber`)
    ) {$charset_collate};";
 
 
 
	$sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_produits (
   `productCode` VARCHAR(15) NOT NULL,
  `productName` VARCHAR(70) NOT NULL,
  `productLine` VARCHAR(50) NOT NULL,
  `productScale` VARCHAR(10) NOT NULL,
  `productVendor` VARCHAR(50) NOT NULL,
  `productDescription` TEXT NOT NULL,
  `quantityInStock` SMALLINT NOT NULL,
  `buyPrice` DOUBLE NOT NULL,
  `MSRP` DOUBLE NOT NULL,
  PRIMARY KEY  `productCode` (`productCode`)
     ) {$charset_collate};";
 
	 $sql[] = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}lp_birt_ligneproduits (
	 `productLine` VARCHAR(50) NOT NULL,
  `textDescription` VARCHAR(4000) NULL,
  `htmlDescription` MEDIUMTEXT NULL,
  `image` MEDIUMBLOB NULL,
  PRIMARY KEY  `productLine` (`productLine`)
	  ) {$charset_collate}";
 
 
  require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 
  dbDelta($sql);
 
}

Merci

[Marc3001]

DbDelta prend'il un tableau en paramétre?

A ce que j'ai vu sur internet ça n'a pas l'air....