I'm creating SQLite tables from code and could use help with the following issues:
1. I'd like some tables to include foreign keys. These should be indexed for speed, but they are neither primary keys or unique. But I don't see any option to index a column without it being one of those two? 2. In my first attempt at this, I used INT data types for columns. It seemed to be working but when I added AUTOINCREMENT, I get an error that this is only valid with INTEGER types. When I changed INT to INTEGER, it works fine. So what the heck type was used when I specified INT? 3. I've been using VARCHAR(n) but see that the SQLite documentation only documents TEXT. Can anyone provide tips or a link to help me decide which of the two is best? If it makes any difference, I will be storing Unicode text (16-bits per character). Thanks! -- View this message in context: http://www.nabble.com/Help-Creating-Tables-tp18918853p18918853.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
