The CREATE code that corresponds to my tables is: CREATE TABLE `datasets` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(250) NOT NULL DEFAULT '0', `user_email` VARCHAR(120) NOT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) COLLATE='utf32_general_ci' ENGINE=InnoDB AUTO_INCREMENT=3 ;
CREATE TABLE `logs` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `user_email` VARCHAR(120) NOT NULL DEFAULT '0', `action` VARCHAR(50) NOT NULL DEFAULT '0', `message` VARCHAR(250) NULL DEFAULT NULL, `related_dataset` VARCHAR(250) NULL DEFAULT '0', `when` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) COLLATE='utf32_general_ci' ENGINE=InnoDB AUTO_INCREMENT=113549 ; -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
