Spade

Mini Shell

Directory:~$ /home/lmsyaran/www/plugins/content/zaya_linkshortener_in_content/sql/mysql/
Upload File

[Home] [System Details] [Kill Me]
Current File:~$ /home/lmsyaran/www/plugins/content/zaya_linkshortener_in_content/sql/mysql/install.sql

CREATE TABLE IF NOT EXISTS `#__zaya_content` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
        `link_id` INT(11) NOT NULL  DEFAULT 0,
        `source_link` VARCHAR(500) NOT NULL  DEFAULT 0,
	`link` VARCHAR(512) NOT NULL,
        `type` VARCHAR(100) NOT NULL,
        `domain` VARCHAR(100) NOT NULL,
	PRIMARY KEY  (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4  DEFAULT
COLLATE=utf8mb4_general_ci  ROW_FORMAT=DYNAMIC;