gbEv2nrD

1$table_query = "CREATE TABLE IF NOT EXISTS ".TP."_usertypes(
2                utid INT(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (utid),
3                utname VARCHAR(255)
4                )
5                DEFAULT CHARACTER SET utf8
6                COLLATE utf8_general_ci;
7
8                CREATE TABLE IF NOT EXISTS ".TP."_users(
9                uid INT(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (uid),
10                utid INT(11) NOT NULL,FOREIGN KEY (utid) REFERENCES ".TP."_usertypes(utid) ON DELETE RESTRICT,
11                username VARCHAR(255), 
12                password VARCHAR(255),
13                avatar VARCHAR(255)
14                )
15                DEFAULT CHARACTER SET utf8
16                COLLATE utf8_general_ci";
17mysqli_query($connection,$table_query) or die(mysqli_error($connection));