Database model example?

The ceLTIc project PHP library for LTI is being updated to add support for LTI 1.3 (just finalising the documentation). It is primarily designed for use by Tools. The main database changes from the current release are to the table holding details of tool consumers and the addition of a table to hold access tokens. For MySQL these changes are:

ALTER TABLE lti2_consumer
ADD COLUMN platform_id VARCHAR(255) DEFAULT NULL AFTER secret,
ADD COLUMN deployment_id VARCHAR(255) DEFAULT NULL AFTER platform_id,
ADD COLUMN authorization_server_id VARCHAR(255) DEFAULT NULL AFTER deployment_id,
ADD COLUMN authentication_url VARCHAR(255) DEFAULT NULL AFTER authorization_server_id,
ADD COLUMN access_token_url VARCHAR(255) DEFAULT NULL AFTER authentication_url,
ADD COLUMN public_key text DEFAULT NULL AFTER signature_method,
ADD COLUMN jku VARCHAR(255) DEFAULT NULL AFTER pem_key;

ALTER TABLE lti2_consumer
DROP INDEX lti2_consumer_consumer_key_UNIQUE,
ADD UNIQUE INDEX lti2_consumer_consumer_key_UNIQUE (consumer_key ASC, platform_id ASC, deployment_id ASC);

CREATE TABLE lti2_access_token (
consumer_pk int(11) NOT NULL,
scopes text NOT NULL,
token varchar(2000) NOT NULL,
expires datetime NOT NULL,
created datetime NOT NULL,
updated datetime NOT NULL,
PRIMARY KEY (consumer_pk)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE lti2_access_token
ADD CONSTRAINT lti2_access_token_lti2_consumer_FK1 FOREIGN KEY (consumer_pk)
REFERENCES lti2_consumer (consumer_pk);

I'd also be interested in seeing other examples.

Apologies, the reference to "pem_key" in my previous message should have read "public_key".

I attached a DB model Martin made for a presentation, he's the one who created that PHP library. It doesn't cover caching keys, but it has the models for how you might store your own keypairs.

I haven't looked at the details of how that library works so I can't answer the question about how it works.

As part of the return it's supposed to set_kid($kid)

The KID that you are setting here is the tool's KID for the tool JWKS URL. If you are not using a JWKS, but instead just using a single JWK, then you can enter anything as your KID. Sorry, I should really have done something to make this clearer.

As for the fake database in the PHP example, i did have plans to add an example using a real database with the docker-compose, i just haven't gotten round to doing that yet

A bit late to reply to this topic, but we released the TAO LTI 1.3 PHP framework:

• Covers LTI advantage needs for both platform and tool sides
• Open source
• IMS certified

Feel free to take a look :) 

A bit late to reply to this topic, but we released the TAO LTI 1.3 PHP framework:

• Covers LTI advantage needs for both platform and tool sides
• Open source
• IMS certified

Feel free to take a look :)