SQLite format 3@  .O} A w-h 0 w TZ tableEmpruntEmpruntCREATE TABLE Emprunt (id_client INT REFERENCES Client(id_client), id_album INT REFERENCES Album(id_album), jour DATE, PRIMARY KEY (id_client, id_album))- Aindexsqlite_autoindex_Emprunt_1Emprunt */tableClientClientCREATE TABLE Client (id_client INTEGER PRIMARY KEY AUTOINCREMENT, nom VARCHAR(100), prenom VARCHAR(100), email VARCHAR(100))E!!UtableArtiste_deArtiste_deCREATE TABLE Artiste_de (id_artiste INT REFERENCES Artiste(id_artiste), id_album INT REFERENCES Album(id_album), PRIMARY KEY (id_artiste, id_album))3G!indexsqlite_autoindex_Artiste_de_1Artiste_de?]tableAlbumAlbumCREATE TABLE Album (id_album INTEGER PRIMARY KEY AUTOINCREMENT, titre VARCHAR(100), annee INT, dispo INT)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)'WtableAlbumAlbumCREATtableArtisteArtisteCREATE TABLE Artiste (id_artiste INTEGER PRIMARY KEY AUTOINCREMENT, nom VARCHAR(100), prenom VARCHAR(100))  kNB$n]G$ 9DELETEDELETE FROM table_name=sUPDATEUPDATE table_name SET col1="work" WHERE col2="test"HINSERTINSERT INTO table_name (col1, col2) VALUES ("example","test")"=SELECTSELECT * FROM table_name.UCREATECREATE TABLE table_name (col1, col2)9SQLSyntax example library@uai.ImageBlob - png, jpg, gif or String(base64) [DbClick] rowai.Color#9393ad* Mai.Urlhttps://sqliteonline.com/LICENSE 7ShareCreate public link DB& !=Size tableFast scroll million rowsL !SQL Editorautocomplete: [Ctrl-Space] or [Alt-Space]; run: [Shift-Enter]D Tabsmouse: [RightClick] , [MiddleClick] , [Wheel] , [LeftClick]6/OLeft-Panel, Table[RightClick] mouse "Context menu"41I[RightClick] mouseOpens many additional featur% Blues Deluxe1 Leave the Light On  T.N.T.# Sex Machine  ExodusContinuumContinuum/Fire on the Floor!A Signed, Sealed & Delivered' The Last ShipPower Up=Songs in the Key of Life# Sacred Love' Back in BlackLady Soul 44/876Let It Be ! Abbey Road  Aretha ' Don't Explain 7 It's Only Rock'n Roll  Bad5Riding With The King) Black and BlueThriller3Axis : Bold As Love% Off the Wall Aftermath! I Still Do) Blues Breakers  Client Artiste Album uaPE9. BrownJames MarleyBobBonamassaJoeWonderStevie AC/DC Shaggy Sting #The Beatles FranklinAretha B.B. KingJacksonMichael HartBeth1The Rolling Stones MayerJohnHendrixJimiMayallJohnClaptonÉric "yrkd]VOHA:3,%"!                         "~vnf^VNF>6.&"!                        kuL,b= kL,;MichelValérievalerie.michel@email.fr'9PetitMorganemorgane.petit@email.fr-!7BernardinStéphaniesbernard1@chezmoi.net$!-PetitSébastienspetit4@email.fr%3SimonSandrinessimon2@domaine.net+ !7LefrancFrançoiseflaurent3@monmail.com# /FournierDaviddfournier4@abc.de" -FournierMariemfournier@abc.de% 5RobertPascalprobert9@monmail.com' 5DuboisPhilippepdubois5@chezmoi.net RougerLéa+MoreauAlainamoreau1@abc.de"/DurandJulienjdurand9@email.fr-PacotJeanjpacot@music.com'5MichelValérievmichel5@monmail.com/?MarchandGrégoiregreg.marchand49@music.com*?DupontMicheldupont.michel@domaine.net,ADupontFlorinedupont.florine@domaine.net ;q_M; !2021-10-01 !2021-10-15 !2021-10-08!2021-10-08! 2021-10-08! 2021-09-28!2021-10-10!2021-09-12!2021-08-18!2021-08-18 !2021-09-10