123456789101112131415161718192021222324252627282930313233 |
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- CREATE TABLE IF NOT EXISTS `shorturl` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `url` varchar(32) NOT NULL COMMENT 'The short URL itself',
- `domain` int(11) NOT NULL,
- `strategy` varchar(8) NOT NULL DEFAULT 'base',
- `submittedBy` int(11) NOT NULL,
- `submittedInfo` int(11) NOT NULL,
- `isEnabled` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `url` (`url`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
|