FrontAccounting forum — What does Table Pref refer to in Company Setup?

Re: What does Table Pref refer to in Company Setup?

null@example.com (apmuthu) — Thu, 25 Jun 2020 05:55:00 +0000

The counter value is in the file config_db.php where the variable $tb_pref_counter should refer to the next available array element.

The command to set the auto increment field correctly (self-adjusting) at the end would be:

ALTER TABLE  AUTO_INCREMENT = 1;

but in FA, there is no "Company" table.

Re: What does Table Pref refer to in Company Setup?

null@example.com (cedricktshiyoyo) — Wed, 24 Jun 2020 12:59:33 +0000

@scendraw of course database field are Auto-incremental, especially if the field is a primary key. It doesn't matter whether you delete a record or not, the space is already taken, the next record will be auto-increment. So what you can do is update the structure of your table.

Syntax:
ALTER TABLE table_name AUTO_INCREMENT = start_value;

For Example:

ALTER TABLE Company AUTO_INCREMENT = 50;

Hope this help

Re: What does Table Pref refer to in Company Setup?

null@example.com (scendraw) — Wed, 24 Jun 2020 05:27:29 +0000

I deleted a company with table pref 3_ then I went on to create another company but I cannot choose 3_ it has to be 4_.

Is this normal?

Re: What does Table Pref refer to in Company Setup?

null@example.com (joe) — Wed, 17 Feb 2010 23:59:49 +0000

Many webhosts only allow clients to have one MySql database. By using table prefixes, you can have multiple companies inside one database. The first company gets 0_ in front of all the tables, the next company gets 1_ and so on.
You don't need to use this feature, if you can create an unlimited amount of databases. However many like to have all their companies inside one database.

/Joe

What does Table Pref refer to in Company Setup?

null@example.com (avb3) — Wed, 17 Feb 2010 21:46:14 +0000

I searched the forum and wiki and cannot find a reference to this. It seems to increment a number (_3 or _6) when you add a company, yet I had some functions appear not to work if I let the incrementation occur. If I leave it as blank, then all functions appear to work.

Any suggestions?