FrontAccounting forum — Line 1369 in en_US-demo.sql can be removed

Re: Line 1369 in en_US-demo.sql can be removed

2019-03-04T15:37:24Z

The following should do the job:

sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-demo.sql
sed -e 's/AUTO_INCREMENT=[0-9]* //g' -i sql/en_US-new.sql

2019-03-04T07:48:20Z

This has been fixed and committed to stable repo. The AUTO_INCREMENT removal will wait until later due to backwards compatibility.

Joe

2019-03-03T17:24:15Z

Line 1950 needs to be PRIMARY KEY:

 UNIQUE KEY `record_id` (`record_id`,`tag_id`)

Check in en_US-new.sql also.

2019-03-03T16:40:49Z

No, hardly not. Will remove it and commit later.

Joe

2019-03-03T16:34:10Z

@joe: Please check if line 1369 in en-US-demo.sql is necessary - it is dated in 2012:

('1', '0', '001/2012'),

There are many long char fields that should actually be varchar.
All AUTO_INCREMENT=XXX strings can be removed.