taskinit.sql

use ca;

insert into pfx_tasks (id, title, url, shown) values
    (1, 'Simple Sum', 'simple-sum', 1);
insert into pfx_taskdata (taskid, type, data) values
    (1, 'text', 'VGhlcmUgYXJlIHR3byByYW5kb20gbnVtYmVycyBwcm92aWRlZCBpbiB0aGUgaW5wdXQsIHBsZWFzZSByZXBvcnQgdGhlaXIgc3VtIGZvciBhbnN3ZXIuCgoqKkV4YW1wbGU6KioKCiAgICBpbnB1dDoKCTE1MyAzNDcKCQoJYW5zd2VyOgoJNTAwCg==');
insert into pfx_taskdata (taskid, type, data) values    
    (1,	'checker', 'PD9waHAKCmZ1bmN0aW9uIGNoZWNrZXIoKSB7CgkkYSA9IHJhbmQoMTAwLCA5OTkpOwoJJGIgPSByYW5kKDEwMCwgOTk5KTsKICAgIHJldHVybiBhcnJheSgiJGEgJGIiLCAkYSArICRiKTsKfQoKPz4=');

insert into pfx_tasks (id, title, url, shown) values
    (2, 'Sum of Squares', 'sum-of-squares', 1);
insert into pfx_taskdata (taskid, type, data) values
    (2, 'text', 'TnVtYmVyIGA4NWAgY291bGQgYmUgcmVwcmVzZW50ZWQgYXMgc3VtIG9mIHR3byBzcXVhcmVzIG9mIHBvc2l0aXZlIGludGVnZXJzIGluIG1vcmUgdGhhbiBvbmUgd2F5OgoKICAgIDg1ICA9ICAyKjIgKyA5KjkgID0gIDYqNiArIDcqNwoKR2l2ZW4gYW4gaW50ZWdlciByYW5nZSBiZXR3ZWVuIGBBYCBhbmQgYEJgIHBsZWFzZSBmaW5kIGhvdyBtYW55IGludGVnZXJzIGluIGl0IGhhdmUgYWxzbyBoYXZlIHN1Y2ggYSBwcm9wZXJ0eS4KCioqRXhhbXBsZToqKgoKCWlucHV0OgoJMzIgMTA5CgkKCWFuc3dlcjoKCTM2NA==');
insert into pfx_taskdata (taskid, type, data) values
    (2, 'checker', 'PD9waHAKCmZ1bmN0aW9uIGNoZWNrZXIoKSB7CgkkYSA9IHJhbmQoMTAsIDQwKTsKCSRiID0gJGEgKyByYW5kKDcwLCA4MCk7Cgkkc3VtcyA9IFtdOwoJZm9yICgkeCA9ICRhOyAkeCA8ICRiOyAkeCsrKSB7CgkJZm9yICgkeSA9ICR4KzE7ICR5IDw9ICRiOyAkeSsrKSB7CgkJCSRrID0gJHgqJHggKyAkeSokeTsKCQkJaWYgKCFpc3NldCgkc3Vtc1ska10pKSB7CgkJCQkkc3Vtc1ska10gPSAxOwoJCQl9IGVsc2UgewoJCQkJJHN1bXNbJGtdICs9IDE7CgkJCX0KCQl9Cgl9CgkkY250ID0gMDsKCWZvcmVhY2ggKCRzdW1zIGFzICRrID0+ICR2KSB7CgkJaWYgKCR2ID4gMSkgJGNudCArPSAxOwoJfQogICAgcmV0dXJuIGFycmF5KCIkYSAkYiIsICRjbnQpOwp9Cgo/Pg==');

insert into pfx_tasktags (taskid, tagid)
    select ts.id, tg.id from pfx_tasks ts join pfx_tags tg;