Lines Matching refs:id
39 id integer NOT NULL, field
64 ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;
72 id integer NOT NULL, field
98 ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;
106 id integer NOT NULL, field
133 ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;
141 id integer NOT NULL, field
162 id integer NOT NULL, field
188 ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;
209 ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;
217 id integer NOT NULL, field
243 ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;
251 id integer NOT NULL, field
283 ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;
291 id integer NOT NULL, field
317 ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;
325 id integer NOT NULL, field
352 ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;
373 id integer NOT NULL, field
402 ALTER SEQUENCE timetracker_billingperiod_id_seq OWNED BY timetracker_billingperiod.id;
410 id integer NOT NULL, field
439 ALTER SEQUENCE timetracker_project_id_seq OWNED BY timetracker_project.id;
447 id integer NOT NULL, field
473 ALTER SEQUENCE timetracker_project_members_id_seq OWNED BY timetracker_project_members.id;
481 id integer NOT NULL, field
512 ALTER SEQUENCE timetracker_worklog_id_seq OWNED BY timetracker_worklog.id;
519 ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);
526 ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions…
533 ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regc…
540 ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);
547 ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::re…
554 ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_per…
561 ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::re…
568 ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_se…
575 ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::…
582 ALTER TABLE ONLY timetracker_billingperiod ALTER COLUMN id SET DEFAULT nextval('timetracker_billing…
589 ALTER TABLE ONLY timetracker_project ALTER COLUMN id SET DEFAULT nextval('timetracker_project_id_se…
596 ALTER TABLE ONLY timetracker_project_members ALTER COLUMN id SET DEFAULT nextval('timetracker_proje…
603 ALTER TABLE ONLY timetracker_worklog ALTER COLUMN id SET DEFAULT nextval('timetracker_worklog_id_se…
610 INSERT INTO auth_group (id, name) VALUES (2, 'Kunden');
611 INSERT INTO auth_group (id, name) VALUES (3, 'Projektleiter');
612 INSERT INTO auth_group (id, name) VALUES (1, 'Mitarbeiter');
613 INSERT INTO auth_group (id, name) VALUES (4, 'Billing');
627 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (1, 4, 8);
628 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (2, 4, 7);
629 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (3, 3, 1);
630 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (4, 3, 2);
631 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (5, 3, 3);
632 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (6, 3, 4);
633 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (7, 3, 5);
634 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (8, 3, 6);
635 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (9, 1, 4);
636 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (10, 1, 5);
637 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (11, 1, 6);
638 INSERT INTO auth_group_permissions (id, group_id, permission_id) VALUES (12, 4, 9);
652 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (1, 'Can add project', 1, …
653 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (2, 'Can change project', …
654 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (3, 'Can delete project', …
655 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (4, 'Can add work log', 2,…
656 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (5, 'Can change work log',…
657 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (6, 'Can delete work log',…
658 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (7, 'Can add billing perio…
659 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (8, 'Can change billing pe…
660 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (9, 'Can delete billing pe…
661 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (10, 'Can add log entry', …
662 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (11, 'Can change log entry…
663 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (12, 'Can delete log entry…
664 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (13, 'Can add permission',…
665 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (14, 'Can change permissio…
666 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (15, 'Can delete permissio…
667 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (16, 'Can add group', 6, '…
668 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (17, 'Can change group', 6…
669 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (18, 'Can delete group', 6…
670 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (19, 'Can add user', 7, 'a…
671 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (20, 'Can change user', 7,…
672 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (21, 'Can delete user', 7,…
673 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (22, 'Can add content type…
674 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (23, 'Can change content t…
675 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (24, 'Can delete content t…
676 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (25, 'Can add session', 9,…
677 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (26, 'Can change session',…
678 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (27, 'Can delete session',…
692 INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, ema…
693 INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, ema…
694 INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, ema…
695 INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, ema…
696 INSERT INTO auth_user (id, password, last_login, is_superuser, username, first_name, last_name, ema…
703 INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (1, 2, 1);
704 INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (2, 3, 2);
705 INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (3, 4, 3);
706 INSERT INTO auth_user_groups (id, user_id, group_id) VALUES (4, 5, 4);
727 INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (1, 4, 19);
728 INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (2, 4, 20);
729 INSERT INTO auth_user_user_permissions (id, user_id, permission_id) VALUES (3, 4, 21);
743 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
744 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
745 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
746 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
747 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
748 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
749 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
750 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
751 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
752 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
753 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
754 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
755 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
756 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
757 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
758 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
759 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
760 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
761 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
762 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
763 INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message,…
777 INSERT INTO django_content_type (id, app_label, model) VALUES (1, 'timetracker', 'project');
778 INSERT INTO django_content_type (id, app_label, model) VALUES (2, 'timetracker', 'worklog');
779 INSERT INTO django_content_type (id, app_label, model) VALUES (3, 'timetracker', 'billingperiod');
780 INSERT INTO django_content_type (id, app_label, model) VALUES (4, 'admin', 'logentry');
781 INSERT INTO django_content_type (id, app_label, model) VALUES (5, 'auth', 'permission');
782 INSERT INTO django_content_type (id, app_label, model) VALUES (6, 'auth', 'group');
783 INSERT INTO django_content_type (id, app_label, model) VALUES (7, 'auth', 'user');
784 INSERT INTO django_content_type (id, app_label, model) VALUES (8, 'contenttypes', 'contenttype');
785 INSERT INTO django_content_type (id, app_label, model) VALUES (9, 'sessions', 'session');
799 INSERT INTO django_migrations (id, app, name, applied) VALUES (1, 'contenttypes', '0001_initial', '…
800 INSERT INTO django_migrations (id, app, name, applied) VALUES (2, 'auth', '0001_initial', '2016-03-…
801 INSERT INTO django_migrations (id, app, name, applied) VALUES (3, 'admin', '0001_initial', '2016-03…
802 INSERT INTO django_migrations (id, app, name, applied) VALUES (4, 'admin', '0002_logentry_remove_au…
803 INSERT INTO django_migrations (id, app, name, applied) VALUES (5, 'contenttypes', '0002_remove_cont…
804 INSERT INTO django_migrations (id, app, name, applied) VALUES (6, 'auth', '0002_alter_permission_na…
805 INSERT INTO django_migrations (id, app, name, applied) VALUES (7, 'auth', '0003_alter_user_email_ma…
806 INSERT INTO django_migrations (id, app, name, applied) VALUES (8, 'auth', '0004_alter_user_username…
807 INSERT INTO django_migrations (id, app, name, applied) VALUES (9, 'auth', '0005_alter_user_last_log…
808 INSERT INTO django_migrations (id, app, name, applied) VALUES (10, 'auth', '0006_require_contenttyp…
809 INSERT INTO django_migrations (id, app, name, applied) VALUES (11, 'auth', '0007_alter_validators_a…
810 INSERT INTO django_migrations (id, app, name, applied) VALUES (12, 'sessions', '0001_initial', '201…
811 INSERT INTO django_migrations (id, app, name, applied) VALUES (13, 'timetracker', '0001_initial', '…
812 INSERT INTO django_migrations (id, app, name, applied) VALUES (14, 'timetracker', '0002_billingperi…
813 INSERT INTO django_migrations (id, app, name, applied) VALUES (15, 'timetracker', '0003_local_datet…
814 INSERT INTO django_migrations (id, app, name, applied) VALUES (16, 'timetracker', '0004_worklog_bil…
815 INSERT INTO django_migrations (id, app, name, applied) VALUES (17, 'timetracker', '0005_billing_per…
905 ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
913 ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
929 ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
937 ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);
953 ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
961 ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);
985 ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);
1001 ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
1009 ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);
1033 ADD CONSTRAINT timetracker_billingperiod_pkey PRIMARY KEY (id);
1041 ADD CONSTRAINT timetracker_project_members_pkey PRIMARY KEY (id);
1065 ADD CONSTRAINT timetracker_project_pkey PRIMARY KEY (id);
1073 ADD CONSTRAINT timetracker_worklog_pkey PRIMARY KEY (id);
1228 …_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALL…
1236 …_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALL…
1244 …ntent_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALL…
1252 …_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALL…
1260 …ser_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALL…
1268 …_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALL…
1276 …ser_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALL…
1284 …ntent_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALL…
1292 …ser_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALL…
1300 …od_id FOREIGN KEY (billing_period_id) REFERENCES timetracker_billingperiod(id) DEFERRABLE INITIALL…
1308 …tracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALL…
1316 …tracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALL…
1324 …ser_id_62b48c3e_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALL…
1332 …tracker_project_id FOREIGN KEY (project_id) REFERENCES timetracker_project(id) DEFERRABLE INITIALL…
1340 …ser_id_c74c8c68_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALL…