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);
} |
