search for: auto_incement

...rformed is DELETE FROM... and not TRUNCATE (which resets the auto increment counter) It seems that Skill.delete_all doesn''t reset the auto_increment counter on the database table. Hope you can help me with my questions here: Q1: Is it a bug in Rails that Class.delete_all does not reset auto_incement counter? Q2: Is there a workaround that I can use? (for instance, how can I do an SQL query ''TRUNCATE skills'') Any help appreciated! -- -- Jesper R?nn-Jensen Capgemini Danmark A/S +45 23 73 62 20 (Mobile) http://justaddwater.dk/ (weblog)

Hey there :) I''m creating this app on top of a legacy database, that has a mixture of auto_inc ids, non-''id'' named pks, non-integer-pks, foreign keys that end in _code instead of _id, etc. I have the model working great in the console, where I can create any modeled object and reference other objects without issues. However, I''m running into problems with

Hello, I created a table and about 10 migrations down the line I decided that I needed to add an ID column (this was actually a table for a has_many :through and I recently realized that it needs an ID column, unlike HABTM tables). I am a big perfectionist and I frequently run "SHOW COLUMNS IN table;", so I naturally expect to see the "id" column the first one listed. However,

I''m working on a simple CMS. The main data type are "listings" a listing habtm (has_and_belongs_to_many) categories and subcategories. Subcategories belong_to categories. Subcategories are basically the same as categories, but they are treated differently in a few situations. The problem is, I can''t seem to write the view/controller/model code that allows me to