SQLite format 3@ " "".$  C h &   #%indexindex_platepic_struct_t CREATE INDEX [index_plate] ON [pic_struct_t] ([plate] ASC)-%indexindex_park_statepic_struct_t CREATE INDEX [index_park_state] ON [pic_struct_t] ([park_state] ASC)&'% indexindex_reco_idpic_struct_tCREATE INDEX [index_reco_id] ON [pic_struct_t] ([reco_id] ASC)+%indexindex_recg_timepic_struct_tCREATE INDEX [index_recg_time] ON [pic_struct_t] ([recg_time] DESC)S)% indexindex_group_idpic_struct_tCREATE INDEX [index_group_id] ON [pic_struct_t] ([group_id] ASC)'% indexindex_zone_idpic_struct_tCREATE INDEX [index_zone_id] ON [pic_struct_t] ([zone_id] ASC))%indexindex_page_idxpic_struct_tCREATE INDEX [index_page_idx] ON [pic_struct_t] ([page_idx] DESC)+%indexindex_block_idxpic_struct_tCREATE INDEX [index_block_idx] ON [pic_struct_t] ([block_idx] DESC)%%tablepic_struct_tpic_struct_tCREATE TABLE [pic_struct_t] ( [id] INTEGER PRIMARY KEY, [block_idx] INT NOT NULL, -- 图片存储的blockid [page_idx] INT NOT NULL, -- 图片存储在block#%indexindex_platepic_struct_tCREATE INDEX [index_plate] ON [pic_struct_t] ([plate] ASC)z'% indexindex__#%indexindex_platepic_struct_tCREATE INDEX [index_plate] ON [pic_struct_t] ([plate] DESC)k+%indexindex_recg_timepic_struct_tCREATE INDEX [index_recg_time] ON [pic_struct_t] ([recg_time] DESC)j)%indexindex_page_idxpic_struct_tCREATE INDEX [index_page_idx] ON [pic_struct_t] ([page_index] DESC)m+%indexindex_block_idxpic_struct_tCREATE INDEX [index_block_idx] ON [pic_struct_t] ([block_index] DESC):%%7tablepic_struct_tpic_struct_tCREATE TABLE [pic_struct_t] ( [id] INTEGER PRIMARY KEY, [block_index] INT NOT NULL, -- 图片存储的blockid-- [page_index] INT NOT NULL, -- 图片存储在block中的page id [image_size] INT NOT NULL, -- 图片的大小 [struct_size] INT NOT NULL, -- 结构化信息的大小 [event_rec_time] INT NOT NULL, -- 关联事件录像的时间 [channel] INT, --通道号 [trigger] INT, --触发类型 [recg_time] INT, --识别时间(秒) [alarm] INT, --报警状态 [retry] INT, --重传标记 [plate] text --车牌号码(utf-8) )