"""creat_raw_ccp_tables Revision ID: e02d69a05578 Revises: cc02d87147ce Create Date: 2021-10-18 09:21:07.804098 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = 'e02d69a05578' down_revision = 'c1b13db9e76a' branch_labels = None depends_on = None new_label_spaces=[ {"id": 45, "name": '5K Records UK', "external_name": '5K Records UK', "profit_centers": [ {"code": "UK1261", "name": "5K Distribution [UK1261] / Sony Music Ent. UK [STAT]"} ] }, {"id": 46, "name": 'Black Butter Records UK', "external_name": 'Black Butter Records UK', "profit_centers": [ {"code": "UK2111", "name": "Black Butter - Loc [UK2111] / Black Butter Limited"}, {"code": "UK2001", "name": "Black Butter - Loc Cata [UK2001] / Black Butter Limited"}, {"code": "UK2112", "name": "Black Butter - Int [UK2112] / Black Butter Limited"}, {"code": "UK2002", "name": "Black Butter - Int Cata [UK2002] / Black Butter Limited"} ] }, {"id": 47, "name": 'Columbia Records UK', "external_name": 'Columbia Records UK', "profit_centers": [ {"code": "UK1141", "name": "Columbia - International Cata [UK1141] / Sony Music Entertainment"}, {"code": "UK1151", "name": "Columbia - Local Cata [UK1151] / Sony Music Entertainment"}, {"code": "UK1150", "name": "Columbia - Local [UK1150] / Sony Music Entertainment"}, {"code": "UK1140", "name": "Columbia - International [UK1140] / Deconstruction Limited"}, ]}, {"id": 48, "name": 'Commercial Group UK', "external_name": 'Commercial Group UK', "profit_centers": [ {"code": "UK1320", "name": "Arista - Local [UK1320] / Sony Music Entertainment"}, {"code": "UK1370", "name": "Budget Campaigns - Local [UK1370] / Sony Music Entertainment"}, {"code": "UK1455", "name": "DVD [UK1455] / Sony Music Entertainment"}, {"code": "UK1310", "name": "Arista - International [UK1310] / Sony Music Entertainment"}, {"code": "UK1380", "name": "Mid Price Campaigns-Local [UK1380] / Blue Sky Music Limited"}, {"code": "UK1404", "name": "Low Full-International [UK1404] / Sony Music Entertainment"}, {"code": "UK1414", "name": "Jazz Catalogue - International [UK1414] / Sony Music Entertainment"}, {"code": "UK1062", "name": "Syco CMG - International Catalogue [UK1062] / Sony Music Entertainment"}, {"code": "UK1390", "name": "Full Price-Local [UK1390] / Sony Music Entertainment"}, {"code": "UK1400", "name": "Low Full-Local [UK1400] / Sony Music Entertainment"}, {"code": "UK1470", "name": "Solus Compilations [UK1470] / Sony Music Entertainment"}, {"code": "UK1396", "name": "Michael Jackson - Catalogue [UK1396] / Sony Music Entertainment"}, {"code": "UK1394", "name": "Full Price-International [UK1394] / Sony Music Entertainment"}, {"code": "UK1374", "name": "Budget Campaigns - International [UK1374] / Sony Music Entertainment"}, {"code": "UK1410", "name": "Jazz Catalogue - Local [UK1410] / Sony Music Entertainment"}, {"code": "UK1440", "name": "TV Projects - International [UK1440] / Sony Music Entertainment"}, {"code": "UK1382", "name": "Craig David Wildstar [UK1382] / Sony Music Entertainment"}, {"code": "UK1072", "name": "Syco CMG Local Catalogue [UK1072] / Sony Music Entertainment"}, {"code": "UK1384", "name": "Mid Price Campaigns-International [UK1384] / Sony Music Entertainment"}, {"code": "UK1430", "name": "TV Projects - Local [UK1430] / Deconstruction Limited"}, {"code": "UK1481", "name": "Comps Mid & Budget [UK1481] / Sony Music Entertainment"}, {"code": "UK5420", "name": "Dig Compression Pending [UK5420] / Sony Music Entertainment"}, ]}, {"id": 49, "name": 'Dreamlife Records UK', "external_name": 'Dreamlife Records UK', "profit_centers": [{"code": "UK2080", "name": "Dreamlife Local [UK2080] / Sony Music Entertainment"}] }, {"id": 50, "name": 'Insanity UK', "external_name": 'Insanity UK', "profit_centers": [ {"code": "UK2114", "name": "Insanity Records - International [UK2114] / Sony Music Entertainment"}, {"code": "UK2113", "name": "Insanity Records - Local [UK2113] / Sony Music Entertainment"} ] }, {"id": 51, "name": 'MagicStar UK', "external_name": 'MagicStar UK', "profit_centers": [ {"code": "UK1397", "name": "Sony Wonder [UK1397] / Sony Music Entertainment"}, ]}, {"id": 52, "name": 'Masterworks UK', "external_name": 'Masterworks UK', "profit_centers": [ {"code": "UK1350", "name": 'Classical - Catalogue - Local [UK1350] / Conifer Records Limited'}, {"code": "UK1344", "name": 'Classical - New- International [UK1344] / Sony Music Entertainment'}, {"code": "UK1351", "name": 'Classical - Catalogue - Syco [UK1351] / Sony Music Entertainment'}, {"code": "UK1340", "name": 'Classical - New- Local [UK1340] / Sony Music Entertainment'}, {"code": "UK1354", "name": 'Classical - Catalogue - International [UK1354] / Sony Music Entertainment'}, ] }, {"id": 53, "name": 'Ministry of Sound UK', "external_name": 'Ministry of Sound UK', "profit_centers": [ {"code": "UK1281", "name": 'Ministry of Sound Local Catalogue [UK1281] / Ministry of Sound Rec LTD'}, {"code": "UK1290", "name": 'Ministry of Sound - Compilations [UK1290] / Sony Music Entertainment'}, {"code": "UK1280", "name": 'Ministry of Sound Local [UK1280] / Ministry of Sound Rec LTD'}, {"code": "UK1278", "name": 'Ministry International Catalogue [UK1278] / Ministry of Sound Rec LTD'}, {"code": "UK1276", "name": 'Ministry of Sound International [UK1276] / Ministry of Sound Rec LTD'}, {"code": "UK1291", "name": 'Ministry of Sound - SDD [UK1291] / Ministry of Sound Rec LTD'}, ] }, {"id": 54, "name": 'Music For Nations UK', "external_name": 'Music For Nations UK', "profit_centers": [ {"code": "UK2117", "name": 'Music for Nations New Signings Local [UK2117] / Sony Music Entertainment'}, {"code": "UK2118", "name": 'Music For Nations Catalogue [UK2118] / Sony Music Entertainment'}, {"code": "UK2121", "name": 'Music for Nations New Signings Int [UK2121] / Sony Music Entertainment'}, ]}, {"id": 55, "name": 'RCA UK', "external_name": 'RCA UK', "profit_centers": [ {"code": "UK1030", "name": 'RCA - Local [UK1030] / Sony Music Entertainment'}, {"code": "UK1021", "name": 'RCA - Inter Cata [UK1021] / Sony Music Entertainment'}, {"code": "UK1020", "name": 'RCA - International [UK1020] / Sony Music Entertainment'}, {"code": "UK1031", "name": 'RCA - Local Cata [UK1031] / Sony Music Entertainment'}, ]}, {"id": 56, "name": 'Relentless Records UK', "external_name": 'Relentless Records UK', "profit_centers": [ {"code": "UK2024", "name": 'Relentless - International [UK2024] / Sony Music Entertainment'}, {"code": "UK2023", "name": 'Relentless - International Catalogue [UK2023] / Sony Music Entertainment'}, {"code": "UK2020", "name": 'Relentless - Local [UK2020] / Sony Music Entertainment'}, ]}, {"id": 57, "name": "Since '93 UK", "external_name": "Since '93 UK", "profit_centers": [ {"code": "UK1050", "name": 'Since 93 - Local [UK1050] / Sony Music Entertainment'}, {"code": "UK1040", "name": 'Since 93 - International [UK1040] / Sony Music Entertainment'} ]}, {"id": 58, "name": 'WEAREBLK UK', "external_name": 'WEAREBLK UK', "profit_centers": [ {"code": "UK1272", "name": 'WEAREBLK [UK1272] / Sony Music Entertainment'} ] }, { "id": 59, "name": 'Ariola/RCA DE', "external_name": 'Ariola/RCA DE', "profit_centers": [ {"code": "GSA0009", "name": '105 Music'}, {"code": "GSA0134", "name": 'Ariola/RCA Local - Hansa Music'}, {"code": "GSA0230", "name": 'Ariola/RCA International'}, {"code": "GSA0232", "name": 'Ariola Schweiz Lokale Titel'}, {"code": "GSA0233", "name": 'RCA Local'}, {"code": "GSA0234", "name": 'Ariola Local'}, {"code": "GSA0236", "name": 'AOR Brönner'}, {"code": "GSA1045", "name": 'Red Rooster AOR'}, {"code": "GSA1080", "name": 'Hypnotize Entertainment (DD31)'}, {"code": "GSA1088", "name": 'Red Rooster Neu-VÖ RCA'}, {"code": "GSA1114", "name": 'NYX Music (MEL)(DD31)'}, {"code": "GSA1117", "name": 'Freie Musik (DD31)'}, {"code": "GSA1144", "name": 'Extra Records'}, {"code": "GSA1148", "name": 'Munich Warehouse (DD31)'}, {"code": "GSA1153", "name": 'Imperium Music (DD31)'}, {"code": "GSA1187", "name": 'JMC Music (DD31)'}, {"code": "GSA1213", "name": 'Revelle (DD31)'}, ] }, { "id": 60, "name": 'Artist & Label Services DE', "external_name": 'Artist & Label Services DE', "profit_centers": [ {"code": "GSA9998", "name": "Distr Labels Consolidation"}, {"code": "GSA1055", "name": "Rey Records (DD31)"}, {"code": "GSA1056", "name": "STUFFED MONKEY (DD1995)"}, {"code": "GSA1057", "name": "Moment mal! Records"}, {"code": "GSA1058", "name": "Bellasoni-Records (ab 2018)"}, {"code": "GSA1059", "name": "Twerdymusic"}, {"code": "GSA1060", "name": "Zwei Bernds tanken Super"}, {"code": "GSA1061", "name": "BHZ (DD 31)"}, {"code": "GSA1062", "name": "069 Clique (DD0031)"}, {"code": "GSA1063", "name": "AESTHETE (DD1041)"}, {"code": "GSA1065", "name": "195 (DD31)"}, {"code": "GSA1015", "name": "Airplay Songs (DD 31)"}, {"code": "GSA1066", "name": "SLS Music (DD31)"}, {"code": "GSA1067", "name": "BombenProdukt (DD31)"}, {"code": "GSA1069", "name": "Family Screen Music (DD31)"}, {"code": "GSA1070", "name": "Lotterlabel (DD31)"}, {"code": "GSA1071", "name": "ESKALA Music (DD1041)"}, {"code": "GSA1016", "name": "Langi Ohre Records (DD1995)"}, {"code": "GSA1048", "name": "Coppenrath (DD31)"}, {"code": "GSA1049", "name": "Team Kuku (DD31)"}, {"code": "GSA1072", "name": "WYNA Records (DD1041)"}, {"code": "GSA1017", "name": "DD Bakara Music_1995"}, {"code": "GSA1073", "name": "Knittel Ton (DD1041)"}, {"code": "GSA1074", "name": "Friends with Money (DD31)"}, {"code": "GSA1076", "name": "Frank Schätzing"}, {"code": "GSA1018", "name": "DD Cicero/ HDW/RAMON"}, {"code": "GSA1077", "name": "Pogo's Empire (DD1041)"}, {"code": "GSA1078", "name": "NEXT LEVEL DREAMS (DD31)"}, {"code": "GSA1079", "name": "Crow Records (DD31)"}, {"code": "GSA1081", "name": "Big Smile Records (DD1041)"}, {"code": "GSA1082", "name": "Naidoo Records GmbH (DD31)"}, {"code": "GSA1020", "name": "meinsongbook Verlag (DD 31)"}, {"code": "GSA1050", "name": "Kultband Records (DD1041)"}, {"code": "GSA1087", "name": "Damestream Records (DD1041)"}, {"code": "GSA1051", "name": "OTR Records"}, {"code": "GSA1021", "name": "Karmarama (DD 1041)"}, {"code": "GSA1052", "name": "Sektor West (DD31)"}, {"code": "GSA1090", "name": "ABOUT YOU (DD31)"}, {"code": "GSA1092", "name": "Bastei Lübbe AG (DD31)"}, {"code": "GSA1094", "name": "Chose Sauvage (DD1995)"}, {"code": "GSA1095", "name": "MINDMAP (DD31)"}, {"code": "GSA1096", "name": "Keine Liebe Records (DD31)"}, {"code": "GSA1022", "name": "TF1 Enterprises (DD 1995)"}, {"code": "GSA1098", "name": "MNF (DD31)"}, {"code": "GSA1214", "name": "Barfuß Records (DD1041)"}, {"code": "GSA1099", "name": "Culcha Sound (DD31)"}, {"code": "GSA1023", "name": "LVM (DD 0031)"}, {"code": "GSA1102", "name": "OLSON (DD31)"}, {"code": "GSA1104", "name": "United Soft Media (DD31)"}, {"code": "GSA1024", "name": "Good Hope Centre e. V."}, {"code": "GSA1109", "name": "R.O.T records GmbH (DD 0031)"}, {"code": "GSA1025", "name": "EL CARTEL MEDIA"}, {"code": "GSA1112", "name": "Eldorado Records (DD1995)"}, {"code": "GSA1116", "name": "Team Kuku (DD31) NEU"}, {"code": "GSA1119", "name": "sepp music (DD31)"}, {"code": "GSA1127", "name": "Goldzweig, Berlin (DD31)"}, {"code": "GSA1026", "name": "Fantastic Music (DD 1995)"}, {"code": "GSA1128", "name": "Embuna (DD1041)"}, {"code": "GSA1129", "name": "Honigdachs (DD1041)"}, {"code": "GSA1130", "name": "PARRAMATTA (DD1041)"}, {"code": "GSA1138", "name": "0472 Records (DD31)"}, {"code": "GSA1139", "name": "I.M.P.S. SA (DD31)"}, {"code": "GSA1140", "name": "Rose May Music (DD1041)"}, {"code": "GSA1141", "name": "CICEU / HDW (DD31)"}, {"code": "GSA1244", "name": "Rap City (DD1995)"}, {"code": "GSA1220", "name": "AINIAC Entertainment (DD1995)"}, {"code": "GSA1145", "name": "Text & Ton (DD31)"}, {"code": "GSA1027", "name": "RBB Media Panda II"}, {"code": "GSA1146", "name": "New Aura Ent. (DD1995)"}, {"code": "GSA1149", "name": "FarMore Records (DD1995)"}, {"code": "GSA1246", "name": "Yo Man! (DD31)"}, {"code": "GSA1215", "name": "Homerun Records (DD31)"}, {"code": "GSA1154", "name": "most-production (DD1041)"}, {"code": "GSA1247", "name": "House of Clio (DD31)"}, {"code": "GSA1028", "name": "Guesstimate"}, {"code": "GSA1222", "name": "LATENIGHTDRIVINGsounds (DD1995"}, {"code": "GSA1155", "name": "ONiKi (DD1041)"}, {"code": "GSA1251", "name": "Antilopen Geldwäsche (DD31)"}, {"code": "GSA1253", "name": "bandoboyz (DD31)"}, {"code": "GSA1029", "name": "Moonlake Entertainment"}, {"code": "GSA1165", "name": "KnK Music (DD31)"}, {"code": "GSA1167", "name": "Die Ärzte früher GbR (DD31)"}, {"code": "GSA1225", "name": "Banana Split Records (DD31)"}, {"code": "GSA1168", "name": "Skandal Vienna (DD1041)"}, {"code": "GSA1169", "name": "BRR BRR (DD1041)"}, {"code": "GSA1226", "name": "SoN Music (DD1041)"}, {"code": "GSA1170", "name": "Capella Music (DD1041)"}, {"code": "GSA1030", "name": "Dikka Musik"}, {"code": "GSA1173", "name": "KNK MusicJamoo (DD31)"}, {"code": "GSA1031", "name": "German Dream Empire (DD31)"}, {"code": "GSA1032", "name": "Yangins"}, {"code": "GSA1033", "name": "FEEZ"}, {"code": "GSA1227", "name": "Big Daddy Musik (DD31)"}, {"code": "GSA1174", "name": "AAA (DD31)"}, {"code": "GSA1175", "name": "Montechristo (DD1995)"}, {"code": "GSA1034", "name": "Catchfire Records"}, {"code": "GSA1178", "name": "AZAD (DD31)"}, {"code": "GSA1180", "name": "SugarLoup Records (DD31)"}, {"code": "GSA1183", "name": "SRF (DD1995)"}, {"code": "GSA1053", "name": "RJF Musik (DD31)"}, {"code": "GSA1228", "name": "Uptrent Records (DD1041)"}, {"code": "GSA1218", "name": "Modern Angst (DD31)"}, {"code": "GSA1184", "name": "BurdaForward Music (DD31)"}, {"code": "GSA0004", "name": "Pirate Music (DisDeal 031)"}, {"code": "GSA0005", "name": "X-cell (DisDeal 031)"}, {"code": "GSA0007", "name": "Kosmo (DisDeal 031)"}, {"code": "GSA0010", "name": "Na Klar! Records (DisDeal 697)"}, {"code": "GSA0022", "name": "3P Distribution (DisDeal 031)"}, {"code": "GSA0031", "name": "JKP Distribution (DisDeal 031)"}, {"code": "GSA0032", "name": "Centaurus (DisDeal 031)"}, {"code": "GSA0860", "name": "DD Restos du Coeur (CH)"}, {"code": "GSA0861", "name": "DD Pablo Musik (CH)"}, {"code": "GSA0862", "name": "DD Allschwil Posse (CH)"}, {"code": "GSA0863", "name": "DD Funk House Blues (CH)"}, {"code": "GSA1189", "name": "BMA"}, {"code": "GSA0864", "name": "DD Sophie Records (CH)"}, {"code": "GSA0865", "name": "DD NI Records (CH)"}, {"code": "GSA0866", "name": "DD Toni Vescoli (CH)"}, {"code": "GSA0867", "name": "DD Around The Music (CH)"}, {"code": "GSA0868", "name": "DD Plüsch.ch GmbH (CH)"}, {"code": "GSA0869", "name": "DD Ivo Sidler Prod. (CH)"}, {"code": "GSA0870", "name": "DD Shakra Records (CH)"}, {"code": "GSA0871", "name": "DD RWP / Kaas (CH)"}, {"code": "GSA0900", "name": "Bertelsm Distrib (DisDeal 031)"}, {"code": "GSA1191", "name": "BLAY (DD 1995)"}, {"code": "GSA1229", "name": "Ranka Kustannus (DD31)"}, {"code": "GSA0901", "name": "FAME Artist Recordings GmbH"}, {"code": "GSA0902", "name": "LZ Records (DisDeal 031)"}, {"code": "GSA1035", "name": "9 Productions (DD0031)"}, {"code": "GSA0903", "name": "Flamingo Music Entertainment"}, {"code": "GSA0904", "name": "7Days S&D Katalogprodukte"}, {"code": "GSA1054", "name": "Für Dich Mama (DD31)"}, {"code": "GSA0905", "name": "frei"}, {"code": "GSA1036", "name": "Paper Plane Records (DD31)"}, {"code": "GSA0906", "name": "Andrina Music (DisDeal 1995)"}, {"code": "GSA0907", "name": "Peppermint Enterprises"}, {"code": "GSA0908", "name": "DRAKKAR (DisDeal 031)"}, {"code": "GSA0909", "name": "Loud & Proud (Dis Deal 031)"}, {"code": "GSA0910", "name": "Gain Records (DisDeal 031)"}, {"code": "GSA0911", "name": "DD - Serious Entertainment (A)"}, {"code": "GSA0912", "name": "Jacko'music (DisDeal 031)"}, {"code": "GSA0913", "name": "MIG Music (DisDeal 031)"}, {"code": "GSA0914", "name": "GLOR Music Production II"}, {"code": "GSA0915", "name": "7 Star Music"}, {"code": "GSA0916", "name": "STARWATCH ENTERTAINMENT LC"}, {"code": "GSA0917", "name": "T.O.M. Themes Of Music"}, {"code": "GSA1192", "name": "LKMTV (DD1041)"}, {"code": "GSA0918", "name": "OE-POP (DD 1041)"}, {"code": "GSA0919", "name": "BML Records"}, {"code": "GSA0921", "name": "DD - Blue Groove (A)"}, {"code": "GSA0922", "name": "T Fischer (DisDeal 031)"}, {"code": "GSA0923", "name": "DD - CMS (A)"}, {"code": "GSA0924", "name": "Membran (ex NEO)"}, {"code": "GSA0925", "name": "Funkhouse/NEO"}, {"code": "GSA0926", "name": "Solid Tubes 2013 (DD 1041)"}, {"code": "GSA0927", "name": "7days music entertainment AG"}, {"code": "GSA0928", "name": "HRP Records (DisDeal)"}, {"code": "GSA1037", "name": "GOOD LIFE MUSIC (DD1041)"}, {"code": "GSA1038", "name": "DVMND Music (DD1041)"}, {"code": "GSA0930", "name": "Motor Entertainment"}, {"code": "GSA0931", "name": "Tunnel (DisDeal 031)"}, {"code": "GSA0932", "name": "Buyu (DisDeal 031)"}, {"code": "GSA0933", "name": "Stage Entertainm (DisDeal 031)"}, {"code": "GSA0934", "name": "TONART"}, {"code": "GSA0935", "name": "Rodeostar"}, {"code": "GSA0936", "name": "BMG Rights Management"}, {"code": "GSA1194", "name": "Cardillac Classic Rec (DD1041)"}, {"code": "GSA1195", "name": "DIEgital Records (DD1041)"}, {"code": "GSA0937", "name": "Red Rock (DisDeal 031)"}, {"code": "GSA0938", "name": "Mandorla Music ( DD 0031)"}, {"code": "GSA0939", "name": "ChinChin Records"}, {"code": "GSA0940", "name": "Department Musik (DD 031)"}, {"code": "GSA1039", "name": "DIALEKT'S MI AM OASCH (DD1041)"}, {"code": "GSA0941", "name": "Verschwende Deine Zeit GmbH"}, {"code": "GSA0942", "name": "Mottom Textil GmbH"}, {"code": "GSA0943", "name": "WePLAY"}, {"code": "GSA0944", "name": "Repertoire Recs (DisDeal 031)"}, {"code": "GSA0945", "name": "Maskulin Music Group (DD 031)"}, {"code": "GSA0946", "name": "Palm Records"}, {"code": "GSA0947", "name": "Sam Media"}, {"code": "GSA0948", "name": "Radiola"}, {"code": "GSA0949", "name": "BlankoMusik"}, {"code": "GSA0950", "name": "Telamo (DisDeal 031)"}, {"code": "GSA0952", "name": "Studio 71 (DisDeal 031)"}, {"code": "GSA0953", "name": "Choice (DisDeal 031)"}, {"code": "GSA0954", "name": "Inkubator (DisDeal 031)"}, {"code": "GSA0955", "name": "BarbaraDennerlein(DisDeal 031)"}, {"code": "GSA0956", "name": "Almost Perfecto Records(DD041)"}, {"code": "GSA1196", "name": "OTon Records (DD1041)"}, {"code": "GSA0957", "name": "Mania Music (DD 0031)"}, {"code": "GSA0958", "name": "Zirkus Records (DD 1041)"}, {"code": "GSA0959", "name": "Kino Media Records (DD 1995)"}, {"code": "GSA0960", "name": "Chartwards (DD 0031)"}, {"code": "GSA0961", "name": "Peppermint Anime (DD 0031)"}, {"code": "GSA0962", "name": "Phrasenmaeher"}, {"code": "GSA0963", "name": "Hit Galaxy"}, {"code": "GSA0964", "name": "If then Records"}, {"code": "GSA0965", "name": "Radio Zürisee (DisDeal)"}, {"code": "GSA0966", "name": "Nordpolrecords (DD 0031)"}, {"code": "GSA0967", "name": "Bushido"}, {"code": "GSA0968", "name": "ersguterjunge (Bushido)"}, {"code": "GSA1230", "name": "Andreas Ritschard (DD1995)"}, {"code": "GSA0969", "name": "Hall of Sermon"}, {"code": "GSA0970", "name": "Coldkings (DD 1995)"}, {"code": "GSA0971", "name": "Solo Musica (Dis Deal)"}, {"code": "GSA0972", "name": "Essah Entertainment (DD 0031)"}, {"code": "GSA1235", "name": "Alpentainer GmbH (DD1995)"}, {"code": "GSA0973", "name": "Highlight (DisDeal 031)"}, {"code": "GSA0974", "name": "ACODA (DD 1041)"}, {"code": "GSA1197", "name": "Loyal 2 Death (DD1041)"}, {"code": "GSA0975", "name": "Bellasoni-Records (1041)"}, {"code": "GSA0976", "name": "Digger Records (DD 1995)"}, {"code": "GSA1040", "name": "Peak Nice (DD 0031)"}, {"code": "GSA0977", "name": "LAUGH & PEAS Entertainment (DD"}, {"code": "GSA0978", "name": "Kneifidelity (DisDeal 031)"}, {"code": "GSA0979", "name": "Sonic Service (DD 1995)"}, {"code": "GSA1202", "name": "Born & Raised (DD1041)"}, {"code": "GSA1041", "name": "Conaha GmbH (DD 0031)"}, {"code": "GSA0980", "name": "Madsius (DisDeal 031)"}, {"code": "GSA0981", "name": "Maseco (DisDeal 031)"}, {"code": "GSA0982", "name": "Teenage Rockstar"}, {"code": "GSA0983", "name": "RED BULL (DD 0031)"}, {"code": "GSA0984", "name": "RBB Media GmbH"}, {"code": "GSA0985", "name": "DEAG Music"}, {"code": "GSA0986", "name": "Kunstflug"}, {"code": "GSA0987", "name": "More Music&Media(Dis Deal 031)"}, {"code": "GSA0988", "name": "6003 Records (DD 1995)"}, {"code": "GSA0989", "name": "Redkey GmbH (DD 1995)"}, {"code": "GSA1042", "name": "Vorsicht Musik (DD 31)"}, {"code": "GSA0990", "name": "SimiSon Records (CH 1995)"}, {"code": "GSA1237", "name": "Emigrate Productions (DD31)"}, {"code": "GSA0991", "name": "Radicalis Music (1995)"}, {"code": "GSA0992", "name": "Tropical Music (DisDeal 031)"}, {"code": "GSA0993", "name": "BMG Rights/ DEAG Music"}, {"code": "GSA0994", "name": "Lichtdicht Records (DD 0031)"}, {"code": "GSA0995", "name": "DECISION PRODUCTS"}, {"code": "GSA0996", "name": "California Sunset Records (DD)"}, {"code": "GSA0997", "name": "Laugh & Peas Entertainment"}, {"code": "GSA0998", "name": "Metal Blade"}, {"code": "GSA1206", "name": "Nesola (DD31)"}, {"code": "GSA0999", "name": "alte deutsche Dis.-Deal"}, {"code": "GSA1000", "name": "HITMIX Music (DD0031)"}, {"code": "GSA1001", "name": "Filter Music Group (DD0031)"}, {"code": "GSA1043", "name": "Heimlich Musik (DD)"}, {"code": "GSA1242", "name": "Sektion Züri (DD1995)"}, {"code": "GSA1002", "name": "NEVE MEDIA (DD)"}, {"code": "GSA1003", "name": "YES MUSIC (DD31)"}, {"code": "GSA1004", "name": "Tawara Music"}, {"code": "GSA1005", "name": "Edition Philharmonie"}, {"code": "GSA1006", "name": "Solis Music (DD31)"}, {"code": "GSA1046", "name": "Matches Music"}, {"code": "GSA1007", "name": "Bergrecords (DD31)"}, {"code": "GSA1008", "name": "Breitbild (DD1995)"}, {"code": "GSA1009", "name": "MYE production(DD31)"}, {"code": "GSA1010", "name": "Dark Wave (DD1995)"}, {"code": "GSA1207", "name": "Howl Records (DD31)"}, {"code": "GSA1011", "name": "GREEN BERLIN (DD31)"}, {"code": "GSA1210", "name": "NoHook (DD1995)"}, {"code": "GSA1012", "name": "BMG Rights Mgmt.2016"}, {"code": "GSA1047", "name": "Outta This World (OTW)"}, {"code": "GSA1013", "name": "Red Essential (DD 0031)"}, {"code": "GSA1014", "name": "SoundToPeople (DD31)"}, ] }, { "id": 61, "name": 'Catalog DE', "external_name": 'Catalog DE', "profit_centers": [ {"code": "GSA0500", "name": "Cat Internat 031"}, {"code": "GSA0504", "name": "Cat DVD (031)"}, {"code": "GSA0505", "name": "Cat Ariola (031)"}, {"code": "GSA0508", "name": "Cat GUN (031)"}, {"code": "GSA0509", "name": "Cat GUN (697)"}, {"code": "GSA0512", "name": "Cat Ariola (697)"}, {"code": "GSA0515", "name": "Cat Columbia (031)"}, {"code": "GSA0516", "name": "Cat Columbia (697)"}, {"code": "GSA0520", "name": "Cat Lokal CH"}, {"code": "GSA0524", "name": "Cat DVD (697)"}, {"code": "GSA0525", "name": "Cat DVD Media (031)"}, {"code": "GSA0530", "name": "Cat Smaris"}, {"code": "GSA0540", "name": "Cat French/Italian (Smaris)"}, {"code": "GSA0555", "name": "Downloads ohne Quellprodukt"}, {"code": "GSA0701", "name": "BAG Transferred national"}, {"code": "GSA0702", "name": "BAG Transferred international"}, {"code": "GSA0703", "name": "BAG Licensed national"}, {"code": "GSA0704", "name": "BAG Licensed international"}, {"code": "GSA0705", "name": "BAG Serien"}, {"code": "GSA0825", "name": "Montana Katalog 0031"}, {"code": "GSA0828", "name": "Berlin JV"}, {"code": "GSA0829", "name": "Amiga JV"}, {"code": "GSA0830", "name": "Cat Artist Concepts Local"}, {"code": "GSA0831", "name": "Catalog Local"}, {"code": "GSA0834", "name": "Cat Artist Concept Internat"}, {"code": "GSA0835", "name": "Cat Artist Concepts (697)"}, {"code": "GSA0836", "name": "Cat Concepts (697)"}, {"code": "GSA0838", "name": "Catalog International"}, {"code": "GSA0839", "name": "Selfmade Records Catalog"}, {"code": "GSA1044", "name": "Red Rooster Catalog"}, {"code": "GSA0370", "name": "Classical International"}, {"code": "GSA0371", "name": "Classical Local"}, ] }, { "id": 62, "name": 'Century Media DE', "external_name": 'Century Media DE', "profit_centers": [ {"code": "GSA0013", "name": "Yo Mama"}, {"code": "GSA0016", "name": "Kookie Diamond"}, {"code": "GSA0163", "name": "Columbia Local - Hansa Music"}, {"code": "GSA0224", "name": "Columbia International"}, {"code": "GSA0225", "name": "Columbia Track International"}, {"code": "GSA0255", "name": "Verschwende Deine Zeit (JV)"}, {"code": "GSA0257", "name": "Paradyse (JV)"}, {"code": "GSA0260", "name": "B1 Recordings"}, {"code": "GSA0262", "name": "Columbia Schweiz Lokale Titel"}, {"code": "GSA0263", "name": "Columbia Local"}, {"code": "GSA0268", "name": "Columbia Track Local"}, {"code": "GSA0951", "name": "DD Department Premium"}, {"code": "GSA1110", "name": "Husla Music (DD 031)"}, {"code": "GSA1113", "name": "1019 Records (DD31)"}, {"code": "GSA1121", "name": "RK (DD31)"}, {"code": "GSA1131", "name": "Symba (DD31)"}, {"code": "GSA1134", "name": "Eight-O (DD31)"}, {"code": "GSA1135", "name": "King Eazy (DD31)"}, {"code": "GSA1136", "name": "Caesar (DD31)"}, {"code": "GSA1137", "name": "ALO431 (DD31)"}, {"code": "GSA1151", "name": "LUVRE47"}, {"code": "GSA1152", "name": "Andere Liga Ahmad Amin (DD31)"}, {"code": "GSA1161", "name": "Yin Kalle (DD31)"}, {"code": "GSA1171", "name": "Jeanette Biedermann Entert."}, {"code": "GSA1185", "name": "Koushino x  Camaeleon (DD31)"}, {"code": "GSA1190", "name": "NANA LE VRAI (DD31)"}, {"code": "GSA1198", "name": "Eklat Tonträger (DD31)"}, {"code": "GSA1199", "name": "Hutmacher (DD31)"}, {"code": "GSA1201", "name": "Verifiziert (DD31)"}, {"code": "GSA1203", "name": "OG Pezo (DD31)"}, {"code": "GSA1204", "name": "Teuterekordz (DD31)"}, {"code": "GSA1205", "name": "TeuterekordzxGlenGang030(DD31)"}, {"code": "GSA1208", "name": "Lucio101 (DD31)"}, {"code": "GSA1209", "name": "GlenGang030 (DD31)"}, {"code": "GSA1211", "name": "RBK/ Yecca (DD31)"}, {"code": "GSA1217", "name": "Missglückte Welt (DD31)"}, {"code": "GSA1219", "name": "Aswad (DD31)"}, {"code": "GSA1232", "name": "Karamel19 (DD31)"}, {"code": "GSA1233", "name": "Omar101 (DD31)"}, {"code": "GSA1234", "name": "Nizi19 (DD31)"}, {"code": "GSA1240", "name": "Fergy53 (DD31)"}, {"code": "GSA1245", "name": "KazOnDaBeat (DD31)"}, {"code": "GSA1248", "name": "RBK / Subasa (DD31)"}, {"code": "GSA1252", "name": "TYM (DD31)"}, {"code": "GSA1254", "name": "BIBIZA (DD31)"}, {"code": "GSA1255", "name": "Chirok 471 (DD31)"}, ] }, { "id": 63, "name": 'Classic DE', "external_name": 'Classic DE', "profit_centers": [ {"code": "GSA0370", "name": "Classical International"}, {"code": "GSA0371", "name": "Classical Local"}, ] }, { "id": 64, "name": 'Columbia DE', "external_name": 'Columbia DE', "profit_centers": [ {"code": "GSA0013", "name": "Yo Mama"}, {"code": "GSA0016", "name": "Kookie Diamond"}, {"code": "GSA0163", "name": "Columbia Local - Hansa Music"}, {"code": "GSA0224", "name": "Columbia International"}, {"code": "GSA0225", "name": "Columbia Track International"}, {"code": "GSA0255", "name": "Verschwende Deine Zeit (JV)"}, {"code": "GSA0257", "name": "Paradyse (JV)"}, {"code": "GSA0260", "name": "B1 Recordings"}, {"code": "GSA0262", "name": "Columbia Schweiz Lokale Titel"}, {"code": "GSA0263", "name": "Columbia Local"}, {"code": "GSA0268", "name": "Columbia Track Local"}, {"code": "GSA0951", "name": "DD Department Premium"}, {"code": "GSA1110", "name": "Husla Music (DD 031)"}, {"code": "GSA1113", "name": "1019 Records (DD31)"}, {"code": "GSA1121", "name": "RK (DD31)"}, {"code": "GSA1131", "name": "Symba (DD31)"}, {"code": "GSA1134", "name": "Eight-O (DD31)"}, {"code": "GSA1135", "name": "King Eazy (DD31)"}, {"code": "GSA1136", "name": "Caesar (DD31)"}, {"code": "GSA1137", "name": "ALO431 (DD31)"}, {"code": "GSA1151", "name": "LUVRE47"}, {"code": "GSA1152", "name": "Andere Liga Ahmad Amin (DD31)"}, {"code": "GSA1161", "name": "Yin Kalle (DD31)"}, {"code": "GSA1171", "name": "Jeanette Biedermann Entert."}, {"code": "GSA1185", "name": "Koushino x  Camaeleon (DD31)"}, {"code": "GSA1190", "name": "NANA LE VRAI (DD31)"}, {"code": "GSA1198", "name": "Eklat Tonträger (DD31)"}, {"code": "GSA1199", "name": "Hutmacher (DD31)"}, {"code": "GSA1201", "name": "Verifiziert (DD31)"}, {"code": "GSA1203", "name": "OG Pezo (DD31)"}, {"code": "GSA1204", "name": "Teuterekordz (DD31)"}, {"code": "GSA1205", "name": "TeuterekordzxGlenGang030(DD31)"}, {"code": "GSA1208", "name": "Lucio101 (DD31)"}, {"code": "GSA1209", "name": "GlenGang030 (DD31)"}, {"code": "GSA1211", "name": "RBK/ Yecca (DD31)"}, {"code": "GSA1217", "name": "Missglückte Welt (DD31)"}, {"code": "GSA1219", "name": "Aswad (DD31)"}, {"code": "GSA1232", "name": "Karamel19 (DD31)"}, {"code": "GSA1233", "name": "Omar101 (DD31)"}, {"code": "GSA1234", "name": "Nizi19 (DD31)"}, {"code": "GSA1240", "name": "Fergy53 (DD31)"}, {"code": "GSA1245", "name": "KazOnDaBeat (DD31)"}, {"code": "GSA1248", "name": "RBK / Subasa (DD31)"}, {"code": "GSA1252", "name": "TYM (DD31)"}, {"code": "GSA1254", "name": "BIBIZA (DD31)"}, {"code": "GSA1255", "name": "Chirok 471 (DD31)"}, ] }, { "id": 65, "name": 'EPIC DE', "external_name": 'EPIC DE', "profit_centers": [ {"code": "GSA1200", "name": "KMZ (DD31)"}, {"code": "GSA1216", "name": "Eunique (DD31)"}, {"code": "GSA1241", "name": "Empire Melody Music (DD31)"}, {"code": "GSA1249", "name": "Soba (DD31)"}, {"code": "GSA1256", "name": "Kara Clique (DD31)"}, {"code": "GSA0238", "name": "DOPE"}, {"code": "GSA0254", "name": "Crash Your Sound (JV)"}, {"code": "GSA0265", "name": "EPIC Local"}, {"code": "GSA0269", "name": "EPIC International"}, {"code": "GSA1075", "name": "Fero47"}, {"code": "GSA1089", "name": "Qualität'er Music (DD31)"}, {"code": "GSA1108", "name": "Keller GmbH (DD31)"}, {"code": "GSA1111", "name": "Luqe Records (DD31)"}, {"code": "GSA1115", "name": "Modest Department (DD31)"}, {"code": "GSA1120", "name": "LL GbR (DD31)"}, {"code": "GSA1132", "name": "People Like Us GmbH (DD31)"}, {"code": "GSA1142", "name": "1998 (DD31)"}, {"code": "GSA1150", "name": "Ali471 (DD31)"}, {"code": "GSA1158", "name": "Malik Montana (DD31)"}, {"code": "GSA1193", "name": "DOPE (DD31)"}, {"code": "GSA1164", "name": "NVN Music GmbH (DD31)"}, {"code": "GSA1166", "name": "Dhurata Dora (DD331)"}, {"code": "GSA1172", "name": "Ilir Balija (DD31)"}, {"code": "GSA1176", "name": "Eddin (DD31)"}, {"code": "GSA1177", "name": "DJ JEEZY (DD31)"}, {"code": "GSA1181", "name": "Albert (DD31)"}, {"code": "GSA1182", "name": "JAPO (DD31)"}, {"code": "GSA1186", "name": "NVN Music - Various (DD31)"}, ] }, { "id": 66, "name": 'Family Entertainment DE', "external_name": 'Family Entertainment DE', "profit_centers": [ {"code": "GSA0840", "name": "Kids & Family (031)"}, {"code": "GSA0853", "name": "Handelsware Family (031)"}, {"code": "GSA0420", "name": "Comedy (031)"}, ] }, { "id": 67, "name": 'Four Music DE', "external_name": 'Four Music DE', "profit_centers": [ {"code": "GSA0014", "name": "Four Music"}, {"code": "GSA0015", "name": "TwoSides"}, {"code": "GSA0017", "name": "November Eleven (JV)"}, {"code": "GSA0018", "name": "Marecs (JV)"}, {"code": "GSA0019", "name": "Wasteland (JV)"}, {"code": "GSA0020", "name": "Teenager Forever (JV)"}, {"code": "GSA0231", "name": "Four Music International"}, {"code": "GSA1093", "name": "Majan (DD31)"}, {"code": "GSA1159", "name": "Treppenhaus Records (DD31)"}, {"code": "GSA1239", "name": "JAGA Recordings (DD31)"}, {"code": "GSA1243", "name": "Himbeertoni (DD31)"}, ] }, { "id": 68, "name": 'GOLD LEAGUE DE', "external_name": 'GOLD LEAGUE DE', "profit_centers": [ {"code": "GSA0121", "name": "GRIND (JV)"}, {"code": "GSA0122", "name": "GOLD LEAGUE (BÜVs)"}, {"code": "GSA1064", "name": "Andere Liga (DD31)"}, {"code": "GSA1068", "name": "AEIOU"}, {"code": "GSA1083", "name": "GOLD LEAGUE"}, {"code": "GSA1084", "name": "SELFMADE ENTERTAINMENT (DD31)"}, {"code": "GSA1085", "name": "RBK (DD31)"}, {"code": "GSA1091", "name": "DIVISION (DD31)"}, {"code": "GSA1097", "name": "SWISH"}, {"code": "GSA1100", "name": "Lizzow (DD31)"}, {"code": "GSA1101", "name": "MIO (DD31)"}, {"code": "GSA1103", "name": "DEADSTCK REC. (DD31)"}, {"code": "GSA1105", "name": "DIVISION Katalog (DD31)"}, {"code": "GSA1106", "name": "GoodFellaz Records (DD31)"}, {"code": "GSA1107", "name": "BMS Musik UG (DD31)"}, {"code": "GSA1118", "name": "Traumfænger (DD31)"}, {"code": "GSA1122", "name": "SeitenaufNull (DD31)"}, {"code": "GSA1123", "name": "JACE (DD31)"}, {"code": "GSA1124", "name": "Kinder der Küste (DD31)"}, {"code": "GSA1125", "name": "Mo$art (DD31)"}, {"code": "GSA1126", "name": "GESU (DD31)"}, {"code": "GSA1133", "name": "Don't Mess With The Weather (D"}, {"code": "GSA1143", "name": "BUGI (DD31)"}, {"code": "GSA1147", "name": "Shiko Records (DD31)"}, {"code": "GSA1156", "name": "Butzemann (DD31)"}, {"code": "GSA1157", "name": "29 Global Public (DD31)"}, {"code": "GSA1160", "name": "King LX (DD31)"}, {"code": "GSA1162", "name": "SDT (DD31)"}, {"code": "GSA1163", "name": "haus333 (DD31)"}, {"code": "GSA1179", "name": "Organisch UG (DD31)"}, {"code": "GSA1188", "name": "Broke Boys (DD31)"}, {"code": "GSA1212", "name": "DIVISION Entertainment (DD31)"}, {"code": "GSA1221", "name": "Roger Rekless (DD31)"}, {"code": "GSA1223", "name": "Plasma (DD31)"}, {"code": "GSA1224", "name": "Raised by wolves (DD31)"}, {"code": "GSA1231", "name": "Darwin Miller (DD31)"}, {"code": "GSA1236", "name": "EINS 3 Musik (DD31)"}, {"code": "GSA1250", "name": "OG Scrpngang GmbH (DD31)"}, ] }, { "id": 69, "name": 'Jive DE', "external_name": 'Jive DE', "profit_centers": [ {"code": "GSA0267", "name": "Jive"}, ] }, { "id": 70, "name": 'New Revenue DE', "external_name": 'New Revenue DE', "profit_centers": [ {"code": "GSA0445", "name": "EMD (031)"}, {"code": "GSA0446", "name": "Mobile (031)"}, {"code": "GSA0447", "name": "New Business (031)"}, {"code": "GSA0448", "name": "Ocean"}, {"code": "GSA0449", "name": "D2C"}, {"code": "GSA9229", "name": "Other Eliminations (MTS D2C)"}, ] }, { "id": 71, "name": 'NITRON DE', "external_name": 'NITRON DE', "profit_centers": [ {"code": "GSA0410", "name": "NITRON media"}, {"code": "GSA0411", "name": "NITRON concepts"}, {"code": "GSA0412", "name": "NITRON music"}, ] }, { "id": 72, "name": "Famouz", "external_name": 'Famouz', "profit_centers": [ {"code": "GSA0237", "name": "Famouz JV"}, ] } ] def get_table(bind, name): meta = sa.MetaData(bind=bind) meta.reflect() return meta.tables[name] def upgrade(): bind = op.get_bind() op.add_column("PRSImportInfo", sa.Column('imported_ccp_date', sa.Date(), nullable=True)) op.add_column("Project", sa.Column('source', sa.String(), nullable=False, server_default="PRS")) op.add_column("Project", sa.Column('currency', sa.String(), nullable=False, server_default="USD")) op.add_column("PRSPurchaseOrder", sa.Column('total_amount_currency', sa.String(), nullable=False, server_default="USD") ) op.add_column("PRSPurchaseOrder", sa.Column('paid_amount_currency', sa.String(), nullable=False, server_default="USD") ) op.add_column("PRSProjectBudget", sa.Column('currency', sa.String(), nullable=False, server_default="USD") ) op.execute( """ ALTER TABLE campaign_provider ALTER COLUMN id type BIGINT; """ ) op.execute(""" ALTER TABLE "PRSPurchaseOrder" ALTER COLUMN "po_number" SET DATA TYPE varchar; """) op.execute(""" ALTER TABLE "PRSPurchaseOrder" ALTER COLUMN "parent_po_number" SET DATA TYPE varchar; """) op.add_column("PRSPurchaseOrder", sa.Column('po_line_item', sa.Integer(), nullable=True, server_default="0")) op.drop_constraint('uq_PRSPurchaseOrder_po_number_project_id', 'PRSPurchaseOrder', type_='unique') op.create_unique_constraint( 'uq_PRSPurchaseOrder_po_number_project_id', 'PRSPurchaseOrder', ["po_number", "po_line_item", "project_id", "group_id", "category_id"] ) op.create_table('RawPRSBudgetGroup', sa.Column('id', sa.BigInteger(), primary_key=True), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id', name=op.f('pk_RawPRSBudgetGroup')), ) op.create_table('RawPRSBudgetCategory', sa.Column('id', sa.BigInteger(), primary_key=True), sa.Column('name', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id', name=op.f('pk_RawPRSBudgetCategory')), ) op.execute( """ insert into "RawPRSBudgetGroup"(id, name) select id, name from "PRSBudgetGroup"; """ ) op.execute( """ insert into "RawPRSBudgetCategory"(id, name) select id, name from "PRSBudgetCategory"; """ ) op.execute( """ insert into "PRSBudgetGroup"(id, name) select id, name from "RawPRSBudgetGroup" ON CONFLICT (id) DO UPDATE SET id=EXCLUDED.id, name=EXCLUDED.name; """ ) op.execute( """ insert into "PRSBudgetCategory"(id, name) select id, name from "RawPRSBudgetCategory" ON CONFLICT (id) DO UPDATE SET id=EXCLUDED.id, name=EXCLUDED.name; """ ) op.alter_column( 'Label', 'rep_owner_key', existing_type=sa.String(), nullable=True ) op.alter_column( 'Label', 'child_rep_owner_keys', existing_type=sa.ARRAY(sa.String()), nullable=True ) op.create_table( "ProfitCenter", sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"ProfitCenter_id_seq"\'::regclass)'), autoincrement=True, nullable=False), sa.Column('name', sa.String, nullable=False), sa.Column('code', sa.String, nullable=False), sa.Column('label_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['label_id'], ['Label.id'], name=op.f('fk_ProfitCenter_label_id_Label')), sa.PrimaryKeyConstraint('id', name=op.f('pk_ProfitCenter')) ) label_table = get_table(bind, "Label") profit_center_table = get_table(bind, 'ProfitCenter') for label in new_label_spaces: bind.execute( label_table.insert().values(id=label['id'], name=label['name'], external_name=label['name']) ) for profit_center in label['profit_centers']: bind.execute( profit_center_table.insert().values( label_id=label['id'], name=profit_center["name"], code=profit_center["code"] ) ) bind = op.get_bind() bind.execute(''' INSERT INTO "User" (email, auth0_id, name, phone, is_service_account) VALUES ('ccp@ccp.com', 'ccp', 'CCP', '', True); ''') op.alter_column('Project', 'prs_project_code', existing_type=sa.VARCHAR(), nullable=True) op.alter_column('Project', 'prs_title', existing_type=sa.VARCHAR(), nullable=True) op.add_column('Project', sa.Column('ccp_project_code', sa.String(), nullable=True)) op.add_column('Project', sa.Column('ccp_title', sa.String(), nullable=True)) op.create_table( 'RawCCPProjects', sa.Column('project_budget_code', sa.String(), nullable=False, primary_key=True), sa.Column('description', sa.String(), nullable=False), sa.Column('gras_project_code', sa.String(), nullable=False), sa.Column('artist_name', sa.String(), nullable=True), sa.Column('title', sa.String(), nullable=False), sa.Column('rep_owner_key', sa.String(), nullable=True), sa.Column('artist_code', sa.String(), nullable=True), sa.Column('profit_center_code', sa.String(), nullable=True), sa.Column('profit_center_description', sa.String(), nullable=True), ) op.create_table( 'RawCCPBudgets', sa.Column('project_budget_code', sa.String(), nullable=False), sa.Column('description', sa.String(), nullable=False), sa.Column('commodity_lvl_2', sa.String(), nullable=True), sa.Column('commodity_lvl_3', sa.String(), nullable=True), sa.Column('total_project_amount', sa.String(), nullable=False), sa.Column('currency', sa.String(), nullable=False), sa.Column('creation_date', sa.Date(), nullable=False), sa.Column('last_modified_date', sa.Date(), nullable=True), sa.Column('region', sa.String(), nullable=True), ) op.create_table( 'RawCCPExpenseHierarchy', sa.Column('commodity_lvl_2', sa.String(), nullable=False), sa.Column('commodity_lvl_2_description', sa.String(), nullable=False), sa.Column('commodity_lvl_3', sa.String(), nullable=False), sa.Column('commodity_lvl_3_description', sa.String(), nullable=False), sa.Column('expense_type', sa.String(), nullable=False, primary_key=True), sa.Column('description', sa.String(), nullable=False), ) op.create_table( 'RawCCPPurchaseOrders', sa.Column('po_id', sa.String(), nullable=False), sa.Column('po_line', sa.String(), nullable=False), sa.Column('commodity_lvl_2', sa.String(), nullable=True), sa.Column('expense_type', sa.String(), nullable=True), sa.Column('creation_date', sa.Date(), nullable=False), sa.Column('last_modified_date', sa.Date(), nullable=True), sa.Column('status', sa.String(), nullable=False), sa.Column('line_item_total_amount', sa.DECIMAL(), nullable=False), sa.Column('line_item_total_amount_currency', sa.String(), nullable=False), sa.Column('paid_line_item_amount', sa.DECIMAL(), nullable=True), sa.Column('paid_line_item_amount_currency', sa.String(), nullable=True), sa.Column('project_budget_code', sa.String(), nullable=True), sa.Column('supplier', sa.String(), nullable=True), sa.Column('short_description', sa.String(), nullable=False), sa.Column('notes', sa.String(), nullable=True), sa.Column('region', sa.String(), nullable=False), ) def downgrade(): op.drop_table('RawCCPProjects') op.drop_table('RawCCPBudgets') op.drop_table('RawCCPExpenseHierarchy') op.drop_table('RawCCPPurchaseOrders')