SQLite format 3@ =)+!=)-)#gtableArtistArtistCREATE TABLE [Artist] ( [ArtistId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(120) )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tableAlbumAlbumCREATE TABLE [Album] ( [AlbumId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Title] NVARCHAR(160) NOT NULL, [ArtistId] INTEGER NOT NULL, FOREIGN KEY ([ArtistId]) REFERENCES [Artist] ([ArtistId]) ON DEL   )W For Those About To Rock We Salute You ww Playlist #InvoiceLine Invoice Customerc Employee Track Album[ Artist MediaType Genre AC/DC $$Y1!oK7115Luis;Carlos+FoobarGonçalvesEmbraer - Empresa Brasileira de Aeronáutica S.A.Av. Brigadeiro Faria Lima, 2170São José dos CamposSPBrazil12227-000+55 (12) 3923-5555+55 (12) 3923-5566luisg@embraer.com.br   %wtableAlbumAlbumCREATE TABLE [Album] ( [AlbumId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Title] NVARCHAR(160) NOT NULL, [ArtistId] INTEGER NOT NULL, FOREIGN KEY ([ArtistId]) REFERENCES [Artist] ([ArtistId]) ON DELETE NO ACTION ON UPDATE NO ACTION )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)gtableArtistArtistCREATE TABLE [Artist] ( [ArtistId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(120) ) MmtableCustomerCustomerCREATE TABLE [Customer] ( [CustomerId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [FirstName] NVARCHAR(40) NOT NULL, [LastName] NVARCHAR(20) NOT NULL, [Company] NVARCHAR(80), [Address] NVARCHAR(70), [City] NVARCHAR(40), [State] NVARCHAR(40), [Country] NVARCHAR(40), [PostalCode] NVARCHAR(10), [Phone] NVARCHAR(24), [Fax] NVARCHAR(24), [Email] NVARCHAR(60) NOT NULL, [SupportRepId] INTEGER, FOREIGN KEY ([SupportRepId]) REFERENCES [Employee] ([EmployeeId]) ON DELETE NO ACTION ON UPDATE NO ACTION ) KK2+333//9AdamsAndrewGeneral Manager1962-02-18 00:00:002002-08-14 00:00:0011120 Jasper Ave NWEdmontonABCanadaT5K 2N1+1 (780) 428-9482+1 (780) 428-3457andrew@chinookcorp.com   {n/tableEmployeeEmployeeCREATE TABLE [Employee] ( [EmployeeId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [LastName] NVARCHAR(20) NOT NULL, [FirstName] NVARCHAR(20) NOT NULL, [Title] NVARCHAR(30), [ReportsTo] INTEGER, [BirthDate] DATETIME, [HireDate] DATETIME, [Address] NVARCHAR(70), [City] NVARCHAR(40), [State] NVARCHAR(40), [Country] NVARCHAR(40), [PostalCode] NVARCHAR(10), [Phone] NVARCHAR(24), [Fax] NVARCHAR(24), [Email] NVARCHAR(60), FOREIGN KEY ([ReportsTo]) REFERENCES [Employee] ([EmployeeId]) ON DELETE NO ACTION ON UPDATE NO ACTION )ctableGenreGenre CREATE TABLE [Genre] ( [GenreId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(120) ) vcSF0&Opera Classical#Alternative ComedyDrama-Sci Fi & Fantasy TV Shows+Science Fiction#Hip Hop/RapWorld/Electronica/Dance R&B/Soul #Heavy Metal )Easy Listening !Bossa Nova !Soundtrack Pop ReggaeLatinBlues'Rock And Roll1Alternative & PunkMetalJazzRock S 3=2009-01-01 00:00:00Theodor-Heuss-Straße 34StuttgartGermany70174?zG |OtableInvoiceInvoice CREATE TABLE [Invoice] ( [InvoiceId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [CustomerId] INTEGER NOT NULL, [InvoiceDate] DATETIME NOT NULL, [BillingAddress] NVARCHAR(70), [BillingCity] NVARCHAR(40), [BillingState] NVARCHAR(40), [BillingCountry] NVARCHAR(40), [BillingPostalCode] NVARCHAR(10), [Total] NUMERIC(10,2) NOT NULL, FOREIGN KEY ([CustomerId]) REFERENCES [Customer] ([CustomerId]) ON DELETE NO ACTION ON UPDATE NO ACTION )c## tableInvoiceLineInvoiceLine CREATE TABLE [InvoiceLine] ( [InvoiceLineId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [InvoiceId] INTEGER NOT NULL, [TrackId] INTEGER NOT NULL, [UnitPrice] NUMERIC(10,2) NOT NULL, [Quantity] INTEGER NOT NULL, FOREIGN KEY ([InvoiceId]) REFERENCES [Invoice] ([InvoiceId]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([TrackId]) REFERENCES [Track] ([TrackId]) ON DELETE NO ACTION ON UPDATE NO ACTION )   ?zG )AAC audio file=Purchased AAC audio fileCProtected MPEG-4 video file=Protected AAC audio file+MPEG audio file ,  stableMediaTypeMediaTypeCREATE TABLE [MediaType] ( [MediaTypeId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(120) ) otablePlaylistPlaylistCREATE TABLE [Playlist] ( [PlaylistId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(120) ), ''tablePlaylistTrackPlaylistTrackCREATE TABLE [PlaylistTrack] ( [PlaylistId] INTEGER NOT NULL, [TrackId] INTEGER NOT NULL, CONSTRAINT [PK_PlaylistTrack] PRIMARY KEY ([PlaylistId], [TrackId]), FOREIGN KEY ([PlaylistId]) REFERENCES [Playlist] ([PlaylistId]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([TrackId]) REFERENCES [Track] ([TrackId]) ON DELETE NO ACTION ON UPDATE NO ACTION )9 M'indexsqlite_autoindex_PlaylistTrack_1PlaylistTrack Music q w w  ! w w i [ _For Those About To Rock (We Salute You)Angus Young, Malcolm Young, Brian Johnson>r?zG " #tableTrackTrackCREATE TABLE [Track] ( [TrackId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [Name] NVARCHAR(200) NOT NULL, [AlbumId] INTEGER, [MediaTypeId] INTEGER NOT NULL, [GenreId] INTEGER, [Composer] NVARCHAR(220), [Milliseconds] INTEGER NOT NULL, [Bytes] INTEGER, [UnitPrice] NUMERIC(10,2) NOT NULL, FOREIGN KEY ([AlbumId]) REFERENCES [Album] ([AlbumId]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([GenreId]) REFERENCES [Genre] ([GenreId]) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY ([MediaTypeId]) REFERENCES [MediaType] ([MediaTypeId]) ON DELETE NO ACTION ON UPDATE NO ACTION )Z/}indexIFK_AlbumArtistIdAlbumCREATE INDEX [IFK_AlbumArtistId] ON [Album] ([ArtistId])s=indexIFK_CustomerSupportRepIdCustomerCREATE INDEX [IFK_CustomerSupportRepId] ON [Customer] ([SupportRepId])j7 indexIFK_EmployeeReportsToEmployeeCREATE INDEX [IFK_EmployeeReportsTo] ON [Employee] ([ReportsTo])       3IW-yindexIFK_TrackGenrOwindexIPK_Albumi7 indexIFK_InvoiceCustomerIdInvoiceCREATE INDEX [IFK_InvoiceCustomerId] ON [Ini7 indexIFK_InvoiceCustomerIdInvoiceCREATE INDEX [IFK_InvoiceCustomerId] ON [Invoice] ([CustomerId])v=#indexIFK_InvoiceLineInvoiceIdInvoiceLineCREATE INDEX [IFK_InvoiceLineInvoiceId] ON [InvoiceLine] ([InvoiceId])p9#indexIFK_InvoiceLineTrackIdInvoiceLineCREATE INDEX [IFK_InvoiceLineTrackId] ON [InvoiceLine] ([TrackId])x='indexIFK_PlaylistTrackTrackIdPlaylistTrackCREATE INDEX [IFK_PlaylistTrackTrackId] ON [PlaylistTrack] ([TrackId])W-yindexIFK_TrackAlbumIdTrackCREATE INDEX [IFK_TrackAlbumId] ON [Track] ([AlbumId])W-yindexIFK_TrackGenreIdTrackCREATE INDEX [IFK_TrackGenreId] ON [Track] ([GenreId])d5 indexIFK_TrackMediaTypeIdTrackCREATE INDEX [IFK_TrackMediaTypeId] ON [Track] ([MediaTypeId])OwindexIPK_AlbumAlbum CREATE UNIQUE INDEX [IPK_Album] ON [Album]([AlbumId])     ! w w       3Zm93O"windexIPK_TrackTrack+CREATE UNIQUE INDEX [IPK_Track] ON [Track]([TrackId])~!/'3indexIPK_PlaylistTrackPlaylistTrack*CREATE UNIQUE INDEX [IPK_PlaylistTrack] ON [PlaylistTrack]([PlaylistId], [TrackId])T!}indexIPK_ArtistArtist!CREATE UNIQUE INDEX [IPK_Artist] ON [Artist]([ArtistId])_% indexIPK_CustomerCustomer"CREATE UNIQUE INDEX [IPK_Customer] ON [Customer]([CustomerId])_% indexIPK_EmployeeEmployee$CREATE UNIQUE INDEX [IPK_Employee] ON [Employee]([EmployeeId])OwindexIPK_GenreGenre%CREATE UNIQUE INDEX [IPK_Genre] ON [Genre]([GenreId])Z#indexIPK_InvoiceInvoice&CREATE UNIQUE INDEX [IPK_Invoice] ON [Invoice]([InvoiceId])n+#indexIPK_InvoiceLineInvoiceLine'CREATE UNIQUE INDEX [IPK_InvoiceLine] ON [InvoiceLine]([InvoiceLineId])d'indexIPK_MediaTypeMediaType(CREATE UNIQUE INDEX [IPK_MediaType] ON [MediaType]([MediaTypeId])_ % indexIPK_PlaylistPlaylist)CREATE UNIQUE INDEX [IPK_Playlist] ON [Playlist]([PlaylistId])  l~xrl           ! w w