1-- 2-- PostgreSQL database dump 3-- 4 5-- Dumped from database version 9.5.1 6-- Dumped by pg_dump version 9.5.1 7 8SET statement_timeout = 0; 9SET client_encoding = 'UTF8'; 10SET standard_conforming_strings = on; 11SET check_function_bodies = false; 12SET client_min_messages = warning; 13 14-- 15-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 16-- 17 18CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; 19 20 21-- 22-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 23-- 24 25COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; 26 27 28SET search_path = public, pg_catalog; 29 30SET default_tablespace = ''; 31 32SET default_with_oids = false; 33 34-- 35-- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres 36-- 37 38CREATE TABLE auth_group ( 39 id integer NOT NULL, 40 name character varying(80) NOT NULL 41); 42 43 44ALTER TABLE auth_group OWNER TO postgres; 45 46-- 47-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 48-- 49 50CREATE SEQUENCE auth_group_id_seq 51 START WITH 1 52 INCREMENT BY 1 53 NO MINVALUE 54 NO MAXVALUE 55 CACHE 1; 56 57 58ALTER TABLE auth_group_id_seq OWNER TO postgres; 59 60-- 61-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 62-- 63 64ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id; 65 66 67-- 68-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres 69-- 70 71CREATE TABLE auth_group_permissions ( 72 id integer NOT NULL, 73 group_id integer NOT NULL, 74 permission_id integer NOT NULL 75); 76 77 78ALTER TABLE auth_group_permissions OWNER TO postgres; 79 80-- 81-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 82-- 83 84CREATE SEQUENCE auth_group_permissions_id_seq 85 START WITH 1 86 INCREMENT BY 1 87 NO MINVALUE 88 NO MAXVALUE 89 CACHE 1; 90 91 92ALTER TABLE auth_group_permissions_id_seq OWNER TO postgres; 93 94-- 95-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 96-- 97 98ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id; 99 100 101-- 102-- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres 103-- 104 105CREATE TABLE auth_permission ( 106 id integer NOT NULL, 107 name character varying(255) NOT NULL, 108 content_type_id integer NOT NULL, 109 codename character varying(100) NOT NULL 110); 111 112 113ALTER TABLE auth_permission OWNER TO postgres; 114 115-- 116-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 117-- 118 119CREATE SEQUENCE auth_permission_id_seq 120 START WITH 1 121 INCREMENT BY 1 122 NO MINVALUE 123 NO MAXVALUE 124 CACHE 1; 125 126 127ALTER TABLE auth_permission_id_seq OWNER TO postgres; 128 129-- 130-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 131-- 132 133ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id; 134 135 136-- 137-- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres 138-- 139 140CREATE TABLE auth_user ( 141 id integer NOT NULL, 142 password character varying(128) NOT NULL, 143 last_login timestamp with time zone, 144 is_superuser boolean NOT NULL, 145 username character varying(30) NOT NULL, 146 first_name character varying(30) NOT NULL, 147 last_name character varying(30) NOT NULL, 148 email character varying(254) NOT NULL, 149 is_staff boolean NOT NULL, 150 is_active boolean NOT NULL, 151 date_joined timestamp with time zone NOT NULL 152); 153 154 155ALTER TABLE auth_user OWNER TO postgres; 156 157-- 158-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres 159-- 160 161CREATE TABLE auth_user_groups ( 162 id integer NOT NULL, 163 user_id integer NOT NULL, 164 group_id integer NOT NULL 165); 166 167 168ALTER TABLE auth_user_groups OWNER TO postgres; 169 170-- 171-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 172-- 173 174CREATE SEQUENCE auth_user_groups_id_seq 175 START WITH 1 176 INCREMENT BY 1 177 NO MINVALUE 178 NO MAXVALUE 179 CACHE 1; 180 181 182ALTER TABLE auth_user_groups_id_seq OWNER TO postgres; 183 184-- 185-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 186-- 187 188ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id; 189 190 191-- 192-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 193-- 194 195CREATE SEQUENCE auth_user_id_seq 196 START WITH 1 197 INCREMENT BY 1 198 NO MINVALUE 199 NO MAXVALUE 200 CACHE 1; 201 202 203ALTER TABLE auth_user_id_seq OWNER TO postgres; 204 205-- 206-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 207-- 208 209ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id; 210 211 212-- 213-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres 214-- 215 216CREATE TABLE auth_user_user_permissions ( 217 id integer NOT NULL, 218 user_id integer NOT NULL, 219 permission_id integer NOT NULL 220); 221 222 223ALTER TABLE auth_user_user_permissions OWNER TO postgres; 224 225-- 226-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 227-- 228 229CREATE SEQUENCE auth_user_user_permissions_id_seq 230 START WITH 1 231 INCREMENT BY 1 232 NO MINVALUE 233 NO MAXVALUE 234 CACHE 1; 235 236 237ALTER TABLE auth_user_user_permissions_id_seq OWNER TO postgres; 238 239-- 240-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 241-- 242 243ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id; 244 245 246-- 247-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres 248-- 249 250CREATE TABLE django_admin_log ( 251 id integer NOT NULL, 252 action_time timestamp with time zone NOT NULL, 253 object_id text, 254 object_repr character varying(200) NOT NULL, 255 action_flag smallint NOT NULL, 256 change_message text NOT NULL, 257 content_type_id integer, 258 user_id integer NOT NULL, 259 CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0)) 260); 261 262 263ALTER TABLE django_admin_log OWNER TO postgres; 264 265-- 266-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 267-- 268 269CREATE SEQUENCE django_admin_log_id_seq 270 START WITH 1 271 INCREMENT BY 1 272 NO MINVALUE 273 NO MAXVALUE 274 CACHE 1; 275 276 277ALTER TABLE django_admin_log_id_seq OWNER TO postgres; 278 279-- 280-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 281-- 282 283ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id; 284 285 286-- 287-- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres 288-- 289 290CREATE TABLE django_content_type ( 291 id integer NOT NULL, 292 app_label character varying(100) NOT NULL, 293 model character varying(100) NOT NULL 294); 295 296 297ALTER TABLE django_content_type OWNER TO postgres; 298 299-- 300-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 301-- 302 303CREATE SEQUENCE django_content_type_id_seq 304 START WITH 1 305 INCREMENT BY 1 306 NO MINVALUE 307 NO MAXVALUE 308 CACHE 1; 309 310 311ALTER TABLE django_content_type_id_seq OWNER TO postgres; 312 313-- 314-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 315-- 316 317ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id; 318 319 320-- 321-- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres 322-- 323 324CREATE TABLE django_migrations ( 325 id integer NOT NULL, 326 app character varying(255) NOT NULL, 327 name character varying(255) NOT NULL, 328 applied timestamp with time zone NOT NULL 329); 330 331 332ALTER TABLE django_migrations OWNER TO postgres; 333 334-- 335-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 336-- 337 338CREATE SEQUENCE django_migrations_id_seq 339 START WITH 1 340 INCREMENT BY 1 341 NO MINVALUE 342 NO MAXVALUE 343 CACHE 1; 344 345 346ALTER TABLE django_migrations_id_seq OWNER TO postgres; 347 348-- 349-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 350-- 351 352ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id; 353 354 355-- 356-- Name: django_session; Type: TABLE; Schema: public; Owner: postgres 357-- 358 359CREATE TABLE django_session ( 360 session_key character varying(40) NOT NULL, 361 session_data text NOT NULL, 362 expire_date timestamp with time zone NOT NULL 363); 364 365 366ALTER TABLE django_session OWNER TO postgres; 367 368-- 369-- Name: timetracker_billingperiod; Type: TABLE; Schema: public; Owner: postgres 370-- 371 372CREATE TABLE timetracker_billingperiod ( 373 id integer NOT NULL, 374 time_from timestamp with time zone NOT NULL, 375 time_until timestamp with time zone NOT NULL, 376 closed boolean NOT NULL, 377 identifier character varying(10), 378 project_id integer NOT NULL 379); 380 381 382ALTER TABLE timetracker_billingperiod OWNER TO postgres; 383 384-- 385-- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 386-- 387 388CREATE SEQUENCE timetracker_billingperiod_id_seq 389 START WITH 1 390 INCREMENT BY 1 391 NO MINVALUE 392 NO MAXVALUE 393 CACHE 1; 394 395 396ALTER TABLE timetracker_billingperiod_id_seq OWNER TO postgres; 397 398-- 399-- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 400-- 401 402ALTER SEQUENCE timetracker_billingperiod_id_seq OWNED BY timetracker_billingperiod.id; 403 404 405-- 406-- Name: timetracker_project; Type: TABLE; Schema: public; Owner: postgres 407-- 408 409CREATE TABLE timetracker_project ( 410 id integer NOT NULL, 411 name character varying(200) NOT NULL, 412 billing_id character varying(50) NOT NULL, 413 active boolean NOT NULL, 414 time_created timestamp with time zone NOT NULL, 415 last_modified timestamp with time zone NOT NULL 416); 417 418 419ALTER TABLE timetracker_project OWNER TO postgres; 420 421-- 422-- Name: timetracker_project_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 423-- 424 425CREATE SEQUENCE timetracker_project_id_seq 426 START WITH 1 427 INCREMENT BY 1 428 NO MINVALUE 429 NO MAXVALUE 430 CACHE 1; 431 432 433ALTER TABLE timetracker_project_id_seq OWNER TO postgres; 434 435-- 436-- Name: timetracker_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 437-- 438 439ALTER SEQUENCE timetracker_project_id_seq OWNED BY timetracker_project.id; 440 441 442-- 443-- Name: timetracker_project_members; Type: TABLE; Schema: public; Owner: postgres 444-- 445 446CREATE TABLE timetracker_project_members ( 447 id integer NOT NULL, 448 project_id integer NOT NULL, 449 user_id integer NOT NULL 450); 451 452 453ALTER TABLE timetracker_project_members OWNER TO postgres; 454 455-- 456-- Name: timetracker_project_members_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 457-- 458 459CREATE SEQUENCE timetracker_project_members_id_seq 460 START WITH 1 461 INCREMENT BY 1 462 NO MINVALUE 463 NO MAXVALUE 464 CACHE 1; 465 466 467ALTER TABLE timetracker_project_members_id_seq OWNER TO postgres; 468 469-- 470-- Name: timetracker_project_members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 471-- 472 473ALTER SEQUENCE timetracker_project_members_id_seq OWNED BY timetracker_project_members.id; 474 475 476-- 477-- Name: timetracker_worklog; Type: TABLE; Schema: public; Owner: postgres 478-- 479 480CREATE TABLE timetracker_worklog ( 481 id integer NOT NULL, 482 time_from timestamp with time zone NOT NULL, 483 time_until timestamp with time zone NOT NULL, 484 description text NOT NULL, 485 office_hour_rate boolean NOT NULL, 486 project_id integer NOT NULL, 487 user_id integer NOT NULL, 488 billing_period_id integer 489); 490 491 492ALTER TABLE timetracker_worklog OWNER TO postgres; 493 494-- 495-- Name: timetracker_worklog_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres 496-- 497 498CREATE SEQUENCE timetracker_worklog_id_seq 499 START WITH 1 500 INCREMENT BY 1 501 NO MINVALUE 502 NO MAXVALUE 503 CACHE 1; 504 505 506ALTER TABLE timetracker_worklog_id_seq OWNER TO postgres; 507 508-- 509-- Name: timetracker_worklog_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres 510-- 511 512ALTER SEQUENCE timetracker_worklog_id_seq OWNED BY timetracker_worklog.id; 513 514 515-- 516-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 517-- 518 519ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass); 520 521 522-- 523-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 524-- 525 526ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass); 527 528 529-- 530-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 531-- 532 533ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass); 534 535 536-- 537-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 538-- 539 540ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass); 541 542 543-- 544-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 545-- 546 547ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass); 548 549 550-- 551-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 552-- 553 554ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass); 555 556 557-- 558-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 559-- 560 561ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass); 562 563 564-- 565-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 566-- 567 568ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass); 569 570 571-- 572-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 573-- 574 575ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass); 576 577 578-- 579-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 580-- 581 582ALTER TABLE ONLY timetracker_billingperiod ALTER COLUMN id SET DEFAULT nextval('timetracker_billingperiod_id_seq'::regclass); 583 584 585-- 586-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 587-- 588 589ALTER TABLE ONLY timetracker_project ALTER COLUMN id SET DEFAULT nextval('timetracker_project_id_seq'::regclass); 590 591 592-- 593-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 594-- 595 596ALTER TABLE ONLY timetracker_project_members ALTER COLUMN id SET DEFAULT nextval('timetracker_project_members_id_seq'::regclass); 597 598 599-- 600-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres 601-- 602 603ALTER TABLE ONLY timetracker_worklog ALTER COLUMN id SET DEFAULT nextval('timetracker_worklog_id_seq'::regclass); 604 605 606-- 607-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: postgres 608-- 609 610INSERT INTO auth_group (id, name) VALUES (2, 'Kunden'); 611INSERT INTO auth_group (id, name) VALUES (3, 'Projektleiter'); 612INSERT INTO auth_group (id, name) VALUES (1, 'Mitarbeiter'); 613INSERT INTO auth_group (id, name) VALUES (4, 'Billing'); 614 615 616-- 617-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 618-- 619 620SELECT pg_catalog.setval('auth_group_id_seq', 4, true); 621 622 623-- 624-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: postgres 625-- 626 627INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (1, 4, 8); 628INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (2, 4, 7); 629INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (3, 3, 1); 630INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (4, 3, 2); 631INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (5, 3, 3); 632INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (6, 3, 4); 633INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (7, 3, 5); 634INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (8, 3, 6); 635INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (9, 1, 4); 636INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (10, 1, 5); 637INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (11, 1, 6); 638INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (12, 4, 9); 639 640 641-- 642-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 643-- 644 645SELECT pg_catalog.setval('auth_group_permissions_id_seq', 12, true); 646 647 648-- 649-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: postgres 650-- 651 652INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (1, 'Can add project', 1, 'add_project'); 653INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (2, 'Can change project', 1, 'change_project'); 654INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (3, 'Can delete project', 1, 'delete_project'); 655INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (4, 'Can add work log', 2, 'add_worklog'); 656INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (5, 'Can change work log', 2, 'change_worklog'); 657INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (6, 'Can delete work log', 2, 'delete_worklog'); 658INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (7, 'Can add billing period', 3, 'add_billingperiod'); 659INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (8, 'Can change billing period', 3, 'change_billingperiod'); 660INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (9, 'Can delete billing period', 3, 'delete_billingperiod'); 661INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (10, 'Can add log entry', 4, 'add_logentry'); 662INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (11, 'Can change log entry', 4, 'change_logentry'); 663INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (12, 'Can delete log entry', 4, 'delete_logentry'); 664INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (13, 'Can add permission', 5, 'add_permission'); 665INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (14, 'Can change permission', 5, 'change_permission'); 666INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (15, 'Can delete permission', 5, 'delete_permission'); 667INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (16, 'Can add group', 6, 'add_group'); 668INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (17, 'Can change group', 6, 'change_group'); 669INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (18, 'Can delete group', 6, 'delete_group'); 670INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (19, 'Can add user', 7, 'add_user'); 671INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (20, 'Can change user', 7, 'change_user'); 672INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (21, 'Can delete user', 7, 'delete_user'); 673INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (22, 'Can add content type', 8, 'add_contenttype'); 674INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (23, 'Can change content type', 8, 'change_contenttype'); 675INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (24, 'Can delete content type', 8, 'delete_contenttype'); 676INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (25, 'Can add session', 9, 'add_session'); 677INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (26, 'Can change session', 9, 'change_session'); 678INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (27, 'Can delete session', 9, 'delete_session'); 679 680 681-- 682-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 683-- 684 685SELECT pg_catalog.setval('auth_permission_id_seq', 27, true); 686 687 688-- 689-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: postgres 690-- 691 692INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) VALUES (5, 'pbkdf2_sha256$24000$LakQQ2OOTO1v$dmUgz8V7zcpaoBSA3MV76J5a4rzrszF0NpxGx6HRBbE=', NULL, false, 'test-billing', 'Joana', 'Gröschel', 'jg@billing.com', true, true, '2016-03-07 15:58:49+01'); 693INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) VALUES (3, 'pbkdf2_sha256$24000$PXogIZpE4gaK$F/P/L5SRrbb6taOGEr4w6DhxjMzNAj1jEWTPyAUn8WU=', NULL, false, 'test-kunde', 'Niels', 'Buchberger', 'ng@kunde.com', false, true, '2016-03-07 15:57:52+01'); 694INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) VALUES (2, 'pbkdf2_sha256$24000$vtn5APnhirmB$/jzJXYvm78X8/FCOMhGUmcCy0iWhtk0L1hcBWN1AYZc=', NULL, false, 'test-mitarbeiter', 'Claus', 'Wernke', 'cw@mitarbeiter.com', false, true, '2016-03-07 15:57:23+01'); 695INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) VALUES (4, 'pbkdf2_sha256$24000$meyCtGKrS5Ai$vkMfMzB/yGFKplmXujgtfl3OGR27AwOQmP+YeRP6lbw=', NULL, false, 'test-projektleiter', 'Sascha', 'Weiher', 'sw@projektleiter.com', true, true, '2016-03-07 15:58:09+01'); 696INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) VALUES (1, 'pbkdf2_sha256$24000$M8ecC8zfqLmJ$l6cIa/Od+m56VMm9hJbdPNhTXZykPVbUGGTPx7/VRE4=', '2016-03-07 15:54:45+01', true, 'admin', 'Admin', 'Istrator', 'admin@example.com', true, true, '2016-03-07 15:54:22+01'); 697 698 699-- 700-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: postgres 701-- 702 703INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (1, 2, 1); 704INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (2, 3, 2); 705INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (3, 4, 3); 706INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (4, 5, 4); 707 708 709-- 710-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 711-- 712 713SELECT pg_catalog.setval('auth_user_groups_id_seq', 4, true); 714 715 716-- 717-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 718-- 719 720SELECT pg_catalog.setval('auth_user_id_seq', 5, true); 721 722 723-- 724-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres 725-- 726 727INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (1, 4, 19); 728INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (2, 4, 20); 729INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (3, 4, 21); 730 731 732-- 733-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 734-- 735 736SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 3, true); 737 738 739-- 740-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: postgres 741-- 742 743INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (1, '2016-03-07 15:54:56.300644+01', '1', 'Mitarbeiter', 1, 'Hinzugefügt.', 6, 1); 744INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (2, '2016-03-07 15:55:03.567461+01', '2', 'Kunden', 1, 'Hinzugefügt.', 6, 1); 745INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (3, '2016-03-07 15:55:12.909732+01', '3', 'Projektleiter', 1, 'Hinzugefügt.', 6, 1); 746INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (4, '2016-03-07 15:55:19.286428+01', '4', 'Billing', 1, 'Hinzugefügt.', 6, 1); 747INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (5, '2016-03-07 15:55:46.352427+01', '4', 'Billing', 2, 'permissions geändert.', 6, 1); 748INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (6, '2016-03-07 15:56:20.226365+01', '3', 'Projektleiter', 2, 'permissions geändert.', 6, 1); 749INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (7, '2016-03-07 15:56:28.990235+01', '1', 'Mitarbeiter', 2, 'permissions geändert.', 6, 1); 750INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (8, '2016-03-07 15:56:52.876303+01', '4', 'Billing', 2, 'permissions geändert.', 6, 1); 751INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (9, '2016-03-07 15:57:23.335998+01', '2', 'test-mitarbeiter', 1, 'Hinzugefügt.', 7, 1); 752INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (10, '2016-03-07 15:57:44.179275+01', '2', 'test-mitarbeiter', 2, 'groups geändert.', 7, 1); 753INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (11, '2016-03-07 15:57:52.235262+01', '3', 'test-kunde', 1, 'Hinzugefügt.', 7, 1); 754INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (12, '2016-03-07 15:57:59.05676+01', '3', 'test-kunde', 2, 'groups geändert.', 7, 1); 755INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (13, '2016-03-07 15:58:10.0047+01', '4', 'test-projektleiter', 1, 'Hinzugefügt.', 7, 1); 756INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (14, '2016-03-07 15:58:35.229359+01', '4', 'test-projektleiter', 2, 'is_staff, groups und user_permissions geändert.', 7, 1); 757INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (15, '2016-03-07 15:58:49.513774+01', '5', 'test-billing', 1, 'Hinzugefügt.', 7, 1); 758INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (16, '2016-03-07 15:58:55.398695+01', '5', 'test-billing', 2, 'is_staff und groups geändert.', 7, 1); 759INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (17, '2016-03-07 15:59:56.823546+01', '5', 'test-billing', 2, 'first_name, last_name und email geändert.', 7, 1); 760INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (18, '2016-03-07 16:00:15.718568+01', '3', 'test-kunde', 2, 'first_name, last_name und email geändert.', 7, 1); 761INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (19, '2016-03-07 16:00:37.583668+01', '2', 'test-mitarbeiter', 2, 'first_name, last_name und email geändert.', 7, 1); 762INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (20, '2016-03-07 16:00:59.426815+01', '4', 'test-projektleiter', 2, 'first_name, last_name und email geändert.', 7, 1); 763INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (21, '2016-03-07 16:01:13.440369+01', '1', 'admin', 2, 'first_name und last_name geändert.', 7, 1); 764 765 766-- 767-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 768-- 769 770SELECT pg_catalog.setval('django_admin_log_id_seq', 21, true); 771 772 773-- 774-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: postgres 775-- 776 777INSERT INTO django_content_type (id, app_label, model) VALUES (1, 'timetracker', 'project'); 778INSERT INTO django_content_type (id, app_label, model) VALUES (2, 'timetracker', 'worklog'); 779INSERT INTO django_content_type (id, app_label, model) VALUES (3, 'timetracker', 'billingperiod'); 780INSERT INTO django_content_type (id, app_label, model) VALUES (4, 'admin', 'logentry'); 781INSERT INTO django_content_type (id, app_label, model) VALUES (5, 'auth', 'permission'); 782INSERT INTO django_content_type (id, app_label, model) VALUES (6, 'auth', 'group'); 783INSERT INTO django_content_type (id, app_label, model) VALUES (7, 'auth', 'user'); 784INSERT INTO django_content_type (id, app_label, model) VALUES (8, 'contenttypes', 'contenttype'); 785INSERT INTO django_content_type (id, app_label, model) VALUES (9, 'sessions', 'session'); 786 787 788-- 789-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 790-- 791 792SELECT pg_catalog.setval('django_content_type_id_seq', 9, true); 793 794 795-- 796-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: postgres 797-- 798 799INSERT INTO django_migrations (id, app, name, applied) VALUES (1, 'contenttypes', '0001_initial', '2016-03-07 15:53:25.193162+01'); 800INSERT INTO django_migrations (id, app, name, applied) VALUES (2, 'auth', '0001_initial', '2016-03-07 15:53:25.273474+01'); 801INSERT INTO django_migrations (id, app, name, applied) VALUES (3, 'admin', '0001_initial', '2016-03-07 15:53:25.30131+01'); 802INSERT INTO django_migrations (id, app, name, applied) VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2016-03-07 15:53:25.319456+01'); 803INSERT INTO django_migrations (id, app, name, applied) VALUES (5, 'contenttypes', '0002_remove_content_type_name', '2016-03-07 15:53:25.36513+01'); 804INSERT INTO django_migrations (id, app, name, applied) VALUES (6, 'auth', '0002_alter_permission_name_max_length', '2016-03-07 15:53:25.38065+01'); 805INSERT INTO django_migrations (id, app, name, applied) VALUES (7, 'auth', '0003_alter_user_email_max_length', '2016-03-07 15:53:25.398969+01'); 806INSERT INTO django_migrations (id, app, name, applied) VALUES (8, 'auth', '0004_alter_user_username_opts', '2016-03-07 15:53:25.41613+01'); 807INSERT INTO django_migrations (id, app, name, applied) VALUES (9, 'auth', '0005_alter_user_last_login_null', '2016-03-07 15:53:25.434578+01'); 808INSERT INTO django_migrations (id, app, name, applied) VALUES (10, 'auth', '0006_require_contenttypes_0002', '2016-03-07 15:53:25.437224+01'); 809INSERT INTO django_migrations (id, app, name, applied) VALUES (11, 'auth', '0007_alter_validators_add_error_messages', '2016-03-07 15:53:25.45391+01'); 810INSERT INTO django_migrations (id, app, name, applied) VALUES (12, 'sessions', '0001_initial', '2016-03-07 15:53:25.46445+01'); 811INSERT INTO django_migrations (id, app, name, applied) VALUES (13, 'timetracker', '0001_initial', '2016-03-07 15:53:25.530527+01'); 812INSERT INTO django_migrations (id, app, name, applied) VALUES (14, 'timetracker', '0002_billingperiod', '2016-03-07 15:53:25.560994+01'); 813INSERT INTO django_migrations (id, app, name, applied) VALUES (15, 'timetracker', '0003_local_datetime_fields', '2016-03-07 15:53:25.677892+01'); 814INSERT INTO django_migrations (id, app, name, applied) VALUES (16, 'timetracker', '0004_worklog_billing_period', '2016-03-07 15:53:25.703913+01'); 815INSERT INTO django_migrations (id, app, name, applied) VALUES (17, 'timetracker', '0005_billing_period_identifier_index', '2016-03-07 15:53:25.726466+01'); 816 817 818-- 819-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 820-- 821 822SELECT pg_catalog.setval('django_migrations_id_seq', 17, true); 823 824 825-- 826-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: postgres 827-- 828 829INSERT INTO django_session (session_key, session_data, expire_date) VALUES ('lu5upc331w1hp9t6ofu5xt5asbd4k5mv', 'ODMxNDFiOGMzYTJmNGFkM2ZhZmVkOWEyMmZhMjJmMDgzNTg4ZWJlMTp7Il9hdXRoX3VzZXJfaGFzaCI6ImQxODIzNDYyYWU2ZjNiZmVmOGJkZTFlMmJiYTE3ZDkyOGQ3NDAwMTAiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=', '2016-03-21 15:54:45.280447+01'); 830 831 832-- 833-- Data for Name: timetracker_billingperiod; Type: TABLE DATA; Schema: public; Owner: postgres 834-- 835 836 837 838-- 839-- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 840-- 841 842SELECT pg_catalog.setval('timetracker_billingperiod_id_seq', 1, false); 843 844 845-- 846-- Data for Name: timetracker_project; Type: TABLE DATA; Schema: public; Owner: postgres 847-- 848 849 850 851-- 852-- Name: timetracker_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 853-- 854 855SELECT pg_catalog.setval('timetracker_project_id_seq', 1, false); 856 857 858-- 859-- Data for Name: timetracker_project_members; Type: TABLE DATA; Schema: public; Owner: postgres 860-- 861 862 863 864-- 865-- Name: timetracker_project_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 866-- 867 868SELECT pg_catalog.setval('timetracker_project_members_id_seq', 1, false); 869 870 871-- 872-- Data for Name: timetracker_worklog; Type: TABLE DATA; Schema: public; Owner: postgres 873-- 874 875 876 877-- 878-- Name: timetracker_worklog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres 879-- 880 881SELECT pg_catalog.setval('timetracker_worklog_id_seq', 1, false); 882 883 884-- 885-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres 886-- 887 888ALTER TABLE ONLY auth_group 889 ADD CONSTRAINT auth_group_name_key UNIQUE (name); 890 891 892-- 893-- Name: auth_group_permissions_group_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 894-- 895 896ALTER TABLE ONLY auth_group_permissions 897 ADD CONSTRAINT auth_group_permissions_group_id_0cd325b0_uniq UNIQUE (group_id, permission_id); 898 899 900-- 901-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 902-- 903 904ALTER TABLE ONLY auth_group_permissions 905 ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id); 906 907 908-- 909-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 910-- 911 912ALTER TABLE ONLY auth_group 913 ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id); 914 915 916-- 917-- Name: auth_permission_content_type_id_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 918-- 919 920ALTER TABLE ONLY auth_permission 921 ADD CONSTRAINT auth_permission_content_type_id_01ab375a_uniq UNIQUE (content_type_id, codename); 922 923 924-- 925-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 926-- 927 928ALTER TABLE ONLY auth_permission 929 ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id); 930 931 932-- 933-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 934-- 935 936ALTER TABLE ONLY auth_user_groups 937 ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id); 938 939 940-- 941-- Name: auth_user_groups_user_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 942-- 943 944ALTER TABLE ONLY auth_user_groups 945 ADD CONSTRAINT auth_user_groups_user_id_94350c0c_uniq UNIQUE (user_id, group_id); 946 947 948-- 949-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 950-- 951 952ALTER TABLE ONLY auth_user 953 ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id); 954 955 956-- 957-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 958-- 959 960ALTER TABLE ONLY auth_user_user_permissions 961 ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id); 962 963 964-- 965-- Name: auth_user_user_permissions_user_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 966-- 967 968ALTER TABLE ONLY auth_user_user_permissions 969 ADD CONSTRAINT auth_user_user_permissions_user_id_14a6b632_uniq UNIQUE (user_id, permission_id); 970 971 972-- 973-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres 974-- 975 976ALTER TABLE ONLY auth_user 977 ADD CONSTRAINT auth_user_username_key UNIQUE (username); 978 979 980-- 981-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 982-- 983 984ALTER TABLE ONLY django_admin_log 985 ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id); 986 987 988-- 989-- Name: django_content_type_app_label_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 990-- 991 992ALTER TABLE ONLY django_content_type 993 ADD CONSTRAINT django_content_type_app_label_76bd3d3b_uniq UNIQUE (app_label, model); 994 995 996-- 997-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 998-- 999 1000ALTER TABLE ONLY django_content_type 1001 ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id); 1002 1003 1004-- 1005-- Name: django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1006-- 1007 1008ALTER TABLE ONLY django_migrations 1009 ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id); 1010 1011 1012-- 1013-- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1014-- 1015 1016ALTER TABLE ONLY django_session 1017 ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key); 1018 1019 1020-- 1021-- Name: timetracker_billingperiod_identifier_key; Type: CONSTRAINT; Schema: public; Owner: postgres 1022-- 1023 1024ALTER TABLE ONLY timetracker_billingperiod 1025 ADD CONSTRAINT timetracker_billingperiod_identifier_key UNIQUE (identifier); 1026 1027 1028-- 1029-- Name: timetracker_billingperiod_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1030-- 1031 1032ALTER TABLE ONLY timetracker_billingperiod 1033 ADD CONSTRAINT timetracker_billingperiod_pkey PRIMARY KEY (id); 1034 1035 1036-- 1037-- Name: timetracker_project_members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1038-- 1039 1040ALTER TABLE ONLY timetracker_project_members 1041 ADD CONSTRAINT timetracker_project_members_pkey PRIMARY KEY (id); 1042 1043 1044-- 1045-- Name: timetracker_project_members_project_id_786577ed_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres 1046-- 1047 1048ALTER TABLE ONLY timetracker_project_members 1049 ADD CONSTRAINT timetracker_project_members_project_id_786577ed_uniq UNIQUE (project_id, user_id); 1050 1051 1052-- 1053-- Name: timetracker_project_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres 1054-- 1055 1056ALTER TABLE ONLY timetracker_project 1057 ADD CONSTRAINT timetracker_project_name_key UNIQUE (name); 1058 1059 1060-- 1061-- Name: timetracker_project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1062-- 1063 1064ALTER TABLE ONLY timetracker_project 1065 ADD CONSTRAINT timetracker_project_pkey PRIMARY KEY (id); 1066 1067 1068-- 1069-- Name: timetracker_worklog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 1070-- 1071 1072ALTER TABLE ONLY timetracker_worklog 1073 ADD CONSTRAINT timetracker_worklog_pkey PRIMARY KEY (id); 1074 1075 1076-- 1077-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: postgres 1078-- 1079 1080CREATE INDEX auth_group_name_a6ea08ec_like ON auth_group USING btree (name varchar_pattern_ops); 1081 1082 1083-- 1084-- Name: auth_group_permissions_0e939a4f; Type: INDEX; Schema: public; Owner: postgres 1085-- 1086 1087CREATE INDEX auth_group_permissions_0e939a4f ON auth_group_permissions USING btree (group_id); 1088 1089 1090-- 1091-- Name: auth_group_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres 1092-- 1093 1094CREATE INDEX auth_group_permissions_8373b171 ON auth_group_permissions USING btree (permission_id); 1095 1096 1097-- 1098-- Name: auth_permission_417f1b1c; Type: INDEX; Schema: public; Owner: postgres 1099-- 1100 1101CREATE INDEX auth_permission_417f1b1c ON auth_permission USING btree (content_type_id); 1102 1103 1104-- 1105-- Name: auth_user_groups_0e939a4f; Type: INDEX; Schema: public; Owner: postgres 1106-- 1107 1108CREATE INDEX auth_user_groups_0e939a4f ON auth_user_groups USING btree (group_id); 1109 1110 1111-- 1112-- Name: auth_user_groups_e8701ad4; Type: INDEX; Schema: public; Owner: postgres 1113-- 1114 1115CREATE INDEX auth_user_groups_e8701ad4 ON auth_user_groups USING btree (user_id); 1116 1117 1118-- 1119-- Name: auth_user_user_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres 1120-- 1121 1122CREATE INDEX auth_user_user_permissions_8373b171 ON auth_user_user_permissions USING btree (permission_id); 1123 1124 1125-- 1126-- Name: auth_user_user_permissions_e8701ad4; Type: INDEX; Schema: public; Owner: postgres 1127-- 1128 1129CREATE INDEX auth_user_user_permissions_e8701ad4 ON auth_user_user_permissions USING btree (user_id); 1130 1131 1132-- 1133-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: postgres 1134-- 1135 1136CREATE INDEX auth_user_username_6821ab7c_like ON auth_user USING btree (username varchar_pattern_ops); 1137 1138 1139-- 1140-- Name: django_admin_log_417f1b1c; Type: INDEX; Schema: public; Owner: postgres 1141-- 1142 1143CREATE INDEX django_admin_log_417f1b1c ON django_admin_log USING btree (content_type_id); 1144 1145 1146-- 1147-- Name: django_admin_log_e8701ad4; Type: INDEX; Schema: public; Owner: postgres 1148-- 1149 1150CREATE INDEX django_admin_log_e8701ad4 ON django_admin_log USING btree (user_id); 1151 1152 1153-- 1154-- Name: django_session_de54fa62; Type: INDEX; Schema: public; Owner: postgres 1155-- 1156 1157CREATE INDEX django_session_de54fa62 ON django_session USING btree (expire_date); 1158 1159 1160-- 1161-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: postgres 1162-- 1163 1164CREATE INDEX django_session_session_key_c0390e0f_like ON django_session USING btree (session_key varchar_pattern_ops); 1165 1166 1167-- 1168-- Name: timetracker_billingperiod_b098ad43; Type: INDEX; Schema: public; Owner: postgres 1169-- 1170 1171CREATE INDEX timetracker_billingperiod_b098ad43 ON timetracker_billingperiod USING btree (project_id); 1172 1173 1174-- 1175-- Name: timetracker_billingperiod_identifier_8432361f_like; Type: INDEX; Schema: public; Owner: postgres 1176-- 1177 1178CREATE INDEX timetracker_billingperiod_identifier_8432361f_like ON timetracker_billingperiod USING btree (identifier varchar_pattern_ops); 1179 1180 1181-- 1182-- Name: timetracker_project_members_b098ad43; Type: INDEX; Schema: public; Owner: postgres 1183-- 1184 1185CREATE INDEX timetracker_project_members_b098ad43 ON timetracker_project_members USING btree (project_id); 1186 1187 1188-- 1189-- Name: timetracker_project_members_e8701ad4; Type: INDEX; Schema: public; Owner: postgres 1190-- 1191 1192CREATE INDEX timetracker_project_members_e8701ad4 ON timetracker_project_members USING btree (user_id); 1193 1194 1195-- 1196-- Name: timetracker_project_name_daf0136a_like; Type: INDEX; Schema: public; Owner: postgres 1197-- 1198 1199CREATE INDEX timetracker_project_name_daf0136a_like ON timetracker_project USING btree (name varchar_pattern_ops); 1200 1201 1202-- 1203-- Name: timetracker_worklog_3c1a7956; Type: INDEX; Schema: public; Owner: postgres 1204-- 1205 1206CREATE INDEX timetracker_worklog_3c1a7956 ON timetracker_worklog USING btree (billing_period_id); 1207 1208 1209-- 1210-- Name: timetracker_worklog_b098ad43; Type: INDEX; Schema: public; Owner: postgres 1211-- 1212 1213CREATE INDEX timetracker_worklog_b098ad43 ON timetracker_worklog USING btree (project_id); 1214 1215 1216-- 1217-- Name: timetracker_worklog_e8701ad4; Type: INDEX; Schema: public; Owner: postgres 1218-- 1219 1220CREATE INDEX timetracker_worklog_e8701ad4 ON timetracker_worklog USING btree (user_id); 1221 1222 1223-- 1224-- Name: auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1225-- 1226 1227ALTER TABLE ONLY auth_group_permissions 1228 ADD CONSTRAINT auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; 1229 1230 1231-- 1232-- Name: auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1233-- 1234 1235ALTER TABLE ONLY auth_group_permissions 1236 ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; 1237 1238 1239-- 1240-- Name: auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1241-- 1242 1243ALTER TABLE ONLY auth_permission 1244 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; 1245 1246 1247-- 1248-- Name: auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1249-- 1250 1251ALTER TABLE ONLY auth_user_groups 1252 ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; 1253 1254 1255-- 1256-- Name: auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1257-- 1258 1259ALTER TABLE ONLY auth_user_groups 1260 ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; 1261 1262 1263-- 1264-- Name: auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1265-- 1266 1267ALTER TABLE ONLY auth_user_user_permissions 1268 ADD CONSTRAINT auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; 1269 1270 1271-- 1272-- Name: auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1273-- 1274 1275ALTER TABLE ONLY auth_user_user_permissions 1276 ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; 1277 1278 1279-- 1280-- Name: django_admin_content_type_id_c4bce8eb_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1281-- 1282 1283ALTER TABLE ONLY django_admin_log 1284 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; 1285 1286 1287-- 1288-- Name: django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1289-- 1290 1291ALTER TABLE ONLY django_admin_log 1292 ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; 1293 1294 1295-- 1296-- Name: time_billing_period_id_c4b944d1_fk_timetracker_billingperiod_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1297-- 1298 1299ALTER TABLE ONLY timetracker_worklog 1300 ADD CONSTRAINT time_billing_period_id_c4b944d1_fk_timetracker_billingperiod_id FOREIGN KEY (billing_period_id) REFERENCES timetracker_billingperiod(id) DEFERRABLE INITIALLY DEFERRED; 1301 1302 1303-- 1304-- Name: timetracker_billi_project_id_8dd7b2e2_fk_timetracker_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1305-- 1306 1307ALTER TABLE ONLY timetracker_billingperiod 1308 ADD CONSTRAINT timetracker_billi_project_id_8dd7b2e2_fk_timetracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALLY DEFERRED; 1309 1310 1311-- 1312-- Name: timetracker_proje_project_id_85632ed8_fk_timetracker_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1313-- 1314 1315ALTER TABLE ONLY timetracker_project_members 1316 ADD CONSTRAINT timetracker_proje_project_id_85632ed8_fk_timetracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALLY DEFERRED; 1317 1318 1319-- 1320-- Name: timetracker_project_members_user_id_62b48c3e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1321-- 1322 1323ALTER TABLE ONLY timetracker_project_members 1324 ADD CONSTRAINT timetracker_project_members_user_id_62b48c3e_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; 1325 1326 1327-- 1328-- Name: timetracker_workl_project_id_69fa76d5_fk_timetracker_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1329-- 1330 1331ALTER TABLE ONLY timetracker_worklog 1332 ADD CONSTRAINT timetracker_workl_project_id_69fa76d5_fk_timetracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALLY DEFERRED; 1333 1334 1335-- 1336-- Name: timetracker_worklog_user_id_c74c8c68_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres 1337-- 1338 1339ALTER TABLE ONLY timetracker_worklog 1340 ADD CONSTRAINT timetracker_worklog_user_id_c74c8c68_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; 1341 1342 1343-- 1344-- Name: public; Type: ACL; Schema: -; Owner: postgres 1345-- 1346 1347REVOKE ALL ON SCHEMA public FROM PUBLIC; 1348REVOKE ALL ON SCHEMA public FROM postgres; 1349GRANT ALL ON SCHEMA public TO postgres; 1350GRANT ALL ON SCHEMA public TO PUBLIC; 1351 1352 1353-- 1354-- PostgreSQL database dump complete 1355-- 1356 1357