CodeIgniter Forums

Full Version: Setting start value for auto increment field with ci migrations
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]xtremer360[/eluser]
Earlier today I signed up for a nettuts plus account and have been watching this series on codeigniter cms building. I am creating a migration file to create my users table. With my user ids I prefer to work with user ids that look like this 10000 and increment to 10001 for the next inserted user. What I'm trying to figure out was how do I setup so that when it creates the users table then to have the key start at 10000

https://tutsplus.com/course/build-a-cms-in-codeigniter/

After looking around I am not able to find out how to accomplish this. If anyone knows please help me out.

El Forum

El Forum

[eluser]xtremer360[/eluser]
My fault I'm trying to figure out how to accomplish this with migrations.

El Forum

[eluser]xtremer360[/eluser]
Does anybody know?

El Forum

[eluser]Aken[/eluser]
Just run the ALTER TABLE query using $this->db->query().

El Forum

[eluser]xtremer360[/eluser]
Inside the migrations file?

El Forum

[eluser]xtremer360[/eluser]
Is this how?

El Forum

[eluser]Aken[/eluser]
In the 8 1/2 hours in between those two posts, you couldn't just TRY it? Yes in the migrations file; you asked about migrations after all...

El Forum

[eluser]xtremer360[/eluser]
It works but I was curious as to why when you set the primary key you can't tell it to start at 10000 when you set the key.

El Forum

[eluser]Aken[/eluser]
You can if you write the query yourself. CI does not have that feature. If you think it should be added, bring it up on Github.