5ZHChRZ1

1$sql = ' CREATE TABLE IF NOT EXISTS `mod_reminder_entries` 
2  ( 
3   `id`          INT(10) NOT NULL auto_increment, 
4   `user_id`     INT(10) NOT NULL, 
5   `entry_name`  VARCHAR(255) NOT NULL, 
6   `entry_value` INT(10) NOT NULL, 
7   PRIMARY KEY (`id`), 
8   FOREIGN KEY (`user_id`) REFERENCES tblclients (`id`) 
9 ); 
10
11 CREATE TABLE IF NOT EXISTS `second_table` 
12  ( 
13   `user_id`     INT(10) NOT NULL, 
14   `fieldstotal` INT(10) NOT NULL, 
15   FOREIGN KEY (`user_id`) REFERENCES tblclients (`id`) 
16  ); ';
17
18  mysql_query($sql); 
19     
20mysql_query("
21    CREATE TABLE IF NOT EXISTS `mod_reminder_entries` (
22        `id` INT(10) NOT NULL AUTO_INCREMENT, 
23        `user_id` INT(10) NOT NULL, 
24        `entry_name` VARCHAR(255) NOT NULL, 
25        `entry_value` INT(10) NOT NULL, 
26        PRIMARY KEY (`id`), 
27        FOREIGN KEY (`user_id`) REFERENCES tblclients (`id`) 
28    )
29") or die(mysql_error());
30
31mysql_query("
32CREATE TABLE IF NOT EXISTS `second_table` (
33    `user_id` INT(10) NOT NULL, 
34    `fieldstotal` INT(10) NOT NULL, 
35    FOREIGN KEY (`user_id`) REFERENCES tblclients (`id`) 
36)
37") or die(mysql_error());