mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
19 lines
1.2 KiB
Text
19 lines
1.2 KiB
Text
connection node_2;
|
||
connection node_1;
|
||
CREATE TABLE `r8kmb_redirect_links` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`old_url` varchar(255) DEFAULT NULL,
|
||
`new_url` varchar(255) NOT NULL,
|
||
`referer` varchar(150) NOT NULL,
|
||
`comment` varchar(255) NOT NULL,
|
||
`published` tinyint(4) NOT NULL,
|
||
`created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
||
`modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `idx_link_old` (`old_url`),
|
||
KEY `idx_link_modifed` (`modified_date`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
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');
|
||
Warnings:
|
||
Warning 1265 Data truncated for column 'old_url' at row 1
|
||
DROP TABLE r8kmb_redirect_links;
|