SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
'SELECT 1 FROM `test`'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM projects'
1
  • /app/Schema/Migration.php
'Update van dit bord niet mogelijk.'
1
  • /app/Locale/nl_NL/translations.php
'SELECT 1 FROM swimlanes WHERE name=? AND project_id=?'
1
  • /app/Schema/Migration.php
'INSERT INTO swimlanes (project_id, name, is_active, position) VALUES (?, ?, ?, ?)'
1
  • /app/Schema/Migration.php
"UPDATE swimlanes SET position=position+1 WHERE project_id=? AND is_active='1' AND id!=?"
1
  • /app/Schema/Migration.php
"UPDATE tasks SET swimlane_id=? WHERE swimlane_id='0' AND project_id=?"
1
  • /app/Schema/Migration.php
"SELECT action_has_params.id FROM action_has_params LEFT JOIN actions ON actions.id=action_has_params.action_id WHERE project_id=? AND name='swimlane_id' AND value='0'"
1
  • /app/Schema/Migration.php
"UPDATE action_has_params SET value=? WHERE id=?"
1
  • /app/Schema/Migration.php
'INSERT INTO project_activities SELECT * FROM project_activities_bak'
1
  • /app/Schema/Sqlite.php
'SELECT 1 FROM ' . $this->table . ' WHERE ' . $this->key . '=?'
1
  • /libs/SimpleValidator/Validators/Exists.php
'UPDATE comments SET date_modification = date_creation WHERE date_modification IS NULL;'
1
  • /app/Schema/Sqlite.php
'SELECT * FROM users'
1
  • /app/Schema/Sqlite.php
'UPDATE users SET "role"=? WHERE "id"=?'
1
  • /app/Schema/Sqlite.php
"DELETE FROM settings WHERE option='subtask_time_tracking'"
1
  • /app/Schema/Sqlite.php
'UPDATE tasks SET date_completed=date_creation WHERE is_active=0'
1
  • /app/Schema/Sqlite.php
"DELETE FROM settings WHERE `option`='application_datetime_format'"
1
  • /app/Schema/Mysql.php
'UPDATE `comments` SET `date_modification` = `date_creation` WHERE `date_modification` IS NULL'
1
  • /app/Schema/Mysql.php
'SELECT `a`, `b` FROM `test`'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT 1 FROM ' . $this->table . '
                    WHERE ' . $this->field . '=? AND ' . $this->primary_key . ' != ?'
1
  • /libs/SimpleValidator/Validators/Unique.php
'UPDATE `users` SET `role`=? WHERE `id`=?'
1
  • /app/Schema/Mysql.php
'SELECT `version` FROM `' . $this->schemaTable . '`'
1
  • /libs/picodb/lib/PicoDb/Driver/Mysql.php
'INSERT INTO ' . $this->escape($table) . ' (' . $this->escape($keyColumn) . ', ' . $this->escape($valueColumn) . ') VALUES (?, ?)'
1
  • /libs/picodb/lib/PicoDb/Driver/Base.php
'SELECT VERSION()'
1
  • /libs/picodb/lib/PicoDb/Driver/Base.php
'SELECT [version] FROM [' . $this->schemaTable . ']'
1
  • /libs/picodb/lib/PicoDb/Driver/Mssql.php
'INSERT INTO [' . $this->schemaTable . '] VALUES(0)'
1
  • /libs/picodb/lib/PicoDb/Driver/Mssql.php
'UPDATE [' . $this->schemaTable . '] SET [version]=?'
1
  • /libs/picodb/lib/PicoDb/Driver/Mssql.php
'INSERT OR REPLACE INTO %s (%s, %s) VALUES (?, ?)'
1
  • /libs/picodb/lib/PicoDb/Driver/Sqlite.php
'SELECT sqlite_version()'
1
  • /libs/picodb/lib/PicoDb/Driver/Sqlite.php
'INSERT INTO `' . $this->schemaTable . '` VALUES(0)'
1
  • /libs/picodb/lib/PicoDb/Driver/Mysql.php
'SELECT 1 FROM ' . $this->table . ' WHERE ' . $this->field . '=?'
1
  • /libs/SimpleValidator/Validators/Unique.php
'UPDATE `' . $this->schemaTable . '` SET `version`=?'
1
  • /libs/picodb/lib/PicoDb/Driver/Mysql.php
'SELECT "version" FROM "' . $this->schemaTable . '"'
1
  • /libs/picodb/lib/PicoDb/Driver/Postgres.php
'INSERT INTO ' . $this->schemaTable . ' VALUES(0)'
1
  • /libs/picodb/lib/PicoDb/Driver/Postgres.php
'UPDATE ' . $this->schemaTable . ' SET version=?'
1
  • /libs/picodb/lib/PicoDb/Driver/Postgres.php
'SHOW server_version'
1
  • /libs/picodb/lib/PicoDb/Driver/Postgres.php
'UPDATE %s SET %s %s'
1
  • /libs/picodb/lib/PicoDb/Builder/UpdateBuilder.php
'INSERT INTO %s (%s) VALUES (%s)'
1
  • /libs/picodb/lib/PicoDb/Builder/InsertBuilder.php
'SELECT * FROM `users`'
1
  • /app/Schema/Mysql.php
'UPDATE `project_has_users` SET `role`=? WHERE `id`=?'
1
  • /app/Schema/Mysql.php
'SELECT 1 FROM ' . $this->escape($table) . ' WHERE ' . $this->escape($keyColumn) . '=?'
1
  • /libs/picodb/lib/PicoDb/Driver/Base.php
'Show sent overdue tasks'
1
  • /app/Console/TaskOverdueNotificationCommand.php
'UPDATE "users" SET "role"=? WHERE "id"=?'
1
  • /app/Schema/Postgres.php
"SELECT id FROM users WHERE notifications_enabled='1'"
1
  • /app/Schema/Postgres.php
'DELETE FROM "settings" WHERE "option"=\'subtask_time_tracking\''
1
  • /app/Schema/Postgres.php
"SELECT id FROM projects WHERE is_private='1'"
1
  • /app/Schema/Postgres.php
"UPDATE project_has_users SET is_owner='1' WHERE project_id=?"
1
  • /app/Schema/Postgres.php
"
        INSERT INTO config
        (webhooks_token, api_token)
        VALUES ('" . Token::getToken( ) . "', '" . Token::getToken( ) . "')
    "
1
  • /app/Schema/Postgres.php
'Update all installed plugins'
1
  • /app/Console/PluginUpgradeCommand.php
'Show database schema version'
1
  • /app/Console/DatabaseVersionCommand.php
'UPDATE "comments" SET date_modification = date_creation WHERE date_modification IS NULL'
1
  • /app/Schema/Postgres.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE swimlane_id=" . self::TABLE . ".id AND is_active='1'"
1
  • /app/Model/SwimlaneModel.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE swimlane_id=" . self::TABLE . ".id AND is_active='0'"
1
  • /app/Model/SwimlaneModel.php
'SELECT COUNT(*) FROM ' . GroupMemberModel::TABLE . ' WHERE group_id=' . self::TABLE . '.id'
1
  • /app/Model/GroupModel.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE column_id=" . self::TABLE . ".id AND is_active='1'"
1
  • /app/Model/ColumnModel.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE column_id=" . self::TABLE . ".id AND is_active='0'"
1
  • /app/Model/ColumnModel.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE column_id=" . self::TABLE . ".id AND swimlane_id=" . $swimlane_id . " AND is_active='1'"
1
  • /app/Model/ColumnModel.php
"SELECT COUNT(*) FROM " . TaskModel::TABLE . " WHERE column_id=" . self::TABLE . ".id AND swimlane_id=" . $swimlane_id . " AND is_active='0'"
1
  • /app/Model/ColumnModel.php
'SELECT * FROM "users"'
1
  • /app/Schema/Postgres.php
'UPDATE links SET opposite_id=? WHERE label=?'
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_hipchat_api_url'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_server'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_domain'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_username'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_password'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_nickname'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_jabber_room'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_hipchat'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_hipchat_room_id'"
1
  • /app/Schema/Mysql.php
"DELETE FROM `settings` WHERE `option`='subtask_forecast'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_hipchat_room_token'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_slack_webhook'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_slack_webhook_url'"
1
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE `option`='integration_slack_webhook_channel'"
1
  • /app/Schema/Mysql.php
"DELETE FROM `settings` WHERE `option`='subtask_time_tracking'"
1
  • /app/Schema/Mysql.php
'INSERT INTO `settings` VALUES (?, ?)'
1
  • /app/Schema/Mysql.php
"DELETE FROM `settings` WHERE `option`='webhook_url_task_creation'"
1
  • /app/Schema/Mysql.php
"DELETE FROM `settings` WHERE `option`='webhook_url_task_modification'"
1
  • /app/Schema/Mysql.php
'UPDATE ' . $this->escape($table) . ' SET ' . $this->escape($valueColumn) . '=? WHERE ' . $this->escape($keyColumn) . '=?'
1
  • /libs/picodb/lib/PicoDb/Driver/Base.php
"SELECT %s FROM %s WHERE %s='%d' AND %s='0' AND %s=%s LIMIT 1"
1
  • /app/Model/SubtaskTimeTrackingModel.php
'SELECT %s FROM %s %s %s %s %s %s %s'
1
  • /libs/picodb/lib/PicoDb/Table.php
'UPDATE %s SET %s=%s-%d ' . $this->conditionBuilder->build( )
1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT * FROM `test`       OFFSET 10'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`      LIMIT 2  OFFSET 0'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"   WHERE "a" > (SELECT "c" FROM "test2"   WHERE "d" = ?)'
1
  • /libs/picodb/tests/SqliteTableTest.php
'SELECT * FROM `test`      LIMIT 5  OFFSET 10'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT (SELECT 1 FROM "foobar" WHERE 1=1) AS `b` FROM `test`'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` = ? AND `b` = ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` != ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` IN (SELECT `c` FROM `test2`   WHERE `d` = ?)'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` NOT IN (?, ?)'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` NOT IN (SELECT `c` FROM `test2`   WHERE `d` = ?)'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`      LIMIT 10'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` LIKE BINARY ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` LIKE ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` > ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` >= ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` < ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` <= ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` IS NOT NULL'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE a=c AND `b` = ?'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` IS NOT NULL AND (`b` = ? OR `c` >= ?)'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`       OFFSET 0'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`   WHERE `a` IN (?, ?)'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"   WHERE "a" >= (SELECT "c" FROM "test2"   WHERE "d" = ?)'
1
  • /libs/picodb/tests/SqliteTableTest.php
'UPDATE %s SET %s=%s+%d ' . $this->conditionBuilder->build( )
1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT * FROM "test"   WHERE "a" IS NOT NULL AND ("b" = ? OR ("b" != ? OR "c" = ?) OR "c" >= ?)'
1
  • /libs/picodb/tests/SqliteTableTest.php
'SELECT * FROM `test`   GROUP BY `a`'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT DISTINCT `a`, `b` FROM `test`'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"   WHERE "a" ILIKE ?'
1
  • /libs/picodb/tests/PostgresTableTest.php
'DELETE FROM %s %s'
1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT COUNT(*) FROM %s ' . implode(' ', $this->joins) . $this->conditionBuilder->build( ) . $this->sqlOrder . $this->sqlLimit . $this->sqlOffset1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT SUM(%s) FROM %s ' . implode(' ', $this->joins) . $this->conditionBuilder->build( ) . $this->sqlOrder . $this->sqlLimit . $this->sqlOffset1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT 1 FROM %s ' . implode(' ', $this->joins) . $this->conditionBuilder->build( )
1
  • /libs/picodb/lib/PicoDb/Table.php
'SELECT * FROM `test`     ORDER BY `a` DESC, `b` ASC'
1
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"   WHERE "a" <= (SELECT "c" FROM "test2"   WHERE "d" = ?)'
1
  • /libs/picodb/tests/SqliteTableTest.php
'SELECT * FROM "test"   WHERE "a" < (SELECT "c" FROM "test2"   WHERE "d" = ?)'
1
  • /libs/picodb/tests/SqliteTableTest.php
'SELECT 1 FROM "test"'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
"DELETE FROM settings WHERE \"option\"='integration_slack_webhook_channel'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT id FROM users WHERE notifications_enabled=1'
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
'SELECT "a", "b" FROM "test"'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM `test`     ORDER BY `a` ASC, `b` ASC'
2
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT LASTVAL()'
2
  • /libs/picodb/lib/PicoDb/Driver/Postgres.php
  • /app/Schema/Migration.php
'SELECT * FROM `test`     ORDER BY `a` DESC'
2
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM `test`     ORDER BY `a` ASC'
2
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"      LIMIT 2  OFFSET 0'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'INSERT INTO comments SELECT * FROM comments_bak'
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
"
        INSERT INTO config
        (webhooks_token)
        VALUES ('" . Token::getToken( ) . "')
    "
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE option='webhook_url_task_creation'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"       OFFSET 10'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
"DELETE FROM settings WHERE option='subtask_forecast'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"     ORDER BY "a" DESC, "b" ASC'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"      LIMIT 10'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
"DELETE FROM settings WHERE \"option\"='integration_slack_webhook_url'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"       OFFSET 0'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT id FROM projects WHERE is_private=1'
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
'UPDATE project_has_users SET is_owner=1 WHERE project_id=?'
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
"UPDATE config SET api_token='" . Token::getToken( ) . "'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
"DELETE FROM settings WHERE option='webhook_url_task_modification'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_hipchat_room_token'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_slack_webhook'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_hipchat_room_id'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM `test`     ORDER BY `a` DESC, `b` DESC'
2
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"   WHERE "a" < ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" >= ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" <= ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" > ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" NOT IN (SELECT "c" FROM "test2"   WHERE "d" = ?)'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" NOT IN (?, ?)'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" IN (SELECT "c" FROM "test2"   WHERE "d" = ?)'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" IN (?, ?)'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" != ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
"DELETE FROM settings WHERE \"option\"='application_datetime_format'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"   WHERE "a" = ? AND "b" = ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" IS NOT NULL'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE a=c AND "b" = ?'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"   WHERE "a" IS NOT NULL AND ("b" = ? OR "c" >= ?)'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_username'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_hipchat_api_url'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_hipchat'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_room'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_nickname'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_password'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_domain'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber_server'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
"DELETE FROM settings WHERE \"option\"='integration_jabber'"
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'UPDATE project_has_users SET "role"=? WHERE "id"=?'
2
  • /app/Schema/Sqlite.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"   GROUP BY "a"'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"      LIMIT 5  OFFSET 10'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT (SELECT 1 FROM "foobar" WHERE 1=1) AS "b" FROM "test"'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT DISTINCT "a", "b" FROM "test"'
2
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT 1 FROM "foobar" WHERE 1=1'
3
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'INSERT INTO foobar (something) VALUES (1)'
3
  • /libs/picodb/tests/MysqlDriverTest.php
  • /libs/picodb/tests/SqliteDriverTest.php
  • /libs/picodb/tests/PostgresDriverTest.php
"INSERT INTO settings VALUES ('cfd_include_closed_tasks', '1')"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'UPDATE actions SET action_name=? WHERE id=?'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'UPDATE subtasks SET position=? WHERE id=?'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"UPDATE project_activities SET event_name='task.file.create' WHERE event_name='file.create'"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'SELECT * FROM project_has_users'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'INSERT INTO user_has_notification_types (user_id, notification_type) VALUES (?, ?)'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"INSERT INTO settings VALUES ('subtask_time_tracking', '1')"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"INSERT INTO settings VALUES ('default_color', 'yellow')"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"INSERT INTO settings VALUES ('integration_slack_webhook_channel', '')"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'SELECT * FROM "test"   WHERE "a" LIKE ?'
3
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM subtasks ORDER BY task_id, id ASC'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"INSERT INTO settings VALUES ('password_reset', '1')"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'INSERT INTO links (label, opposite_id) VALUES (?, ?)'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"UPDATE tasks
                SET date_moved = (
                    SELECT md
                    FROM (
                        SELECT task_id, max(date_creation) md
                        FROM project_activities
                        WHERE event_name IN ('task.create', 'task.move.column')
                        GROUP BY task_id
                    ) src
                    WHERE id = src.task_id
                )
                WHERE (date_moved IS NULL OR date_moved = 0) AND id IN (
                    SELECT task_id
                    FROM (
                        SELECT task_id, max(date_creation) md
                        FROM project_activities
                        WHERE event_name IN ('task.create', 'task.move.column')
                        GROUP BY task_id
                    ) src
                )"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"UPDATE tasks SET date_moved = date_creation WHERE date_moved IS NULL OR date_moved = 0"
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'SELECT * FROM config'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
"
        INSERT INTO users
        (username, password, is_admin)
        VALUES ('admin', '" . \password_hash('admin', PASSWORD_BCRYPT) . "', '1')
    "
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'INSERT INTO foobar'
3
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
'SELECT COUNT(*) FROM foobar WHERE something=?'
3
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
'SELECT * FROM actions'
3
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
'SELECT * FROM `test`'
4
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
  • /libs/picodb/tests/MysqlTableTest.php
'SELECT * FROM "test"     ORDER BY "a" ASC'
4
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"     ORDER BY "a" DESC, "b" DESC'
4
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"     ORDER BY "a" DESC'
4
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT * FROM "test"     ORDER BY "a" ASC, "b" ASC'
4
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT something FROM foobar WHERE something=?'
6
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
'SELECT * FROM "test"'
8
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/SqliteTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
  • /libs/picodb/tests/PostgresTableTest.php
'SELECT COUNT(*) FROM test'
12
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
'Select All'
21
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/sv_SE/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Template/task_list/header.php
'INSERT INTO foobar (something) VALUES (?)'
21
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/SqliteDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/PostgresDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
  • /libs/picodb/tests/MysqlDatabaseTest.php
'Update only assigned tasks is permitted'
23
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Model/ProjectRoleRestrictionModel.php
'Show subtasks'
24
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/zh_TW/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Template/task_list/header.php
'Insert after this task'
27
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/bs_BA/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/ko_KR/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/id_ID/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/zh_TW/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Template/task_move_position/show.php
'Insert before this task'
27
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/bs_BA/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/ko_KR/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/id_ID/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/zh_TW/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Template/task_move_position/show.php
'Select the new status of the subtask: "%s"'
32
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/bs_BA/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/el_GR/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/ko_KR/translations.php
  • /app/Locale/my_MY/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/id_ID/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/sv_SE/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/nl_NL/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/zh_TW/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Locale/th_TH/translations.php
  • /app/Template/subtask_restriction/show.php
'Show this column'
33
  • /app/Locale/vi_VN/translations.php
  • /app/Locale/ro_RO/translations.php
  • /app/Locale/ja_JP/translations.php
  • /app/Locale/bs_BA/translations.php
  • /app/Locale/es_VE/translations.php
  • /app/Locale/fr_FR/translations.php
  • /app/Locale/sk_SK/translations.php
  • /app/Locale/nb_NO/translations.php
  • /app/Locale/zh_CN/translations.php
  • /app/Locale/tr_TR/translations.php
  • /app/Locale/ca_ES/translations.php
  • /app/Locale/it_IT/translations.php
  • /app/Locale/el_GR/translations.php
  • /app/Locale/fa_IR/translations.php
  • /app/Locale/ru_RU/translations.php
  • /app/Locale/pt_PT/translations.php
  • /app/Locale/ko_KR/translations.php
  • /app/Locale/my_MY/translations.php
  • /app/Locale/de_DE/translations.php
  • /app/Locale/id_ID/translations.php
  • /app/Locale/da_DK/translations.php
  • /app/Locale/sv_SE/translations.php
  • /app/Locale/cs_CZ/translations.php
  • /app/Locale/uk_UA/translations.php
  • /app/Locale/pt_BR/translations.php
  • /app/Locale/nl_NL/translations.php
  • /app/Locale/hu_HU/translations.php
  • /app/Locale/zh_TW/translations.php
  • /app/Locale/es_ES/translations.php
  • /app/Locale/pl_PL/translations.php
  • /app/Locale/th_TH/translations.php
  • /app/Template/board/table_tasks.php
  • /app/Template/board/table_column.php
'INSERT INTO settings VALUES (?, ?)'
38
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Sqlite.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Mysql.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php
  • /app/Schema/Postgres.php