gLCB1jGB

1<?php 
2	$conn = new mysqli('localhost', 'root', '');
3
4	$sqlC="CREATE DATABASE auctionDB;";
5	$conn->query($sqlC);
6	mysqli_select_db($conn,"auctionDB");
7
8	$sql="DROP TABLE IF EXISTS `auktions`;";
9	$sql .="CREATE TABLE `auktions` (
10 			 `id` int(255) NOT NULL,
11			  `name` varchar(50) COLLATE utf8_bin NOT NULL
12			  `start_price` int(100) NOT NULL,
13			  `highest_bid` int(100) NOT NULL,
14			  `start_date` datetime NOT NULL,
15			  `end_date` datetime DEFAULT NULL,
16			  `owner` varchar(100) COLLATE utf8_bin NOT NULL,
17			  `description` text COLLATE utf8_bin NOT NULL,
18			  `picture` varchar(100) COLLATE utf8_bin NOT NULL
19			) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
20
21	$sql .="DROP TABLE IF EXISTS `history`;";
22	$sql .="CREATE TABLE `history` (
23			  `id` int(225) NOT NULL AUTO_INCREMENT,
24			  `owner` varchar(100) COLLATE utf8_bin NOT NULL,
25			  `auctionId` int(255) NOT NULL,
26			  `money` int(255) NOT NULL,
27			  `time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
28			  PRIMARY KEY (`id`)
29			) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;";
30
31	$sql .="DROP TABLE IF EXISTS `users`;";
32	$sql .="CREATE TABLE `users` (
33		  `id` int(255) NOT NULL AUTO_INCREMENT,
34		  `user_name` varchar(50) COLLATE utf8_bin NOT NULL,
35		  `password` varchar(50) COLLATE utf8_bin NOT NULL,
36		  `email` varchar(50) COLLATE utf8_bin NOT NULL,
37		  `addres` varchar(70) COLLATE utf8_bin NOT NULL,
38		  `postcode` int(10) NOT NULL,
39		  PRIMARY KEY (`id`),
40		  UNIQUE KEY `id` (`id`),
41		  UNIQUE KEY `user_name` (`user_name`),
42		  UNIQUE KEY `email` (`email`),
43		  UNIQUE KEY `id_2` (`id`)
44		) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
45		";
46
47	if($conn->multi_query($sql)){
48		echo 'donno';
49	}else{echo 'fucker';}
50	
51 ?>