game_yedek.dump

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.7
-- Dumped by pg_dump version 9.5.7

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: game_trnetdb; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE game_trnetdb WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';


ALTER DATABASE game_trnetdb OWNER TO postgres;

\connect game_trnetdb

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

--
-- Name: logfunction(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION logfunction() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
begin
IF (TG_OP = 'DELETE') THEN
insert into log (username,date,name,operation,price,genre_id,logo,game_id) values (user,now(),OLD.name,'D',OLD.price,OLD.genre_id,OLD.logo,OLD.id);
return OLD;
ELSIF(TG_OP = 'UPDATE') THEN
insert into log (username,date,name,operation,price,genre_id,logo,game_id) values (user,now(),OLD.name,'U',OLD.price,OLD.genre_id,OLD.logo,NEW.id);
return OLD;
ELSIF (TG_OP = 'INSERT') THEN
insert into log (username,date,name,operation,price,genre_id,logo,game_id) values(user,now(),NEW.name,'I',NEW.price,NEW.genre_id,NEW.logo,NEW.id);
return NEW;
end if;
return null;
end;$$;


ALTER FUNCTION public.logfunction() OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: admin; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE admin (
    id integer NOT NULL,
    is_admin boolean NOT NULL
);


ALTER TABLE admin OWNER TO postgres;

--
-- Name: admin_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE admin_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE admin_id_seq OWNER TO postgres;

--
-- Name: admin_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE admin_id_seq OWNED BY admin.id;


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE auth_group OWNER TO postgres;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_group_id_seq OWNER TO postgres;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE auth_group_permissions OWNER TO postgres;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_group_permissions_id_seq OWNER TO postgres;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE auth_permission OWNER TO postgres;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_permission_id_seq OWNER TO postgres;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE auth_user OWNER TO postgres;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE auth_user_groups OWNER TO postgres;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_user_groups_id_seq OWNER TO postgres;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_user_id_seq OWNER TO postgres;

--
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE auth_user_user_permissions OWNER TO postgres;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE auth_user_user_permissions_id_seq OWNER TO postgres;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- Name: company; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE company (
    id integer NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE company OWNER TO postgres;

--
-- Name: company_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE company_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE company_id_seq OWNER TO postgres;

--
-- Name: company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE company_id_seq OWNED BY company.id;


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE django_admin_log OWNER TO postgres;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE django_admin_log_id_seq OWNER TO postgres;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE django_content_type OWNER TO postgres;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE django_content_type_id_seq OWNER TO postgres;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE django_migrations OWNER TO postgres;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE django_migrations_id_seq OWNER TO postgres;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE django_session OWNER TO postgres;

--
-- Name: game; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE game (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    price real NOT NULL,
    created_date timestamp without time zone DEFAULT now() NOT NULL,
    update_date timestamp without time zone DEFAULT now() NOT NULL,
    logo character varying(200),
    genre_id integer NOT NULL,
    company_id integer NOT NULL,
    content text,
    platform_id integer NOT NULL,
    CONSTRAINT game_price_check CHECK ((price > (0)::double precision))
);


ALTER TABLE game OWNER TO postgres;

--
-- Name: game_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE game_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE game_id_seq OWNER TO postgres;

--
-- Name: game_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE game_id_seq OWNED BY game.id;


--
-- Name: genre; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE genre (
    id integer NOT NULL,
    name character varying(40) NOT NULL
);


ALTER TABLE genre OWNER TO postgres;

--
-- Name: genre_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE genre_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE genre_id_seq OWNER TO postgres;

--
-- Name: genre_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE genre_id_seq OWNED BY genre.id;


--
-- Name: log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE log (
    id integer NOT NULL,
    username character varying(40),
    operation character varying(1) NOT NULL,
    name character varying(100) NOT NULL,
    price real NOT NULL,
    genre_id integer NOT NULL,
    company_id integer NOT NULL,
    game_id integer NOT NULL,
    logo text
);


ALTER TABLE log OWNER TO postgres;

--
-- Name: log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE log_id_seq OWNER TO postgres;

--
-- Name: log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE log_id_seq OWNED BY log.id;


--
-- Name: platform; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE platform (
    id integer NOT NULL,
    name character varying(40) NOT NULL
);


ALTER TABLE platform OWNER TO postgres;

--
-- Name: platform_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE platform_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE platform_id_seq OWNER TO postgres;

--
-- Name: platform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE platform_id_seq OWNED BY platform.id;


--
-- Name: sale; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE sale (
    id integer NOT NULL,
    user_id integer NOT NULL,
    game_id integer NOT NULL,
    c_date timestamp without time zone DEFAULT now(),
    amount real NOT NULL,
    CONSTRAINT sale_amount_check CHECK ((amount > (0)::double precision))
);


ALTER TABLE sale OWNER TO postgres;

--
-- Name: sale_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE sale_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE sale_id_seq OWNER TO postgres;

--
-- Name: sale_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE sale_id_seq OWNED BY sale.id;


--
-- Name: status; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE status (
    id integer NOT NULL,
    is_active boolean NOT NULL
);


ALTER TABLE status OWNER TO postgres;

--
-- Name: status_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE status_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE status_id_seq OWNER TO postgres;

--
-- Name: status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE status_id_seq OWNED BY status.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE users (
    id integer NOT NULL,
    username character varying(15) NOT NULL,
    password text NOT NULL,
    email text NOT NULL,
    c_date timestamp without time zone DEFAULT now(),
    full_name character varying(40),
    balance real DEFAULT 0 NOT NULL,
    lastlogin timestamp without time zone DEFAULT now() NOT NULL,
    admin_id integer NOT NULL,
    status_id integer NOT NULL
);


ALTER TABLE users OWNER TO postgres;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE users_id_seq OWNER TO postgres;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: users_profile; Type: TABLE; Schema: public; Owner: sercan
--

CREATE TABLE users_profile (
    id integer NOT NULL,
    birth_date date,
    status boolean NOT NULL,
    balance double precision NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE users_profile OWNER TO sercan;

--
-- Name: users_profile_id_seq; Type: SEQUENCE; Schema: public; Owner: sercan
--

CREATE SEQUENCE users_profile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE users_profile_id_seq OWNER TO sercan;

--
-- Name: users_profile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sercan
--

ALTER SEQUENCE users_profile_id_seq OWNED BY users_profile.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY admin ALTER COLUMN id SET DEFAULT nextval('admin_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY company ALTER COLUMN id SET DEFAULT nextval('company_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game ALTER COLUMN id SET DEFAULT nextval('game_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY genre ALTER COLUMN id SET DEFAULT nextval('genre_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY log ALTER COLUMN id SET DEFAULT nextval('log_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform ALTER COLUMN id SET DEFAULT nextval('platform_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sale ALTER COLUMN id SET DEFAULT nextval('sale_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY status ALTER COLUMN id SET DEFAULT nextval('status_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: sercan
--

ALTER TABLE ONLY users_profile ALTER COLUMN id SET DEFAULT nextval('users_profile_id_seq'::regclass);


--
-- Data for Name: admin; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY admin (id, is_admin) FROM stdin;
1	t
2	f
\.


--
-- Name: admin_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('admin_id_seq', 2, true);


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_group (id, name) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_group_id_seq', 1, false);


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_group_permissions_id_seq', 1, false);


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can add permission	2	add_permission
5	Can change permission	2	change_permission
6	Can delete permission	2	delete_permission
7	Can add user	3	add_user
8	Can change user	3	change_user
9	Can delete user	3	delete_user
10	Can add group	4	add_group
11	Can change group	4	change_group
12	Can delete group	4	delete_group
13	Can add content type	5	add_contenttype
14	Can change content type	5	change_contenttype
15	Can delete content type	5	delete_contenttype
16	Can add session	6	add_session
17	Can change session	6	change_session
18	Can delete session	6	delete_session
19	Can add comment	7	add_comment
20	Can change comment	7	change_comment
21	Can delete comment	7	delete_comment
22	Can add genre	8	add_genre
23	Can change genre	8	change_genre
24	Can delete genre	8	delete_genre
25	Can add article	9	add_article
26	Can change article	9	change_article
27	Can delete article	9	delete_article
28	Can add game	10	add_game
29	Can change game	10	change_game
30	Can delete game	10	delete_game
31	Can add profile	11	add_profile
32	Can change profile	11	change_profile
33	Can delete profile	11	delete_profile
\.


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_permission_id_seq', 33, true);


--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_id_seq', 1, false);


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 1, false);


--
-- Data for Name: company; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY company (id, name) FROM stdin;
13	Blizzard
14	yagmur yapti
\.


--
-- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('company_id_seq', 14, true);


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('django_admin_log_id_seq', 1, false);


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	user
4	auth	group
5	contenttypes	contenttype
6	sessions	session
7	Articles	comment
8	Articles	genre
9	Articles	article
10	games	game
11	users	profile
\.


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('django_content_type_id_seq', 11, true);


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_migrations (id, app, name, applied) FROM stdin;
1	Articles	0001_initial	2017-07-06 09:01:24.810455+00
2	Articles	0002_auto_20170703_1445	2017-07-06 09:01:24.951378+00
3	contenttypes	0001_initial	2017-07-06 09:01:25.004738+00
4	auth	0001_initial	2017-07-06 09:01:25.336991+00
5	admin	0001_initial	2017-07-06 09:01:25.448857+00
6	admin	0002_logentry_remove_auto_add	2017-07-06 09:01:25.487175+00
7	contenttypes	0002_remove_content_type_name	2017-07-06 09:01:25.545076+00
8	auth	0002_alter_permission_name_max_length	2017-07-06 09:01:25.581044+00
9	auth	0003_alter_user_email_max_length	2017-07-06 09:01:25.615847+00
10	auth	0004_alter_user_username_opts	2017-07-06 09:01:25.639165+00
11	auth	0005_alter_user_last_login_null	2017-07-06 09:01:25.673963+00
12	auth	0006_require_contenttypes_0002	2017-07-06 09:01:25.687678+00
13	auth	0007_alter_validators_add_error_messages	2017-07-06 09:01:25.714907+00
14	auth	0008_alter_user_username_max_length	2017-07-06 09:01:25.768361+00
15	sessions	0001_initial	2017-07-06 09:01:25.838699+00
16	games	0001_initial	2017-07-13 16:56:37.397712+00
17	users	0001_initial	2017-07-13 16:56:38.297987+00
18	games	0002_delete_game	2017-07-13 18:50:42.849184+00
\.


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('django_migrations_id_seq', 18, true);


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY django_session (session_key, session_data, expire_date) FROM stdin;
0zfjpid9rdvwva0zpo8jdia36r9n9mv7	Y2I3ODA1NDQ4OTA3YWRlMjJjZTgwZWY1NGYxNWE1NmUyYjQ4NjE5ZTp7ImFkbWluX2lkIjoxLCJ1c2VybmFtZSI6InNlcmNhbiIsInBhc3N3b3JkIjoiMTIzNDUiLCJpc19sb2dnZWQiOnRydWV9	2017-07-31 08:16:09.362723+00
g5nm7ulggurrupoakwwnh53l7eiu8em6	ZmM3OGE4MjUzZjM4NjRhMTA5MjA5YTliYmUxZDljNmU2N2UxNThlNTp7InBhc3N3b3JkIjoiMTIzNDUiLCJpc19sb2dnZWQiOnRydWUsInVzZXJuYW1lIjoic2VyY2FuIn0=	2017-07-27 14:08:37.690045+00
gm3uhuny1qcpbr94nsespl5hwqx2d30f	NjE5ZDcwOTg2YjRiODg5ZTJhZmRjNTBhMTFmYTE0ODczOGU3NzgyMDp7InVzZXJuYW1lIjoic2VyY2FuIiwiaXNfbG9nZ2VkIjp0cnVlLCJhZG1pbl9pZCI6MSwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:18:50.615817+00
tv3j8hk5imq5gszkoc2n5rnb5tsylh6j	MDE5OGFlNjljNjU4YjBkNzRiMGVlNzUwMTRkNTBlYWU3OWFmZWE5Zjp7ImlzX2xvZ2dlZCI6dHJ1ZSwidXNlcm5hbWUiOiJzZXJjYW4iLCJhZG1pbl9pZCI6MSwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:26:27.972045+00
shnvbzq6tgd84nt1clza4lv28gpf1lqe	MmE4NTE3YTk2ZmIwM2Q0ODE1M2Q5MWU3YjJmZTljMmI3NDFlZmRlODp7Imxhbmd1YWdlIjoiZW4ifQ==	2017-07-30 21:15:53.275206+00
faw78ide07uyehs5w8v24e6omob6j2b3	MTViNzVhYTc1Yzg5MTk3ZWE2MmEyZTFlMWYzNWFkNjljZjc1N2UyZjp7InBhc3N3b3JkIjoiMTIzNDUiLCJ1c2VybmFtZSI6InNlcmNhbiIsImlzX2xvZ2dlZCI6dHJ1ZX0=	2017-07-28 10:41:19.632703+00
4vy321cnez2j1x6ibvgabu4a6wq3f529	MDE5OGFlNjljNjU4YjBkNzRiMGVlNzUwMTRkNTBlYWU3OWFmZWE5Zjp7ImlzX2xvZ2dlZCI6dHJ1ZSwidXNlcm5hbWUiOiJzZXJjYW4iLCJhZG1pbl9pZCI6MSwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:26:27.978005+00
l55vnf8i8cvdnd7trcrwgkxckbu9dvpf	MTViNzVhYTc1Yzg5MTk3ZWE2MmEyZTFlMWYzNWFkNjljZjc1N2UyZjp7InBhc3N3b3JkIjoiMTIzNDUiLCJ1c2VybmFtZSI6InNlcmNhbiIsImlzX2xvZ2dlZCI6dHJ1ZX0=	2017-07-28 10:48:51.878237+00
15dnn94i8v5owr4ggthbqv3rutodyre4	YTEyOTc1NzMxMTkxOWI4ZDI2NDZhOTFiNTUwMmFiN2Y2YjI3MDExMjp7InVzZXJuYW1lIjoic2VyY2FuIiwiZ2FtZSI6IkRpYWJsbzEiLCJpc19sb2dnZWQiOnRydWUsInBhc3N3b3JkIjoiMTIzNDUifQ==	2017-07-29 20:28:25.501654+00
jg7i6igqme669nxrgk56ui6lg5tzmrdp	MTViNzVhYTc1Yzg5MTk3ZWE2MmEyZTFlMWYzNWFkNjljZjc1N2UyZjp7InBhc3N3b3JkIjoiMTIzNDUiLCJ1c2VybmFtZSI6InNlcmNhbiIsImlzX2xvZ2dlZCI6dHJ1ZX0=	2017-07-28 08:03:42.733628+00
ls1fds4ytvwk1gla6m7xmnhyuz6tdpj5	YjVjNTRlNTMzYTRhZjVlMjc2ZmEyMWViZWIwOTI0ZDVjOGE3ZGI3Mjp7Imxhbmd1YWdlIjoidHIifQ==	2017-07-31 07:02:21.056118+00
haepmqewfisfclmlsr6llveau9tdi2do	Y2ZkNGJjNDljMzQ2NGFhZjNmNjZhMTNiYmQ1ODgyOGVmNjkxMWE2Mjp7ImlzX2xvZ2dlZCI6dHJ1ZSwicGFzc3dvcmQiOiIxMjM0NSIsInVzZXJuYW1lIjoic2VyY2FuIn0=	2017-07-28 17:01:35.177928+00
0iph391rryc16yw2gcw1sy6wjlvbeq0a	YjVjNTRlNTMzYTRhZjVlMjc2ZmEyMWViZWIwOTI0ZDVjOGE3ZGI3Mjp7Imxhbmd1YWdlIjoidHIifQ==	2017-07-31 08:04:21.777248+00
ry8mor6gufblrzouw39o7hxi2lycxh9b	ZWFjMzRkMDNlNGJkNGRmZDg5YjA5NzRmYTg3YWRhMTExMzhmMTE0Zjp7ImlzX2xvZ2dlZCI6dHJ1ZSwidXNlcm5hbWUiOiJzZXJjYW4iLCJwYXNzd29yZCI6IjEyMzQ1In0=	2017-07-28 18:31:14.355044+00
0dkc5u6zutwaxn55ht29ha95pybp2a5r	ZWFjMzRkMDNlNGJkNGRmZDg5YjA5NzRmYTg3YWRhMTExMzhmMTE0Zjp7ImlzX2xvZ2dlZCI6dHJ1ZSwidXNlcm5hbWUiOiJzZXJjYW4iLCJwYXNzd29yZCI6IjEyMzQ1In0=	2017-07-28 18:32:58.392455+00
zf0jbjo3vg7xbdz461n5sjx54zyns1au	MmE4NTE3YTk2ZmIwM2Q0ODE1M2Q5MWU3YjJmZTljMmI3NDFlZmRlODp7Imxhbmd1YWdlIjoiZW4ifQ==	2017-07-30 20:21:55.857108+00
yq0lci1dtlhiv80k82aniewmbw0lqvbp	NWFkZTQ1MjQxMGZjMjE2YjY2YjQwZDJjZDIwYTQxZjUyMDIzMjg0YTp7Imxhbmd1YWdlIjoiIn0=	2017-07-31 07:54:36.52729+00
vu45c4jv80fgims9tlqmvezmxhpdk4yv	YzhhOTdmNDdhOTc1OTJhNDJmZWRjODFjZDkwMzFlNDBjNDRkYzgzZjp7ImlzX2xvZ2dlZCI6dHJ1ZSwiYWRtaW5faWQiOjEsInBhc3N3b3JkIjoiMTIzNDUiLCJ1c2VybmFtZSI6InNlcmNhbiJ9	2017-07-31 08:19:33.898624+00
sizjjddunhcq3n24qfgjf0og70t3u52t	NzRiMDA4MjQ5Mzk2ZWMwZTM5NTA0ODgzMjg1MTQ2NzljOTU0NzQzNTp7ImlzX2xvZ2dlZCI6dHJ1ZSwicGFzc3dvcmQiOiIxMjM0NSIsInVzZXJuYW1lIjoic2VyY2FuIiwiYWRtaW5faWQiOjF9	2017-07-31 08:52:42.367976+00
7d3csximcmuzrkld1rcziuar19afx23a	MmMxZTA2YWJmZjU4M2QzNjk0Mjk3ZTNiYWNlOWQ1NmQ4YjM0YWE3ODp7InBhc3N3b3JkIjoiMTIzNDUiLCJ1c2VybmFtZSI6InNlcmNhbiIsImFkbWluX2lkIjoxLCJpc19sb2dnZWQiOnRydWUsImxhbmd1YWdlIjoidHIifQ==	2017-07-31 08:30:18.34868+00
bccox9q2g00c8mf1ndk5eiullrlcitc3	NDNlODFiM2Q2MDU2N2ExZTUxN2U0ODEyNmViNjdmNjg5Y2UwYTY2ZDp7fQ==	2017-07-31 08:01:12.006256+00
87gcfm1plb0p1xx6t3q5cbe2wmbkfi50	MDE5OGFlNjljNjU4YjBkNzRiMGVlNzUwMTRkNTBlYWU3OWFmZWE5Zjp7ImlzX2xvZ2dlZCI6dHJ1ZSwidXNlcm5hbWUiOiJzZXJjYW4iLCJhZG1pbl9pZCI6MSwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:26:27.975403+00
xd3jfsvmj3g8p3hk1x33527v3uioc46a	MmJiZTBlYjMwNWFlM2E1ZTZmNDJlNGNkMGZjZDlhYWIyYTM1ZjM4YTp7ImFkbWluX2lkIjoxLCJpc19sb2dnZWQiOnRydWUsInVzZXJuYW1lIjoic2VyY2FuIiwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:19:33.286599+00
zdytbpawcnxkn32osnwomhxt1e018va8	MmJiZTBlYjMwNWFlM2E1ZTZmNDJlNGNkMGZjZDlhYWIyYTM1ZjM4YTp7ImFkbWluX2lkIjoxLCJpc19sb2dnZWQiOnRydWUsInVzZXJuYW1lIjoic2VyY2FuIiwicGFzc3dvcmQiOiIxMjM0NSJ9	2017-07-31 08:51:41.014348+00
ahd97w8r7ld2mwjb3omqy2oe8hrxmo2p	ODVkZmNlODdmMWM4NDg3OWIwM2ViZDkwNDg1OTBmYTg3N2I0MjU3Zjp7InVzZXJuYW1lIjoic2VyY2FuIiwiaXNfbG9nZ2VkIjp0cnVlLCJsYW5ndWFnZSI6InRyIiwicGFzc3dvcmQiOiIxMjM0NSIsImFkbWluX2lkIjoxfQ==	2017-07-31 08:52:20.721947+00
wia9chac6xkmlghdptvejqktl6dvia93	YjVjNTRlNTMzYTRhZjVlMjc2ZmEyMWViZWIwOTI0ZDVjOGE3ZGI3Mjp7Imxhbmd1YWdlIjoidHIifQ==	2017-07-31 08:54:25.393832+00
\.


--
-- Data for Name: game; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY game (id, name, price, created_date, update_date, logo, genre_id, company_id, content, platform_id) FROM stdin;
11	NeverWinter	130	2017-07-13 22:46:06.058648	2017-07-13 22:46:06.058648	\N	1	13	Nice Game	1
12	Diablo3	145	2017-07-13 23:19:18.361846	2017-07-13 23:19:18.361846	\N	1	13	EhisteGame	1
13	Diablo2	145	2017-07-13 23:24:28.472626	2017-07-13 23:24:28.472626	\N	1	13	EhisteGame	1
14	Diablo1	145	2017-07-13 23:25:21.726983	2017-07-13 23:25:21.726983	\N	1	13	EhisteGame	1
16	Diablo4	145	2017-07-13 23:30:41.117818	2017-07-13 23:30:41.117818	https://vignette2.wikia.nocookie.net/diablo/images/a/a4/Diablo_III_icon.png/revision/latest?cb=20140316104004	1	13	EhisteGame	1
19	StarWars	145	2017-07-14 08:24:06.637803	2017-07-14 08:24:06.637803	\N	1	13	EhisteGame	1
20	StarWars2	145	2017-07-14 08:25:16.383459	2017-07-14 08:25:16.383459	\N	1	13	EhisteGame	1
22	StarWars22	145	2017-07-14 08:25:26.864483	2017-07-14 08:25:26.864483	\N	1	13	EhisteGame	1
24	StarWars223	145	2017-07-14 08:26:14.700322	2017-07-14 08:26:14.700322	\N	1	13	EhisteGame	1
25	StarWar	145	2017-07-14 08:27:20.469526	2017-07-14 08:27:20.469526	\N	1	13	EhisteGame	1
26	StarWa	145	2017-07-14 08:28:12.33964	2017-07-14 08:28:12.33964	\N	1	13	EhisteGame	1
28	asd2	145	2017-07-14 08:46:01.236082	2017-07-14 08:46:01.236082	\N	1	13	EhisteGame	1
30	asd23	145	2017-07-14 08:48:21.910074	2017-07-14 08:48:21.910074	\N	1	13	EhisteGame	1
32	Diablo232	123.300003	2017-07-14 09:02:21.482357	2017-07-14 09:02:21.482357	\N	1	13	EhisteGame	1
33	SoulsOfGuns	12312	2017-07-14 11:54:12.763949	2017-07-14 11:54:12.763949	\N	1	13	EhisteGame	1
34	ADSADSASDASD	12312	2017-07-14 13:23:29.286612	2017-07-14 13:23:29.286612	\N	1	13	EhisteGame	1
35	ADSADSASDAasdadadsasdSD	12312	2017-07-14 13:23:45.640361	2017-07-14 13:23:45.640361	\N	1	13	EhisteGame	1
37	ADSADSASDAasdadadsasdSD2	12312	2017-07-14 14:12:08.335798	2017-07-14 14:12:08.335798	\N	1	13	EhisteGame	1
38	Dablio2123	23	2017-07-14 14:13:43.433379	2017-07-14 14:13:43.433379	\N	1	13	EhisteGame	1
39	Hallo223	23.2299995	2017-07-14 14:22:18.761136	2017-07-14 14:22:18.761136	\N	1	13	EhisteGame	1
40	Hallo2235	23.2299995	2017-07-14 14:25:32.859872	2017-07-14 14:25:32.859872	\N	1	13	EhisteGame	1
41	Hallo223534	23.2299995	2017-07-14 14:35:33.100149	2017-07-14 14:35:33.100149	\N	1	13	EhisteGame	1
42	Hallo2235343	23.2299995	2017-07-14 14:35:52.420396	2017-07-14 14:35:52.420396	\N	1	13	EhisteGame	1
43	RedDeadRedemption	123.230003	2017-07-14 14:36:41.158351	2017-07-14 14:36:41.158351	\N	1	13	EhisteGame	1
44	RedDeadRedemption2	123.230003	2017-07-14 14:37:27.389671	2017-07-14 14:37:27.389671	\N	1	13	EhisteGame	1
45	NeverWinter3434	123.230003	2017-07-14 14:40:02.986899	2017-07-14 14:40:02.986899	\N	1	13	EhisteGame	1
46	NeverWinter12312	123.230003	2017-07-14 14:40:19.36347	2017-07-14 14:40:19.36347	\N	1	13	EhisteGame	1
47	NeverWinter12312ASD	123.123001	2017-07-14 14:41:21.080901	2017-07-14 14:41:21.080901	\N	1	13	EhisteGame	1
49	NeverWinter12312ASD34	123.123001	2017-07-14 14:43:02.88695	2017-07-14 14:43:02.88695	\N	1	13	EhisteGame	1
50	Diablo343	12.3000002	2017-07-14 14:57:26.528084	2017-07-14 14:57:26.528084	\N	1	13	EhisteGame	1
52	Dabilo123	12.2299995	2017-07-14 19:06:54.000282	2017-07-14 19:06:54.000282	\N	1	13	EhisteGame	1
\.


--
-- Name: game_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('game_id_seq', 52, true);


--
-- Data for Name: genre; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY genre (id, name) FROM stdin;
1	RPG
\.


--
-- Name: genre_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('genre_id_seq', 1, true);


--
-- Data for Name: log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY log (id, username, operation, name, price, genre_id, company_id, game_id, logo) FROM stdin;
\.


--
-- Name: log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('log_id_seq', 1, false);


--
-- Data for Name: platform; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY platform (id, name) FROM stdin;
1	PC
\.


--
-- Name: platform_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('platform_id_seq', 1, true);


--
-- Data for Name: sale; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sale (id, user_id, game_id, c_date, amount) FROM stdin;
1	2	14	2017-07-15 17:34:01.789306	145
2	2	14	2017-07-15 18:01:43.342795	145
3	2	14	2017-07-15 18:02:22.274096	145
\.


--
-- Name: sale_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('sale_id_seq', 7, true);


--
-- Data for Name: status; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY status (id, is_active) FROM stdin;
1	t
2	f
\.


--
-- Name: status_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('status_id_seq', 2, true);


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY users (id, username, password, email, c_date, full_name, balance, lastlogin, admin_id, status_id) FROM stdin;
5	zxczxc	zxczxc	zxcxcxz@gmail.com	2017-07-13 10:58:52.467456	xzxzx ZXZX	0	2017-07-13 10:58:52.467456	2	1
7	asdad	asdfasdf	sdas@gmail.com	2017-07-13 22:20:23.454909	asdasd sdasd	0	2017-07-13 22:20:23.454909	2	1
8	asd	abcder34	admin@hotmail.com	2017-07-13 22:31:14.683828	asd asd	0	2017-07-13 22:31:14.683828	2	1
9	dafafdss	A12fgbcy$	asdfasdfas@gmail.com	2017-07-14 06:42:04.902717	dasdasd gfddfhdfh	0	2017-07-14 06:42:04.902717	2	1
10	fasds	grAwc34xz	gsdfsdf@gmail.com	2017-07-14 07:36:33.823762	fdsfs ZXZX	0	2017-07-14 07:36:33.823762	2	1
50	sercan3	Aa1234567	s@s.com	2017-07-15 21:27:34.262163	SERCAN1 sercan2	0	2017-07-16 01:28:24.150072	2	1
14	tadem	Ahkc326j81	tademhadj@gmail.com	2017-07-14 07:50:32.147565	taha demir	0	2017-07-14 07:50:32.147565	2	1
19	dawdq	afsbr234b	dskjhfkjsd@gmail.com	2017-07-14 08:42:50.173745	dadas fdafaw	0	2017-07-14 08:42:50.173745	2	1
49	as	Aa12345432	asd@asd.com	2017-07-15 13:40:49.845791	asdasd asas	0	2017-07-15 13:40:49.845791	2	1
43	deneme	denemeA12345	deneme@deneme.com	2017-07-14 18:08:57.675564	deneme deneme	0	2017-07-15 16:28:33.692719	2	1
6	asdasd	sdfasdf	asdasd@gma.com	2017-07-13 21:10:41.249613	asdasd asdasd	0	2017-07-16 00:17:38.049808	2	1
2	sercan	12345	test@test.com	2017-07-13 13:41:30.285832	sercan yektas	100	2017-07-17 08:51:36.752973	1	1
\.


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('users_id_seq', 50, true);


--
-- Data for Name: users_profile; Type: TABLE DATA; Schema: public; Owner: sercan
--

COPY users_profile (id, birth_date, status, balance, user_id) FROM stdin;
\.


--
-- Name: users_profile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sercan
--

SELECT pg_catalog.setval('users_profile_id_seq', 1, false);


--
-- Name: admin_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY admin
    ADD CONSTRAINT admin_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions_group_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission_content_type_id_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_user_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_user_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: company_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY company
    ADD CONSTRAINT company_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type_app_label_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_app_label_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: game_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game
    ADD CONSTRAINT game_name_key UNIQUE (name);


--
-- Name: game_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game
    ADD CONSTRAINT game_pkey PRIMARY KEY (id);


--
-- Name: genre_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY genre
    ADD CONSTRAINT genre_name_key UNIQUE (name);


--
-- Name: genre_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY genre
    ADD CONSTRAINT genre_pkey PRIMARY KEY (id);


--
-- Name: log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY log
    ADD CONSTRAINT log_pkey PRIMARY KEY (id);


--
-- Name: platform_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_pkey PRIMARY KEY (id);


--
-- Name: sale_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sale
    ADD CONSTRAINT sale_pkey PRIMARY KEY (id);


--
-- Name: status_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY status
    ADD CONSTRAINT status_pkey PRIMARY KEY (id);


--
-- Name: users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: users_profile_pkey; Type: CONSTRAINT; Schema: public; Owner: sercan
--

ALTER TABLE ONLY users_profile
    ADD CONSTRAINT users_profile_pkey PRIMARY KEY (id);


--
-- Name: users_profile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: sercan
--

ALTER TABLE ONLY users_profile
    ADD CONSTRAINT users_profile_user_id_key UNIQUE (user_id);


--
-- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_name_a6ea08ec_like ON auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_0e939a4f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_permissions_0e939a4f ON auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_permissions_8373b171 ON auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_417f1b1c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_permission_417f1b1c ON auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_0e939a4f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_groups_0e939a4f ON auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_groups_e8701ad4 ON auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_user_permissions_8373b171 ON auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_user_permissions_e8701ad4 ON auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_username_6821ab7c_like ON auth_user USING btree (username varchar_pattern_ops);


--
-- Name: company_name_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX company_name_idx ON company USING btree (name);


--
-- Name: django_admin_log_417f1b1c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_admin_log_417f1b1c ON django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_admin_log_e8701ad4 ON django_admin_log USING btree (user_id);


--
-- Name: django_session_de54fa62; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_session_de54fa62 ON django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_session_session_key_c0390e0f_like ON django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: genre_name_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX genre_name_idx ON company USING btree (name);


--
-- Name: platform_name_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX platform_name_idx ON company USING btree (name);


--
-- Name: auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_content_type_id_c4bce8eb_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_content_type_id_c4bce8eb_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: game_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game
    ADD CONSTRAINT game_company_id_fkey FOREIGN KEY (company_id) REFERENCES company(id);


--
-- Name: game_genre_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game
    ADD CONSTRAINT game_genre_id_fkey FOREIGN KEY (genre_id) REFERENCES genre(id);


--
-- Name: game_platform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY game
    ADD CONSTRAINT game_platform_id_fkey FOREIGN KEY (platform_id) REFERENCES platform(id);


--
-- Name: sale_game_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sale
    ADD CONSTRAINT sale_game_id_fkey FOREIGN KEY (game_id) REFERENCES game(id);


--
-- Name: sale_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sale
    ADD CONSTRAINT sale_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);


--
-- Name: users_admin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_admin_id_fkey FOREIGN KEY (admin_id) REFERENCES admin(id);


--
-- Name: users_profile_user_id_2112e78d_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sercan
--

ALTER TABLE ONLY users_profile
    ADD CONSTRAINT users_profile_user_id_2112e78d_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_status_id_fkey FOREIGN KEY (status_id) REFERENCES status(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: company; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE company FROM PUBLIC;
REVOKE ALL ON TABLE company FROM postgres;
GRANT ALL ON TABLE company TO postgres;
GRANT ALL ON TABLE company TO emir;
GRANT ALL ON TABLE company TO yagmur;
GRANT ALL ON TABLE company TO sercan;
GRANT ALL ON TABLE company TO halilabi;
GRANT ALL ON TABLE company TO taha;
GRANT ALL ON TABLE company TO halil;


--
-- Name: company_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE company_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE company_id_seq FROM postgres;
GRANT ALL ON SEQUENCE company_id_seq TO postgres;
GRANT ALL ON SEQUENCE company_id_seq TO emir;
GRANT ALL ON SEQUENCE company_id_seq TO yagmur;
GRANT ALL ON SEQUENCE company_id_seq TO sercan;
GRANT ALL ON SEQUENCE company_id_seq TO halilabi;
GRANT ALL ON SEQUENCE company_id_seq TO taha;
GRANT ALL ON SEQUENCE company_id_seq TO halil;


--
-- Name: django_migrations; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE django_migrations FROM PUBLIC;
REVOKE ALL ON TABLE django_migrations FROM postgres;
GRANT ALL ON TABLE django_migrations TO postgres;
GRANT ALL ON TABLE django_migrations TO emir;
GRANT ALL ON TABLE django_migrations TO halil;
GRANT ALL ON TABLE django_migrations TO halilabi;
GRANT ALL ON TABLE django_migrations TO yagmur;
GRANT ALL ON TABLE django_migrations TO taha;
GRANT ALL ON TABLE django_migrations TO sercan;


--
-- Name: django_migrations_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE django_migrations_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE django_migrations_id_seq FROM postgres;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO postgres;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO emir;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO halil;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO halilabi;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO yagmur;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO taha;
GRANT ALL ON SEQUENCE django_migrations_id_seq TO sercan;


--
-- Name: game; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE game FROM PUBLIC;
REVOKE ALL ON TABLE game FROM postgres;
GRANT ALL ON TABLE game TO postgres;
GRANT ALL ON TABLE game TO emir;
GRANT ALL ON TABLE game TO yagmur;
GRANT ALL ON TABLE game TO sercan;
GRANT ALL ON TABLE game TO halilabi;
GRANT ALL ON TABLE game TO taha;
GRANT ALL ON TABLE game TO halil;


--
-- Name: game_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE game_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE game_id_seq FROM postgres;
GRANT ALL ON SEQUENCE game_id_seq TO postgres;
GRANT ALL ON SEQUENCE game_id_seq TO emir;
GRANT ALL ON SEQUENCE game_id_seq TO yagmur;
GRANT ALL ON SEQUENCE game_id_seq TO sercan;
GRANT ALL ON SEQUENCE game_id_seq TO halilabi;
GRANT ALL ON SEQUENCE game_id_seq TO taha;
GRANT ALL ON SEQUENCE game_id_seq TO halil;


--
-- Name: genre; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE genre FROM PUBLIC;
REVOKE ALL ON TABLE genre FROM postgres;
GRANT ALL ON TABLE genre TO postgres;
GRANT ALL ON TABLE genre TO emir;
GRANT ALL ON TABLE genre TO yagmur;
GRANT ALL ON TABLE genre TO sercan;
GRANT ALL ON TABLE genre TO halilabi;
GRANT ALL ON TABLE genre TO taha;
GRANT ALL ON TABLE genre TO halil;


--
-- Name: genre_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE genre_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE genre_id_seq FROM postgres;
GRANT ALL ON SEQUENCE genre_id_seq TO postgres;
GRANT ALL ON SEQUENCE genre_id_seq TO emir;
GRANT ALL ON SEQUENCE genre_id_seq TO yagmur;
GRANT ALL ON SEQUENCE genre_id_seq TO sercan;
GRANT ALL ON SEQUENCE genre_id_seq TO halilabi;
GRANT ALL ON SEQUENCE genre_id_seq TO taha;
GRANT ALL ON SEQUENCE genre_id_seq TO halil;


--
-- Name: platform; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE platform FROM PUBLIC;
REVOKE ALL ON TABLE platform FROM postgres;
GRANT ALL ON TABLE platform TO postgres;
GRANT ALL ON TABLE platform TO emir;
GRANT ALL ON TABLE platform TO yagmur;
GRANT ALL ON TABLE platform TO halil;
GRANT ALL ON TABLE platform TO taha;
GRANT ALL ON TABLE platform TO halilabi;


--
-- Name: platform_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE platform_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE platform_id_seq FROM postgres;
GRANT ALL ON SEQUENCE platform_id_seq TO postgres;
GRANT ALL ON SEQUENCE platform_id_seq TO emir;
GRANT ALL ON SEQUENCE platform_id_seq TO yagmur;
GRANT ALL ON SEQUENCE platform_id_seq TO halil;
GRANT ALL ON SEQUENCE platform_id_seq TO taha;
GRANT ALL ON SEQUENCE platform_id_seq TO halilabi;


--
-- Name: sale; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE sale FROM PUBLIC;
REVOKE ALL ON TABLE sale FROM postgres;
GRANT ALL ON TABLE sale TO postgres;
GRANT ALL ON TABLE sale TO emir;
GRANT ALL ON TABLE sale TO yagmur;
GRANT ALL ON TABLE sale TO sercan;
GRANT ALL ON TABLE sale TO halilabi;
GRANT ALL ON TABLE sale TO taha;
GRANT ALL ON TABLE sale TO halil;


--
-- Name: sale_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE sale_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE sale_id_seq FROM postgres;
GRANT ALL ON SEQUENCE sale_id_seq TO postgres;
GRANT ALL ON SEQUENCE sale_id_seq TO emir;
GRANT ALL ON SEQUENCE sale_id_seq TO yagmur;
GRANT ALL ON SEQUENCE sale_id_seq TO sercan;
GRANT ALL ON SEQUENCE sale_id_seq TO halilabi;
GRANT ALL ON SEQUENCE sale_id_seq TO taha;
GRANT ALL ON SEQUENCE sale_id_seq TO halil;


--
-- Name: users; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE users FROM PUBLIC;
REVOKE ALL ON TABLE users FROM postgres;
GRANT ALL ON TABLE users TO postgres;
GRANT ALL ON TABLE users TO emir;
GRANT ALL ON TABLE users TO yagmur;
GRANT ALL ON TABLE users TO sercan;
GRANT ALL ON TABLE users TO halilabi;
GRANT ALL ON TABLE users TO taha;
GRANT ALL ON TABLE users TO halil;


--
-- Name: users_id_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE users_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE users_id_seq FROM postgres;
GRANT ALL ON SEQUENCE users_id_seq TO postgres;
GRANT ALL ON SEQUENCE users_id_seq TO emir;
GRANT ALL ON SEQUENCE users_id_seq TO yagmur;
GRANT ALL ON SEQUENCE users_id_seq TO sercan;
GRANT ALL ON SEQUENCE users_id_seq TO halilabi;
GRANT ALL ON SEQUENCE users_id_seq TO taha;
GRANT ALL ON SEQUENCE users_id_seq TO halil;


--
-- PostgreSQL database dump complete
--