yJX9Werk

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.5.10
6-- Dumped by pg_dump version 9.5.10
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14SET row_security = off;
15
16--
17-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
18--
19
20CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21
22
23--
24-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
25--
26
27COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
28
29
30SET search_path = public, pg_catalog;
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: armchairs; Type: TABLE; Schema: public; Owner: postgres
38--
39
40CREATE TABLE armchairs (
41    id integer NOT NULL,
42    name text NOT NULL,
43    price bigint NOT NULL
44);
45
46
47ALTER TABLE armchairs OWNER TO postgres;
48
49--
50-- Name: armchairs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
51--
52
53CREATE SEQUENCE armchairs_id_seq
54    START WITH 1
55    INCREMENT BY 1
56    NO MINVALUE
57    NO MAXVALUE
58    CACHE 1;
59
60
61ALTER TABLE armchairs_id_seq OWNER TO postgres;
62
63--
64-- Name: armchairs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
65--
66
67ALTER SEQUENCE armchairs_id_seq OWNED BY armchairs.id;
68
69
70--
71-- Name: armrests; Type: TABLE; Schema: public; Owner: postgres
72--
73
74CREATE TABLE armrests (
75    id integer NOT NULL,
76    name text,
77    price bigint
78);
79
80
81ALTER TABLE armrests OWNER TO postgres;
82
83--
84-- Name: armrests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
85--
86
87CREATE SEQUENCE armrests_id_seq
88    START WITH 1
89    INCREMENT BY 1
90    NO MINVALUE
91    NO MAXVALUE
92    CACHE 1;
93
94
95ALTER TABLE armrests_id_seq OWNER TO postgres;
96
97--
98-- Name: armrests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
99--
100
101ALTER SEQUENCE armrests_id_seq OWNED BY armrests.id;
102
103
104--
105-- Name: car_clothes_combinations; Type: TABLE; Schema: public; Owner: postgres
106--
107
108CREATE TABLE car_clothes_combinations (
109    id integer NOT NULL,
110    name text NOT NULL,
111    percent_multiplier bigint NOT NULL
112);
113
114
115ALTER TABLE car_clothes_combinations OWNER TO postgres;
116
117--
118-- Name: car_clothes_combinations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
119--
120
121CREATE SEQUENCE car_clothes_combinations_id_seq
122    START WITH 1
123    INCREMENT BY 1
124    NO MINVALUE
125    NO MAXVALUE
126    CACHE 1;
127
128
129ALTER TABLE car_clothes_combinations_id_seq OWNER TO postgres;
130
131--
132-- Name: car_clothes_combinations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
133--
134
135ALTER SEQUENCE car_clothes_combinations_id_seq OWNED BY car_clothes_combinations.id;
136
137
138--
139-- Name: car_covers_installations; Type: TABLE; Schema: public; Owner: postgres
140--
141
142CREATE TABLE car_covers_installations (
143    id integer NOT NULL,
144    name text,
145    price bigint
146);
147
148
149ALTER TABLE car_covers_installations OWNER TO postgres;
150
151--
152-- Name: car_cover_installation_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
153--
154
155CREATE SEQUENCE car_cover_installation_id_seq
156    START WITH 1
157    INCREMENT BY 1
158    NO MINVALUE
159    NO MAXVALUE
160    CACHE 1;
161
162
163ALTER TABLE car_cover_installation_id_seq OWNER TO postgres;
164
165--
166-- Name: car_cover_installation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
167--
168
169ALTER SEQUENCE car_cover_installation_id_seq OWNED BY car_covers_installations.id;
170
171
172--
173-- Name: car_pillows; Type: TABLE; Schema: public; Owner: postgres
174--
175
176CREATE TABLE car_pillows (
177    id integer NOT NULL,
178    name text,
179    price bigint
180);
181
182
183ALTER TABLE car_pillows OWNER TO postgres;
184
185--
186-- Name: car_pillows_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
187--
188
189CREATE SEQUENCE car_pillows_id_seq
190    START WITH 1
191    INCREMENT BY 1
192    NO MINVALUE
193    NO MAXVALUE
194    CACHE 1;
195
196
197ALTER TABLE car_pillows_id_seq OWNER TO postgres;
198
199--
200-- Name: car_pillows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
201--
202
203ALTER SEQUENCE car_pillows_id_seq OWNED BY car_pillows.id;
204
205
206--
207-- Name: car_pockets; Type: TABLE; Schema: public; Owner: postgres
208--
209
210CREATE TABLE car_pockets (
211    id integer NOT NULL,
212    name text,
213    price bigint
214);
215
216
217ALTER TABLE car_pockets OWNER TO postgres;
218
219--
220-- Name: car_pockets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
221--
222
223CREATE SEQUENCE car_pockets_id_seq
224    START WITH 1
225    INCREMENT BY 1
226    NO MINVALUE
227    NO MAXVALUE
228    CACHE 1;
229
230
231ALTER TABLE car_pockets_id_seq OWNER TO postgres;
232
233--
234-- Name: car_pockets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
235--
236
237ALTER SEQUENCE car_pockets_id_seq OWNED BY car_pockets.id;
238
239
240--
241-- Name: car_quilting_inserts; Type: TABLE; Schema: public; Owner: postgres
242--
243
244CREATE TABLE car_quilting_inserts (
245    id integer NOT NULL,
246    name text,
247    price bigint
248);
249
250
251ALTER TABLE car_quilting_inserts OWNER TO postgres;
252
253--
254-- Name: car_quilting_inserts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
255--
256
257CREATE SEQUENCE car_quilting_inserts_id_seq
258    START WITH 1
259    INCREMENT BY 1
260    NO MINVALUE
261    NO MAXVALUE
262    CACHE 1;
263
264
265ALTER TABLE car_quilting_inserts_id_seq OWNER TO postgres;
266
267--
268-- Name: car_quilting_inserts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
269--
270
271ALTER SEQUENCE car_quilting_inserts_id_seq OWNED BY car_quilting_inserts.id;
272
273
274--
275-- Name: cars; Type: TABLE; Schema: public; Owner: root
276--
277
278CREATE TABLE cars (
279    id integer NOT NULL,
280    manufacturer text NOT NULL,
281    model text NOT NULL,
282    body text,
283    release_years text,
284    comment text,
285    pattern boolean NOT NULL,
286    scheme text,
287    showing_data text
288);
289
290
291ALTER TABLE cars OWNER TO root;
292
293--
294-- Name: cars_id_seq; Type: SEQUENCE; Schema: public; Owner: root
295--
296
297CREATE SEQUENCE cars_id_seq
298    START WITH 1
299    INCREMENT BY 1
300    NO MINVALUE
301    NO MAXVALUE
302    CACHE 1;
303
304
305ALTER TABLE cars_id_seq OWNER TO root;
306
307--
308-- Name: cars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
309--
310
311ALTER SEQUENCE cars_id_seq OWNED BY cars.id;
312
313
314--
315-- Name: clients; Type: TABLE; Schema: public; Owner: root
316--
317
318CREATE TABLE clients (
319    id integer NOT NULL,
320    name text NOT NULL,
321    phone_number bigint NOT NULL,
322    city text NOT NULL,
323    contact_person_1 text,
324    contact_person_1_phone_number bigint,
325    contact_person_2 text,
326    contact_person_2_phone_number bigint,
327    comment text
328);
329
330
331ALTER TABLE clients OWNER TO root;
332
333--
334-- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: root
335--
336
337CREATE SEQUENCE clients_id_seq
338    START WITH 1
339    INCREMENT BY 1
340    NO MINVALUE
341    NO MAXVALUE
342    CACHE 1;
343
344
345ALTER TABLE clients_id_seq OWNER TO root;
346
347--
348-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
349--
350
351ALTER SEQUENCE clients_id_seq OWNED BY clients.id;
352
353
354--
355-- Name: data_rows; Type: TABLE; Schema: public; Owner: root
356--
357
358CREATE TABLE data_rows (
359    id integer NOT NULL,
360    data_type_id integer NOT NULL,
361    field character varying(255) NOT NULL,
362    type character varying(255) NOT NULL,
363    display_name character varying(255) NOT NULL,
364    required boolean DEFAULT false NOT NULL,
365    browse boolean DEFAULT true NOT NULL,
366    read boolean DEFAULT true NOT NULL,
367    edit boolean DEFAULT true NOT NULL,
368    add boolean DEFAULT true NOT NULL,
369    delete boolean DEFAULT true NOT NULL,
370    details text,
371    "order" integer DEFAULT 1 NOT NULL
372);
373
374
375ALTER TABLE data_rows OWNER TO root;
376
377--
378-- Name: data_rows_id_seq; Type: SEQUENCE; Schema: public; Owner: root
379--
380
381CREATE SEQUENCE data_rows_id_seq
382    START WITH 1
383    INCREMENT BY 1
384    NO MINVALUE
385    NO MAXVALUE
386    CACHE 1;
387
388
389ALTER TABLE data_rows_id_seq OWNER TO root;
390
391--
392-- Name: data_rows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
393--
394
395ALTER SEQUENCE data_rows_id_seq OWNED BY data_rows.id;
396
397
398--
399-- Name: data_types; Type: TABLE; Schema: public; Owner: root
400--
401
402CREATE TABLE data_types (
403    id integer NOT NULL,
404    name character varying(255) NOT NULL,
405    slug character varying(255) NOT NULL,
406    display_name_singular character varying(255) NOT NULL,
407    display_name_plural character varying(255) NOT NULL,
408    icon character varying(255),
409    model_name character varying(255),
410    description character varying(255),
411    generate_permissions boolean DEFAULT false NOT NULL,
412    created_at timestamp(0) without time zone,
413    updated_at timestamp(0) without time zone,
414    server_side smallint DEFAULT '0'::smallint NOT NULL,
415    controller character varying(255),
416    policy_name character varying(255)
417);
418
419
420ALTER TABLE data_types OWNER TO root;
421
422--
423-- Name: data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: root
424--
425
426CREATE SEQUENCE data_types_id_seq
427    START WITH 1
428    INCREMENT BY 1
429    NO MINVALUE
430    NO MAXVALUE
431    CACHE 1;
432
433
434ALTER TABLE data_types_id_seq OWNER TO root;
435
436--
437-- Name: data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
438--
439
440ALTER SEQUENCE data_types_id_seq OWNED BY data_types.id;
441
442
443--
444-- Name: headrests; Type: TABLE; Schema: public; Owner: postgres
445--
446
447CREATE TABLE headrests (
448    id integer NOT NULL,
449    name text,
450    price bigint
451);
452
453
454ALTER TABLE headrests OWNER TO postgres;
455
456--
457-- Name: headrests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
458--
459
460CREATE SEQUENCE headrests_id_seq
461    START WITH 1
462    INCREMENT BY 1
463    NO MINVALUE
464    NO MAXVALUE
465    CACHE 1;
466
467
468ALTER TABLE headrests_id_seq OWNER TO postgres;
469
470--
471-- Name: headrests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
472--
473
474ALTER SEQUENCE headrests_id_seq OWNED BY headrests.id;
475
476
477--
478-- Name: materials; Type: TABLE; Schema: public; Owner: root
479--
480
481CREATE TABLE materials (
482    id integer NOT NULL,
483    name text NOT NULL,
484    price bigint,
485    count bigint
486);
487
488
489ALTER TABLE materials OWNER TO root;
490
491--
492-- Name: materials_arrivals; Type: TABLE; Schema: public; Owner: root
493--
494
495CREATE TABLE materials_arrivals (
496    id integer NOT NULL,
497    material_id integer NOT NULL,
498    count bigint NOT NULL,
499    created_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
500    updated_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
501);
502
503
504ALTER TABLE materials_arrivals OWNER TO root;
505
506--
507-- Name: materials_arrival_id_seq; Type: SEQUENCE; Schema: public; Owner: root
508--
509
510CREATE SEQUENCE materials_arrival_id_seq
511    START WITH 1
512    INCREMENT BY 1
513    NO MINVALUE
514    NO MAXVALUE
515    CACHE 1;
516
517
518ALTER TABLE materials_arrival_id_seq OWNER TO root;
519
520--
521-- Name: materials_arrival_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
522--
523
524ALTER SEQUENCE materials_arrival_id_seq OWNED BY materials_arrivals.id;
525
526
527--
528-- Name: materials_id_seq; Type: SEQUENCE; Schema: public; Owner: root
529--
530
531CREATE SEQUENCE materials_id_seq
532    START WITH 1
533    INCREMENT BY 1
534    NO MINVALUE
535    NO MAXVALUE
536    CACHE 1;
537
538
539ALTER TABLE materials_id_seq OWNER TO root;
540
541--
542-- Name: materials_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
543--
544
545ALTER SEQUENCE materials_id_seq OWNED BY materials.id;
546
547
548--
549-- Name: menu_items; Type: TABLE; Schema: public; Owner: root
550--
551
552CREATE TABLE menu_items (
553    id integer NOT NULL,
554    menu_id integer,
555    title character varying(255) NOT NULL,
556    url character varying(255) NOT NULL,
557    target character varying(255) DEFAULT '_self'::character varying NOT NULL,
558    icon_class character varying(255),
559    color character varying(255),
560    parent_id integer,
561    "order" integer NOT NULL,
562    created_at timestamp(0) without time zone,
563    updated_at timestamp(0) without time zone,
564    route character varying(255),
565    parameters text
566);
567
568
569ALTER TABLE menu_items OWNER TO root;
570
571--
572-- Name: menu_items_id_seq; Type: SEQUENCE; Schema: public; Owner: root
573--
574
575CREATE SEQUENCE menu_items_id_seq
576    START WITH 1
577    INCREMENT BY 1
578    NO MINVALUE
579    NO MAXVALUE
580    CACHE 1;
581
582
583ALTER TABLE menu_items_id_seq OWNER TO root;
584
585--
586-- Name: menu_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
587--
588
589ALTER SEQUENCE menu_items_id_seq OWNED BY menu_items.id;
590
591
592--
593-- Name: menus; Type: TABLE; Schema: public; Owner: root
594--
595
596CREATE TABLE menus (
597    id integer NOT NULL,
598    name character varying(255) NOT NULL,
599    created_at timestamp(0) without time zone,
600    updated_at timestamp(0) without time zone
601);
602
603
604ALTER TABLE menus OWNER TO root;
605
606--
607-- Name: menus_id_seq; Type: SEQUENCE; Schema: public; Owner: root
608--
609
610CREATE SEQUENCE menus_id_seq
611    START WITH 1
612    INCREMENT BY 1
613    NO MINVALUE
614    NO MAXVALUE
615    CACHE 1;
616
617
618ALTER TABLE menus_id_seq OWNER TO root;
619
620--
621-- Name: menus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
622--
623
624ALTER SEQUENCE menus_id_seq OWNED BY menus.id;
625
626
627--
628-- Name: migrations; Type: TABLE; Schema: public; Owner: root
629--
630
631CREATE TABLE migrations (
632    id integer NOT NULL,
633    migration character varying(255) NOT NULL,
634    batch integer NOT NULL
635);
636
637
638ALTER TABLE migrations OWNER TO root;
639
640--
641-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: root
642--
643
644CREATE SEQUENCE migrations_id_seq
645    START WITH 1
646    INCREMENT BY 1
647    NO MINVALUE
648    NO MAXVALUE
649    CACHE 1;
650
651
652ALTER TABLE migrations_id_seq OWNER TO root;
653
654--
655-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
656--
657
658ALTER SEQUENCE migrations_id_seq OWNED BY migrations.id;
659
660
661--
662-- Name: orders; Type: TABLE; Schema: public; Owner: root
663--
664
665CREATE TABLE orders (
666    id integer NOT NULL,
667    client_id bigint NOT NULL,
668    master_id bigint NOT NULL,
669    car_id bigint NOT NULL,
670    description text NOT NULL,
671    issue_date date NOT NULL,
672    created_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
673    updated_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
674    armchairs_id bigint,
675    armchairs_count bigint,
676    car_pockets_id integer,
677    car_pockets_count bigint,
678    car_quilting_inserts_id bigint,
679    car_quilting_inserts_count bigint,
680    car_covers_installations_id bigint,
681    car_covers_installations_count bigint,
682    sofas_first_id bigint,
683    sofas_first_count bigint,
684    sofas_second_id bigint,
685    sofas_second_count bigint,
686    sofas_third_id bigint,
687    sofas_third_count bigint,
688    car_pillows_id bigint,
689    car_pillows_count bigint,
690    headrests_id bigint,
691    headrests_count bigint,
692    car_clothes_combinations_id bigint,
693    car_clothes_combinations_count bigint,
694    armrests_id bigint,
695    armrests_count bigint,
696    basic_fabric_id bigint,
697    basic_fabric_count bigint,
698    inserting_fabric_id bigint,
699    inserting_fabric_count bigint,
700    fragments_fabric_id bigint,
701    fragments_fabric_count bigint,
702    door_panels_fabric_id bigint,
703    door_panels_fabric_count bigint,
704    pillows_fabric_id bigint,
705    pillows_fabric_count bigint,
706    fittings_id bigint,
707    fittings_count bigint,
708    first_additional_material_id bigint,
709    first_additional_material_count bigint,
710    second_additional_material_id bigint,
711    second_additional_material_count bigint,
712    third_additional_material_id bigint,
713    third_additional_material_count bigint,
714    total_price real
715);
716
717
718ALTER TABLE orders OWNER TO root;
719
720--
721-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: root
722--
723
724CREATE SEQUENCE orders_id_seq
725    START WITH 1
726    INCREMENT BY 1
727    NO MINVALUE
728    NO MAXVALUE
729    CACHE 1;
730
731
732ALTER TABLE orders_id_seq OWNER TO root;
733
734--
735-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
736--
737
738ALTER SEQUENCE orders_id_seq OWNED BY orders.id;
739
740
741--
742-- Name: password_resets; Type: TABLE; Schema: public; Owner: root
743--
744
745CREATE TABLE password_resets (
746    email character varying(255) NOT NULL,
747    token character varying(255) NOT NULL,
748    created_at timestamp(0) without time zone
749);
750
751
752ALTER TABLE password_resets OWNER TO root;
753
754--
755-- Name: permission_groups; Type: TABLE; Schema: public; Owner: root
756--
757
758CREATE TABLE permission_groups (
759    id integer NOT NULL,
760    name character varying(255) NOT NULL
761);
762
763
764ALTER TABLE permission_groups OWNER TO root;
765
766--
767-- Name: permission_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: root
768--
769
770CREATE SEQUENCE permission_groups_id_seq
771    START WITH 1
772    INCREMENT BY 1
773    NO MINVALUE
774    NO MAXVALUE
775    CACHE 1;
776
777
778ALTER TABLE permission_groups_id_seq OWNER TO root;
779
780--
781-- Name: permission_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
782--
783
784ALTER SEQUENCE permission_groups_id_seq OWNED BY permission_groups.id;
785
786
787--
788-- Name: permission_role; Type: TABLE; Schema: public; Owner: root
789--
790
791CREATE TABLE permission_role (
792    permission_id integer NOT NULL,
793    role_id integer NOT NULL
794);
795
796
797ALTER TABLE permission_role OWNER TO root;
798
799--
800-- Name: permissions; Type: TABLE; Schema: public; Owner: root
801--
802
803CREATE TABLE permissions (
804    id integer NOT NULL,
805    key character varying(255) NOT NULL,
806    table_name character varying(255),
807    created_at timestamp(0) without time zone,
808    updated_at timestamp(0) without time zone,
809    permission_group_id integer
810);
811
812
813ALTER TABLE permissions OWNER TO root;
814
815--
816-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: root
817--
818
819CREATE SEQUENCE permissions_id_seq
820    START WITH 1
821    INCREMENT BY 1
822    NO MINVALUE
823    NO MAXVALUE
824    CACHE 1;
825
826
827ALTER TABLE permissions_id_seq OWNER TO root;
828
829--
830-- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
831--
832
833ALTER SEQUENCE permissions_id_seq OWNED BY permissions.id;
834
835
836--
837-- Name: roles; Type: TABLE; Schema: public; Owner: root
838--
839
840CREATE TABLE roles (
841    id integer NOT NULL,
842    name character varying(255) NOT NULL,
843    display_name character varying(255) NOT NULL,
844    created_at timestamp(0) without time zone,
845    updated_at timestamp(0) without time zone
846);
847
848
849ALTER TABLE roles OWNER TO root;
850
851--
852-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: root
853--
854
855CREATE SEQUENCE roles_id_seq
856    START WITH 1
857    INCREMENT BY 1
858    NO MINVALUE
859    NO MAXVALUE
860    CACHE 1;
861
862
863ALTER TABLE roles_id_seq OWNER TO root;
864
865--
866-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
867--
868
869ALTER SEQUENCE roles_id_seq OWNED BY roles.id;
870
871
872--
873-- Name: salaries; Type: TABLE; Schema: public; Owner: postgres
874--
875
876CREATE TABLE salaries (
877    id integer NOT NULL,
878    user_id bigint,
879    date date NOT NULL,
880    salary_amount real NOT NULL
881);
882
883
884ALTER TABLE salaries OWNER TO postgres;
885
886--
887-- Name: salaries_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
888--
889
890CREATE SEQUENCE salaries_id_seq
891    START WITH 1
892    INCREMENT BY 1
893    NO MINVALUE
894    NO MAXVALUE
895    CACHE 1;
896
897
898ALTER TABLE salaries_id_seq OWNER TO postgres;
899
900--
901-- Name: salaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
902--
903
904ALTER SEQUENCE salaries_id_seq OWNED BY salaries.id;
905
906
907--
908-- Name: settings; Type: TABLE; Schema: public; Owner: root
909--
910
911CREATE TABLE settings (
912    id integer NOT NULL,
913    key character varying(255) NOT NULL,
914    display_name character varying(255) NOT NULL,
915    value text NOT NULL,
916    details text,
917    type character varying(255) NOT NULL,
918    "order" integer DEFAULT 1 NOT NULL,
919    "group" character varying(255)
920);
921
922
923ALTER TABLE settings OWNER TO root;
924
925--
926-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: root
927--
928
929CREATE SEQUENCE settings_id_seq
930    START WITH 1
931    INCREMENT BY 1
932    NO MINVALUE
933    NO MAXVALUE
934    CACHE 1;
935
936
937ALTER TABLE settings_id_seq OWNER TO root;
938
939--
940-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
941--
942
943ALTER SEQUENCE settings_id_seq OWNED BY settings.id;
944
945
946--
947-- Name: sofas; Type: TABLE; Schema: public; Owner: postgres
948--
949
950CREATE TABLE sofas (
951    id integer NOT NULL,
952    name text,
953    price bigint
954);
955
956
957ALTER TABLE sofas OWNER TO postgres;
958
959--
960-- Name: sofas_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
961--
962
963CREATE SEQUENCE sofas_id_seq
964    START WITH 1
965    INCREMENT BY 1
966    NO MINVALUE
967    NO MAXVALUE
968    CACHE 1;
969
970
971ALTER TABLE sofas_id_seq OWNER TO postgres;
972
973--
974-- Name: sofas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
975--
976
977ALTER SEQUENCE sofas_id_seq OWNED BY sofas.id;
978
979
980--
981-- Name: translations; Type: TABLE; Schema: public; Owner: root
982--
983
984CREATE TABLE translations (
985    id integer NOT NULL,
986    table_name character varying(255) NOT NULL,
987    column_name character varying(255) NOT NULL,
988    foreign_key integer NOT NULL,
989    locale character varying(255) NOT NULL,
990    value text NOT NULL,
991    created_at timestamp(0) without time zone,
992    updated_at timestamp(0) without time zone
993);
994
995
996ALTER TABLE translations OWNER TO root;
997
998--
999-- Name: translations_id_seq; Type: SEQUENCE; Schema: public; Owner: root
1000--
1001
1002CREATE SEQUENCE translations_id_seq
1003    START WITH 1
1004    INCREMENT BY 1
1005    NO MINVALUE
1006    NO MAXVALUE
1007    CACHE 1;
1008
1009
1010ALTER TABLE translations_id_seq OWNER TO root;
1011
1012--
1013-- Name: translations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
1014--
1015
1016ALTER SEQUENCE translations_id_seq OWNED BY translations.id;
1017
1018
1019--
1020-- Name: users; Type: TABLE; Schema: public; Owner: root
1021--
1022
1023CREATE TABLE users (
1024    id integer NOT NULL,
1025    name character varying(255) NOT NULL,
1026    email character varying(255) NOT NULL,
1027    password character varying(255) NOT NULL,
1028    remember_token character varying(100),
1029    created_at timestamp(0) without time zone,
1030    updated_at timestamp(0) without time zone,
1031    avatar character varying(255) DEFAULT 'users/default.png'::character varying,
1032    role_id integer
1033);
1034
1035
1036ALTER TABLE users OWNER TO root;
1037
1038--
1039-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: root
1040--
1041
1042CREATE SEQUENCE users_id_seq
1043    START WITH 1
1044    INCREMENT BY 1
1045    NO MINVALUE
1046    NO MAXVALUE
1047    CACHE 1;
1048
1049
1050ALTER TABLE users_id_seq OWNER TO root;
1051
1052--
1053-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
1054--
1055
1056ALTER SEQUENCE users_id_seq OWNED BY users.id;
1057
1058
1059--
1060-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1061--
1062
1063ALTER TABLE ONLY armchairs ALTER COLUMN id SET DEFAULT nextval('armchairs_id_seq'::regclass);
1064
1065
1066--
1067-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1068--
1069
1070ALTER TABLE ONLY armrests ALTER COLUMN id SET DEFAULT nextval('armrests_id_seq'::regclass);
1071
1072
1073--
1074-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1075--
1076
1077ALTER TABLE ONLY car_clothes_combinations ALTER COLUMN id SET DEFAULT nextval('car_clothes_combinations_id_seq'::regclass);
1078
1079
1080--
1081-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1082--
1083
1084ALTER TABLE ONLY car_covers_installations ALTER COLUMN id SET DEFAULT nextval('car_cover_installation_id_seq'::regclass);
1085
1086
1087--
1088-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1089--
1090
1091ALTER TABLE ONLY car_pillows ALTER COLUMN id SET DEFAULT nextval('car_pillows_id_seq'::regclass);
1092
1093
1094--
1095-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1096--
1097
1098ALTER TABLE ONLY car_pockets ALTER COLUMN id SET DEFAULT nextval('car_pockets_id_seq'::regclass);
1099
1100
1101--
1102-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1103--
1104
1105ALTER TABLE ONLY car_quilting_inserts ALTER COLUMN id SET DEFAULT nextval('car_quilting_inserts_id_seq'::regclass);
1106
1107
1108--
1109-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1110--
1111
1112ALTER TABLE ONLY cars ALTER COLUMN id SET DEFAULT nextval('cars_id_seq'::regclass);
1113
1114
1115--
1116-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1117--
1118
1119ALTER TABLE ONLY clients ALTER COLUMN id SET DEFAULT nextval('clients_id_seq'::regclass);
1120
1121
1122--
1123-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1124--
1125
1126ALTER TABLE ONLY data_rows ALTER COLUMN id SET DEFAULT nextval('data_rows_id_seq'::regclass);
1127
1128
1129--
1130-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1131--
1132
1133ALTER TABLE ONLY data_types ALTER COLUMN id SET DEFAULT nextval('data_types_id_seq'::regclass);
1134
1135
1136--
1137-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1138--
1139
1140ALTER TABLE ONLY headrests ALTER COLUMN id SET DEFAULT nextval('headrests_id_seq'::regclass);
1141
1142
1143--
1144-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1145--
1146
1147ALTER TABLE ONLY materials ALTER COLUMN id SET DEFAULT nextval('materials_id_seq'::regclass);
1148
1149
1150--
1151-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1152--
1153
1154ALTER TABLE ONLY materials_arrivals ALTER COLUMN id SET DEFAULT nextval('materials_arrival_id_seq'::regclass);
1155
1156
1157--
1158-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1159--
1160
1161ALTER TABLE ONLY menu_items ALTER COLUMN id SET DEFAULT nextval('menu_items_id_seq'::regclass);
1162
1163
1164--
1165-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1166--
1167
1168ALTER TABLE ONLY menus ALTER COLUMN id SET DEFAULT nextval('menus_id_seq'::regclass);
1169
1170
1171--
1172-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1173--
1174
1175ALTER TABLE ONLY migrations ALTER COLUMN id SET DEFAULT nextval('migrations_id_seq'::regclass);
1176
1177
1178--
1179-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1180--
1181
1182ALTER TABLE ONLY orders ALTER COLUMN id SET DEFAULT nextval('orders_id_seq'::regclass);
1183
1184
1185--
1186-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1187--
1188
1189ALTER TABLE ONLY permission_groups ALTER COLUMN id SET DEFAULT nextval('permission_groups_id_seq'::regclass);
1190
1191
1192--
1193-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1194--
1195
1196ALTER TABLE ONLY permissions ALTER COLUMN id SET DEFAULT nextval('permissions_id_seq'::regclass);
1197
1198
1199--
1200-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1201--
1202
1203ALTER TABLE ONLY roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);
1204
1205
1206--
1207-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1208--
1209
1210ALTER TABLE ONLY salaries ALTER COLUMN id SET DEFAULT nextval('salaries_id_seq'::regclass);
1211
1212
1213--
1214-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1215--
1216
1217ALTER TABLE ONLY settings ALTER COLUMN id SET DEFAULT nextval('settings_id_seq'::regclass);
1218
1219
1220--
1221-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
1222--
1223
1224ALTER TABLE ONLY sofas ALTER COLUMN id SET DEFAULT nextval('sofas_id_seq'::regclass);
1225
1226
1227--
1228-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1229--
1230
1231ALTER TABLE ONLY translations ALTER COLUMN id SET DEFAULT nextval('translations_id_seq'::regclass);
1232
1233
1234--
1235-- Name: id; Type: DEFAULT; Schema: public; Owner: root
1236--
1237
1238ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1239
1240
1241--
1242-- Data for Name: armchairs; Type: TABLE DATA; Schema: public; Owner: postgres
1243--
1244
1245INSERT INTO armchairs VALUES (1, 'Простое кресло', 1000);
1246INSERT INTO armchairs VALUES (2, 'Сложное кресло', 4000);
1247
1248
1249--
1250-- Name: armchairs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1251--
1252
1253SELECT pg_catalog.setval('armchairs_id_seq', 2, true);
1254
1255
1256--
1257-- Data for Name: armrests; Type: TABLE DATA; Schema: public; Owner: postgres
1258--
1259
1260
1261
1262--
1263-- Name: armrests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1264--
1265
1266SELECT pg_catalog.setval('armrests_id_seq', 1, false);
1267
1268
1269--
1270-- Data for Name: car_clothes_combinations; Type: TABLE DATA; Schema: public; Owner: postgres
1271--
1272
1273
1274
1275--
1276-- Name: car_clothes_combinations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1277--
1278
1279SELECT pg_catalog.setval('car_clothes_combinations_id_seq', 1, false);
1280
1281
1282--
1283-- Name: car_cover_installation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1284--
1285
1286SELECT pg_catalog.setval('car_cover_installation_id_seq', 1, false);
1287
1288
1289--
1290-- Data for Name: car_covers_installations; Type: TABLE DATA; Schema: public; Owner: postgres
1291--
1292
1293
1294
1295--
1296-- Data for Name: car_pillows; Type: TABLE DATA; Schema: public; Owner: postgres
1297--
1298
1299
1300
1301--
1302-- Name: car_pillows_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1303--
1304
1305SELECT pg_catalog.setval('car_pillows_id_seq', 1, false);
1306
1307
1308--
1309-- Data for Name: car_pockets; Type: TABLE DATA; Schema: public; Owner: postgres
1310--
1311
1312
1313
1314--
1315-- Name: car_pockets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1316--
1317
1318SELECT pg_catalog.setval('car_pockets_id_seq', 1, false);
1319
1320
1321--
1322-- Data for Name: car_quilting_inserts; Type: TABLE DATA; Schema: public; Owner: postgres
1323--
1324
1325
1326
1327--
1328-- Name: car_quilting_inserts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1329--
1330
1331SELECT pg_catalog.setval('car_quilting_inserts_id_seq', 1, false);
1332
1333
1334--
1335-- Data for Name: cars; Type: TABLE DATA; Schema: public; Owner: root
1336--
1337
1338INSERT INTO cars VALUES (3, 'Nissan', 'adwadwawdadw', 'dwaawdadwadw', '1996-2000', 'awdwawadawdad', true, 'cars/December2017/ZdEl5IvLYSzaftwAHrFF.png', 'Nissan adwadwawdadw dwaawdadwadw 1996-2000');
1339INSERT INTO cars VALUES (1, 'Toyota', 'Mark II', 'jzx100', '1996-2000', NULL, true, 'cars/December2017/j1haytnGAFuWidt5JhAz.png', 'Toyota Mark II, кузов: jzx100, года выпуска: 1996-2000');
1340INSERT INTO cars VALUES (2, 'Nissan', 'Cedric', 'HY34', '1996-2000', 'Ведрышко ржаааавое )', true, 'cars/December2017/CVMJITejLToQxr0W9qLR.png', 'Nissan Cedric, кузов: HY34, года выпуска: 1996-2000');
1341
1342
1343--
1344-- Name: cars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1345--
1346
1347SELECT pg_catalog.setval('cars_id_seq', 3, true);
1348
1349
1350--
1351-- Data for Name: clients; Type: TABLE DATA; Schema: public; Owner: root
1352--
1353
1354INSERT INTO clients VALUES (1, 'Павел Нечаев', 89242336096, 'Владивосток', 'Леонид Бабков', 89242336096, NULL, NULL, 'СУБАРУ!!!!');
1355INSERT INTO clients VALUES (2, 'Ветлугин Дмитрий Михайлович', 89247388075, 'Владивосток', NULL, NULL, NULL, NULL, 'красавчег');
1356
1357
1358--
1359-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1360--
1361
1362SELECT pg_catalog.setval('clients_id_seq', 2, true);
1363
1364
1365--
1366-- Data for Name: data_rows; Type: TABLE DATA; Schema: public; Owner: root
1367--
1368
1369INSERT INTO data_rows VALUES (1, 1, 'id', 'number', 'ID', true, false, false, false, false, false, '', 1);
1370INSERT INTO data_rows VALUES (2, 1, 'author_id', 'text', 'Author', true, false, true, true, false, true, '', 2);
1371INSERT INTO data_rows VALUES (3, 1, 'category_id', 'text', 'Category', true, false, true, true, true, false, '', 3);
1372INSERT INTO data_rows VALUES (4, 1, 'title', 'text', 'Title', true, true, true, true, true, true, '', 4);
1373INSERT INTO data_rows VALUES (5, 1, 'excerpt', 'text_area', 'excerpt', true, false, true, true, true, true, '', 5);
1374INSERT INTO data_rows VALUES (6, 1, 'body', 'rich_text_box', 'Body', true, false, true, true, true, true, '', 6);
1375INSERT INTO data_rows VALUES (7, 1, 'image', 'image', 'Post Image', false, true, true, true, true, true, '{"resize":{"width":"1000","height":"null"},"quality":"70%","upsize":true,"thumbnails":[{"name":"medium","scale":"50%"},{"name":"small","scale":"25%"},{"name":"cropped","crop":{"width":"300","height":"250"}}]}', 7);
1376INSERT INTO data_rows VALUES (8, 1, 'slug', 'text', 'slug', true, false, true, true, true, true, '{"slugify":{"origin":"title","forceUpdate":true}}', 8);
1377INSERT INTO data_rows VALUES (9, 1, 'meta_description', 'text_area', 'meta_description', true, false, true, true, true, true, '', 9);
1378INSERT INTO data_rows VALUES (10, 1, 'meta_keywords', 'text_area', 'meta_keywords', true, false, true, true, true, true, '', 10);
1379INSERT INTO data_rows VALUES (11, 1, 'status', 'select_dropdown', 'status', true, true, true, true, true, true, '{"default":"DRAFT","options":{"PUBLISHED":"published","DRAFT":"draft","PENDING":"pending"}}', 11);
1380INSERT INTO data_rows VALUES (12, 1, 'created_at', 'timestamp', 'created_at', false, true, true, false, false, false, '', 12);
1381INSERT INTO data_rows VALUES (13, 1, 'updated_at', 'timestamp', 'updated_at', false, false, false, false, false, false, '', 13);
1382INSERT INTO data_rows VALUES (14, 2, 'id', 'number', 'id', true, false, false, false, false, false, '', 1);
1383INSERT INTO data_rows VALUES (15, 2, 'author_id', 'text', 'author_id', true, false, false, false, false, false, '', 2);
1384INSERT INTO data_rows VALUES (16, 2, 'title', 'text', 'title', true, true, true, true, true, true, '', 3);
1385INSERT INTO data_rows VALUES (17, 2, 'excerpt', 'text_area', 'excerpt', true, false, true, true, true, true, '', 4);
1386INSERT INTO data_rows VALUES (18, 2, 'body', 'rich_text_box', 'body', true, false, true, true, true, true, '', 5);
1387INSERT INTO data_rows VALUES (19, 2, 'slug', 'text', 'slug', true, false, true, true, true, true, '{"slugify":{"origin":"title"}}', 6);
1388INSERT INTO data_rows VALUES (20, 2, 'meta_description', 'text', 'meta_description', true, false, true, true, true, true, '', 7);
1389INSERT INTO data_rows VALUES (21, 2, 'meta_keywords', 'text', 'meta_keywords', true, false, true, true, true, true, '', 8);
1390INSERT INTO data_rows VALUES (22, 2, 'status', 'select_dropdown', 'status', true, true, true, true, true, true, '{"default":"INACTIVE","options":{"INACTIVE":"INACTIVE","ACTIVE":"ACTIVE"}}', 9);
1391INSERT INTO data_rows VALUES (23, 2, 'created_at', 'timestamp', 'created_at', true, true, true, false, false, false, '', 10);
1392INSERT INTO data_rows VALUES (24, 2, 'updated_at', 'timestamp', 'updated_at', true, false, false, false, false, false, '', 11);
1393INSERT INTO data_rows VALUES (25, 2, 'image', 'image', 'image', false, true, true, true, true, true, '', 12);
1394INSERT INTO data_rows VALUES (35, 5, 'id', 'number', 'id', true, false, false, false, false, false, '', 1);
1395INSERT INTO data_rows VALUES (36, 5, 'name', 'text', 'name', true, true, true, true, true, true, '', 2);
1396INSERT INTO data_rows VALUES (37, 5, 'created_at', 'timestamp', 'created_at', false, false, false, false, false, false, '', 3);
1397INSERT INTO data_rows VALUES (38, 5, 'updated_at', 'timestamp', 'updated_at', false, false, false, false, false, false, '', 4);
1398INSERT INTO data_rows VALUES (39, 4, 'id', 'number', 'id', true, false, false, false, false, false, '', 1);
1399INSERT INTO data_rows VALUES (40, 4, 'parent_id', 'select_dropdown', 'parent_id', false, false, true, true, true, true, '{"default":"","null":"","options":{"":"-- None --"},"relationship":{"key":"id","label":"name"}}', 2);
1400INSERT INTO data_rows VALUES (41, 4, 'order', 'text', 'order', true, true, true, true, true, true, '{"default":1}', 3);
1401INSERT INTO data_rows VALUES (42, 4, 'name', 'text', 'name', true, true, true, true, true, true, '', 4);
1402INSERT INTO data_rows VALUES (43, 4, 'slug', 'text', 'slug', true, true, true, true, true, true, '{"slugify":{"origin":"name"}}', 5);
1403INSERT INTO data_rows VALUES (44, 4, 'created_at', 'timestamp', 'created_at', false, false, true, false, false, false, '', 6);
1404INSERT INTO data_rows VALUES (45, 4, 'updated_at', 'timestamp', 'updated_at', false, false, false, false, false, false, '', 7);
1405INSERT INTO data_rows VALUES (46, 6, 'id', 'number', 'id', true, false, false, false, false, false, '', 1);
1406INSERT INTO data_rows VALUES (47, 6, 'name', 'text', 'Name', true, true, true, true, true, true, '', 2);
1407INSERT INTO data_rows VALUES (48, 6, 'created_at', 'timestamp', 'created_at', false, false, false, false, false, false, '', 3);
1408INSERT INTO data_rows VALUES (49, 6, 'updated_at', 'timestamp', 'updated_at', false, false, false, false, false, false, '', 4);
1409INSERT INTO data_rows VALUES (50, 6, 'display_name', 'text', 'Display Name', true, true, true, true, true, true, '', 5);
1410INSERT INTO data_rows VALUES (51, 1, 'seo_title', 'text', 'seo_title', false, true, true, true, true, true, '', 14);
1411INSERT INTO data_rows VALUES (52, 1, 'featured', 'checkbox', 'featured', true, true, true, true, true, true, '', 15);
1412INSERT INTO data_rows VALUES (167, 12, 'order_belongsto_armchair_relationship', 'relationship', 'Кресла', false, false, true, true, true, true, '{"model":"App\\Armchair","table":"armchairs","type":"belongsTo","column":"armchairs_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 12);
1413INSERT INTO data_rows VALUES (63, 8, 'id', 'checkbox', 'Id', true, false, false, false, false, false, NULL, 1);
1414INSERT INTO data_rows VALUES (64, 8, 'manufacturer', 'text', 'Марка', true, true, true, true, true, true, NULL, 2);
1415INSERT INTO data_rows VALUES (65, 8, 'model', 'text', 'Модель', true, true, true, true, true, true, NULL, 3);
1416INSERT INTO data_rows VALUES (66, 8, 'body', 'text', 'Кузов', false, true, true, true, true, true, NULL, 4);
1417INSERT INTO data_rows VALUES (67, 8, 'release_years', 'text', 'Года выпуска', false, true, true, true, true, true, NULL, 5);
1418INSERT INTO data_rows VALUES (68, 8, 'comment', 'text_area', 'Комментарий', false, true, true, true, true, true, NULL, 6);
1419INSERT INTO data_rows VALUES (69, 8, 'pattern', 'checkbox', 'Наличие лекала', true, true, true, true, true, true, NULL, 7);
1420INSERT INTO data_rows VALUES (70, 8, 'scheme', 'image', 'Изображение схемы', false, true, true, true, true, true, NULL, 8);
1421INSERT INTO data_rows VALUES (74, 8, 'showing_data', 'checkbox', 'Данные автомобиля', false, false, false, false, false, false, NULL, 9);
1422INSERT INTO data_rows VALUES (26, 3, 'id', 'number', 'id', true, false, false, false, false, false, NULL, 1);
1423INSERT INTO data_rows VALUES (27, 3, 'name', 'text', 'ФИО', true, true, true, true, true, true, NULL, 2);
1424INSERT INTO data_rows VALUES (28, 3, 'email', 'text', 'E-mail', true, true, true, true, true, true, NULL, 3);
1425INSERT INTO data_rows VALUES (29, 3, 'password', 'password', 'Пароль', true, false, false, true, true, false, NULL, 4);
1426INSERT INTO data_rows VALUES (31, 3, 'remember_token', 'text', 'remember_token', false, false, false, false, false, false, NULL, 5);
1427INSERT INTO data_rows VALUES (32, 3, 'created_at', 'timestamp', 'created_at', false, false, false, false, false, false, NULL, 6);
1428INSERT INTO data_rows VALUES (33, 3, 'updated_at', 'timestamp', 'updated_at', false, false, false, false, false, false, NULL, 7);
1429INSERT INTO data_rows VALUES (34, 3, 'avatar', 'image', 'Аватар', false, false, true, true, true, true, NULL, 8);
1430INSERT INTO data_rows VALUES (53, 3, 'role_id', 'text', 'Роль (должность)', false, false, false, false, false, false, NULL, 9);
1431INSERT INTO data_rows VALUES (30, 3, 'user_belongsto_role_relationship', 'relationship', 'Роль (должность)', false, true, true, true, true, false, '{"model":"TCG\\Voyager\\Models\\Role","table":"roles","type":"belongsTo","column":"role_id","key":"id","label":"name","pivot_table":"roles","pivot":"0"}', 10);
1432INSERT INTO data_rows VALUES (76, 9, 'id', 'checkbox', 'Id', true, false, false, false, false, false, NULL, 1);
1433INSERT INTO data_rows VALUES (77, 9, 'name', 'text', 'Название', true, true, true, true, true, true, NULL, 2);
1434INSERT INTO data_rows VALUES (78, 9, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1435INSERT INTO data_rows VALUES (79, 9, 'count', 'number', 'Количество', false, true, true, true, true, true, NULL, 4);
1436INSERT INTO data_rows VALUES (86, 11, 'id', 'checkbox', 'Id', true, false, false, false, false, false, NULL, 1);
1437INSERT INTO data_rows VALUES (87, 11, 'material_id', 'checkbox', 'Material Id', true, false, false, false, false, false, NULL, 2);
1438INSERT INTO data_rows VALUES (88, 11, 'count', 'number', 'Количество', true, true, true, true, true, true, NULL, 6);
1439INSERT INTO data_rows VALUES (89, 11, 'created_at', 'timestamp', 'Created At', false, false, false, false, false, false, NULL, 3);
1440INSERT INTO data_rows VALUES (90, 11, 'updated_at', 'timestamp', 'Updated At', false, false, false, false, false, false, NULL, 4);
1441INSERT INTO data_rows VALUES (54, 7, 'id', 'checkbox', 'Id', true, false, false, false, false, false, NULL, 1);
1442INSERT INTO data_rows VALUES (55, 7, 'name', 'text', 'ФИО', true, true, true, true, true, true, NULL, 2);
1443INSERT INTO data_rows VALUES (56, 7, 'phone_number', 'number', 'Телефонный номер', true, true, true, true, true, true, NULL, 3);
1444INSERT INTO data_rows VALUES (57, 7, 'city', 'text', 'Город', true, true, true, true, true, true, NULL, 4);
1445INSERT INTO data_rows VALUES (58, 7, 'contact_person_1', 'text', 'ФИО контактного лица 1', false, true, true, true, true, true, NULL, 5);
1446INSERT INTO data_rows VALUES (91, 11, 'materials_arrival_belongsto_material_relationship', 'relationship', 'materials', false, true, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"material_id","key":"id","label":"name","pivot_table":"migrations","pivot":"0"}', 5);
1447INSERT INTO data_rows VALUES (59, 7, 'contact_person_1_phone_number', 'number', 'Телефонный номер контактного лица 1', false, true, true, true, true, true, NULL, 6);
1448INSERT INTO data_rows VALUES (60, 7, 'contact_person_2', 'text', 'ФИО контактного лица 2', false, true, true, true, true, true, NULL, 7);
1449INSERT INTO data_rows VALUES (61, 7, 'contact_person_2_phone_number', 'number', 'Телефонный номер контактного лица 2', false, true, true, true, true, true, NULL, 8);
1450INSERT INTO data_rows VALUES (62, 7, 'comment', 'text_area', 'Комментарий', false, true, true, true, true, true, NULL, 9);
1451INSERT INTO data_rows VALUES (75, 7, 'car_id', 'checkbox', 'ID машины', false, false, false, false, false, false, NULL, 10);
1452INSERT INTO data_rows VALUES (98, 12, 'created_at', 'timestamp', 'Дата создания заказа', false, true, false, false, false, false, '{"format":"Y-m-d"}', 10);
1453INSERT INTO data_rows VALUES (99, 12, 'updated_at', 'timestamp', 'Updated At', false, false, false, false, false, false, '{"format":"Y-m-d"}', 11);
1454INSERT INTO data_rows VALUES (134, 12, 'armchairs_id', 'checkbox', 'Armchairs Id', false, false, false, false, false, false, '{}', 13);
1455INSERT INTO data_rows VALUES (135, 12, 'armchairs_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 14);
1456INSERT INTO data_rows VALUES (136, 12, 'car_pockets_id', 'checkbox', 'Car Pockets Id', false, false, false, false, false, false, NULL, 31);
1457INSERT INTO data_rows VALUES (137, 12, 'car_pockets_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 32);
1458INSERT INTO data_rows VALUES (104, 14, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1459INSERT INTO data_rows VALUES (105, 14, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1460INSERT INTO data_rows VALUES (107, 15, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1461INSERT INTO data_rows VALUES (108, 15, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1462INSERT INTO data_rows VALUES (110, 16, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1463INSERT INTO data_rows VALUES (111, 16, 'name', 'text', 'Название', true, true, true, true, true, true, NULL, 2);
1464INSERT INTO data_rows VALUES (113, 17, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1465INSERT INTO data_rows VALUES (114, 17, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1466INSERT INTO data_rows VALUES (116, 18, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1467INSERT INTO data_rows VALUES (117, 18, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1468INSERT INTO data_rows VALUES (119, 19, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1469INSERT INTO data_rows VALUES (133, 23, 'percent_multiplier', 'number', 'Процентный множитель', true, true, true, true, true, true, NULL, 3);
1470INSERT INTO data_rows VALUES (138, 12, 'car_quilting_inserts_id', 'checkbox', 'Car Quilting Inserts Id', false, false, false, false, false, false, NULL, 34);
1471INSERT INTO data_rows VALUES (139, 12, 'car_quilting_inserts_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 35);
1472INSERT INTO data_rows VALUES (120, 19, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1473INSERT INTO data_rows VALUES (122, 20, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1474INSERT INTO data_rows VALUES (123, 20, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1475INSERT INTO data_rows VALUES (92, 12, 'id', 'checkbox', 'Id', true, true, false, false, false, false, NULL, 1);
1476INSERT INTO data_rows VALUES (128, 22, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1477INSERT INTO data_rows VALUES (129, 22, 'name', 'text', 'Название', false, true, true, true, true, true, NULL, 2);
1478INSERT INTO data_rows VALUES (106, 14, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1479INSERT INTO data_rows VALUES (109, 15, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1480INSERT INTO data_rows VALUES (112, 16, 'price', 'number', 'Цена', true, true, true, true, true, true, NULL, 3);
1481INSERT INTO data_rows VALUES (115, 17, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1482INSERT INTO data_rows VALUES (118, 18, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1483INSERT INTO data_rows VALUES (121, 19, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1484INSERT INTO data_rows VALUES (124, 20, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1485INSERT INTO data_rows VALUES (130, 22, 'price', 'number', 'Цена', false, true, true, true, true, true, NULL, 3);
1486INSERT INTO data_rows VALUES (131, 23, 'id', 'checkbox', 'Id', true, true, true, false, false, false, NULL, 1);
1487INSERT INTO data_rows VALUES (132, 23, 'name', 'text', 'Название', true, true, true, true, true, true, NULL, 2);
1488INSERT INTO data_rows VALUES (93, 12, 'client_id', 'checkbox', 'Client Id', true, false, false, false, false, false, NULL, 2);
1489INSERT INTO data_rows VALUES (168, 24, 'id', 'checkbox', 'Id', true, false, false, false, false, false, NULL, 1);
1490INSERT INTO data_rows VALUES (169, 24, 'user_id', 'checkbox', 'Сотрудник', false, false, false, false, false, false, NULL, 2);
1491INSERT INTO data_rows VALUES (94, 12, 'master_id', 'checkbox', 'Master Id', true, false, false, false, false, false, NULL, 3);
1492INSERT INTO data_rows VALUES (140, 12, 'car_covers_installations_id', 'checkbox', 'Car Covers Installations Id', false, false, false, false, false, false, NULL, 37);
1493INSERT INTO data_rows VALUES (141, 12, 'car_covers_installations_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 38);
1494INSERT INTO data_rows VALUES (170, 24, 'date', 'date', 'Дата', true, true, true, true, true, true, NULL, 3);
1495INSERT INTO data_rows VALUES (95, 12, 'car_id', 'checkbox', 'Car Id', true, false, false, false, false, false, NULL, 4);
1496INSERT INTO data_rows VALUES (171, 24, 'salary_amount', 'number', 'Зарплата', true, true, true, true, true, true, NULL, 4);
1497INSERT INTO data_rows VALUES (96, 12, 'description', 'text_area', 'Описание', true, true, true, true, true, true, NULL, 8);
1498INSERT INTO data_rows VALUES (103, 12, 'issue_date', 'date', 'Дата выдачи', true, true, true, true, true, true, '{"format":"Y-m-d"}', 9);
1499INSERT INTO data_rows VALUES (172, 24, 'salary_belongsto_user_relationship', 'relationship', 'Сотрудник', false, true, true, true, true, true, '{"model":"App\\User","table":"users","type":"belongsTo","column":"user_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 5);
1500INSERT INTO data_rows VALUES (142, 12, 'sofas_first_id', 'checkbox', 'Sofas First Id', false, false, false, false, false, false, NULL, 16);
1501INSERT INTO data_rows VALUES (143, 12, 'sofas_first_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 17);
1502INSERT INTO data_rows VALUES (144, 12, 'sofas_second_id', 'checkbox', 'Sofas Second Id', false, false, false, false, false, false, NULL, 19);
1503INSERT INTO data_rows VALUES (145, 12, 'sofas_second_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 20);
1504INSERT INTO data_rows VALUES (146, 12, 'sofas_third_id', 'checkbox', 'Sofas Third Id', false, false, false, false, false, false, NULL, 22);
1505INSERT INTO data_rows VALUES (147, 12, 'sofas_third_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 23);
1506INSERT INTO data_rows VALUES (148, 12, 'car_pillows_id', 'checkbox', 'Car Pillows Id', false, false, false, false, false, false, NULL, 40);
1507INSERT INTO data_rows VALUES (149, 12, 'car_pillows_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 41);
1508INSERT INTO data_rows VALUES (150, 12, 'headrests_id', 'checkbox', 'Headrests Id', false, false, false, false, false, false, NULL, 25);
1509INSERT INTO data_rows VALUES (151, 12, 'headrests_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 26);
1510INSERT INTO data_rows VALUES (152, 12, 'car_clothes_combinations_id', 'checkbox', 'Car Clothes Combinations Id', false, false, false, false, false, false, NULL, 43);
1511INSERT INTO data_rows VALUES (153, 12, 'car_clothes_combinations_count', 'number', 'Процентный множитель (комбинирование тканей)', false, false, true, true, true, true, NULL, 44);
1512INSERT INTO data_rows VALUES (154, 12, 'armrests_id', 'checkbox', 'Armrests Id', false, false, false, false, false, false, NULL, 28);
1513INSERT INTO data_rows VALUES (155, 12, 'armrests_count', 'number', 'Количество', false, false, true, true, true, true, NULL, 29);
1514INSERT INTO data_rows VALUES (100, 12, 'order_belongsto_client_relationship', 'relationship', 'Клиент', false, true, true, true, true, true, '{"model":"App\\Client","table":"clients","type":"belongsTo","column":"client_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 5);
1515INSERT INTO data_rows VALUES (101, 12, 'order_belongsto_car_relationship', 'relationship', 'Автомобиль клиента', false, true, true, true, true, true, '{"model":"App\\Car","table":"cars","type":"belongsTo","column":"car_id","key":"id","label":"showing_data","pivot_table":"cars","pivot":"0"}', 6);
1516INSERT INTO data_rows VALUES (173, 12, 'basic_fabric_id', 'checkbox', 'Basic Fabric Id', false, false, false, false, false, false, NULL, 46);
1517INSERT INTO data_rows VALUES (174, 12, 'basic_fabric_count', 'number', 'Погонные метры', false, false, true, true, true, true, NULL, 47);
1518INSERT INTO data_rows VALUES (175, 12, 'inserting_fabric_id', 'checkbox', 'Inserting Fabric Id', false, false, false, false, false, false, NULL, 49);
1519INSERT INTO data_rows VALUES (176, 12, 'inserting_fabric_count', 'number', 'Погонные метры', false, false, true, true, true, true, NULL, 50);
1520INSERT INTO data_rows VALUES (177, 12, 'fragments_fabric_id', 'checkbox', 'Fragments Fabric Id', false, false, false, false, false, false, NULL, 52);
1521INSERT INTO data_rows VALUES (178, 12, 'fragments_fabric_count', 'number', 'Погонные метры', false, false, true, true, true, true, NULL, 53);
1522INSERT INTO data_rows VALUES (179, 12, 'door_panels_fabric_id', 'checkbox', 'Door Panels Fabric Id', false, false, false, false, false, false, NULL, 55);
1523INSERT INTO data_rows VALUES (180, 12, 'door_panels_fabric_count', 'number', 'Погонные метры', false, false, true, true, true, true, NULL, 56);
1524INSERT INTO data_rows VALUES (181, 12, 'pillows_fabric_id', 'checkbox', 'Pillows Fabric Id', false, false, false, false, false, false, NULL, 58);
1525INSERT INTO data_rows VALUES (182, 12, 'pillows_fabric_count', 'number', 'Погонные метры', false, false, true, true, true, true, NULL, 59);
1526INSERT INTO data_rows VALUES (183, 12, 'fittings_id', 'checkbox', 'Fittings Id', false, false, false, false, false, false, NULL, 61);
1527INSERT INTO data_rows VALUES (184, 12, 'fittings_count', 'number', 'Стоимость', false, false, true, true, true, true, NULL, 62);
1528INSERT INTO data_rows VALUES (185, 12, 'first_additional_material_id', 'checkbox', 'First Additional Material Id', false, false, false, false, false, false, NULL, 64);
1529INSERT INTO data_rows VALUES (186, 12, 'first_additional_material_count', 'number', 'Стоимость', false, false, true, true, true, true, NULL, 65);
1530INSERT INTO data_rows VALUES (187, 12, 'second_additional_material_id', 'checkbox', 'Second Additional Material Id', false, false, false, false, false, false, NULL, 67);
1531INSERT INTO data_rows VALUES (188, 12, 'second_additional_material_count', 'number', 'Стоимость', false, false, true, true, true, true, NULL, 68);
1532INSERT INTO data_rows VALUES (189, 12, 'third_additional_material_id', 'checkbox', 'Third Additional Material Id', false, false, false, false, false, false, NULL, 70);
1533INSERT INTO data_rows VALUES (190, 12, 'third_additional_material_count', 'number', 'Стоимость', false, false, true, true, true, true, NULL, 71);
1534INSERT INTO data_rows VALUES (200, 12, 'total_price', 'number', 'Итоговая стоимость', false, true, true, false, true, false, NULL, 72);
1535INSERT INTO data_rows VALUES (157, 12, 'order_belongsto_sofa_relationship', 'relationship', 'Диваны (1)', false, false, true, true, true, true, '{"model":"App\\Sofa","table":"sofas","type":"belongsTo","column":"sofas_first_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 15);
1536INSERT INTO data_rows VALUES (158, 12, 'order_belongsto_sofa_relationship_1', 'relationship', 'Диваны (2)', false, false, true, true, true, true, '{"model":"App\\Sofa","table":"sofas","type":"belongsTo","column":"sofas_second_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 18);
1537INSERT INTO data_rows VALUES (159, 12, 'order_belongsto_sofa_relationship_2', 'relationship', 'Диваны (3)', false, false, true, true, true, true, '{"model":"App\\Sofa","table":"sofas","type":"belongsTo","column":"sofas_third_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 21);
1538INSERT INTO data_rows VALUES (160, 12, 'order_belongsto_headrest_relationship', 'relationship', 'Подголовники', false, false, true, true, true, true, '{"model":"App\\Headrest","table":"headrests","type":"belongsTo","column":"headrests_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 24);
1539INSERT INTO data_rows VALUES (161, 12, 'order_belongsto_armrest_relationship', 'relationship', 'Подлокотники', false, false, true, true, true, true, '{"model":"App\\Armrest","table":"armrests","type":"belongsTo","column":"armrests_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 27);
1540INSERT INTO data_rows VALUES (162, 12, 'order_belongsto_car_pocket_relationship', 'relationship', 'Карманы', false, false, true, true, true, true, '{"model":"App\\CarPocket","table":"car_pockets","type":"belongsTo","column":"car_pockets_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 30);
1541INSERT INTO data_rows VALUES (102, 12, 'order_belongsto_user_relationship', 'relationship', 'Мастер-исполнитель', false, true, true, true, true, true, '{"model":"App\\User","table":"users","type":"belongsTo","column":"master_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 7);
1542INSERT INTO data_rows VALUES (163, 12, 'order_belongsto_car_quilting_insert_relationship', 'relationship', 'Простежки вставок', false, false, true, true, true, true, '{"model":"App\\CarQuiltingInsert","table":"car_quilting_inserts","type":"belongsTo","column":"car_quilting_inserts_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 33);
1543INSERT INTO data_rows VALUES (164, 12, 'order_belongsto_car_covers_installation_relationship', 'relationship', 'Установка', false, false, true, true, true, true, '{"model":"App\\CarCoversInstallation","table":"car_covers_installations","type":"belongsTo","column":"car_covers_installations_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 36);
1544INSERT INTO data_rows VALUES (165, 12, 'order_belongsto_car_pillow_relationship', 'relationship', 'Подушки', false, false, true, true, true, true, '{"model":"App\\CarPillow","table":"car_pillows","type":"belongsTo","column":"car_pillows_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 39);
1545INSERT INTO data_rows VALUES (166, 12, 'order_belongsto_car_clothes_combination_relationship', 'relationship', 'Комбинирование тканей', false, false, true, true, true, true, '{"model":"App\\CarClothesCombination","table":"car_clothes_combinations","type":"belongsTo","column":"car_clothes_combinations_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 42);
1546INSERT INTO data_rows VALUES (191, 12, 'order_belongsto_material_relationship', 'relationship', 'Основная ткань', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"basic_fabric_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 45);
1547INSERT INTO data_rows VALUES (192, 12, 'order_belongsto_material_relationship_1', 'relationship', 'Ткань на вставку (середина)', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"inserting_fabric_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 48);
1548INSERT INTO data_rows VALUES (193, 12, 'order_belongsto_material_relationship_2', 'relationship', 'Ткань на фрагменты', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"fragments_fabric_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 51);
1549INSERT INTO data_rows VALUES (194, 12, 'order_belongsto_material_relationship_3', 'relationship', 'Ткань на дверные панели', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"door_panels_fabric_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 54);
1550INSERT INTO data_rows VALUES (195, 12, 'order_belongsto_material_relationship_4', 'relationship', 'Ткань на подушки, пр.детали', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"pillows_fabric_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 57);
1551INSERT INTO data_rows VALUES (196, 12, 'order_belongsto_material_relationship_5', 'relationship', 'Фурнитура', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"fittings_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 60);
1552INSERT INTO data_rows VALUES (197, 12, 'order_belongsto_material_relationship_6', 'relationship', 'Дополнительный материал 1', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"first_additional_material_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 63);
1553INSERT INTO data_rows VALUES (198, 12, 'order_belongsto_material_relationship_7', 'relationship', 'Дополнительный материал 2', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"second_additional_material_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 66);
1554INSERT INTO data_rows VALUES (199, 12, 'order_belongsto_material_relationship_8', 'relationship', 'Дополнительный материал 3', false, false, true, true, true, true, '{"model":"App\\Material","table":"materials","type":"belongsTo","column":"third_additional_material_id","key":"id","label":"name","pivot_table":"cars","pivot":"0"}', 69);
1555
1556
1557--
1558-- Name: data_rows_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1559--
1560
1561SELECT pg_catalog.setval('data_rows_id_seq', 200, true);
1562
1563
1564--
1565-- Data for Name: data_types; Type: TABLE DATA; Schema: public; Owner: root
1566--
1567
1568INSERT INTO data_types VALUES (1, 'posts', 'posts', 'Post', 'Posts', 'voyager-news', 'TCG\Voyager\Models\Post', '', true, '2017-12-12 06:31:26', '2017-12-12 06:31:26', 0, '', 'TCG\Voyager\Policies\PostPolicy');
1569INSERT INTO data_types VALUES (2, 'pages', 'pages', 'Page', 'Pages', 'voyager-file-text', 'TCG\Voyager\Models\Page', '', true, '2017-12-12 06:31:26', '2017-12-12 06:31:26', 0, '', NULL);
1570INSERT INTO data_types VALUES (4, 'categories', 'categories', 'Category', 'Categories', 'voyager-categories', 'TCG\Voyager\Models\Category', '', true, '2017-12-12 06:31:26', '2017-12-12 06:31:26', 0, '', NULL);
1571INSERT INTO data_types VALUES (5, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\Voyager\Models\Menu', '', true, '2017-12-12 06:31:26', '2017-12-12 06:31:26', 0, '', NULL);
1572INSERT INTO data_types VALUES (6, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\Voyager\Models\Role', '', true, '2017-12-12 06:31:26', '2017-12-12 06:31:26', 0, '', NULL);
1573INSERT INTO data_types VALUES (8, 'cars', 'cars', 'Автомобиль', 'Автомобили', 'voyager-dashboard', 'App\Car', NULL, true, '2017-12-12 07:04:58', '2017-12-13 06:58:18', 1, NULL, NULL);
1574INSERT INTO data_types VALUES (3, 'users', 'users', 'Пользователь', 'Персонал', 'voyager-person', 'TCG\Voyager\Models\User', NULL, true, '2017-12-12 06:31:26', '2017-12-13 07:29:13', 1, NULL, 'TCG\Voyager\Policies\UserPolicy');
1575INSERT INTO data_types VALUES (9, 'materials', 'materials', 'Материал', 'Список материалов', 'voyager-file-text', 'App\Material', NULL, true, '2017-12-13 07:59:29', '2017-12-13 08:20:38', 1, NULL, NULL);
1576INSERT INTO data_types VALUES (11, 'materials_arrivals', 'materials-arrivals', 'Приход материала', 'Приход материалов', 'voyager-truck', 'App\MaterialsArrival', NULL, true, '2017-12-13 08:29:52', '2017-12-13 08:30:47', 1, NULL, NULL);
1577INSERT INTO data_types VALUES (7, 'clients', 'clients', 'Клиент', 'Клиенты', 'voyager-group', 'App\Client', NULL, true, '2017-12-12 06:45:54', '2017-12-14 08:10:09', 1, NULL, NULL);
1578INSERT INTO data_types VALUES (14, 'car_pockets', 'car-pockets', 'Карман', 'Карманы', NULL, 'App\CarPocket', NULL, true, '2017-12-20 07:05:42', '2017-12-20 07:05:42', 0, NULL, NULL);
1579INSERT INTO data_types VALUES (15, 'car_quilting_inserts', 'car-quilting-inserts', 'Простежка вставкок', 'Простежки вставок', NULL, 'App\CarQuiltingInsert', NULL, true, '2017-12-20 07:07:09', '2017-12-20 07:07:09', 0, NULL, NULL);
1580INSERT INTO data_types VALUES (16, 'armchairs', 'armchairs', 'Кресло', 'Кресла', NULL, 'App\Armchair', NULL, true, '2017-12-20 07:10:08', '2017-12-20 07:10:08', 0, NULL, NULL);
1581INSERT INTO data_types VALUES (17, 'car_covers_installations', 'car-covers-installations', 'Установка чехлов', 'Установки чехлов', NULL, 'App\CarCoversInstallation', NULL, true, '2017-12-20 07:11:09', '2017-12-20 07:11:09', 0, NULL, NULL);
1582INSERT INTO data_types VALUES (18, 'sofas', 'sofas', 'Диван', 'Диваны', NULL, 'App\Sofa', NULL, true, '2017-12-20 07:11:41', '2017-12-20 07:11:41', 0, NULL, NULL);
1583INSERT INTO data_types VALUES (19, 'car_pillows', 'car-pillows', 'Подушка', 'Подушки', NULL, 'App\CarPillow', NULL, true, '2017-12-20 07:12:16', '2017-12-20 07:12:16', 0, NULL, NULL);
1584INSERT INTO data_types VALUES (20, 'headrests', 'headrests', 'Подголовник', 'Подголовники', NULL, 'App\Headrest', NULL, true, '2017-12-20 07:13:20', '2017-12-20 07:13:20', 0, NULL, NULL);
1585INSERT INTO data_types VALUES (22, 'armrests', 'armrests', 'Подлокотник', 'Подлокотники', NULL, 'App\Armrest', NULL, true, '2017-12-20 07:15:19', '2017-12-20 07:15:19', 0, NULL, NULL);
1586INSERT INTO data_types VALUES (23, 'car_clothes_combinations', 'car-clothes-combinations', 'Комбинирование тканей', 'Комбинирование тканей', NULL, 'App\CarClothesCombination', NULL, true, '2017-12-20 07:21:09', '2017-12-20 07:21:09', 0, NULL, NULL);
1587INSERT INTO data_types VALUES (24, 'salaries', 'salaries', 'Зарплата', 'Зарплата', 'voyager-wallet', 'App\Salary', NULL, true, '2017-12-23 08:19:41', '2017-12-23 08:44:04', 1, NULL, NULL);
1588INSERT INTO data_types VALUES (12, 'orders', 'orders', 'Заказ', 'Заказы', 'voyager-basket', 'App\Order', NULL, true, '2017-12-14 08:17:37', '2017-12-23 08:59:40', 1, NULL, NULL);
1589
1590
1591--
1592-- Name: data_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1593--
1594
1595SELECT pg_catalog.setval('data_types_id_seq', 24, true);
1596
1597
1598--
1599-- Data for Name: headrests; Type: TABLE DATA; Schema: public; Owner: postgres
1600--
1601
1602
1603
1604--
1605-- Name: headrests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1606--
1607
1608SELECT pg_catalog.setval('headrests_id_seq', 1, false);
1609
1610
1611--
1612-- Data for Name: materials; Type: TABLE DATA; Schema: public; Owner: root
1613--
1614
1615INSERT INTO materials VALUES (1, 'Кожзаменитель', 100, 12);
1616INSERT INTO materials VALUES (2, 'бум', 500, 50);
1617
1618
1619--
1620-- Name: materials_arrival_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1621--
1622
1623SELECT pg_catalog.setval('materials_arrival_id_seq', 2, true);
1624
1625
1626--
1627-- Data for Name: materials_arrivals; Type: TABLE DATA; Schema: public; Owner: root
1628--
1629
1630INSERT INTO materials_arrivals VALUES (1, 1, 10, '2017-12-13 08:25:04', '2017-12-13 08:25:04');
1631INSERT INTO materials_arrivals VALUES (2, 1, 1, '2017-12-13 08:31:15', '2017-12-13 08:31:15');
1632
1633
1634--
1635-- Name: materials_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1636--
1637
1638SELECT pg_catalog.setval('materials_id_seq', 2, true);
1639
1640
1641--
1642-- Data for Name: menu_items; Type: TABLE DATA; Schema: public; Owner: root
1643--
1644
1645INSERT INTO menu_items VALUES (10, 1, 'База данных', '', '_self', 'voyager-data', '#000000', 8, 2, '2017-12-12 06:31:27', '2017-12-13 07:53:02', 'voyager.database.index', 'null');
1646INSERT INTO menu_items VALUES (11, 1, 'Документация админ-панели', '', '_self', 'voyager-compass', '#000000', 8, 3, '2017-12-12 06:31:27', '2017-12-13 07:53:02', 'voyager.compass.index', 'null');
1647INSERT INTO menu_items VALUES (13, 1, 'Внешний вид', '', '_self', 'voyager-settings', '#000000', 8, 4, '2017-12-12 06:31:27', '2017-12-13 07:53:02', 'voyager.settings.index', 'null');
1648INSERT INTO menu_items VALUES (12, 1, 'Hooks', '', '_self', 'voyager-hook', NULL, 8, 5, '2017-12-12 06:31:27', '2017-12-13 07:53:02', 'voyager.hooks', NULL);
1649INSERT INTO menu_items VALUES (1, 1, 'Главная', '', '_self', 'voyager-boat', '#000000', NULL, 1, '2017-12-12 06:31:27', '2017-12-13 07:48:31', 'voyager.dashboard', 'null');
1650INSERT INTO menu_items VALUES (18, 1, 'Список материалов', '/admin/materials', '_self', 'voyager-file-text', NULL, 16, 1, '2017-12-13 07:59:29', '2017-12-13 08:19:10', NULL, NULL);
1651INSERT INTO menu_items VALUES (9, 1, 'Конструктор меню', '', '_self', 'voyager-list', '#000000', 8, 1, '2017-12-12 06:31:27', '2017-12-13 07:51:00', 'voyager.menus.index', 'null');
1652INSERT INTO menu_items VALUES (20, 1, 'Приход материалов', '/admin/materials-arrivals', '_self', 'voyager-truck', NULL, 16, 2, '2017-12-13 08:29:52', '2017-12-13 08:31:00', NULL, NULL);
1653INSERT INTO menu_items VALUES (4, 1, 'Персонал', '', '_self', 'voyager-person', NULL, 17, 1, '2017-12-12 06:31:27', '2017-12-13 07:53:09', 'voyager.users.index', NULL);
1654INSERT INTO menu_items VALUES (21, 1, 'Заказы', '/admin/orders', '_self', 'voyager-basket', NULL, NULL, 2, '2017-12-14 08:17:37', '2017-12-14 08:20:39', NULL, NULL);
1655INSERT INTO menu_items VALUES (14, 1, 'Клиенты', '/admin/clients', '_self', 'voyager-group', NULL, NULL, 3, '2017-12-12 06:45:54', '2017-12-14 08:20:39', NULL, NULL);
1656INSERT INTO menu_items VALUES (17, 1, 'Работа со штатом', '', '_self', 'voyager-people', '#000000', NULL, 4, '2017-12-13 07:52:55', '2017-12-14 08:20:39', NULL, '');
1657INSERT INTO menu_items VALUES (27, 1, 'Диваны', '/admin/sofas', '_self', NULL, NULL, 22, 5, '2017-12-20 07:11:41', '2017-12-23 08:45:58', NULL, NULL);
1658INSERT INTO menu_items VALUES (28, 1, 'Подушки', '/admin/car-pillows', '_self', NULL, NULL, 22, 6, '2017-12-20 07:12:16', '2017-12-23 08:45:58', NULL, NULL);
1659INSERT INTO menu_items VALUES (29, 1, 'Подголовники', '/admin/headrests', '_self', NULL, NULL, 22, 7, '2017-12-20 07:13:20', '2017-12-23 08:45:58', NULL, NULL);
1660INSERT INTO menu_items VALUES (30, 1, 'Комбинирование тканей', '/admin/car-clothes-combinations', '_self', NULL, NULL, 22, 8, '2017-12-20 07:13:56', '2017-12-23 08:45:58', NULL, NULL);
1661INSERT INTO menu_items VALUES (31, 1, 'Подлокотники', '/admin/armrests', '_self', NULL, NULL, 22, 9, '2017-12-20 07:15:19', '2017-12-23 08:45:58', NULL, NULL);
1662INSERT INTO menu_items VALUES (16, 1, 'Склад материалов', '', '_self', 'voyager-treasure', '#000000', NULL, 5, '2017-12-13 07:47:09', '2017-12-23 08:46:02', NULL, '');
1663INSERT INTO menu_items VALUES (22, 1, 'Элементы салона', '', '_self', 'voyager-hammer', '#000000', NULL, 6, '2017-12-20 04:51:47', '2017-12-23 08:46:02', NULL, '');
1664INSERT INTO menu_items VALUES (15, 1, 'Автомобили', '/admin/cars', '_self', 'voyager-dashboard', NULL, NULL, 7, '2017-12-12 07:04:58', '2017-12-23 08:46:02', NULL, NULL);
1665INSERT INTO menu_items VALUES (23, 1, 'Карманы', '/admin/car-pockets', '_self', NULL, NULL, 22, 1, '2017-12-20 07:05:42', '2017-12-20 07:22:07', NULL, NULL);
1666INSERT INTO menu_items VALUES (24, 1, 'Простежки вставок', '/admin/car-quilting-inserts', '_self', NULL, NULL, 22, 2, '2017-12-20 07:07:09', '2017-12-20 07:22:07', NULL, NULL);
1667INSERT INTO menu_items VALUES (25, 1, 'Кресла', '/admin/armchairs', '_self', NULL, NULL, 22, 3, '2017-12-20 07:10:08', '2017-12-20 07:22:07', NULL, NULL);
1668INSERT INTO menu_items VALUES (26, 1, 'Установки чехлов', '/admin/car-covers-installations', '_self', NULL, NULL, 22, 4, '2017-12-20 07:11:09', '2017-12-20 07:22:07', NULL, NULL);
1669INSERT INTO menu_items VALUES (8, 1, 'Настройки', '', '_self', 'voyager-tools', '#000000', NULL, 8, '2017-12-12 06:31:27', '2017-12-23 08:46:02', NULL, '');
1670INSERT INTO menu_items VALUES (2, 1, 'Медиа', '', '_self', 'voyager-images', '#000000', NULL, 9, '2017-12-12 06:31:27', '2017-12-23 08:46:02', 'voyager.media.index', 'null');
1671INSERT INTO menu_items VALUES (32, 1, 'Зарплата', '/admin/salaries', '_self', 'voyager-wallet', '#000000', 17, 2, '2017-12-23 08:19:41', '2017-12-23 08:46:09', NULL, '');
1672INSERT INTO menu_items VALUES (7, 1, 'Роли (должности)', '', '_self', 'voyager-lock', '#000000', 17, 3, '2017-12-12 06:31:27', '2017-12-23 08:46:09', 'voyager.roles.index', 'null');
1673
1674
1675--
1676-- Name: menu_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1677--
1678
1679SELECT pg_catalog.setval('menu_items_id_seq', 32, true);
1680
1681
1682--
1683-- Data for Name: menus; Type: TABLE DATA; Schema: public; Owner: root
1684--
1685
1686INSERT INTO menus VALUES (1, 'admin', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
1687
1688
1689--
1690-- Name: menus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1691--
1692
1693SELECT pg_catalog.setval('menus_id_seq', 1, true);
1694
1695
1696--
1697-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: root
1698--
1699
1700INSERT INTO migrations VALUES (1, '2014_10_12_000000_create_users_table', 1);
1701INSERT INTO migrations VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
1702INSERT INTO migrations VALUES (3, '2016_01_01_000000_add_voyager_user_fields', 1);
1703INSERT INTO migrations VALUES (4, '2016_01_01_000000_create_data_types_table', 1);
1704INSERT INTO migrations VALUES (5, '2016_01_01_000000_create_pages_table', 1);
1705INSERT INTO migrations VALUES (6, '2016_01_01_000000_create_posts_table', 1);
1706INSERT INTO migrations VALUES (7, '2016_02_15_204651_create_categories_table', 1);
1707INSERT INTO migrations VALUES (8, '2016_05_19_173453_create_menu_table', 1);
1708INSERT INTO migrations VALUES (9, '2016_10_21_190000_create_roles_table', 1);
1709INSERT INTO migrations VALUES (10, '2016_10_21_190000_create_settings_table', 1);
1710INSERT INTO migrations VALUES (11, '2016_11_30_135954_create_permission_table', 1);
1711INSERT INTO migrations VALUES (12, '2016_11_30_141208_create_permission_role_table', 1);
1712INSERT INTO migrations VALUES (13, '2016_12_26_201236_data_types__add__server_side', 1);
1713INSERT INTO migrations VALUES (14, '2017_01_13_000000_add_route_to_menu_items_table', 1);
1714INSERT INTO migrations VALUES (15, '2017_01_14_005015_create_translations_table', 1);
1715INSERT INTO migrations VALUES (16, '2017_01_15_000000_add_permission_group_id_to_permissions_table', 1);
1716INSERT INTO migrations VALUES (17, '2017_01_15_000000_create_permission_groups_table', 1);
1717INSERT INTO migrations VALUES (18, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1);
1718INSERT INTO migrations VALUES (19, '2017_03_06_000000_add_controller_to_data_types_table', 1);
1719INSERT INTO migrations VALUES (20, '2017_04_11_000000_alter_post_nullable_fields_table', 1);
1720INSERT INTO migrations VALUES (21, '2017_04_21_000000_add_order_to_data_rows_table', 1);
1721INSERT INTO migrations VALUES (22, '2017_07_05_210000_add_policyname_to_data_types_table', 1);
1722INSERT INTO migrations VALUES (23, '2017_08_05_000000_add_group_to_settings_table', 1);
1723
1724
1725--
1726-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1727--
1728
1729SELECT pg_catalog.setval('migrations_id_seq', 23, true);
1730
1731
1732--
1733-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: root
1734--
1735
1736INSERT INTO orders VALUES (1, 1, 3, 1, 'Обшить хорошо салон.', '2017-12-16', '2017-12-14 08:23:49', '2017-12-14 08:23:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1737INSERT INTO orders VALUES (2, 2, 3, 1, 'уаыаы', '2017-12-12', '2017-12-14 08:24:24', '2017-12-20 13:40:28', 1, 1, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1738
1739
1740--
1741-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1742--
1743
1744SELECT pg_catalog.setval('orders_id_seq', 7, true);
1745
1746
1747--
1748-- Data for Name: password_resets; Type: TABLE DATA; Schema: public; Owner: root
1749--
1750
1751
1752
1753--
1754-- Data for Name: permission_groups; Type: TABLE DATA; Schema: public; Owner: root
1755--
1756
1757
1758
1759--
1760-- Name: permission_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1761--
1762
1763SELECT pg_catalog.setval('permission_groups_id_seq', 1, false);
1764
1765
1766--
1767-- Data for Name: permission_role; Type: TABLE DATA; Schema: public; Owner: root
1768--
1769
1770INSERT INTO permission_role VALUES (1, 1);
1771INSERT INTO permission_role VALUES (2, 1);
1772INSERT INTO permission_role VALUES (3, 1);
1773INSERT INTO permission_role VALUES (4, 1);
1774INSERT INTO permission_role VALUES (5, 1);
1775INSERT INTO permission_role VALUES (6, 1);
1776INSERT INTO permission_role VALUES (7, 1);
1777INSERT INTO permission_role VALUES (8, 1);
1778INSERT INTO permission_role VALUES (9, 1);
1779INSERT INTO permission_role VALUES (15, 1);
1780INSERT INTO permission_role VALUES (16, 1);
1781INSERT INTO permission_role VALUES (17, 1);
1782INSERT INTO permission_role VALUES (18, 1);
1783INSERT INTO permission_role VALUES (19, 1);
1784INSERT INTO permission_role VALUES (20, 1);
1785INSERT INTO permission_role VALUES (21, 1);
1786INSERT INTO permission_role VALUES (22, 1);
1787INSERT INTO permission_role VALUES (23, 1);
1788INSERT INTO permission_role VALUES (24, 1);
1789INSERT INTO permission_role VALUES (35, 1);
1790INSERT INTO permission_role VALUES (36, 1);
1791INSERT INTO permission_role VALUES (37, 1);
1792INSERT INTO permission_role VALUES (38, 1);
1793INSERT INTO permission_role VALUES (39, 1);
1794INSERT INTO permission_role VALUES (40, 1);
1795INSERT INTO permission_role VALUES (41, 1);
1796INSERT INTO permission_role VALUES (42, 1);
1797INSERT INTO permission_role VALUES (43, 1);
1798INSERT INTO permission_role VALUES (44, 1);
1799INSERT INTO permission_role VALUES (45, 1);
1800INSERT INTO permission_role VALUES (46, 1);
1801INSERT INTO permission_role VALUES (47, 1);
1802INSERT INTO permission_role VALUES (48, 1);
1803INSERT INTO permission_role VALUES (49, 1);
1804INSERT INTO permission_role VALUES (50, 1);
1805INSERT INTO permission_role VALUES (51, 1);
1806INSERT INTO permission_role VALUES (52, 1);
1807INSERT INTO permission_role VALUES (53, 1);
1808INSERT INTO permission_role VALUES (54, 1);
1809INSERT INTO permission_role VALUES (65, 1);
1810INSERT INTO permission_role VALUES (66, 1);
1811INSERT INTO permission_role VALUES (67, 1);
1812INSERT INTO permission_role VALUES (68, 1);
1813INSERT INTO permission_role VALUES (69, 1);
1814INSERT INTO permission_role VALUES (40, 3);
1815INSERT INTO permission_role VALUES (41, 3);
1816INSERT INTO permission_role VALUES (42, 3);
1817INSERT INTO permission_role VALUES (43, 3);
1818INSERT INTO permission_role VALUES (44, 3);
1819INSERT INTO permission_role VALUES (45, 3);
1820INSERT INTO permission_role VALUES (46, 3);
1821INSERT INTO permission_role VALUES (47, 3);
1822INSERT INTO permission_role VALUES (48, 3);
1823INSERT INTO permission_role VALUES (49, 3);
1824INSERT INTO permission_role VALUES (50, 3);
1825INSERT INTO permission_role VALUES (51, 3);
1826INSERT INTO permission_role VALUES (52, 3);
1827INSERT INTO permission_role VALUES (53, 3);
1828INSERT INTO permission_role VALUES (54, 3);
1829INSERT INTO permission_role VALUES (65, 3);
1830INSERT INTO permission_role VALUES (66, 3);
1831INSERT INTO permission_role VALUES (67, 3);
1832INSERT INTO permission_role VALUES (68, 3);
1833INSERT INTO permission_role VALUES (69, 3);
1834INSERT INTO permission_role VALUES (1, 3);
1835INSERT INTO permission_role VALUES (70, 1);
1836INSERT INTO permission_role VALUES (71, 1);
1837INSERT INTO permission_role VALUES (72, 1);
1838INSERT INTO permission_role VALUES (73, 1);
1839INSERT INTO permission_role VALUES (74, 1);
1840INSERT INTO permission_role VALUES (1, 4);
1841INSERT INTO permission_role VALUES (4, 4);
1842INSERT INTO permission_role VALUES (70, 4);
1843INSERT INTO permission_role VALUES (71, 4);
1844INSERT INTO permission_role VALUES (75, 1);
1845INSERT INTO permission_role VALUES (76, 1);
1846INSERT INTO permission_role VALUES (77, 1);
1847INSERT INTO permission_role VALUES (78, 1);
1848INSERT INTO permission_role VALUES (79, 1);
1849INSERT INTO permission_role VALUES (80, 1);
1850INSERT INTO permission_role VALUES (81, 1);
1851INSERT INTO permission_role VALUES (82, 1);
1852INSERT INTO permission_role VALUES (83, 1);
1853INSERT INTO permission_role VALUES (84, 1);
1854INSERT INTO permission_role VALUES (85, 1);
1855INSERT INTO permission_role VALUES (86, 1);
1856INSERT INTO permission_role VALUES (87, 1);
1857INSERT INTO permission_role VALUES (88, 1);
1858INSERT INTO permission_role VALUES (89, 1);
1859INSERT INTO permission_role VALUES (90, 1);
1860INSERT INTO permission_role VALUES (91, 1);
1861INSERT INTO permission_role VALUES (92, 1);
1862INSERT INTO permission_role VALUES (93, 1);
1863INSERT INTO permission_role VALUES (94, 1);
1864INSERT INTO permission_role VALUES (95, 1);
1865INSERT INTO permission_role VALUES (96, 1);
1866INSERT INTO permission_role VALUES (97, 1);
1867INSERT INTO permission_role VALUES (98, 1);
1868INSERT INTO permission_role VALUES (99, 1);
1869INSERT INTO permission_role VALUES (100, 1);
1870INSERT INTO permission_role VALUES (101, 1);
1871INSERT INTO permission_role VALUES (102, 1);
1872INSERT INTO permission_role VALUES (103, 1);
1873INSERT INTO permission_role VALUES (104, 1);
1874INSERT INTO permission_role VALUES (105, 1);
1875INSERT INTO permission_role VALUES (106, 1);
1876INSERT INTO permission_role VALUES (107, 1);
1877INSERT INTO permission_role VALUES (108, 1);
1878INSERT INTO permission_role VALUES (109, 1);
1879INSERT INTO permission_role VALUES (115, 1);
1880INSERT INTO permission_role VALUES (116, 1);
1881INSERT INTO permission_role VALUES (117, 1);
1882INSERT INTO permission_role VALUES (118, 1);
1883INSERT INTO permission_role VALUES (119, 1);
1884INSERT INTO permission_role VALUES (120, 1);
1885INSERT INTO permission_role VALUES (121, 1);
1886INSERT INTO permission_role VALUES (122, 1);
1887INSERT INTO permission_role VALUES (123, 1);
1888INSERT INTO permission_role VALUES (124, 1);
1889INSERT INTO permission_role VALUES (125, 1);
1890INSERT INTO permission_role VALUES (126, 1);
1891INSERT INTO permission_role VALUES (127, 1);
1892INSERT INTO permission_role VALUES (128, 1);
1893INSERT INTO permission_role VALUES (129, 1);
1894
1895
1896--
1897-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: root
1898--
1899
1900INSERT INTO permissions VALUES (1, 'browse_admin', NULL, '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1901INSERT INTO permissions VALUES (2, 'browse_database', NULL, '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1902INSERT INTO permissions VALUES (3, 'browse_media', NULL, '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1903INSERT INTO permissions VALUES (4, 'browse_compass', NULL, '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1904INSERT INTO permissions VALUES (5, 'browse_menus', 'menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1905INSERT INTO permissions VALUES (6, 'read_menus', 'menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1906INSERT INTO permissions VALUES (7, 'edit_menus', 'menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1907INSERT INTO permissions VALUES (8, 'add_menus', 'menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1908INSERT INTO permissions VALUES (9, 'delete_menus', 'menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1909INSERT INTO permissions VALUES (15, 'browse_roles', 'roles', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1910INSERT INTO permissions VALUES (16, 'read_roles', 'roles', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1911INSERT INTO permissions VALUES (17, 'edit_roles', 'roles', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1912INSERT INTO permissions VALUES (18, 'add_roles', 'roles', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1913INSERT INTO permissions VALUES (19, 'delete_roles', 'roles', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1914INSERT INTO permissions VALUES (20, 'browse_users', 'users', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1915INSERT INTO permissions VALUES (21, 'read_users', 'users', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1916INSERT INTO permissions VALUES (22, 'edit_users', 'users', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1917INSERT INTO permissions VALUES (23, 'add_users', 'users', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1918INSERT INTO permissions VALUES (24, 'delete_users', 'users', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1919INSERT INTO permissions VALUES (35, 'browse_settings', 'settings', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1920INSERT INTO permissions VALUES (36, 'read_settings', 'settings', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1921INSERT INTO permissions VALUES (37, 'edit_settings', 'settings', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1922INSERT INTO permissions VALUES (38, 'add_settings', 'settings', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1923INSERT INTO permissions VALUES (39, 'delete_settings', 'settings', '2017-12-12 06:31:27', '2017-12-12 06:31:27', NULL);
1924INSERT INTO permissions VALUES (40, 'browse_clients', 'clients', '2017-12-12 06:45:54', '2017-12-12 06:45:54', NULL);
1925INSERT INTO permissions VALUES (41, 'read_clients', 'clients', '2017-12-12 06:45:54', '2017-12-12 06:45:54', NULL);
1926INSERT INTO permissions VALUES (42, 'edit_clients', 'clients', '2017-12-12 06:45:54', '2017-12-12 06:45:54', NULL);
1927INSERT INTO permissions VALUES (43, 'add_clients', 'clients', '2017-12-12 06:45:54', '2017-12-12 06:45:54', NULL);
1928INSERT INTO permissions VALUES (44, 'delete_clients', 'clients', '2017-12-12 06:45:54', '2017-12-12 06:45:54', NULL);
1929INSERT INTO permissions VALUES (45, 'browse_cars', 'cars', '2017-12-12 07:04:58', '2017-12-12 07:04:58', NULL);
1930INSERT INTO permissions VALUES (46, 'read_cars', 'cars', '2017-12-12 07:04:58', '2017-12-12 07:04:58', NULL);
1931INSERT INTO permissions VALUES (47, 'edit_cars', 'cars', '2017-12-12 07:04:58', '2017-12-12 07:04:58', NULL);
1932INSERT INTO permissions VALUES (48, 'add_cars', 'cars', '2017-12-12 07:04:58', '2017-12-12 07:04:58', NULL);
1933INSERT INTO permissions VALUES (49, 'delete_cars', 'cars', '2017-12-12 07:04:58', '2017-12-12 07:04:58', NULL);
1934INSERT INTO permissions VALUES (50, 'browse_materials', 'materials', '2017-12-13 07:59:29', '2017-12-13 07:59:29', NULL);
1935INSERT INTO permissions VALUES (51, 'read_materials', 'materials', '2017-12-13 07:59:29', '2017-12-13 07:59:29', NULL);
1936INSERT INTO permissions VALUES (52, 'edit_materials', 'materials', '2017-12-13 07:59:29', '2017-12-13 07:59:29', NULL);
1937INSERT INTO permissions VALUES (53, 'add_materials', 'materials', '2017-12-13 07:59:29', '2017-12-13 07:59:29', NULL);
1938INSERT INTO permissions VALUES (54, 'delete_materials', 'materials', '2017-12-13 07:59:29', '2017-12-13 07:59:29', NULL);
1939INSERT INTO permissions VALUES (65, 'browse_materials_arrivals', 'materials_arrivals', '2017-12-13 08:29:52', '2017-12-13 08:29:52', NULL);
1940INSERT INTO permissions VALUES (66, 'read_materials_arrivals', 'materials_arrivals', '2017-12-13 08:29:52', '2017-12-13 08:29:52', NULL);
1941INSERT INTO permissions VALUES (67, 'edit_materials_arrivals', 'materials_arrivals', '2017-12-13 08:29:52', '2017-12-13 08:29:52', NULL);
1942INSERT INTO permissions VALUES (68, 'add_materials_arrivals', 'materials_arrivals', '2017-12-13 08:29:52', '2017-12-13 08:29:52', NULL);
1943INSERT INTO permissions VALUES (69, 'delete_materials_arrivals', 'materials_arrivals', '2017-12-13 08:29:52', '2017-12-13 08:29:52', NULL);
1944INSERT INTO permissions VALUES (70, 'browse_orders', 'orders', '2017-12-14 08:17:37', '2017-12-14 08:17:37', NULL);
1945INSERT INTO permissions VALUES (71, 'read_orders', 'orders', '2017-12-14 08:17:37', '2017-12-14 08:17:37', NULL);
1946INSERT INTO permissions VALUES (72, 'edit_orders', 'orders', '2017-12-14 08:17:37', '2017-12-14 08:17:37', NULL);
1947INSERT INTO permissions VALUES (73, 'add_orders', 'orders', '2017-12-14 08:17:37', '2017-12-14 08:17:37', NULL);
1948INSERT INTO permissions VALUES (74, 'delete_orders', 'orders', '2017-12-14 08:17:37', '2017-12-14 08:17:37', NULL);
1949INSERT INTO permissions VALUES (75, 'browse_car_pockets', 'car_pockets', '2017-12-20 07:05:42', '2017-12-20 07:05:42', NULL);
1950INSERT INTO permissions VALUES (76, 'read_car_pockets', 'car_pockets', '2017-12-20 07:05:42', '2017-12-20 07:05:42', NULL);
1951INSERT INTO permissions VALUES (77, 'edit_car_pockets', 'car_pockets', '2017-12-20 07:05:42', '2017-12-20 07:05:42', NULL);
1952INSERT INTO permissions VALUES (78, 'add_car_pockets', 'car_pockets', '2017-12-20 07:05:42', '2017-12-20 07:05:42', NULL);
1953INSERT INTO permissions VALUES (79, 'delete_car_pockets', 'car_pockets', '2017-12-20 07:05:42', '2017-12-20 07:05:42', NULL);
1954INSERT INTO permissions VALUES (80, 'browse_car_quilting_inserts', 'car_quilting_inserts', '2017-12-20 07:07:09', '2017-12-20 07:07:09', NULL);
1955INSERT INTO permissions VALUES (81, 'read_car_quilting_inserts', 'car_quilting_inserts', '2017-12-20 07:07:09', '2017-12-20 07:07:09', NULL);
1956INSERT INTO permissions VALUES (82, 'edit_car_quilting_inserts', 'car_quilting_inserts', '2017-12-20 07:07:09', '2017-12-20 07:07:09', NULL);
1957INSERT INTO permissions VALUES (83, 'add_car_quilting_inserts', 'car_quilting_inserts', '2017-12-20 07:07:09', '2017-12-20 07:07:09', NULL);
1958INSERT INTO permissions VALUES (84, 'delete_car_quilting_inserts', 'car_quilting_inserts', '2017-12-20 07:07:09', '2017-12-20 07:07:09', NULL);
1959INSERT INTO permissions VALUES (85, 'browse_armchairs', 'armchairs', '2017-12-20 07:10:08', '2017-12-20 07:10:08', NULL);
1960INSERT INTO permissions VALUES (86, 'read_armchairs', 'armchairs', '2017-12-20 07:10:08', '2017-12-20 07:10:08', NULL);
1961INSERT INTO permissions VALUES (87, 'edit_armchairs', 'armchairs', '2017-12-20 07:10:08', '2017-12-20 07:10:08', NULL);
1962INSERT INTO permissions VALUES (88, 'add_armchairs', 'armchairs', '2017-12-20 07:10:08', '2017-12-20 07:10:08', NULL);
1963INSERT INTO permissions VALUES (89, 'delete_armchairs', 'armchairs', '2017-12-20 07:10:08', '2017-12-20 07:10:08', NULL);
1964INSERT INTO permissions VALUES (90, 'browse_car_covers_installations', 'car_covers_installations', '2017-12-20 07:11:09', '2017-12-20 07:11:09', NULL);
1965INSERT INTO permissions VALUES (91, 'read_car_covers_installations', 'car_covers_installations', '2017-12-20 07:11:09', '2017-12-20 07:11:09', NULL);
1966INSERT INTO permissions VALUES (92, 'edit_car_covers_installations', 'car_covers_installations', '2017-12-20 07:11:09', '2017-12-20 07:11:09', NULL);
1967INSERT INTO permissions VALUES (93, 'add_car_covers_installations', 'car_covers_installations', '2017-12-20 07:11:09', '2017-12-20 07:11:09', NULL);
1968INSERT INTO permissions VALUES (94, 'delete_car_covers_installations', 'car_covers_installations', '2017-12-20 07:11:09', '2017-12-20 07:11:09', NULL);
1969INSERT INTO permissions VALUES (95, 'browse_sofas', 'sofas', '2017-12-20 07:11:41', '2017-12-20 07:11:41', NULL);
1970INSERT INTO permissions VALUES (96, 'read_sofas', 'sofas', '2017-12-20 07:11:41', '2017-12-20 07:11:41', NULL);
1971INSERT INTO permissions VALUES (97, 'edit_sofas', 'sofas', '2017-12-20 07:11:41', '2017-12-20 07:11:41', NULL);
1972INSERT INTO permissions VALUES (98, 'add_sofas', 'sofas', '2017-12-20 07:11:41', '2017-12-20 07:11:41', NULL);
1973INSERT INTO permissions VALUES (99, 'delete_sofas', 'sofas', '2017-12-20 07:11:41', '2017-12-20 07:11:41', NULL);
1974INSERT INTO permissions VALUES (100, 'browse_car_pillows', 'car_pillows', '2017-12-20 07:12:16', '2017-12-20 07:12:16', NULL);
1975INSERT INTO permissions VALUES (101, 'read_car_pillows', 'car_pillows', '2017-12-20 07:12:16', '2017-12-20 07:12:16', NULL);
1976INSERT INTO permissions VALUES (102, 'edit_car_pillows', 'car_pillows', '2017-12-20 07:12:16', '2017-12-20 07:12:16', NULL);
1977INSERT INTO permissions VALUES (103, 'add_car_pillows', 'car_pillows', '2017-12-20 07:12:16', '2017-12-20 07:12:16', NULL);
1978INSERT INTO permissions VALUES (104, 'delete_car_pillows', 'car_pillows', '2017-12-20 07:12:16', '2017-12-20 07:12:16', NULL);
1979INSERT INTO permissions VALUES (105, 'browse_headrests', 'headrests', '2017-12-20 07:13:20', '2017-12-20 07:13:20', NULL);
1980INSERT INTO permissions VALUES (106, 'read_headrests', 'headrests', '2017-12-20 07:13:20', '2017-12-20 07:13:20', NULL);
1981INSERT INTO permissions VALUES (107, 'edit_headrests', 'headrests', '2017-12-20 07:13:20', '2017-12-20 07:13:20', NULL);
1982INSERT INTO permissions VALUES (108, 'add_headrests', 'headrests', '2017-12-20 07:13:20', '2017-12-20 07:13:20', NULL);
1983INSERT INTO permissions VALUES (109, 'delete_headrests', 'headrests', '2017-12-20 07:13:20', '2017-12-20 07:13:20', NULL);
1984INSERT INTO permissions VALUES (115, 'browse_armrests', 'armrests', '2017-12-20 07:15:19', '2017-12-20 07:15:19', NULL);
1985INSERT INTO permissions VALUES (116, 'read_armrests', 'armrests', '2017-12-20 07:15:19', '2017-12-20 07:15:19', NULL);
1986INSERT INTO permissions VALUES (117, 'edit_armrests', 'armrests', '2017-12-20 07:15:19', '2017-12-20 07:15:19', NULL);
1987INSERT INTO permissions VALUES (118, 'add_armrests', 'armrests', '2017-12-20 07:15:19', '2017-12-20 07:15:19', NULL);
1988INSERT INTO permissions VALUES (119, 'delete_armrests', 'armrests', '2017-12-20 07:15:19', '2017-12-20 07:15:19', NULL);
1989INSERT INTO permissions VALUES (120, 'browse_car_clothes_combinations', 'car_clothes_combinations', '2017-12-20 07:21:10', '2017-12-20 07:21:10', NULL);
1990INSERT INTO permissions VALUES (121, 'read_car_clothes_combinations', 'car_clothes_combinations', '2017-12-20 07:21:10', '2017-12-20 07:21:10', NULL);
1991INSERT INTO permissions VALUES (122, 'edit_car_clothes_combinations', 'car_clothes_combinations', '2017-12-20 07:21:10', '2017-12-20 07:21:10', NULL);
1992INSERT INTO permissions VALUES (123, 'add_car_clothes_combinations', 'car_clothes_combinations', '2017-12-20 07:21:10', '2017-12-20 07:21:10', NULL);
1993INSERT INTO permissions VALUES (124, 'delete_car_clothes_combinations', 'car_clothes_combinations', '2017-12-20 07:21:10', '2017-12-20 07:21:10', NULL);
1994INSERT INTO permissions VALUES (125, 'browse_salaries', 'salaries', '2017-12-23 08:19:41', '2017-12-23 08:19:41', NULL);
1995INSERT INTO permissions VALUES (126, 'read_salaries', 'salaries', '2017-12-23 08:19:41', '2017-12-23 08:19:41', NULL);
1996INSERT INTO permissions VALUES (127, 'edit_salaries', 'salaries', '2017-12-23 08:19:41', '2017-12-23 08:19:41', NULL);
1997INSERT INTO permissions VALUES (128, 'add_salaries', 'salaries', '2017-12-23 08:19:41', '2017-12-23 08:19:41', NULL);
1998INSERT INTO permissions VALUES (129, 'delete_salaries', 'salaries', '2017-12-23 08:19:41', '2017-12-23 08:19:41', NULL);
1999
2000
2001--
2002-- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
2003--
2004
2005SELECT pg_catalog.setval('permissions_id_seq', 129, true);
2006
2007
2008--
2009-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: root
2010--
2011
2012INSERT INTO roles VALUES (1, 'admin', 'Administrator', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2013INSERT INTO roles VALUES (2, 'user', 'Normal User', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2014INSERT INTO roles VALUES (3, 'Оператор системы', 'Оператор системы', '2017-12-13 08:37:06', '2017-12-13 08:48:36');
2015INSERT INTO roles VALUES (4, 'Мастер-исполнитель', 'Мастер-исполнитель', '2017-12-14 08:22:25', '2017-12-14 08:22:25');
2016
2017
2018--
2019-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
2020--
2021
2022SELECT pg_catalog.setval('roles_id_seq', 4, true);
2023
2024
2025--
2026-- Data for Name: salaries; Type: TABLE DATA; Schema: public; Owner: postgres
2027--
2028
2029INSERT INTO salaries VALUES (1, 3, '1997-02-22', 100001);
2030
2031
2032--
2033-- Name: salaries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
2034--
2035
2036SELECT pg_catalog.setval('salaries_id_seq', 1, true);
2037
2038
2039--
2040-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: root
2041--
2042
2043INSERT INTO settings VALUES (4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', '', '', 'text', 4, 'Site');
2044INSERT INTO settings VALUES (10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', '', '', 'text', 1, 'Admin');
2045INSERT INTO settings VALUES (6, 'admin.title', 'Admin Title', 'Ательер', '', 'text', 1, 'Admin');
2046INSERT INTO settings VALUES (7, 'admin.description', 'Admin Description', 'Система автоматизации рабочих процессов. Создано компанией Awake!', '', 'text', 2, 'Admin');
2047INSERT INTO settings VALUES (8, 'admin.loader', 'Admin Loader', 'settings/December2017/P0BsT9pX4Rh3HSPJshLE.gif', '', 'image', 3, 'Admin');
2048INSERT INTO settings VALUES (5, 'admin.bg_image', 'Admin Background Image', 'settings/December2017/0VfSr6I0AlydcqmyROnB.jpg', '', 'image', 5, 'Admin');
2049INSERT INTO settings VALUES (9, 'admin.icon_image', 'Admin Icon Image', 'settings/December2017/56T7ROUeJc7OT5n2SOYa.png', '', 'image', 4, 'Admin');
2050INSERT INTO settings VALUES (1, 'site.title', 'Site Title', 'Ательер', '', 'text', 1, 'Site');
2051INSERT INTO settings VALUES (2, 'site.description', 'Site Description', 'Система автоматизации рабочих процессов. Создано компанией Awake!', '', 'text', 2, 'Site');
2052INSERT INTO settings VALUES (3, 'site.logo', 'Site Logo', 'settings/December2017/DQfD0QMBcBDem0PeZJqh.png', '', 'image', 3, 'Site');
2053
2054
2055--
2056-- Name: settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
2057--
2058
2059SELECT pg_catalog.setval('settings_id_seq', 11, true);
2060
2061
2062--
2063-- Data for Name: sofas; Type: TABLE DATA; Schema: public; Owner: postgres
2064--
2065
2066INSERT INTO sofas VALUES (1, 'Диван простой', 2000);
2067INSERT INTO sofas VALUES (4, 'Диван сложный', 3000);
2068
2069
2070--
2071-- Name: sofas_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
2072--
2073
2074SELECT pg_catalog.setval('sofas_id_seq', 4, true);
2075
2076
2077--
2078-- Data for Name: translations; Type: TABLE DATA; Schema: public; Owner: root
2079--
2080
2081INSERT INTO translations VALUES (1, 'data_types', 'display_name_singular', 1, 'pt', 'Post', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2082INSERT INTO translations VALUES (2, 'data_types', 'display_name_singular', 2, 'pt', 'Página', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2083INSERT INTO translations VALUES (3, 'data_types', 'display_name_singular', 3, 'pt', 'Utilizador', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2084INSERT INTO translations VALUES (4, 'data_types', 'display_name_singular', 4, 'pt', 'Categoria', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2085INSERT INTO translations VALUES (5, 'data_types', 'display_name_singular', 5, 'pt', 'Menu', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2086INSERT INTO translations VALUES (6, 'data_types', 'display_name_singular', 6, 'pt', 'Função', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2087INSERT INTO translations VALUES (7, 'data_types', 'display_name_plural', 1, 'pt', 'Posts', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2088INSERT INTO translations VALUES (8, 'data_types', 'display_name_plural', 2, 'pt', 'Páginas', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2089INSERT INTO translations VALUES (9, 'data_types', 'display_name_plural', 3, 'pt', 'Utilizadores', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2090INSERT INTO translations VALUES (10, 'data_types', 'display_name_plural', 4, 'pt', 'Categorias', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2091INSERT INTO translations VALUES (11, 'data_types', 'display_name_plural', 5, 'pt', 'Menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2092INSERT INTO translations VALUES (12, 'data_types', 'display_name_plural', 6, 'pt', 'Funções', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2093INSERT INTO translations VALUES (13, 'categories', 'slug', 1, 'pt', 'categoria-1', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2094INSERT INTO translations VALUES (14, 'categories', 'name', 1, 'pt', 'Categoria 1', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2095INSERT INTO translations VALUES (15, 'categories', 'slug', 2, 'pt', 'categoria-2', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2096INSERT INTO translations VALUES (16, 'categories', 'name', 2, 'pt', 'Categoria 2', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2097INSERT INTO translations VALUES (17, 'pages', 'title', 1, 'pt', 'Olá Mundo', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2098INSERT INTO translations VALUES (18, 'pages', 'slug', 1, 'pt', 'ola-mundo', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2099INSERT INTO translations VALUES (19, 'pages', 'body', 1, 'pt', '<p>Olá Mundo. Scallywag grog swab Cat o''nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.</p>
2100<p>Ballast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.</p>', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2101INSERT INTO translations VALUES (20, 'menu_items', 'title', 1, 'pt', 'Painel de Controle', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2102INSERT INTO translations VALUES (21, 'menu_items', 'title', 2, 'pt', 'Media', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2103INSERT INTO translations VALUES (22, 'menu_items', 'title', 3, 'pt', 'Publicações', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2104INSERT INTO translations VALUES (23, 'menu_items', 'title', 4, 'pt', 'Utilizadores', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2105INSERT INTO translations VALUES (24, 'menu_items', 'title', 5, 'pt', 'Categorias', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2106INSERT INTO translations VALUES (25, 'menu_items', 'title', 6, 'pt', 'Páginas', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2107INSERT INTO translations VALUES (26, 'menu_items', 'title', 7, 'pt', 'Funções', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2108INSERT INTO translations VALUES (27, 'menu_items', 'title', 8, 'pt', 'Ferramentas', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2109INSERT INTO translations VALUES (28, 'menu_items', 'title', 9, 'pt', 'Menus', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2110INSERT INTO translations VALUES (29, 'menu_items', 'title', 10, 'pt', 'Base de dados', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2111INSERT INTO translations VALUES (30, 'menu_items', 'title', 13, 'pt', 'Configurações', '2017-12-12 06:31:27', '2017-12-12 06:31:27');
2112
2113
2114--
2115-- Name: translations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
2116--
2117
2118SELECT pg_catalog.setval('translations_id_seq', 30, true);
2119
2120
2121--
2122-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: root
2123--
2124
2125INSERT INTO users VALUES (1, 'Admin', 'admin@admin.com', '$2y$10$moGFasMYyMR0SwCNIQHuseYPm72X/g9i0Ye74bOtHFc0A50kH9v.y', 'Fkbd4qLRHBbRHvKzdVkqFlOQp7rQP0nzA3TnSzOBtNIIsspX0MJLZsKe6Lgm', '2017-12-12 06:31:27', '2017-12-21 05:10:08', 'users/December2017/oj9X2xPjHBxAunaOYvvF.jpeg', 1);
2126INSERT INTO users VALUES (3, 'Бабков Леонид Николаевич', 'adgfq121519@gmail.com', '$2y$10$3jsRvx/F8MgPVoEXnkrYgOMgga1IJNLrtebrWLz1a5ztjuWKGhMVW', 'wABCLGeavsgh1VvRs9XmmHwxP87SCoPtj6XURdHt40QHJPSGFqAIlIlYOm7e', '2017-12-14 08:22:39', '2017-12-14 08:22:47', 'users/default.png', 4);
2127
2128
2129--
2130-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
2131--
2132
2133SELECT pg_catalog.setval('users_id_seq', 3, true);
2134
2135
2136--
2137-- Name: armchairs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2138--
2139
2140ALTER TABLE ONLY armchairs
2141    ADD CONSTRAINT armchairs_pkey PRIMARY KEY (id);
2142
2143
2144--
2145-- Name: cars_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2146--
2147
2148ALTER TABLE ONLY cars
2149    ADD CONSTRAINT cars_pkey PRIMARY KEY (id);
2150
2151
2152--
2153-- Name: clients_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2154--
2155
2156ALTER TABLE ONLY clients
2157    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
2158
2159
2160--
2161-- Name: data_rows_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2162--
2163
2164ALTER TABLE ONLY data_rows
2165    ADD CONSTRAINT data_rows_pkey PRIMARY KEY (id);
2166
2167
2168--
2169-- Name: data_types_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
2170--
2171
2172ALTER TABLE ONLY data_types
2173    ADD CONSTRAINT data_types_name_unique UNIQUE (name);
2174
2175
2176--
2177-- Name: data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2178--
2179
2180ALTER TABLE ONLY data_types
2181    ADD CONSTRAINT data_types_pkey PRIMARY KEY (id);
2182
2183
2184--
2185-- Name: data_types_slug_unique; Type: CONSTRAINT; Schema: public; Owner: root
2186--
2187
2188ALTER TABLE ONLY data_types
2189    ADD CONSTRAINT data_types_slug_unique UNIQUE (slug);
2190
2191
2192--
2193-- Name: materials_arrival_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2194--
2195
2196ALTER TABLE ONLY materials_arrivals
2197    ADD CONSTRAINT materials_arrival_pkey PRIMARY KEY (id);
2198
2199
2200--
2201-- Name: materials_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2202--
2203
2204ALTER TABLE ONLY materials
2205    ADD CONSTRAINT materials_pkey PRIMARY KEY (id);
2206
2207
2208--
2209-- Name: menu_items_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2210--
2211
2212ALTER TABLE ONLY menu_items
2213    ADD CONSTRAINT menu_items_pkey PRIMARY KEY (id);
2214
2215
2216--
2217-- Name: menus_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
2218--
2219
2220ALTER TABLE ONLY menus
2221    ADD CONSTRAINT menus_name_unique UNIQUE (name);
2222
2223
2224--
2225-- Name: menus_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2226--
2227
2228ALTER TABLE ONLY menus
2229    ADD CONSTRAINT menus_pkey PRIMARY KEY (id);
2230
2231
2232--
2233-- Name: migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2234--
2235
2236ALTER TABLE ONLY migrations
2237    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);
2238
2239
2240--
2241-- Name: orders_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2242--
2243
2244ALTER TABLE ONLY orders
2245    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);
2246
2247
2248--
2249-- Name: permission_groups_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
2250--
2251
2252ALTER TABLE ONLY permission_groups
2253    ADD CONSTRAINT permission_groups_name_unique UNIQUE (name);
2254
2255
2256--
2257-- Name: permission_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2258--
2259
2260ALTER TABLE ONLY permission_groups
2261    ADD CONSTRAINT permission_groups_pkey PRIMARY KEY (id);
2262
2263
2264--
2265-- Name: permission_role_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2266--
2267
2268ALTER TABLE ONLY permission_role
2269    ADD CONSTRAINT permission_role_pkey PRIMARY KEY (permission_id, role_id);
2270
2271
2272--
2273-- Name: permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2274--
2275
2276ALTER TABLE ONLY permissions
2277    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
2278
2279
2280--
2281-- Name: roles_name_unique; Type: CONSTRAINT; Schema: public; Owner: root
2282--
2283
2284ALTER TABLE ONLY roles
2285    ADD CONSTRAINT roles_name_unique UNIQUE (name);
2286
2287
2288--
2289-- Name: roles_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2290--
2291
2292ALTER TABLE ONLY roles
2293    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
2294
2295
2296--
2297-- Name: salaries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2298--
2299
2300ALTER TABLE ONLY salaries
2301    ADD CONSTRAINT salaries_pkey PRIMARY KEY (id);
2302
2303
2304--
2305-- Name: settings_key_unique; Type: CONSTRAINT; Schema: public; Owner: root
2306--
2307
2308ALTER TABLE ONLY settings
2309    ADD CONSTRAINT settings_key_unique UNIQUE (key);
2310
2311
2312--
2313-- Name: settings_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2314--
2315
2316ALTER TABLE ONLY settings
2317    ADD CONSTRAINT settings_pkey PRIMARY KEY (id);
2318
2319
2320--
2321-- Name: translations_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2322--
2323
2324ALTER TABLE ONLY translations
2325    ADD CONSTRAINT translations_pkey PRIMARY KEY (id);
2326
2327
2328--
2329-- Name: translations_table_name_column_name_foreign_key_locale_unique; Type: CONSTRAINT; Schema: public; Owner: root
2330--
2331
2332ALTER TABLE ONLY translations
2333    ADD CONSTRAINT translations_table_name_column_name_foreign_key_locale_unique UNIQUE (table_name, column_name, foreign_key, locale);
2334
2335
2336--
2337-- Name: users_email_unique; Type: CONSTRAINT; Schema: public; Owner: root
2338--
2339
2340ALTER TABLE ONLY users
2341    ADD CONSTRAINT users_email_unique UNIQUE (email);
2342
2343
2344--
2345-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: root
2346--
2347
2348ALTER TABLE ONLY users
2349    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
2350
2351
2352--
2353-- Name: password_resets_email_index; Type: INDEX; Schema: public; Owner: root
2354--
2355
2356CREATE INDEX password_resets_email_index ON password_resets USING btree (email);
2357
2358
2359--
2360-- Name: permission_role_permission_id_index; Type: INDEX; Schema: public; Owner: root
2361--
2362
2363CREATE INDEX permission_role_permission_id_index ON permission_role USING btree (permission_id);
2364
2365
2366--
2367-- Name: permission_role_role_id_index; Type: INDEX; Schema: public; Owner: root
2368--
2369
2370CREATE INDEX permission_role_role_id_index ON permission_role USING btree (role_id);
2371
2372
2373--
2374-- Name: permissions_key_index; Type: INDEX; Schema: public; Owner: root
2375--
2376
2377CREATE INDEX permissions_key_index ON permissions USING btree (key);
2378
2379
2380--
2381-- Name: data_rows_data_type_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
2382--
2383
2384ALTER TABLE ONLY data_rows
2385    ADD CONSTRAINT data_rows_data_type_id_foreign FOREIGN KEY (data_type_id) REFERENCES data_types(id) ON UPDATE CASCADE ON DELETE CASCADE;
2386
2387
2388--
2389-- Name: menu_items_menu_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
2390--
2391
2392ALTER TABLE ONLY menu_items
2393    ADD CONSTRAINT menu_items_menu_id_foreign FOREIGN KEY (menu_id) REFERENCES menus(id) ON DELETE CASCADE;
2394
2395
2396--
2397-- Name: permission_role_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
2398--
2399
2400ALTER TABLE ONLY permission_role
2401    ADD CONSTRAINT permission_role_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES permissions(id) ON DELETE CASCADE;
2402
2403
2404--
2405-- Name: permission_role_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: root
2406--
2407
2408ALTER TABLE ONLY permission_role
2409    ADD CONSTRAINT permission_role_role_id_foreign FOREIGN KEY (role_id) REFERENCES roles(id) ON DELETE CASCADE;
2410
2411
2412--
2413-- Name: public; Type: ACL; Schema: -; Owner: postgres
2414--
2415
2416REVOKE ALL ON SCHEMA public FROM PUBLIC;
2417REVOKE ALL ON SCHEMA public FROM postgres;
2418GRANT ALL ON SCHEMA public TO postgres;
2419GRANT ALL ON SCHEMA public TO PUBLIC;
2420
2421
2422--
2423-- PostgreSQL database dump complete
2424--