CREATE TABLE def_learning (
guid CHAR(36) NOT NULL,
package VARCHAR(255) NOT NULL,
module VARCHAR(255) NOT NULL,
title VARCHAR(500) NOT NULL,
description TEXT,
resource_type VARCHAR(50) NOT NULL,
url TEXT NOT NULL,
author VARCHAR(255),
tags VARCHAR(500),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (guid, package, module)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};