hrhzuTbd

1<?php
2
3$host = "127.0.0.1";
4$db = "forum";
5$port = "3306";
6$user = "user";
7$pass = "password";
8$charset = "utf8";
9
10/** Do not edit below**/
11define("USER_TABLE_INIT", 'CREATE TABLE IF NOT EXISTS user (
12  user_id BIGINT NOT NULL AUTO_INCREMENT,
13  user_display_name VARCHAR(128) NOT NULL,
14  user_icon VARCHAR(512) NOT NULL,
15  user_google_id VARCHAR(64),
16  PRIMARY KEY (user_id))
17  ENGINE = InnoDB;'
18);
19
20define("POST_TABLE_INIT", 'CREATE TABLE IF NOT EXISTS post (
21  post_id BIGINT NOT NULL AUTO_INCREMENT,
22  user_id BIGINT NOT NULL,
23  event_id BIGINT NOT NULL,
24  post_content MEDIUMTEXT NOT NULL,
25  post_latitude DOUBLE NOT NULL,
26  post_longitude DOUBLE NOT NULL,
27  post_timestamp DATETIME NOT NULL,
28  PRIMARY KEY (post_id),
29  FOREIGN KEY (user_id) REFERENCES user(user_id) ON DELETE NO ACTION)
30  ENGINE = InnoDB;'
31);
32
33define("DATABASE_INIT", USER_TABLE_INIT . POST_TABLE_INIT);