> If the column is INTEGER, the default value shouldn't be a string. > This is especially true of the INTEGER PRIMARY KEY column.
I didn't make this schema, so I can take no credit (or blame) for its design. This schema was created by the Webform module, which is a contributed module to the Drupal project. I will give your feedback to the developers of that module, but they're not using SQLite exclusively and there might be a reason why they have those extra indexes there for other database engines. Then again, I do agree that there seems to be a bit of cruft there. > It is a bug. The ticket is here: > https://www.sqlite.org/src/tktview/a0bac8b3c3 Thanks! > The bug is now fixed on trunk. Thanks again! I appreciate the quick fix. -- Tim Gustafson Technical Lead, Baskin School of Engineering [email protected] 831-459-5354 Baskin Engineering, Room 313A The most dangerous phrase in the language is, "We've always done it this way." - Grace Hopper _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
