blob: 971499ba9cada08dcc1af810c5a768ae40dfaca1 [file] [log] [blame]
Andreu8192d552019-09-22 16:51:39 +02001<?php
2 require '../credentials.php';
3 require '../php/utils.php';
4
5 $dbname = $_GET['dbname'];
Andreu0530b302019-09-24 04:18:20 +02006 $mortsname = $dbname . "_morts";
Andreu8192d552019-09-22 16:51:39 +02007
Andreu0530b302019-09-24 04:18:20 +02008 $queries = ["CREATE TABLE `$dbname` (
Andreu8192d552019-09-22 16:51:39 +02009 `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
10 `nom` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
11 `curs` tinyint(1) NOT NULL,
12 `grau` tinyint(1) NOT NULL,
13 `quimata` int(11) NOT NULL,
14 `requested` tinyint(1) NOT NULL DEFAULT 0,
15 `mort` tinyint(1) NOT NULL DEFAULT 0,
Adrià Vilanova Martínez13cf0cd2022-11-20 01:02:20 +010016 `password` varchar(255) NOT NULL DEFAULT '',
Andreu0530b302019-09-24 04:18:20 +020017 `bits` int(3) NOT NULL
18 )",
19 "CREATE TABLE `$mortsname` (
Andreu04f79ef2019-09-22 18:52:19 +020020 `id` int(11) NOT NULL,
21 `quimatava` int(11) NOT NULL,
22 `assassi` int(11) NOT NULL,
23 `curs` tinyint(1) NOT NULL,
24 `grau` tinyint(1) NOT NULL,
Andreu20af6c22019-09-24 18:33:50 +020025 `data` timestamp NOT NULL DEFAULT current_timestamp()
Andreu0530b302019-09-24 04:18:20 +020026 )"];
27
Andreu20af6c22019-09-24 18:33:50 +020028 foreach ($queries as $query) if (!query($query)) die('An error ocurred. ' . $query);
Andreu03d030d2019-09-25 21:52:01 +020029 die("<script>window.location.href = './?dbname=$dbname'</script>");