aLaGZqFQ

1		// INIT DATABASE
2		public function initDatabase(){
3			$sql = array();
4			$sql[] = <<<SQL
5						CREATE TABLE IF NOT EXISTS tasks ( 
6							id INT PRIMARY KEY,
7							tripcode VARCHAR(25),
8							status INT ,
9							created INT ,
10							bumped INT ,
11							title VARCHAR(100),
12							message VARCHAR(2000)
13						);
14SQL;
15			
16			$sql[] = <<<SQL
17						CREATE TABLE IF NOT EXISTS tags ( 
18							task_id INT,
19							label VARCHAR(50)
20						);
21SQL;
22			
23			$sql[] = <<<SQL
24						CREATE TABLE IF NOT EXISTS messages (
25							id INT PRIMARY KEY,
26							task_id INT NOT NULL,
27							user_id INT,
28							created INT,
29							msg_type VARCHAR(25),    
30							title VARCHAR(25),
31							message VARCHAR(25)
32						);
33SQL;
34			
35			 //var_dump($sql);
36			
37			foreach($sql as $s){
38				Database::query($s);
39			}
40		}
41	}