Skip to content

Instantly share code, notes, and snippets.

@eduardoromero
Created December 9, 2014 00:54
Show Gist options
  • Save eduardoromero/b21c2d7e21c3e8f37c06 to your computer and use it in GitHub Desktop.
Save eduardoromero/b21c2d7e21c3e8f37c06 to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS `applications`;
CREATE TABLE `applications` (
`id` binary(36) NOT NULL,
`name` varchar(128) DEFAULT NULL,
`basename` varchar(32) DEFAULT NULL COMMENT 'URL BASENAME',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `applications` (`id`, `name`, `basename`) VALUES
(UNHEX('35343764663937662D653431632D343030302D613662322D343866313530333039333633'), 'ASDF', 'asdf.com')
ON DUPLICATE KEY UPDATE `id` = VALUES(`id`), `name` = VALUES(`name`), `basename` = VALUES(`basename`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment