[sqlite] how to store a object into database？

[jiffies]

hello，
          I'm a new programer to sqlite and SQL . I have a struct like
this
   typedef struct program
{
    int tp_id;

    UM_U32 provider_lock    : 1;
    UM_U32 subtitle_pid   :13;
    UM_U32 teletext_pid   :13;
    UM_U32 cur_audio      : 5;

    UM_U8 oes_type[MAX_OES_CNT];
    UM_U16 oes_pid[MAX_OES_CNT];
}/*__attribute__((packed))*/ P_NODE;

what SQL should i use?
how to create a table?
how to insert ?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users