v3.1.0 to v4.0.0
CREATE TABLE `tbl_category` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`category_name` varchar(255) NOT NULL,
`category_image` varchar(255) NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;INSERT INTO `tbl_category` (`cid`, `category_name`, `category_image`)
VALUES (1, 'Uncategorized', 'uncategorized.png');ALTER TABLE `tbl_book`
ADD `category_id` INT NOT NULL DEFAULT '1' AFTER `book_id`;ALTER TABLE `tbl_settings`
ADD `package_name` VARCHAR(255) NOT NULL AFTER `story_order`,
ADD `fcm_notification_topic` VARCHAR(255) NOT NULL
DEFAULT 'android_ebook_app_topic' AFTER `package_name`,
ADD `privacy_policy` TEXT NOT NULL AFTER `fcm_notification_topic`,
ADD `more_apps_url` VARCHAR(255) NOT NULL AFTER `privacy_policy`;CREATE TABLE `tbl_ads` (
`id` int(11) NOT NULL,
`ad_status` varchar(5) NOT NULL DEFAULT 'on',
`ad_type` varchar(45) NOT NULL DEFAULT 'admob',
`admob_publisher_id` varchar(45) NOT NULL DEFAULT '0',
`admob_app_id` varchar(255) NOT NULL DEFAULT '0',
`admob_banner_unit_id` varchar(255) NOT NULL DEFAULT '0',
`admob_interstitial_unit_id` varchar(255) NOT NULL DEFAULT '0',
`admob_native_unit_id` varchar(255) NOT NULL DEFAULT '0',
`admob_app_open_ad_unit_id` varchar(45) NOT NULL DEFAULT '0',
`startapp_app_id` varchar(255) NOT NULL DEFAULT '0',
`unity_game_id` varchar(45) NOT NULL DEFAULT '0',
`unity_banner_placement_id` varchar(45) NOT NULL DEFAULT 'banner',
`unity_interstitial_placement_id` varchar(45) NOT NULL DEFAULT 'video',
`applovin_banner_ad_unit_id` varchar(45) NOT NULL DEFAULT '0',
`applovin_interstitial_ad_unit_id` varchar(45) NOT NULL DEFAULT '0',
`mopub_banner_ad_unit_id` varchar(45) NOT NULL DEFAULT '0',
`mopub_interstitial_ad_unit_id` varchar(45) NOT NULL DEFAULT '0',
`interstitial_ad_interval` int(11) NOT NULL DEFAULT 3,
`native_ad_interval` int(11) NOT NULL DEFAULT 24,
`native_ad_index` int(11) NOT NULL DEFAULT 6
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;Last updated
Was this helpful?