1
2
3
4
5
6
7
8
9
10
11
12
13
14
| INSERT INTO web_hooks
(url,project_id,created_at,updated_at,TYPE,push_events,issues_events,merge_requests_events,tag_push_events,note_events,enable_ssl_verification,build_events)
SELECT
'http://klonfisch.mogiedyne.mogic/webhook-call.php',
projects.id,
NOW(), NOW(),
'ProjectHook',
TRUE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE
FROM projects
LEFT JOIN web_hooks
ON projects.id = web_hooks.project_id
AND web_hooks.url = 'http://klonfisch.mogiedyne.mogic/webhook-call.php'
WHERE web_hooks.id IS NULL;
|