RbhHNNq3

1<?php
2include_once("php_includes/db_conx.php");
3
4$tbl_users = "CREATE TABLE IF NOT EXISTS users (
5              id INT(11) NOT NULL AUTO_INCREMENT,
6              username VARCHAR(16) NOT NULL,
7              email VARCHAR(255) NOT NULL,
8              password VARCHAR(255) NOT NULL,
9              gender ENUM('m','f') NOT NULL,
10              website VARCHAR(255) NULL,
11              country VARCHAR(255) NULL,
12              userlevel ENUM('a','b','c','d') NOT NULL DEFAULT 'a',
13              avatar VARCHAR(255) NULL,
14              ip VARCHAR(255) NOT NULL,
15              signup DATETIME NOT NULL,
16              lastlogin DATETIME NOT NULL,
17              notescheck DATETIME NOT NULL,
18              activated ENUM('0','1') NOT NULL DEFAULT '0',
19              PRIMARY KEY (id),
20              UNIQUE KEY username (username,email)
21             )";
22$query = mysqli_query($db_conx, $tbl_users);
23if ($query === TRUE) {
24    echo "<h3>user table created OK :) </h3>"; 
25} else {
26    echo "<h3>user table NOT created :( </h3>"; 
27}
28////////////////////////////////////
29$tbl_useroptions = "CREATE TABLE IF NOT EXISTS useroptions ( 
30                id INT(11) NOT NULL,
31                username VARCHAR(16) NOT NULL,
32                background VARCHAR(255) NOT NULL,
33                question VARCHAR(255) NULL,
34                answer VARCHAR(255) NULL,
35                PRIMARY KEY (id),
36                UNIQUE KEY username (username) 
37                )"; 
38$query = mysqli_query($db_conx, $tbl_useroptions); 
39if ($query === TRUE) {
40    echo "<h3>useroptions table created OK :) </h3>"; 
41} else {
42    echo "<h3>useroptions table NOT created :( </h3>"; 
43}
44////////////////////////////////////
45$tbl_friends = "CREATE TABLE IF NOT EXISTS friends ( 
46                id INT(11) NOT NULL AUTO_INCREMENT,
47                user1 VARCHAR(16) NOT NULL,
48                user2 VARCHAR(16) NOT NULL,
49                datemade DATETIME NOT NULL,
50                accepted ENUM('0','1') NOT NULL DEFAULT '0',
51                PRIMARY KEY (id)
52                )"; 
53$query = mysqli_query($db_conx, $tbl_friends); 
54if ($query === TRUE) {
55    echo "<h3>friends table created OK :) </h3>"; 
56} else {
57    echo "<h3>friends table NOT created :( </h3>"; 
58}
59////////////////////////////////////
60$tbl_blockedusers = "CREATE TABLE IF NOT EXISTS blockedusers ( 
61                id INT(11) NOT NULL AUTO_INCREMENT,
62                blocker VARCHAR(16) NOT NULL,
63                blockee VARCHAR(16) NOT NULL,
64                blockdate DATETIME NOT NULL,
65                PRIMARY KEY (id) 
66                )"; 
67$query = mysqli_query($db_conx, $tbl_blockedusers); 
68if ($query === TRUE) {
69    echo "<h3>blockedusers table created OK :) </h3>"; 
70} else {
71    echo "<h3>blockedusers table NOT created :( </h3>"; 
72}
73////////////////////////////////////
74$tbl_status = "CREATE TABLE IF NOT EXISTS status ( 
75                id INT(11) NOT NULL AUTO_INCREMENT,
76                osid INT(11) NOT NULL,
77                account_name VARCHAR(16) NOT NULL,
78                author VARCHAR(16) NOT NULL,
79                type ENUM('a','b','c') NOT NULL,
80                data TEXT NOT NULL,
81                postdate DATETIME NOT NULL,
82                PRIMARY KEY (id) 
83                )"; 
84$query = mysqli_query($db_conx, $tbl_status); 
85if ($query === TRUE) {
86    echo "<h3>status table created OK :) </h3>"; 
87} else {
88    echo "<h3>status table NOT created :( </h3>"; 
89}
90////////////////////////////////////
91$tbl_photos = "CREATE TABLE IF NOT EXISTS photos ( 
92                id INT(11) NOT NULL AUTO_INCREMENT,
93                user VARCHAR(16) NOT NULL,
94                gallery VARCHAR(16) NOT NULL,
95                filename VARCHAR(255) NOT NULL,
96                description VARCHAR(255) NULL,
97                uploaddate DATETIME NOT NULL,
98                PRIMARY KEY (id) 
99                )"; 
100$query = mysqli_query($db_conx, $tbl_photos); 
101if ($query === TRUE) {
102    echo "<h3>photos table created OK :) </h3>"; 
103} else {
104    echo "<h3>photos table NOT created :( </h3>"; 
105}
106////////////////////////////////////
107$tbl_notifications = "CREATE TABLE IF NOT EXISTS notifications ( 
108                id INT(11) NOT NULL AUTO_INCREMENT,
109                username VARCHAR(16) NOT NULL,
110                initiator VARCHAR(16) NOT NULL,
111                app VARCHAR(255) NOT NULL,
112                note VARCHAR(255) NOT NULL,
113                did_read ENUM('0','1') NOT NULL DEFAULT '0',
114                date_time DATETIME NOT NULL,
115                PRIMARY KEY (id) 
116                )"; 
117$query = mysqli_query($db_conx, $tbl_notifications); 
118if ($query === TRUE) {
119    echo "<h3>notifications table created OK :) </h3>"; 
120} else {
121    echo "<h3>notifications table NOT created :( </h3>"; 
122}
123?>
124	
125<?php
126$db_conx = mysqli_connect("localhost", "database_user", "pass", "database_name");
127// Evaluate the connection
128if (mysqli_connect_errno()) {
129    echo mysqli_connect_error();
130    exit();
131} else {
132    echo "Successful database connection, happy coding!!!";
133}
134?>