"DELETE FROM %s WHERE file_id = :file_id AND deleted = 1"
"DELETE FROM %s WHERE deleted = 1 AND deleted_at <= :deleted_at"
"INSERT INTO %s (id,source_hostname,synced_on_hostnames,deleted_on_hostnames,file_id,file_name,file_parent_path,file_type,file_part_index,file_part_size,file_part_data_ds,file_part_data_table,file_part_last_index,file_size,file_modify_time,file_deleted,created_user_id,updated_user_id,deleted_user_id,created_at,updated_at,deleted_at,deleted) VALUES (:id,:source_hostname,:synced_on_hostnames,:deleted_on_hostnames,:file_id,:file_name,:file_parent_path,:file_type,:file_part_index,:file_part_size,:file_part_data_ds,:file_part_data_table,:file_part_last_index,:file_size,:file_modify_time,:file_deleted,:created_user_id,:updated_user_id,NULL,:created_at,:updated_at,NULL,0)"
"INSERT INTO %s (id,file_id,remote_file_id,file_part_data,created_at,updated_at,deleted_at,deleted) VALUES (:id,:file_id,:remote_file_id,:file_part_data,:created_at,:updated_at,NULL,0)"
"SELECT * FROM %s WHERE file_part_index = 0 AND file_parent_path = :file_parent_path AND file_name = :file_name ORDER BY created_at DESC"
"SELECT * FROM %s WHERE deleted = 0 AND remote_file_id = :remote_file_id"
"SELECT * FROM %s WHERE file_deleted = 0 AND deleted = 0 AND file_part_index = 0 AND file_part_last_index > -1 AND file_id = :file_id"
"SELECT * FROM %s WHERE deleted = 0 AND file_id = :file_id ORDER BY file_part_index ASC"
"SELECT * FROM %s WHERE deleted = 0 AND file_id = :file_id AND file_type = \'F\' ORDER BY file_part_index ASC"
"SELECT * FROM %s WHERE deleted = 0 AND file_type = \'F\' AND file_part_last_index = -1 AND file_part_index = 0 AND updated_at < :before_updated_at AND (file_parent_path = :file_parent_path OR (file_parent_path LIKE :like_file_parent_path)) ORDER BY created_at ASC"
"SELECT file_part_data_ds,file_part_data_table,file_id,file_type FROM %s WHERE deleted = 1 AND deleted_at <= :before_deleted_at AND (file_parent_path = :file_parent_path OR file_parent_path LIKE :like_file_parent_path) GROUP BY file_part_data_ds,file_part_data_table,file_id,file_type ORDER BY file_part_data_table ASC"
"SELECT file_part_data_ds,file_part_data_table,file_id,file_type FROM %s WHERE file_deleted = 1 AND deleted = 0 AND deleted_at <= :before_deleted_at AND file_type IN (\'F\',\'L\') AND (file_parent_path = :file_parent_path OR file_parent_path LIKE :like_file_parent_path) GROUP BY file_part_data_ds,file_part_data_table,file_id,file_type ORDER BY file_part_data_table ASC"
"SELECT * FROM %s WHERE deleted = 0 AND file_deleted = 0 AND file_part_last_index > -1 AND file_part_index = 0 AND file_parent_path = :file_parent_path AND file_name = :file_name ORDER BY updated_at DESC"
"SELECT COUNT(id) AS as_count FROM %s WHERE file_parent_path = :file_parent_path AND file_name = :file_name AND file_part_index = 0"
"SELECT * FROM %s WHERE deleted = 0 AND file_part_index = 0 AND file_part_last_index > -1 AND (file_parent_path = :file_parent_path OR (file_parent_path LIKE :like_file_parent_path)) AND deleted_on_hostnames NOT LIKE :deleted_on_hostnames ORDER BY created_at ASC"
"SELECT * FROM %s WHERE file_parent_path = :file_parent_path AND file_name = :file_name AND file_part_index = 0 AND deleted = 0 AND file_deleted = 0"
"SELECT * FROM %s WHERE file_id = :file_id AND file_parent_path = :file_parent_path AND file_name = :file_name ORDER BY file_part_index DESC"
"SELECT * FROM %s WHERE file_part_index = 0 AND file_parent_path = :file_parent_path AND file_name = :file_name ORDER BY updated_at DESC"
"SELECT * FROM %s WHERE deleted = 0 AND file_part_index = 0 AND file_part_last_index > -1 AND file_parent_path LIKE :file_parent_path AND file_name LIKE :file_name ORDER BY created_at ASC"
"SELECT * FROM %s WHERE file_part_index = 0 AND file_part_last_index > -1 AND file_parent_path LIKE :file_parent_path AND file_name LIKE :file_name AND file_deleted = 1 AND deleted = 0 AND file_modify_time >= :begin_time AND file_modify_time <= :end_time AND created_at <= :created_at AND deleted_on_hostnames NOT LIKE :deleted_on_hostnames ORDER BY file_type,deleted_at ASC"
"SELECT * FROM %s WHERE deleted = 0 AND file_part_index = 0 AND file_part_last_index > -1 AND file_part_data_table = :file_part_data_table AND file_modify_time >= :begin_time AND file_modify_time <= :end_time AND created_at <= :created_at AND (file_parent_path = :file_parent_path OR (file_parent_path LIKE :like_file_parent_path)) AND deleted_on_hostnames NOT LIKE :deleted_on_hostnames ORDER BY created_at ASC"
"SELECT * FROM %s WHERE file_part_index = 0 AND file_part_last_index > -1 AND file_parent_path LIKE :file_parent_path AND file_name LIKE :file_name AND deleted = 0 AND file_deleted = 0 AND file_modify_time >= :begin_time AND file_modify_time <= :end_time AND created_at <= :created_at AND synced_on_hostnames NOT LIKE :synced_on_hostnames ORDER BY created_at ASC"
"SELECT * FROM %s WHERE deleted = 0 AND file_part_index = 0 AND file_part_last_index > -1 AND (file_parent_path = :file_parent_path OR (file_parent_path LIKE :like_file_parent_path)) ORDER BY file_part_data_table DESC"
"SELECT SUM(file_part_size) AS file_part_size,MAX(file_part_index) AS file_part_index,MAX(created_at) AS created_at FROM %s WHERE deleted = 0 AND file_id = :file_id AND file_parent_path = :file_parent_path AND file_name = :file_name GROUP BY file_id,file_parent_path,file_name"
"SELECT * FROM %s WHERE deleted = 0 AND file_type = \'F\' AND file_part_last_index = -1 AND file_parent_path = :file_parent_path AND file_name = :file_name ORDER BY updated_at DESC"
"SELECT * FROM %s WHERE file_id = :file_id AND file_part_index = 0"
"SELECT * FROM %s WHERE id = :id"
"UPDATE %s SET file_part_data = NULL,deleted = 1,deleted_at = :deleted_at WHERE file_id = :file_id"
"UPDATE %s SET file_part_last_index = :file_part_last_index,file_size = :file_size,file_modify_time = :file_modify_time,updated_at = :updated_at,updated_user_id = :updated_user_id WHERE deleted = 0 AND file_part_index = 0 AND file_id = :file_id"
"UPDATE %s SET file_deleted = :file_deleted,deleted = :deleted,deleted_user_id = :deleted_user_id,deleted_at = :deleted_at,updated_user_id = :updated_user_id,updated_at = :updated_at WHERE deleted = 0 AND ((file_parent_path = :file_parent_path AND file_name = :file_name) OR file_parent_path = :root_folder OR file_parent_path LIKE :like_subfolder)"
"UPDATE %s SET file_deleted = :file_deleted,deleted = :deleted,deleted_user_id = :deleted_user_id,deleted_at = :deleted_at,updated_user_id = :updated_user_id,updated_at = :updated_at WHERE file_parent_path = :file_parent_path AND file_name = :file_name AND file_type = :file_type AND deleted = 0"
"UPDATE %s SET deleted_on_hostnames = :deleted_on_hostnames,updated_at = :updated_at,updated_user_id = :updated_user_id WHERE file_deleted = 1 AND file_parent_path = :file_parent_path AND file_name = :file_name AND file_part_index = 0 AND file_part_last_index > -1"
"UPDATE %s SET deleted_on_hostnames = :deleted_on_hostnames,updated_at = :updated_at,updated_user_id = :updated_user_id WHERE file_deleted = 1 AND (file_parent_path = :file_parent_path OR file_parent_path LIKE :like_file_parent_path)"
"UPDATE %s SET synced_on_hostnames = :synced_on_hostnames,updated_at = :updated_at,updated_user_id = :updated_user_id WHERE file_parent_path = :file_parent_path AND file_name = :file_name AND file_part_index = 0 AND file_part_last_index > -1"
"UPDATE %s SET deleted = 1,deleted_at = :deleted_at,deleted_user_id = :deleted_user_id WHERE file_id = :file_id AND deleted = 0"