Lines Matching refs:sql_exec
113 ret = sql_exec(db, "INSERT into OBJECTS"
173 sql_exec(db, "INSERT into OBJECTS"
208 sql_exec(db, "INSERT into OBJECTS"
218 sql_exec(db, "INSERT into OBJECTS"
262 sql_exec(db, "INSERT into OBJECTS"
298 sql_exec(db, "INSERT into OBJECTS"
303 sql_exec(db, "INSERT into OBJECTS"
338 sql_exec(db, "INSERT into OBJECTS"
343 sql_exec(db, "INSERT into OBJECTS"
354 sql_exec(db, "INSERT into OBJECTS"
369 sql_exec(db, "INSERT into OBJECTS"
424 sql_exec(db, "INSERT into OBJECTS"
445 sql_exec(db, "INSERT into OBJECTS"
506 sql_exec(db, "INSERT into OBJECTS"
529 sql_exec(db, "INSERT into OBJECTS"
562 ret = sql_exec(db, "CREATE TABLE OBJECTS ( "
573 ret = sql_exec(db, "CREATE TABLE DETAILS ( "
599 ret = sql_exec(db, "CREATE TABLE ALBUM_ART ( "
605 ret = sql_exec(db, "CREATE TABLE CAPTIONS ("
611 ret = sql_exec(db, "CREATE TABLE PLAYLISTS ("
620 ret = sql_exec(db, "CREATE TABLE SETTINGS ("
626 ret = sql_exec(db, "INSERT into SETTINGS values (0, 0)");
631 ret = sql_exec(db, "INSERT into OBJECTS (OBJECT_ID, PARENT_ID, DETAIL_ID, CLASS, NAME)"
638 sql_exec(db, "create INDEX IDX_OBJECTS_OBJECT_ID ON OBJECTS(OBJECT_ID);");
639 sql_exec(db, "create INDEX IDX_OBJECTS_PARENT_ID ON OBJECTS(PARENT_ID);");
640 sql_exec(db, "create INDEX IDX_OBJECTS_DETAIL_ID ON OBJECTS(DETAIL_ID);");
641 sql_exec(db, "create INDEX IDX_OBJECTS_CLASS ON OBJECTS(CLASS);");
642 sql_exec(db, "create INDEX IDX_DETAILS_PATH ON DETAILS(PATH);");
643 sql_exec(db, "create INDEX IDX_DETAILS_ID ON DETAILS(ID);");
644 sql_exec(db, "create INDEX IDX_ALBUM_ART ON ALBUM_ART(ID);");
645 sql_exec(db, "create INDEX IDX_SCANNER_OPT ON OBJECTS(PARENT_ID, NAME, OBJECT_ID);");
837 sql_exec(db, "create INDEX IDX_SEARCH_OPT ON OBJECTS(OBJECT_ID, CLASS, DETAIL_ID);");
842 sql_exec(db, "pragma user_version = %d;", DB_VERSION);