• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Setting start value for auto increment field with ci migrations

#1
[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.

#2
[eluser]Aken[/eluser]
http://stackoverflow.com/questions/21306...-from-1000

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

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

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

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

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

#8
[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...

#9
[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.

#10
[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.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.