CMS Made Simple Forums

Posted: **Tue May 11, 2010 12:55 pm**

Should I rather use :

$flds = "
	ipwatch_id I AUTOINCREMENT PRIMARY,
	(...)
";

OR

Code: Select all

$flds = "
	ipwatch_id I KEY,
	(...)
";
(...)
$db->CreateSequence(cms_db_prefix().'module_iplock_watch_seq');

The first one looks easier to use to me, so what's the catch ?

Thanks in advance.
--
Redwarp

Posted: **Tue May 11, 2010 1:23 pm**

PS : I read that squences were important because of certain db that don't support auto increment, but I also heard that cms made simple didn't support them anymore, so... I'm basically lost !

Posted: **Tue May 11, 2010 2:09 pm**

Sequence tables were used because common versions of postgres didn't support auto increment fields back in the day when CMSMS was started.

We're not using sequence tables on any new development now.

Posted: **Tue May 11, 2010 2:11 pm**

Thanks !
Then I'll modify my code. It's gonna be a lot easier !

CMS Made Simple Forums

[SOLVED] ADOBD : creating a database : sequence or auto-increment ?

[SOLVED] ADOBD : creating a database : sequence or auto-increment ?

Re: ADOBD : creating a database : sequence or auto-increment ?

Re: ADOBD : creating a database : sequence or auto-increment ?

Re: ADOBD : creating a database : sequence or auto-increment ?