NPKQ74fb

1SET statement_timeout = 0;
2SET client_encoding = 'UTF8';
3SET standard_conforming_strings = on;
4SET check_function_bodies = false;
5SET client_min_messages = warning;
6CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
7COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
8SET search_path = public, pg_catalog;
9SET default_tablespace = '';
10SET default_with_oids = false;
11CREATE TABLE buyins (
12    buyin integer,
13    first integer,
14    second integer
15);
16ALTER TABLE public.buyins OWNER TO postgres;
17CREATE TABLE playerlist (
18    playername character(60),
19    platz1 integer DEFAULT 0,
20    platz2 integer DEFAULT 0,
21    platz3 integer DEFAULT 0,
22    platz4 integer DEFAULT 0,
23    platz5 integer DEFAULT 0,
24    platz6 integer DEFAULT 0,
25    buyin integer
26);
27ALTER TABLE public.playerlist OWNER TO postgres;
28CREATE TABLE stats (
29    overall integer DEFAULT 0
30);
31ALTER TABLE public.stats OWNER TO postgres;
32CREATE TABLE playerresults (
33    playername character(50),
34    buyin integer,
35    zeit timestamp without time zone,
36    winnings integer
37);
38ALTER TABLE public.playerresults OWNER TO postgres;
39REVOKE ALL ON SCHEMA public FROM PUBLIC;
40REVOKE ALL ON SCHEMA public FROM postgres;
41GRANT ALL ON SCHEMA public TO postgres;
42GRANT ALL ON SCHEMA public TO PUBLIC;