{"table_name":"aeroscroll_gallery","full_table_name":"wp_aeroscroll_gallery","description":"Stores aeroscroll gallery data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_aeroscroll_gallery ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, title VARCHAR(120) DEFAULT '', subtitle VARCHAR(256) DEFAULT '', shortcode VARCHAR(30) NOT NULL DEFAULT '', orientation VARCHAR(30) NOT NULL DEFAULT 'vertical', height VARCHAR(30) NOT NULL DEFAULT '400px', layout VARCHAR(30) NOT NULL, type VARCHAR(30) NOT NULL, categories TEXT NOT NULL, theme VARCHAR(30) NOT NULL, numrows INT NOT NULL DEFAULT 2, numcolumns INT NOT NULL DEFAULT 3, numcolumns_mid INT NOT NULL DEFAULT 2, numcolumns_low INT NOT NULL DEFAULT 1, cellsize INT NOT NULL DEFAULT 200, cellsquared TINYINT NOT NULL DEFAULT 0, scrollspeed TINYINT NOT NULL DEFAULT 6, isinfinite TINYINT NOT NULL DEFAULT 1, scrollbar TINYINT NOT NULL DEFAULT 1, hoveranimation VARCHAR(30) NOT NULL DEFAULT 'none', published TINYINT NOT NULL DEFAULT 1, cellgap INT(11) DEFAULT 0, sortby VARCHAR(30) NOT NULL DEFAULT 'id', sortbydir VARCHAR(30) NOT NULL DEFAULT 'ASC', sidegap INT(11) DEFAULT 0, marginX INT(11) DEFAULT 0, marginY INT(11) DEFAULT 0, usemousewheel TINYINT DEFAULT 1, autoscroll TINYINT DEFAULT 0, imagegallery_id INT(11) DEFAULT 0, themeonhover TINYINT NOT NULL DEFAULT 1, color_theme_desc VARCHAR(30) NOT NULL DEFAULT '#bfbfbfff', color_theme_title VARCHAR(30) NOT NULL DEFAULT '#ffffffff', color_theme_a VARCHAR(30) NOT NULL DEFAULT '#2d2f31ff', color_cell_bg VARCHAR(30) NOT NULL DEFAULT '#dbdfe5ff', showreadmore TINYINT NOT NULL DEFAULT 1, color_bg VARCHAR(30) NOT NULL DEFAULT '#ffffff00', social_share_facebook TINYINT DEFAULT 0, social_share_twitter TINYINT DEFAULT 0, social_share_pinterest TINYINT DEFAULT 0, social_share_instagram TINYINT DEFAULT 0, social_share_tumblr TINYINT DEFAULT 0, social_share_email TINYINT DEFAULT 0, watermark_type TINYINT DEFAULT 0, watermark_text VARCHAR(120) NOT NULL DEFAULT '', watermark_fontsize INT NOT NULL DEFAULT 16, watermark_color VARCHAR(30) NOT NULL DEFAULT '#000000', watermark_opacity TINYINT DEFAULT 30, watermark_position TINYINT DEFAULT 7, watermark_image_url VARCHAR(2048) NOT NULL DEFAULT '', watermark_image_size TINYINT DEFAULT 20, advertisment_type TINYINT DEFAULT 0, advertisment_text VARCHAR(120) NOT NULL DEFAULT '', advertisment_link VARCHAR(2048) NOT NULL DEFAULT '', advertisment_fontsize INT NOT NULL DEFAULT 16, advertisment_color VARCHAR(30) NOT NULL DEFAULT '#000000', advertisment_opacity TINYINT DEFAULT 30, advertisment_position TINYINT DEFAULT 7, advertisment_image_url VARCHAR(2048) NOT NULL DEFAULT '', advertisment_image_size TINYINT DEFAULT 20, poweredbyactive TINYINT DEFAULT 0, PRIMARY KEY (id) ) $collate;\"; dbDelta($schema);","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"subtitle","type":"VARCHAR(256)","nullable":true,"primary_key":false},{"name":"shortcode","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"orientation","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"height","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"layout","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"categories","type":"TEXT","nullable":false,"primary_key":false},{"name":"theme","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"numrows","type":"INT","nullable":false,"primary_key":false},{"name":"numcolumns","type":"INT","nullable":false,"primary_key":false},{"name":"numcolumns_mid","type":"INT","nullable":false,"primary_key":false},{"name":"numcolumns_low","type":"INT","nullable":false,"primary_key":false},{"name":"cellsize","type":"INT","nullable":false,"primary_key":false},{"name":"cellsquared","type":"TINYINT","nullable":false,"primary_key":false},{"name":"scrollspeed","type":"TINYINT","nullable":false,"primary_key":false},{"name":"isinfinite","type":"TINYINT","nullable":false,"primary_key":false},{"name":"scrollbar","type":"TINYINT","nullable":false,"primary_key":false},{"name":"hoveranimation","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"published","type":"TINYINT","nullable":false,"primary_key":false},{"name":"cellgap","type":"INT(11)","nullable":true,"primary_key":false},{"name":"sortby","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"sortbydir","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"sidegap","type":"INT(11)","nullable":true,"primary_key":false},{"name":"marginX","type":"INT(11)","nullable":true,"primary_key":false},{"name":"marginY","type":"INT(11)","nullable":true,"primary_key":false},{"name":"usemousewheel","type":"TINYINT","nullable":true,"primary_key":false},{"name":"autoscroll","type":"TINYINT","nullable":true,"primary_key":false},{"name":"imagegallery_id","type":"INT(11)","nullable":true,"primary_key":false},{"name":"themeonhover","type":"TINYINT","nullable":false,"primary_key":false},{"name":"color_theme_desc","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"color_theme_title","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"color_theme_a","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"color_cell_bg","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"showreadmore","type":"TINYINT","nullable":false,"primary_key":false},{"name":"color_bg","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"social_share_facebook","type":"TINYINT","nullable":true,"primary_key":false},{"name":"social_share_twitter","type":"TINYINT","nullable":true,"primary_key":false},{"name":"social_share_pinterest","type":"TINYINT","nullable":true,"primary_key":false},{"name":"social_share_instagram","type":"TINYINT","nullable":true,"primary_key":false},{"name":"social_share_tumblr","type":"TINYINT","nullable":true,"primary_key":false},{"name":"social_share_email","type":"TINYINT","nullable":true,"primary_key":false},{"name":"watermark_type","type":"TINYINT","nullable":true,"primary_key":false},{"name":"watermark_text","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"watermark_fontsize","type":"INT","nullable":false,"primary_key":false},{"name":"watermark_color","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"watermark_opacity","type":"TINYINT","nullable":true,"primary_key":false},{"name":"watermark_position","type":"TINYINT","nullable":true,"primary_key":false},{"name":"watermark_image_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"watermark_image_size","type":"TINYINT","nullable":true,"primary_key":false},{"name":"advertisment_type","type":"TINYINT","nullable":true,"primary_key":false},{"name":"advertisment_text","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"advertisment_link","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"advertisment_fontsize","type":"INT","nullable":false,"primary_key":false},{"name":"advertisment_color","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"advertisment_opacity","type":"TINYINT","nullable":true,"primary_key":false},{"name":"advertisment_position","type":"TINYINT","nullable":true,"primary_key":false},{"name":"advertisment_image_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"advertisment_image_size","type":"TINYINT","nullable":true,"primary_key":false},{"name":"poweredbyactive","type":"TINYINT","nullable":true,"primary_key":false}],"plugin":{"slug":"aeroscroll-gallery","name":"Aeroscroll Gallery – Infinite Scroll Image Gallery & Post Grid with Photo Gallery","active_installs":10,"version":"1.0.13","wp_org_url":"https://wordpress.org/plugins/aeroscroll-gallery/"}}