1 2 3 4 5 6 7 8 | INSERT INTO tt_content (pid, tstamp, crdate, cruser_id, CType, header, tx_fed_fcefile) SELECT uid, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 1, "fluidcontent_content", "Content elements", "Vnd.Foo:Container.html" FROM pages WHERE title = "Referenzen" LIMIT 1 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | UPDATE tt_content AS t1, tt_content AS t2, pages SET t1.colPos = 18181, t1.tx_flux_column = "content", t1.tx_flux_parent = t2.uid WHERE t2.pid = pages.uid AND t1.colPos = 0 AND t1.tx_fed_fcefile != "Vnd.Foo:Container.html" AND t1.pid = pages.uid AND t2.pid = pages.uid AND pages.title = "Referenzen" AND t2.tx_fed_fcefile = "Vnd.Foo:Container.html" |