| 1 |
connection node_2; |
| 2 |
connection node_1; |
| 3 |
CREATE TABLE `r8kmb_redirect_links` ( |
| 4 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 5 |
`old_url` varchar(255) DEFAULT NULL, |
| 6 |
`new_url` varchar(255) NOT NULL, |
| 7 |
`referer` varchar(150) NOT NULL, |
| 8 |
`comment` varchar(255) NOT NULL, |
| 9 |
`published` tinyint(4) NOT NULL, |
| 10 |
`created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 11 |
`modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 12 |
PRIMARY KEY (`id`), |
| 13 |
UNIQUE KEY `idx_link_old` (`old_url`), |
| 14 |
KEY `idx_link_modifed` (`modified_date`) |
| 15 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 16 |
INSERT IGNORE INTO r8kmb_redirect_links VALUES (550,'http://mysite.com/images/download/ßуñûічýøù_ôþóþòір_þфõÑ.doc','','','',0,'2013-07-15 14:29:42','0000-00-00 00:00:00'); |
| 17 |
Warnings: |
| 18 |
Warning 1265 Data truncated for column 'old_url' at row 1 |
| 19 |
DROP TABLE r8kmb_redirect_links; |