search

sougatamondal / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Invalid SQL generated when creating table with indexes on SQLite #76

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
db.AddTable("System_SecurityCache",
new Column("SubjectId", DbType.Guid, ColumnProperty.NotNull | 
ColumnProperty.Indexed),
 new Column("EntityId", DbType.Guid, ColumnProperty.NotNull |  
ColumnProperty.Indexed),
new Column("AccessTypeId", DbType.Guid, ColumnProperty.NotNull));

SQLite exception "error near index " is thrown when adding table like this.

Sql generated is:
CREATE TABLE System_SecurityCache (SubjectId UNIQUEIDENTIFIER NOT NULL, 
EntityId UNIQUEIDENTIFIER NOT NULL, AccessTypeId UNIQUEIDENTIFIER NOT 
NULL, INDEX("SubjectId"), INDEX("EntityId"))

which doesn't seem to be valid

using version 0.7  , tried to checkout latest source from svn, but got 
lots of problems with incompatible sqlite library versions

Original issue reported on code.google.com by alex.uni...@gmail.com on 15 Oct 2008 at 5:18