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

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

null@example.com (apmuthu) — Mon, 04 Mar 2019 15:37:24 +0000

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

null@example.com (joe) — Mon, 04 Mar 2019 07:48:20 +0000

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

Joe

null@example.com (apmuthu) — Sun, 03 Mar 2019 17:24:15 +0000

Line 1950 needs to be PRIMARY KEY:

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

Check in en_US-new.sql also.

null@example.com (joe) — Sun, 03 Mar 2019 16:40:49 +0000

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

Joe

null@example.com (apmuthu) — Sun, 03 Mar 2019 16:34:10 +0000

@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.