########### Begin ALBUM
#INSERT INTO pseudonym (Name) values ("Miranda Sex Garden"); insert into project(name) values(null); insert into project_involvement (project_id, pseudonym_id) select project.id, pseudonym.id from project left join pseudonym on project.tag="new" && pseudonym.tag="new"; update pseudonym set tag="normal" where tag="new";

###### one or the other
INSERT INTO project (Name) values ("Miranda Sex Garden"); 

update project set tag="new" where name="Miranda Sex Garden";


INSERT into album (project_id) SELECT (id) FROM project where tag="new";

UPDATE album SET name="Iris" where tag="new";


insert into release (album_id, label_id) SELECT album.id, label.id from album join label where album.tag="new" &&

label.name="Mute";  


update release set 

media_type="cd"

#############################

#,name="",


where tag="new";


####### BEGIN TRACK

INSERT into song (project_id) select id from project where tag="new";

update song set

########################
name="Lovely Joan"

where tag="new";


insert into cut (song_id, project_id) select song.id, project.id from song join project where song.tag="new" && 

project.tag="new";
update cut set length="00:2:40"

#,name=""

where tag="new";

insert into track (cut_id, release_id) select cut.id, release.id from cut join release where cut.tag="new" && release.tag="new";

update track set 

disc_no=1,
number=1 where tag="new";


update song set tag="normal" where tag="new";

update cut set tag="normal" where tag="new";

update track set tag="normal" where tag="new";

######## END TRACK

####### BEGIN TRACK

INSERT into song (project_id) select id from project where tag="new";

update song set

########################
name="Falling"

where tag="new";


insert into cut (song_id, project_id) select song.id, project.id from song join project where song.tag="new" && 

project.tag="new";
update cut set length="00:5:39"

#,name=""

where tag="new";

insert into track (cut_id, release_id) select cut.id, release.id from cut join release where cut.tag="new" && release.tag="new";

update track set 

disc_no=1,
number=2 where tag="new";


update song set tag="normal" where tag="new";

update cut set tag="normal" where tag="new";

update track set tag="normal" where tag="new";

######## END TRACK

####### BEGIN TRACK

INSERT into song (project_id) select id from project where tag="new";

update song set

########################
name="Fear"

where tag="new";


insert into cut (song_id, project_id) select song.id, project.id from song join project where song.tag="new" && 

project.tag="new";
update cut set length="00:7:07"

#,name=""

where tag="new";

insert into track (cut_id, release_id) select cut.id, release.id from cut join release where cut.tag="new" && release.tag="new";

update track set 

disc_no=1,
number=3 where tag="new";


update song set tag="normal" where tag="new";

update cut set tag="normal" where tag="new";

update track set tag="normal" where tag="new";

######## END TRACK

####### BEGIN TRACK

INSERT into song (project_id) select id from project where tag="new";

update song set

########################
name="Blue Light"

where tag="new";


insert into cut (song_id, project_id) select song.id, project.id from song join project where song.tag="new" && 

project.tag="new";
update cut set length="00:6:30"

#,name=""

where tag="new";

insert into track (cut_id, release_id) select cut.id, release.id from cut join release where cut.tag="new" && release.tag="new";

update track set 

disc_no=1,
number=4 where tag="new";


update song set tag="normal" where tag="new";

update cut set tag="normal" where tag="new";

update track set tag="normal" where tag="new";

######## END TRACK

####### BEGIN TRACK

INSERT into song (project_id) select id from project where tag="new";

update song set

########################
name="Iris"

where tag="new";


insert into cut (song_id, project_id) select song.id, project.id from song join project where song.tag="new" && 

project.tag="new";
update cut set length="00:7:17"

#,name=""

where tag="new";

insert into track (cut_id, release_id) select cut.id, release.id from cut join release where cut.tag="new" && release.tag="new";

update track set 

disc_no=1,
number=5 where tag="new";


update song set tag="normal" where tag="new";

update cut set tag="normal" where tag="new";

update track set tag="normal" where tag="new";

######## END TRACK



update release set tag="normal" where tag="new";

update album set tag="normal" where tag="new";

update project set tag="normal" where tag="new";

########### END ALBUM