I think the following header:
SET client_encoding = 'WIN1252';
should be added on top of Chinook_PostgreSql.sql since it actually use that encoding, but the default for psql is UTF8 nowadays, no m...
Id #29384 | Release:
| Updated: Jun 28, 2016 at 3:54 PM by teejay87 | Created: Jun 28, 2016 at 3:54 PM by teejay87
Should be update to require minimum version: 4.0.8876.1
Happy to do a pull request if desired...
Id #29383 | Release:
Chinook Database 1.4
| Updated: Nov 23, 2014 at 5:56 AM by lerocha | Created: Oct 24, 2014 at 11:25 AM by ErikEJ
Getting the following error now:
Error: near line 1: near "xxx": syntax error
Id #29382 | Release:
| Updated: Jul 16, 2014 at 11:40 AM by xarkam | Created: Mar 30, 2014 at 8:57 PM by pop8808
when running the batch file in command window, received the following error message
'sqlite3' is not recognized as an internal or external command, operable program or batch file.
Id #29381 | Release:
| Updated: Mar 31, 2014 at 4:35 PM by lerocha | Created: Mar 29, 2014 at 11:46 PM by pop8808
Wrap at least the INSERT Statements within the sqlite script into transactions per default.
Id #29380 | Release:
| Updated: Mar 7, 2013 at 3:06 AM by lerocha | Created: Mar 7, 2013 at 3:06 AM by lerocha
It would be nice to include
SET DATEFORMAT ymd;
statement to SQL Server script file (maybe some other scripts also need that fix) to guarantee correct data conversion from varchar to datetime.
Id #29379 | Release:
| Updated: Feb 13, 2013 at 4:23 PM by lerocha | Created: Feb 13, 2013 at 2:01 PM by skeeter_by
I know this is a just a "sample" database, but I'm using it in demos and I can't have people see me choosing lame music. Please add "Electronica" as a genre in the database. :)
Id #29376 | Release:
| Updated: Oct 20, 2012 at 3:07 AM by lerocha | Created: Nov 30, 2010 at 5:22 PM by Haacked
Note: This bug has been reported by a user (Thanks Gordon!).
Regardless, the following code in ITunesToChinookDataSetConverter.cs:
private static int AddAlbum(TrackInfo trackInfo, ChinookDataSet...
Id #29371 | Release:
| Updated: Dec 3, 2012 at 1:31 AM by lerocha | Created: Nov 7, 2010 at 1:08 AM by lerocha
It would be nice if there were a pluralized table name version of the scripts.
Create Table Customer
Create Table Customers
Id #26964 | Release:
| Updated: May 4, 2010 at 8:51 PM by LordBender | Created: May 4, 2010 at 8:51 PM by LordBender
This request is from Rub member of the uNhAddIns project (Unofficial addins for NHibernate): http://code.google.com/p/unhaddins/
Change the data model to allow developers to implement the three b...
Id #22184 | Release:
| Updated: Nov 14, 2010 at 8:07 PM by lerocha | Created: Apr 26, 2009 at 10:30 PM by lerocha