-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase old backup.sql
More file actions
1703 lines (1373 loc) · 127 KB
/
database old backup.sql
File metadata and controls
1703 lines (1373 loc) · 127 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
create table "albums" (
"album_id" serial primary key,
"album_name" varchar(64) not null,
"release_year" int not null);
create table "songs" (
"song_id" serial primary key,
"song_name" varchar(64) not null,
"album_id" int not null,
"song_lyrics" text not null,
);
create table "lyrics_fragments" (
"fragment_id" serial primary key,
"fragment_text" text not null,
"song_id" int not null
);
create table "context_data" (
"context_id" serial primary key,
"location_ref" varchar(64) default 'null',
"music_lit_ref" varchar(64) default 'null',
"theme" varchar(64) default null,
"chords" varchar(64) default null,
"song_id" int default null,
"fragment_id" default null
);
alter table "context_data" alter column "theme" drop not null;
alter table "context_data" alter column "chords" drop not null;
alter table "context_data" alter column "song_id" drop not null;
alter table "context_data" alter column "fragment_id" drop not null;
create table "users" (
"user_id" serial primary key,
"username" varchar(64) not null,
"salted hash" varchar(64) not null unique
);
create table "user_creations" (
"content_id" serial primary key,
"content_name" varchar(64) not null,
"content_text" text not null,
"user_id" int not null
);
create table "saved_fragments" (
"fragment_id" serial primary key,
"user_id" int not null
);
alter table "songs" add constraint "songs_fk0" foreign key ("album_id") references "albums"("album_id");
alter table "lyrics_fragments" add constraint "lyrics_fragments_fk0" foreign key ("song_id") references "songs"("song_id");
alter table "context_data" add constraint "context_data_fk0" foreign key ("song_id") references "songs"("song_id");
alter table "context_data" add constraint "context_data_fk1" foreign key ("fragment_id") references "lyrics_fragments"("fragment_id");
alter table "user_creations" add constraint "user creations_fk0" foreign key ("user_id") references "users"("user_id");
alter table "saved_fragments" add constraint "saved fragments_fk0" foreign key ("fragment_id") references "lyrics_fragments"("fragment_id");
alter table "saved_fragments" add constraint "saved_fragments_fk1" foreign key ("user_id") references "users"("user_id");
select * from albums;
select * from songs;
select * from albums join songs on albums.album_id = songs.album_id;
select * from albums join songs on albums.album_id = songs.album_id join lyrics_fragments on songs.song_id = lyrics_fragments.song_id;
select * from albums join songs on albums.album_id = songs.album_id join lyrics_fragments on songs.song_id = lyrics_fragments.song_id;
join context_data on lyrics_fragments.fragment_id = context_data.fragment_id;
select * from users join user_creations on users.user_id = user_creations.user_id join saved_fragments on users.user_id = saved_fragments.user_id;
insert into "albums" ("album_name", "release_year") values ('Born to Run', 1975);
insert into "albums" ("album_name", "release_year") values ('The River', 1980);
insert into "albums" ("album_name", "release_year") values ('Nebraska', 1982);
insert into "albums" ("album_name", "release_year") values ('Born in the USA', 1984);
insert into "albums" ("album_name", "release_year") values ('Greetings from Asbury Park, NJ', 1973);
insert into "albums" ("album_name", "release_year") values ('The Wild, the Innocent, & the E Street Shuffle', 1973);
insert into "albums" ("album_name", "release_year") values ('Darkness at thte Edge of Town', 1978);
alter table "lyrics_fragments" add column song_id int;
insert into "songs" ("song_name", "album_id", "song_lyrics") values ('Born in the USA', 7, 'Born down in a dead man''s town
The first kick I took was when I hit the ground
You end up like a dog that''s been beat too much
Till you spend half your life just covering up
Born in the USA, I was born in the USA
I was born in the USA, born in the USA
Got in a little hometown jam
So they put a rifle in my hand
Sent me off to a foreign land
To go and kill the yellow man
Born in the USA...
Come back home to the refinery
Hiring man said "Son if it was up to me"
Went down to see my V.A. man
He said "Son, don''t you understand"
I had a brother at Khe Sahn
Fighting off the Viet Cong
They''re still there, he''s all gone
He had a woman he loved in Saigon
I got a picture of him in her arms now
Down in the shadow of the penitentiary
Out by the gas fires of the refinery
I''m ten years burning down the road
Nowhere to run ain''t got nowhere to go
Born in the USA, I was born in the USA
Born in the USA, I''m a long gone Daddy in the USA
Born in the USA, Born in the USA
Born in the USA, I''m a cool rocking Daddy in the USA'),
('Cover Me', 7, 'The times are tough now, just getting tougher
This old world is rough, it''s just getting rougher
Cover me, come on baby, cover me
Well I''m looking for a lover who will come on in and cover me
Promise me baby you won''t let them find us
Hold me in your arms, let''s let our love blind us
Cover me, shut the door and cover me
Well I''m looking for a lover who will come on in and cover me
Outside''s the rain, the driving snow
I can hear the wild wind blowing
Turn out the light, bolt the door
I ain''t going out there no more
This whole world is out there just trying to score
I''ve seen enough I don''t want to see any more,
Cover me, come on and cover me
I''m looking for a lover who will come on in and cover me
Looking for a lover who will come on in and cover me'),
('Darlington County', 7, 'Driving into Darlington County
Me and Wayne on the Fourth of July
Driving into Darlington County
Lookin'' for some work on the county line
We drove down from New York City
Where the girls are pretty but they just wanna know your name
Driving into Darlington City
Got a union connection with an uncle of Wayne''s
We drove eight hundred miles without seeing a cop
We got rock''n''roll music blasting off the t top
Singing sha la la, sha la la la la la
sha la la la la la la
sha la la, sha la la la la la
sha la la la la la la
Hey little girl, standing on the corner
Today''s your lucky day for shure, all right
Me and my buddy, we''re from New York City
We got two hundred dollars, we want to rock all night
Girl, you''re lookin'' at two big spenders
Why, the world don''t know what me and Wayne might do
Our pa''s each own one of the World Trade Centers
For a kiss and a smile I''ll give mine all to you
C''mon baby, take a seat on the fender, it''s a long night
Tell me, what else were you gonna do?
Just me and you, we could ...
Singing sha la la, sha la la la la la
sha la la la la la la
sha la la, sha la la la la la
sha la la la la la la
Little girl, sittin'' in the window
Ain''t seen my buddy in seven days
County man tells me the same thing
He don''t work, and he don''t get paid
Little girl, you''re so young and pretty
Walk with me and you can have your way
Then we''ll leave this Darlington City
For a ride down that Dixie Highway
Singing sha la la, sha la la la la la
sha la la la la la la
sha la la, sha la la la la la
sha la la la la la la
Driving out of Darlington County
My eyes seen the glory of the coming Lord
Driving out of Darlington County
Seen Wayne handcuffed to the bumper of a state trooper''s Ford
Singing sha la la, sha la la la la la
sha la la la la la la
sha la la, sha la la la la la
sha la la la la la la'),
('Working on the Highway', 7, 'Friday night''s pay night guys fresh out of work
Talking about the weekend scrubbing off the dirt
Some heading home to their families some looking to get hurt
Some going down to Stovell wearing trouble on their shirts
I work for the county out on 95
All day I hold a red flag and watch the traffic pass me by
In my head I keep a picture of a pretty little miss
Someday mister I''m gonna lead a better life than this
Working on the highway laying down the blacktop
Working on the highway all day long I don''t stop
Working on the highway blasting through the bedrock
Working on the highway, working on the highway
I met her at a dance down at the union hall
She was standing with her brothers back up against the wall
Sometimes we''d go walking down the union tracks
One day I looked straight at her and she looked straight back
Working on the highway...
I saved up my money and I put it all away
I went to see her daddy but we didn''t have much to say
"Son can''t you see that she''s just a little girl
She don''t know nothing about this cruel cruel world"
We lit out down to Florida we got along all right
One day her brothers came and got her and they took me in a black and white
The prosecutor kept the promise that he made on that day
And the judge got mad and he put me straight away
I wake up every morning to the work bell clang
Me and the warden go swinging on the Charlotte County road gang
Working on the highway...'),
('Downbound Train', 7, 'I had a job, I had a girl
I had something going, mister, in this world
I got laid off down at the lumber yard
Our love went bad, times got hard
Now I work down at the car wash
Where all it ever does is rain
Don''t you feel like you''re a rider on a downbound train
She just said, "Joe, I gotta go
We had it once, we ain''t got it anymore"
She packed her bags, left me behind
She bought a ticket on the Central Line
Nights as I sleep, I hear that whistle whining
I feel her kiss in the misty rain
And I feel like I''m a rider on a downbound train
Last night I heard your voice
You were crying, crying, you were so alone
You said your love had never died
You were waiting for me at home
Put on my jacket, I ran through the woods
I ran till I thought my chest would explode
There in the clearing, beyond the highway
In the moonlight, our wedding house shone
I rushed through the yard
I burst through the front door, my head pounding hard
Up the stairs I climbed
The room was dark, our bed was empty
Then I heard that long whistle whine
And I dropped
to my knees
hung my head and cried
Now I swing a sledge hammer on a railroad gang
Knocking down them cross ties, working in the rain
Now, don''t it feel like you''re a rider on a downbound train'),
('I''m on Fire', 7, 'Hey little girl, is your daddy home?
Did he go away and leave you all alone? Mhmm
I got a bad desire
Oh oh oh, I''m on fire
Tell me now, baby, is he good to you?
And can he do to you the things that I do? Oh no
I can take you higher
Oh oh oh, I''m on fire
Sometimes it''s like someone took a knife, baby
Edgy and dull and cut a six inch valley
Through the middle of my skull
At night I wake up with the sheets soaking wet
And a freight train running through the middle of my head
Only you can cool my desire
Oh oh oh, I''m on fire
Oh oh oh, I''m on fire
Oh oh oh, I''m on fire
Woo ooh ooh
Woo ooh ooh
Ooh ooh ooh
Woo ooh ooh
Woo ooh ooh'),
('No Surrender', 7, 'Well, we busted out of class
Had to get away from those fools
We learned more from a three-minute record, baby
Than we ever learned in school
Tonight I hear the neighborhood drummer sound
I can feel my heart begin to pound
You say you''re tired and you just want to close your eyes
And follow your dreams down
Well, we made a promise we swore we''d always remember
No retreat, baby, no surrender
Like soldiers in the winter''s night with a vow to defend
No retreat, baby, no surrender
Well, now young faces grow sad and old
And hearts of fire grow cold
We swore blood brothers against the wind
Now I''m ready to grow young again
And hear your sister''s voice calling us home
Across the open yards
Well maybe we''ll cut someplace of our own
With these drums and these guitars
''Cause we made a promise we swore we''d always remember
No retreat, baby, no surrender
Blood brothers in the stormy night with a vow to defend
No retreat, baby, no surrender
Now on the street tonight the lights grow dim
The walls of my room are closing in
There''s a war outside still raging
You say it ain''t ours anymore to win
I want to sleep beneath
Peaceful skies in my lover''s bed
With a wide open country in my eyes
And these romantic dreams in my head
Once we made a promise we swore we''d always remember
No retreat, baby, no surrender
Blood brothers in a stormy night with a vow to defend
No retreat, baby, no surrender
No retreat, baby, no surrender'),
('Bobby Jean', 7, 'Well I came by your house the other day
Your mother said you went away
She said there was nothing that I could have done
There was nothing nobody could say
Now me and you we''ve known each other
Ever since we were sixteen
I wished I would have known
I wished I could have called you
Just to say goodbye
Bobby Jean
Now you hung with me when all the others
Turned away turned up their nose
We like the same music we like the same bands
We like the same clothes
We told each other that we were the wildest
The wildest things we''d ever seen
Now I wished I could have talked to you
Just to say goodbye Bobby Jean
Now we went walking in the rain talking about the pain
From the world we hid
Now there ain''t nobody nowhere nohow gonna ever understand me
They way you did
Maybe you''ll be out there on that road somewhere
In some bus or train traveling along
In some motel room there''ll be a radio playing
And you''ll hear me sing this song
Well if you do you''ll know I''m thinking of you
And all the miles in between
And I''m just calling one last time
Not to change your mind
But just to say I miss you baby
Good luck, goodbye
Bobby Jean'),
('I''m Going Down', 7, 'We sit in the car outside your house
I can feel the heat coming ''round
I go to put my arm around you
And you give me a look like I''m way out of bounds
Well you let out one of your bored sighs
Well lately when I look into your eyes
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
We get dressed up and we go out, baby, for the night
We come home early burning, burning, burning in some firefight
I''m sick and tired of you setting me up yeah
Setting me up just to knock-a knock-a knock-a me down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down, hey now
I pull you close now baby
But when we kiss I can feel a doubt
I remember back when we started
My kisses used to turn you inside out
I used to drive you to work in the morning
Friday night I''d drive you all around
You used to love to drive me wild yeah
But lately girl you get your kicks from just driving me down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, down, down, down
I''m goin down, hey bopa d-d-down
I''m goin down, down, down, down
I''m goin down, hey bopa d-d-down
I''m goin down, down, down, yeah
I''m goin down, down, hey bopa hey bopa
Hey hey mmm bopa bopa well down
Hey babe mmm bopa bopa said down
Hey hey mmm bopa bopa well down
Hey hey mmm bopa bopa say
Hey unh say down, down, down, down, down
Hey down now, say down, down, down, down, down'),
('Glory Days', 7, 'I had a friend was a big baseball player back in high school
he could throw that speedball by you
Make you look like a fool
Saw him the other night at this roadside bar I was walking in
And he was walking out
We went back inside sat down
Had a few drinks but all he kept talking about was
Glory days well they''ll pass you by
Glory days in the wink of a young girl''s eye
Glory days, glory days
There''s a girl that lives up the block
back in school
She could turn all the boys'' heads
Sometimes on a Friday I''ll stop by and have a few drinks
After she put her kids to bed
Her and her husband Bobby well they split up
I guess it''s two years gone by now
We just sit around talking about the old times, she says
when she feels like crying she starts laughing thinking about
Glory days well they''ll pass you by
Glory days in the wink of a young girl''s eye
Glory days
Glory days
Think I''m going down to the well tonight
And I''m going to drink till I get my fill
And I hope when I get old I don''t sit around thinking about it
But I probably will
Yeah just sitting back trying to recapture a little of the glory of
But time slips away and leaves you with nothing mister
But boring old stories of glory days
Glory days well they''ll pass you by
Glory days in the wink of a young girl''s eye
Glory days, glory days'),
('Dancing in the Dark', 7, 'I get up in the evening
And I ain''t got nothing to say
I come home in the morning
I go to bed feeling the same way
I ain''t got nothing but tired
Man I''m just tired and bored with myself
Hey there baby I could use just a little help
You can''t start a fire
You can''t start a fire without a spark
This gun''s for hire
Even if we''re just dancing in the dark
Message keeps getting clearer
Radio''s on and I''m moving ''round the place
I check my look in the mirror
I wanna change my clothes, my hair, my face
Man I ain''t getting nowhere just living in a dump like this
There''s something happening somewhere
Baby I just know that there is
You can''t start a fire
You can''t start a fire without a spark
This gun''s for hire
Even if we''re just dancing in the dark
You sit around getting older
There''s a joke here somewhere and it''s on me
I''ll shake this world off my shoulders
Come on now baby the laugh''s on me
Stay on the streets of this town
And they''ll be carving you up all right
They say you gotta stay hungry
Hey baby I''m just about starving tonight
I''m dying for some action
I''m sick of sitting ''round here trying to write this book
I need a love reaction
Come on now baby gimme just one look
You can''t start a fire
Sitting ''round crying over a broken heart
This gun''s for hire
Even if we''re just dancing in the dark
You can''t start a fire
Worrying about your little world falling apart
This gun''s for hire
Even if we''re just dancing in the dark'),
('My Hometown', 7, 'I was eight years old and running with a dime in my hand
To the bus stop to pick up a paper for my old man
I''d sit on his lap
In that big old Buick
And steer as we drove through town
He''d tousle my hair
And say son take a good look around
This is your hometown
This is your hometown
This is your hometown
This is your hometown
In ''65 tension was running high at my high school
There was a lot of fights between the black and white
There was nothing you could do
Two cars at a light
On a Saturday night
In the back seat there was a gun
Words were passed
In a shotgun blast
Troubled times had come to my hometown
My hometown
My hometown
My hometown
Now Main Street''s whitewashed windows and vacant stores
Seems like there ain''t nobody wants to come down here no more
They''re closing down the textile mill across the railroad tracks
Foreman says these jobs are going boys and they ain''t coming back
To your hometown
Your hometown
Your hometown
Your hometown
Last night me and Kate we laid in bed
Talking about getting out
Packing up our bags maybe heading south
I''m thirty-five, we got a boy of our own now
Last night I sat him up behind the wheel
And said son take a good look around
This is your hometown');
insert into "songs" ("song_name", "album_id", "song_lyrics") values
('Thunder Road', 3,
'The screen door slams
Mary''s dress sways
Like a vision she dances across the porch
As the radio plays
Roy Orbison singing for the lonely
Hey that''s me and I want you only
Don''t turn me home again
I just can''t face myself alone again
Don''t run back inside, darling
You know just what I''m here for
So you''re scared and you''re thinking
That maybe we ain''t that young anymore
Show a little faith, there''s magic in the night
You ain''t a beauty, but hey you''re alright
Oh and that''s alright with me
You can hide ''neath your covers
And study your pain
Make crosses from your lovers
Throw roses in the rain
Waste your summer praying in vain
For a savior to rise from these streets
Well now I''m no hero
That''s understood
All the redemption I can offer, girl,
Is beneath this dirty hood
With a chance to make it good somehow
Hey what else can we do now
Except roll down the window
And let the wind blow back your hair
Well the night''s busting open
These two lanes will take us anywhere
We got one last chance to make it real
To trade in these wings on some wheels
Climb in back
Heaven''s waiting on down the tracks
Oh-oh come take my hand
We''re riding out tonight to case the promised land
Oh-oh Thunder Road
Oh Thunder Road
Oh Thunder Road
Lying out there like a killer in the sun
Hey I know it''s late we can make it if we run
Oh Thunder Road
Sit tight
Take hold
Thunder Road
Well I got this guitar
And I learned how to make it talk
And my car''s out back
If you''re ready to take that long walk
From your front porch to my front seat
The door''s open but the ride it ain''t free
And I know you''re lonely
For words that I ain''t spoken
But tonight we''ll be free
All the promises''ll be broken
There were ghosts in the eyes
Of all the boys you sent away
They haunt this dusty beach road
In the skeleton frames of burned out Chevrolets
They scream your name at night in the street
Your graduation gown lies in rags at their feet
And in the lonely cool before the dawn
You hear their engines roaring on
But when you get to the porch they''re gone
On the wind
So Mary climb in
It''s a town full of losers
We''re pulling out of here to win'),
('Tenth Avenue Freeze-out', 3,
'Tear drops on the city
Bad Scooter searching for his groove
Seem like the whole world walking pretty
And you can''t find the room to move
Well everybody better move over, that''s all
I''m running on the bad side
And I got my back to the wall
Tenth Avenue freeze-out, Tenth Avenue freeze-out
I''m stranded in the jungle
Taking all the heat they was giving
The night is dark but the sidewalk''s bright
And lined with the light of the living
From a tenement window a transistor blasts
Turn around the corner things got real quiet real fast
She hit me with a Tenth Avenue freeze-out
Tenth Avenue freeze-out
And I''m all alone, I''m all alone
And kid you better get the picture
And I''m on my own, I''m on my own
And I can''t go home
When the change was made uptown
And the Big Man joined the band
From the coastline to the city
All the little pretties raise their hands
I''m gonna sit back right easy and laugh
When Scooter and the Big Man bust this city in half
With a Tenth Avenue freeze-out, Tenth Avenue freeze-out
Tenth Avenue freeze-out...'),
('Born to Run', 3,
'In the day we sweat it out in the streets of a runaway American dream
At night we ride through mansions of glory in suicide machines
Sprung from cages out on Highway Nine
Chrome wheeled, fuel injected and steppin'' out over the line
Baby this town rips the bones from your back
It''s a death trap, it''s a suicide rap
We gotta get out while we''re young
''Cause tramps like us, baby we were born to run
Wendy let me in I wanna be your friend
I want to guard your dreams and visions
Just wrap your legs round these velvet rims
and strap your hands across my engines
Together we could break this trap
We''ll run till we drop, baby we''ll never go back
Will you walk with me out on the wire
''Cause baby I''m just a scared and lonely rider
But I gotta find out how it feels
I want to know if love is wild, girl I want to know if love is real
Beyond the Palace hemi-powered drones scream down the boulevard
The girls comb their hair in rearview mirrors
And the boys try to look so hard
The amusement park rises bold and stark
Kids are huddled on the beach in a mist
I wanna die with you Wendy on the streets tonight
In an everlasting kiss
The highway''s jammed with broken heroes on a last chance power drive
Everybody''s out on the run tonight but there''s no place left to hide
Together Wendy we''ll live with the sadness
I''ll love you with all the madness in my soul
Someday girl I don''t know when we''re gonna get to that place
Where we really want to go and we''ll walk in the sun
But till then, tramps like us baby we were born to run'),
('Night', 3,
'You get up every morning at the sound of the bell
You get to work late and the boss man''s giving you hell
Till you''re out on a midnight run
Losing your heart to a beautiful one
And it feels right as you lock up the house
Turn out the lights and step out into the night
And the world is busting at its seams
And you''re just a prisoner of your dreams
Holding on for your life ''cause you work all day
To blow ''em away in the night
The rat traps filled with soul crusaders
The circuits lined and jammed with chromed invaders
And she''s so pretty that you''re lost in the stars
As you jockey your way through the cars
And sit at the light, as it changes to green
With your faith in your machine off you scream into the night
And you''re in love with all the wonder it brings
And every muscle in your body sings as the highway ignites
You work nine to five and somehow you survive till the night
Hell all day they''re busting you up on the outside
But tonight you''re gonna break on through to the inside
And it''ll be right, it''ll be right, and it''ll be tonight
And you know she will be waiting there
And you''ll find her somehow you swear
Somewhere tonight you run sad and free
Until all you can see is the night'),
('She''s the One', 3,
'With her killer graces and her secret places
That no boy can fill with her hands on her hips
Oh and that smile on her lips
Because she knows that it kills me
With her soft french cream
Standing in that doorway like a dream
I wish she''d just leave me alone
Because french cream won''t soften them boots
And french kisses will not break that heart of stone
With her long hair falling
And her eyes that shine like a midnight sun
Oh-o she''s the one, she''s the one
That Thunder in your heart
At night when you''re kneeling in the dark
It says you''re never gonna leave her
But there''s this angel in her eyes
That tells such desperate lies
And all you want to do is believe her
And tonight you''ll try just one more time
To leave it all behind and to break on through
Oh she can take you, but if she wants to break you
She''s gonna find out that ain''t so easy to do
And no matter where you sleep tonight or how far you run
Oh-o she''s the one, she''s the one
Oh-o and just one kiss
She''d fill them long summer nights
With her tenderness that secret pact you made
Back when her love could save you from the bitterness
Oh she''s the one, oh she''s the one
Oh she''s the one, oh she''s the one
Oh she''s the one, oh she''s the one'),
('Meeting Across the River', 3,
'Hey, Eddie, can you lend me a few bucks
And tonight can you get us a ride
Gotta make it through the tunnel
Got a meeting with a man on the other side
Hey Eddie, this guy, he''s the real thing
So if you want to come along
You gotta promise you won''t say anything
''Cause this guy don''t dance
And the word''s been passed this is our last chance
We gotta stay cool tonight, Eddie
''Cause man, we got ourselves out on that line
And if we blow this one
They ain''t gonna be looking for just me this time
And all we gotta do is hold up our end
Here stuff this in your pocket
It''ll look like you''re carrying a friend
And remember, just don''t smile
Change your shirt, ''cause tonight we got style
Well Cherry says she''s gonna walk
''Cause she found out I took her radio and hocked it
But Eddie, man, she don''t understand
That two grand''s practically sitting here in my pocket
And tonight''s gonna be everything that I said
And when I walk through that door
I''m just gonna throw that money on the bed
She''ll see this time I wasn''t just talking
Then I''m gonna go out walking
Hey Eddie, can you catch us a ride?'),
('Backstreets', 3,
'One soft infested summer me and Terry became friends
Trying in vain to breathe the fire we was born in
Catching rides to the outskirts tying faith between our teeth
Sleeping in that old abandoned beach house getting wasted in the heat
And hiding on the backstreets, hiding on the backstreets
With a love so hard and filled with defeat
Running for our lives at night on them backstreets
Slow dancing in the dark on the beach at Stockton''s Wing
Where desperate lovers park we sat with the last of the Duke Street Kings
Huddled in our cars waiting for the bells that ring
In the deep heart of the night to set us loose from everything
to go running on the backstreets, running on the backstreets
We swore we''d live forever on the backstreets we take it together
Endless juke joints and Valentino drag where dancers scraped the tears
Up off the street dressed down in rags running into the darkness
Some hurt bad some really dying at night sometimes it seemed
You could hear the whole damn city crying blame it on the lies that killed us
Blame it on the truth that ran us down you can blame it all on me Terry
It don''t matter to me now when the breakdown hit at midnight
There was nothing left to say but I hated him and I hated you when you went away
Laying here in the dark you''re like an angel on my chest
Just another tramp of hearts crying tears of faithlessness
Remember all the movies, Terry, we''d go see
Trying to learn how to walk like heroes we thought we had to be
And after all this time to find we''re just like all the rest
Stranded in the park and forced to confess
To hiding on the backstreets, hiding on the backstreets
We swore forever friends on the backstreets until the end
Hiding on the backstreets, hiding on the backstreets'),
('Jungleland', 3,
'The rangers had a homecoming
In Harlem late last night
And the Magic Rat drove his sleek machine
Over the Jersey state line
Barefoot girl sitting on the hood of a Dodge
Drinking warm beer in the soft summer rain
The Rat pulls into town rolls up his pants
Together they take a stab at romance and disappear down Flamingo Lane
Well the Maximum Lawman run down Flamingo
Chasing the Rat and the barefoot girl
And the kids round here look just like shadows
Always quiet, holding hands
From the churches to the jails
Tonight all is silence in the world
As we take our stand
Down in Jungleland
The midnight gang''s assembled
And picked a rendezvous for the night
They''ll meet ''neath that giant Exxon sign
That brings this fair city light
Man there''s an opera out on the Turnpike
There''s a ballet being fought out in the alley
Until the local cops, Cherry Tops, rip this holy night
The street''s alive as secret debts are paid
Contacts made, they vanished unseen
Kids flash guitars just like switchblades
Hustling for the record machine
The hungry and the hunted explode into rock''n''roll bands
That face off against each other out in the street
Down in Jungleland
In the parking lot the visionaries dress in the latest rage
Inside the backstreet girls are dancing to the records that the D.J. plays
Lonely-hearted lovers struggle in dark corners
Desperate as the night moves on, just a look and a whisper, and they''re gone
Beneath the city two hearts beat
Soul engines running through a night so tender
In a bedroom locked come whispers of soft refusal and then surrender
In the tunnels uptown the Rat''s own dream guns him down
As shots echo down them hallways in the night
No one watches when the ambulance pulls away
Or as the girl shuts out the bedroom light
Outside the street''s on fire in a real death waltz
Between what''s flesh and what''s fantasy
And the poets down here don''t write nothing at all
They just stand back and let it all be
And in the quick of the night they reach for their moment
And try to make an honest stand
But they wind up wounded, not even dead
Tonight in Jungleland');
insert into "songs" ("song_name", "album_id", "song_lyrics") values ('The Ties That Bind', 5,
'You been hurt and you''re all cried out you say
You walk down the street pushin'' people outta your way
You packed your bags and all alone you wanna ride,
You don''t want nothin'', don''t need no one by your side
You''re walkin'' tough baby, but you''re walkin'' blind
[chorus]
The ties that bind
Now you can''t break the ties that bind
Cheap romance, it''s all just a crutch
You don''t want nothin'' that anybody can touch
You''re so afraid of being somebody''s fool
Not walkin'' tough baby, not walkin'' cool
You walk cool, but darlin'', can you walk the line
And face the ties that bind
The ties that bind
Now you can''t break the ties that bind
I would rather feel the hurt inside, yes I would darlin'',
Than know the emptiness your heart must hide,
Yes I would darlin'', yes I would darlin'',
Yes I would baby
You sit and wonder just who''s gonna stop the rain
Who''ll ease the sadness, who''s gonna quiet the pain
It''s a long dark highway and a thin white line
Connecting baby, your heart to mine
We''re runnin'' now but darlin'' we will stand in time
To face the ties that bind
The ties that bind
Now you can''t break the ties that bind
You can''t forsake the ties that bind'),
('Sherry Darling', 5,
'Your mama''s yappin'' in the back seat
Tell her to push over and move them big feet
Every Monday morning I gotta drive her down to the unemployment agency
Well this morning I ain''t fighting, tell her I give up
Tell her she wins if she''ll just shut up
But it''s the last time that she''s gonna be ridin'' with me
And you can tell her there''s a hot sun beatin'' on the blacktop
She keeps talkin'', she''ll be walkin'' that last block
She can take a subway back to the ghetto tonight
Well I got some beer and the highway''s free
And I got you, and baby you''ve got me
Hey hey hey, whataya say, Sherry Darlin''
Now there''s girls melting on the beach
And they''re so fine but so out of reach
Cause I''m stuck in traffic down here on 53rd street
Now Sherry my love for you is real
But I didn''t count on this package deal
And baby this car just ain''t big enough for her and me
[chorus]
Well let there be sunlight, let there be rain
Let the brokenhearted love again