Skip to content
GitLab
Menu
Why GitLab
Pricing
Contact Sales
Explore
Why GitLab
Pricing
Contact Sales
Explore
Sign in
Get free trial
Changes
Page history
Update Database conversion
authored
Aug 26, 2022
by
Émilie Pagé-Perron
Hide whitespace changes
Inline
Side-by-side
Database-conversion.md
View page @
863d1528
...
@@ -106,7 +106,7 @@ SET cdli_db.update_events.created_by =
...
@@ -106,7 +106,7 @@ SET cdli_db.update_events.created_by =
SELECT
cdli_db
.
authors
.
id
FROM
cdli_db
.
authors
SELECT
cdli_db
.
authors
.
id
FROM
cdli_db
.
authors
join
cdli_db_tmp
.
authors_view
on
cdli_db_tmp
.
authors_view
.
author_id
=
cdli_db
.
authors
.
id
join
cdli_db_tmp
.
authors_view
on
cdli_db_tmp
.
authors_view
.
author_id
=
cdli_db
.
authors
.
id
join
cdli_db
.
update_events
on
cdli_db_tmp
.
authors_view
.
mod_date
=
cdli_db
.
update_events
.
created
join
cdli_db
.
update_events
on
cdli_db_tmp
.
authors_view
.
mod_date
=
cdli_db
.
update_events
.
created
WHERE
cdli_db_tmp
.
authors_view
.
mod_date
=
cdli_db
.
update_events
.
created
AND
cdli_db
.
update_events
.
type
=
"atf"
WHERE
cdli_db_tmp
.
authors_view
.
mod_date
=
cdli_db
.
update_events
.
created
AND
cdli_db
.
update_events
.
update_
type
=
"atf"
LIMIT
1
LIMIT
1
);
);
```
```
...
...
...
...