Kermit Mei wrote:
> I have three table like this:
>
> Device(id,name,icon,type) -id as primary key
>
> ZWavePhsicalDevice(id,funcode) -id as primary key
>
> ZWaveGSDevice(Device.id, ZWavePhsicalDevice.id,order)
> -Device.id and ZWavePhsicalDevice.id as mutil primary keys.
>
> Now, I don't know how to build the ZWaveGSDevice(...) in sqlite3 ?
The same way as in any other SQL database:
create table ZWaveGSDevice(Device_id, ZWavePhsicalDevice_id, order,
primary key(Device_id, ZWavePhsicalDevice_id));
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
