· 8 years ago · Jan 26, 2018, 08:32 AM
1
2/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
4/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
5/*!40101 SET NAMES utf8 */;
6
7
8CREATE TABLE IF NOT EXISTS "loper" (
9 "id" int(11) NOT NULL,
10 "naam" varchar(45) NOT NULL,
11 "voornaam" varchar(45) NOT NULL,
12 "geslacht" varchar(45) DEFAULT NULL,
13 "jaar" varchar(45) DEFAULT NULL,
14 "bestetijd" varchar(45) DEFAULT NULL,
15 "aantalrondes" int(11) DEFAULT NULL,
16 PRIMARY KEY ("id")
17) AUTO_INCREMENT=1 ;
18
19
20CREATE TABLE IF NOT EXISTS "ronde" (
21 "id" int(11) NOT NULL,
22 "loperid" int(11) NOT NULL,
23 "tijd" varchar(45) NOT NULL,
24 PRIMARY KEY ("id"),
25 KEY "spelerFK" ("loperid")
26) AUTO_INCREMENT=1 ;