f6178Kgm

1PGDMP

2 


    $                    x            Music    10.11    10.11 $            
   0 
   0    ENCODING    ENCODING        SET client_encoding = 'UTF8';
3     

   

   

            false

                    
   0 
   0 
4   STDSTRINGS 
5   STDSTRINGS     (   SET standard_conforming_strings = 'on';
6     

   

   

            false

                    
   0 
   0 
7   SEARCHPATH 
8   SEARCHPATH     8   SELECT pg_catalog.set_config('search_path', '', false);
9     

   

   

            false

                       1262    16602    Music    DATABASE     ‰   CREATE DATABASE "Music" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Russian_Russia.1251' LC_CTYPE = 'Russian_Russia.1251';
10    DROP DATABASE "Music";
11

   

   

       postgres    false

                        2615    2200    public    SCHEMA        CREATE SCHEMA public;
12    DROP SCHEMA public;
13

   

   

       postgres    false

                     
   0 
   0 
14   SCHEMA public    COMMENT 
    6   COMMENT ON SCHEMA public IS 'standard public schema';
15     

   

   

       postgres    false 
   6

            !        
   0 
   0 
16   SCHEMA public    ACL 
    &   GRANT ALL ON SCHEMA public TO PUBLIC;
17     

   

   

       postgres    false 
   6

            
            3079    12924    plpgsql 	   EXTENSION     ?   CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
18    DROP EXTENSION plpgsql;
19

   

   

            false

            "        
   0 
   0    EXTENSION plpgsql    COMMENT 
    @   COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
20     

   

   

            false 
   1

            Ж            1259    16616    album    TABLE     ¦   CREATE TABLE public.album (
21    id integer NOT NULL,
22    title_album character varying(255) NOT NULL,
23    id_artist integer NOT NULL,
24    year_album date NOT NULL
25);
26    DROP TABLE public.album;
27

       public         postgres    false 
   6

            З            1259    16621    album_track    TABLE     ¬   CREATE TABLE public.album_track (
28    id integer NOT NULL,
29    id_song integer NOT NULL,
30    id_album integer NOT NULL,
31    number_track character varying(255) NOT NULL
32);
33    DROP TABLE public.album_track;
34

       public         postgres    false 
   6

            Е            1259    16608    artists    TABLE     k
  CREATE TABLE public.artists (
35    id integer NOT NULL,
36    stage_name character varying(255) NOT NULL,
37    first_name character varying(255),
38    last_name character varying(255) NOT NULL,
39    "group" character varying(255) NOT NULL,
40    birthday date NOT NULL,
41    gender character varying(10) NOT NULL,
42    about text NOT NULL,
43    id_genre integer NOT NULL
44);
45    DROP TABLE public.artists;
46

       public         postgres    false 
   6

            Д            1259    16603    genres    TABLE     h   CREATE TABLE public.genres (
47    id integer NOT NULL,
48    name_genre character varying(255) NOT NULL
49);
50    DROP TABLE public.genres;
51

       public         postgres    false 
   6

            К            1259    16639    music    TABLE     t   CREATE TABLE public.music (
52    id integer NOT NULL,
53    id_user integer NOT NULL,
54    id_track integer NOT NULL
55);
56    DROP TABLE public.music;
57

       public         postgres    false 
   6

            И            1259    16626    tracks    TABLE     ќ   CREATE TABLE public.tracks (
58    id integer NOT NULL,
59    title_track character varying(255) NOT NULL,
60    duration_track character varying(255) NOT NULL
61);
62    DROP TABLE public.tracks;
63

       public         postgres    false 
   6

            Й            1259    16634    user    TABLE     а   CREATE TABLE public."user" (
64    id integer NOT NULL,
65    name character varying(50) NOT NULL,
66    login character varying(30) NOT NULL,
67    password character varying(30) NOT NULL,
68    age character varying(50) NOT NULL
69);
70    DROP TABLE public."user";
71

       public         postgres    false 
   6

               
    
   0    16616    album 
72   TABLE DATA              

       public

       postgres    false    198

   ’#          
    
   0    16621    album_track 
73   TABLE DATA              

       public

       postgres    false    199

   %          
    
   0    16608    artists 
74   TABLE DATA              

       public

       postgres    false    197

   Э&          
    
   0    16603    genres 
75   TABLE DATA              

       public

       postgres    false    196

   Ј(          
    
   0    16639    music 
76   TABLE DATA              

       public

       postgres    false    202

   v)          
    
   0    16626    tracks 
77   TABLE DATA              

       public

       postgres    false    200

    *          
    
   0    16634    user 
78   TABLE DATA              

       public

       postgres    false    201

   В-       ‹
79           2606    16620    album album_pk 
80   CONSTRAINT     L   ALTER TABLE ONLY public.album
81    ADD CONSTRAINT album_pk PRIMARY KEY (id);
82 8   ALTER TABLE ONLY public.album DROP CONSTRAINT album_pk;
83

       public         postgres    false    198

            Ќ
84           2606    16625    album_track album_track_pk 
85   CONSTRAINT     X   ALTER TABLE ONLY public.album_track
86    ADD CONSTRAINT album_track_pk PRIMARY KEY (id);
87 D   ALTER TABLE ONLY public.album_track DROP CONSTRAINT album_track_pk;
88

       public         postgres    false    199

            ‰
89           2606    16615    artists artists_pk 
90   CONSTRAINT     P   ALTER TABLE ONLY public.artists
91    ADD CONSTRAINT artists_pk PRIMARY KEY (id);
92 <   ALTER TABLE ONLY public.artists DROP CONSTRAINT artists_pk;
93

       public         postgres    false    197

            ‡
94           2606    16607    genres genres_pk 
95   CONSTRAINT     N   ALTER TABLE ONLY public.genres
96    ADD CONSTRAINT genres_pk PRIMARY KEY (id);
97 :   ALTER TABLE ONLY public.genres DROP CONSTRAINT genres_pk;
98

       public         postgres    false    196

            “
99           2606    16643    music music_pk 
100   CONSTRAINT     L   ALTER TABLE ONLY public.music
101    ADD CONSTRAINT music_pk PRIMARY KEY (id);
102 8   ALTER TABLE ONLY public.music DROP CONSTRAINT music_pk;
103

       public         postgres    false    202

            Џ
104           2606    16633    tracks tracks_pk 
105   CONSTRAINT     N   ALTER TABLE ONLY public.tracks
106    ADD CONSTRAINT tracks_pk PRIMARY KEY (id);
107 :   ALTER TABLE ONLY public.tracks DROP CONSTRAINT tracks_pk;
108

       public         postgres    false    200

            ‘
109           2606    16638    user user_pk 
110   CONSTRAINT     L   ALTER TABLE ONLY public."user"
111    ADD CONSTRAINT user_pk PRIMARY KEY (id);
112 8   ALTER TABLE ONLY public."user" DROP CONSTRAINT user_pk;
113

       public         postgres    false    201

            •
114           2606    16649    album album_fk0 
115   FK CONSTRAINT     r   ALTER TABLE ONLY public.album
116    ADD CONSTRAINT album_fk0 FOREIGN KEY (id_artist) REFERENCES public.artists(id);
117 9   ALTER TABLE ONLY public.album DROP CONSTRAINT album_fk0;
118

       public

       postgres    false    197    2697    198

            –
119           2606    16654    album_track album_track_fk0 
120   FK CONSTRAINT     {   ALTER TABLE ONLY public.album_track
121    ADD CONSTRAINT album_track_fk0 FOREIGN KEY (id_song) REFERENCES public.tracks(id);
122 E   ALTER TABLE ONLY public.album_track DROP CONSTRAINT album_track_fk0;
123

       public

       postgres    false    200    199    2703

            —
124           2606    16659    album_track album_track_fk1 
125   FK CONSTRAINT     {   ALTER TABLE ONLY public.album_track
126    ADD CONSTRAINT album_track_fk1 FOREIGN KEY (id_album) REFERENCES public.album(id);
127 E   ALTER TABLE ONLY public.album_track DROP CONSTRAINT album_track_fk1;
128

       public

       postgres    false    2699    198    199

            ”
129           2606    16644    artists artists_fk0 
130   FK CONSTRAINT     t   ALTER TABLE ONLY public.artists
131    ADD CONSTRAINT artists_fk0 FOREIGN KEY (id_genre) REFERENCES public.genres(id);
132 =   ALTER TABLE ONLY public.artists DROP CONSTRAINT artists_fk0;
133

       public

       postgres    false    196    197    2695

            ˜
134           2606    16664    music music_fk0 
135   FK CONSTRAINT     o   ALTER TABLE ONLY public.music
136    ADD CONSTRAINT music_fk0 FOREIGN KEY (id_user) REFERENCES public."user"(id);
137 9   ALTER TABLE ONLY public.music DROP CONSTRAINT music_fk0;
138

       public

       postgres    false    202    2705    201

            ™
139           2606    16674    music music_fk2 
140   FK CONSTRAINT     p   ALTER TABLE ONLY public.music
141    ADD CONSTRAINT music_fk2 FOREIGN KEY (id_track) REFERENCES public.tracks(id);
142 9   ALTER TABLE ONLY public.music DROP CONSTRAINT music_fk2;
143

       public

       postgres    false    2703    200    202

           
    q
  xњµ”Qo‚0…ЯэчijBMoQDчDў‹F§Ft†'ѓЪ№&”™эыµиpѕУЗ¶ЙэТsО=У…?^o`єШ,!-‘8vВиP|BKњ,ђBF|_^X Nы0“"—ьр0»^·бН›oЗ>ґР‚¦w.r	Ј¦®:1ЉЎ.A§Щ~nLk#15{AЄ7…bW”KhЏ [/КVі_—+ћеI*ћ}е
144нДzyЭЉЧW¤^Ib”PFXН$={’¤vIќ¬[ЙhZ3МСЯJвDaрѓ”0»^Lя/О/\GГ1˜Bч›”¤ѕБґUA0ЃTvP±€фЊiїЁБ"ЮhC’">ГK’спRPDѓyDЭ#o={ЪMзЈ»¤FR‰є0.ЮlЫUµ †фФKјс9иEкъP–ЙЏ{!љЇ¬Ћ0ЗЄўI§7Шя*ВЊГ6Х>ХO·‡
145;Dвќ?А*
146Ќ_РБAЅ     
    є
  xњµ—НJBQ…з>ЕћҐp€О=зx•F
147aђЦ4R#$µ°|яЦ:?opмеc±q№ЅЛХzсј±еjуd?Чнс°»}?nЇ§·їЛыоЛЖ‡ЅіГюнчыь™_д7ќќЇ§нЗҐ|hbЇЏ/‹µЌЅі27юfr?Zйоњ•ёѓі2wtVFаNОКЬSgeоЮYЃ{ж¬ЊА=wVFацwhNEЎg1+
148=ЉЩPиСН†BЏz6z4ґЎРЈ¤
149…=m(фЁjCЎG[3°wГ%”5Ј±#4	;ПiWN“АЋР$iмM¦;B“^cGh2УШљМ5v„&щH	фHMј¦­
©‰ЧФ5°Єѕ)Ѓ©‰Ч6рpЁGJ Gjв5•
150HMј¦і
©‰Ч”6 5бЧ>oGhТiмиkFbЏЁkFcЗВIТШy\»r¤v,њф;џYc9R;Nж;Nт‘и±qв5mЌX9сљєFмњxM_vNј¦°‰eххH	фШ9сљК&юхH	ф±<Њр{‡·§ъ”ЩkфхВЌЅ/?фSЌЅXfOГЫ[cc?э•ҐЉ     
    ¶
  xњЕ•ЛnВ0Eч|…Х
151Er*;бuХЄ•ЂЁЉФ2Д
152†$F‰іаплIў6
153РЗКRдguошОМxж?z4ћ-жиђЇ#±№a©™КРµ0Кщ*a1Зи]¤™Єт€}¦Wa*уГFk‘ЄmАЋ…<	xЉ[Л\a$‚•ю“тZЮ=ї>ъиљbФц¦m}>‰ВЊЕ;)Hп>кє]‹ёµбі€CЬд
154"нЬ¶ЖfРmM1©‘ы\оwўAnkl‹tлд(‘
155Uш¶9|ђЃgZ2їйЄ‡в;Ѕcэ№gко˜пBЭGА2Й“вHfrв]ъбт®9т0fai
<qУ1=‹‹:—У3‡ЯЧ(ЛљбЊoЏХ|г·-‡Фщ·,	2CЮ7‡?Ђz?UзеЂ
ямeУ:6„^zЂЃ9CЌrж™BяoЬє†Ў9
156о§ЗV$’‚n)7,ъјЭ‹p$d6ЎZHїСсQџ®9”4рЅ)F…¦r0UПГo¤Њ`s\]”ћ”ЬЗеdZвІG~–P-_bP¬Я№Ътф+эUG«х
»Qёв     
    Г   xњҐТM‚0а=§˜ђ#юW*$b
157 [Ґ‘Fh	mpz7°l'y_:уD‰§Dй™WН>˜¶˜ѓE
158hVгч8°бuј=э,Ч
УчBУ>Бяй…JЗ}!”њ Md©ђkЦчљс•Љ{2з7љВzШўмDYCF8UsMjЈЁЈ’2M`«Ђ3“TґЭ¤Јо†^+ЊD«ы’Ѕ  Б0T¬©ёsЕ<X3iwшҐТ@ЙЖЋ
159гЦдX     
    
  xњ­–±jГ0Ew…ЖBЙ{OЋ:eИ`()4iЧТ:LS(IэяҐє†о=
160љ–осУmч‡ЭУ1µыгcъЮ/}wч9Ьъ.НъУ"х§Чбvѕ–Нчх­ы˜§—нГуођf¶Hїk~_µяExAd‚€‚XD.€† к‚XДЉ_gГЇs-bl
161#В–b PL†f‘ЈБЋ#KЭDћRДdЄЎЂM®:ѓИVgЗ‘ЇОТ‘°(—°V#И(,ызгМеk Ђ]ѕЦK‘ЇБ ЈЇ,њ†Џ5—®Б–®Ѕy!_ќAl‚aтe1A‘И|
162„luфуЕh+R>Ю‹B¶Є5±™  ЌmЂAl‚§";—$З_ѕUххfg     
      xњµ˜MoЪ@†пщУK“HQjпЪ$qХѓ!¤ЎБЂ°iФSµ
163¬0^kЅND}wьС€ыDв ЮЩќ™зќ±'іtјМ`2ЛжPЦrхrmЌxЩWpЎЦW`•Непжџ+XЧFXҐ‹цч%ьЊ§«q
164юњЗЫєІpоѕт(О/їћM¤™УK5l„
с&Ћ(?€<ЏJћ;ЅDнЌЮлк +”чBэА	>кѓм„йт:Бg	±‘0¬у\ЪТhЅЃ…ЅfM,щЄX'8)¬4yЅnoryњJэЖ	О®зэ©o©toќаиXо¤Б¬шќ>»ЈТїs‚™>hcф[#О"ЏQ‰ыћSьQКNЩчЙ”Ц©ґђHx*єЈу€Яђ@d—BќrH“ЏґІаЛН·G)^eЂ“Aе#®S­чc~єЬ^ ©ќАLК5¬ИЅЖ4f“Ї±ґ™ЪоlЯ<dLщkў_{?уйЏё>hїtЭХ5 30Y]ЦmГ„#Г”!¦ГЪ:oЬдЗ.)Њ%†¬>пD®d
!л;†¬њQЌk[
165˜"RU—zЏо
166Иlк¤!“w<kЗk]I˜o`$Мъ.ЂМ>(#й«;hЬЖҐ&ЭiK>µYЛjQ№жмќ’.у€л“чк’Ь
167Ш]›t·QNЯЭ†.х№ќ*INo¦«®,yJ8ІљДIЬ»#ЩЖщы¦ђЇI<8ЩГЂGр¤ЬВjИ]ћ‡'‘X™QҐ=ѕмъ2Ухў;.U®·µЊpf[pУKѕvч"mVy˜kЅ†фM
168џ!“ВфVРBЁпgя;ЊЋ
169Дy(НО¦»ЅЉІт
вјPn«ZЁт:+@Є“ЙоMgvОKЙ–€ Й™ceEiї’“>…тnзя®йµ‘п±—пNM№aa?$с·пњђМы9.JQDA>
170$wѕК–уЁA–>щHм|FџuЦ)аБТTєдѓ!фЪWвфFv'aм––Bддх‘дХчЗOдµ›щ¬uAfЮ.6n|¦J\ћ”ыммЏЛЏ     
    Щ   xњ­Т=В0аЅївp9…"$iлаўѓCAьЪЈЖM[M-ю}Smсp5Уы’боHєXПVH›%ЬкЅС‡aЇ®”нA_C(d®B0e¦‹nІЄћҐuП2SШMзЫЩъ,<i%ve’Km†¶nоOЕёhз8йя wГr}UШж'8ыxВ“'ЮЋ‘Ш&хШw?–xт"7мRћl“z‚ЬУ—»a'[Vм
171#ІўрuТ¤щ*uЎ±M
172ЖЊbOаИ
173Л¤UGм
174%Bт7/щ˜ић