ALTER TABLE `idx_custom_field` CHANGE `field_type` `field_type` ENUM( 'TEXT', 'TEXTAREA', 'SELECT', 'MULTISELECT', 'CHECKBOX', 'RADIO', 'FILE', 'IMAGE', 'DATE', 'DATETIME', 'RICHEDITOR' ) NOT NULL DEFAULT 'TEXT'; # # Version IndexU Deluxe 1.22 # CREATE TABLE `idx_blocked_domain` ( `blocked_id` int(11) NOT NULL auto_increment, `blocked` varchar(255) default NULL, `type` enum('domain','ip') default NULL, PRIMARY KEY (`blocked_id`) ); INSERT INTO `idx_blocked_domain` (`blocked_id`, `blocked`, `type`) VALUES (1, 'buydomains.com', 'domain'), (2, 'this-domain-for-sale.com ', 'domain'), (3, 'oversee.net', 'domain'), (4, 'eNom', 'domain'), (5, 'sedoparking.com', 'domain'); CREATE TABLE `idx_unavailable` ( `idx_unavailable` int(11) NOT NULL auto_increment, `link_id` int(11) default NULL, `url` varchar(255) default NULL, `who_is` varchar(255) default NULL, `note` text , `date` datetime default NULL, PRIMARY KEY (`idx_unavailable`) ); CREATE TABLE `idx_unavailable_latest` ( `idx_link` int(11) default NULL, `record_execution` int(11) default NULL ); CREATE TABLE `idx_hook_place` ( `hook_place_id` int(11) NOT NULL auto_increment, `filename` varchar(255) default NULL, `hookname` varchar(255) default NULL, PRIMARY KEY (`hook_place_id`) ); CREATE TABLE `idx_set_hook_place` ( `set_hook_place_id` int(11) NOT NULL auto_increment, `plugin` varchar(255) default NULL, `set_hook_place` text, PRIMARY KEY (`set_hook_place_id`) ); CREATE TABLE `idx_admin_menu` ( `menu_id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `menu_title` varchar(255) default NULL, `menu_url` varchar(255) default NULL, `order_number` int(11) default NULL, PRIMARY KEY (`menu_id`) ); /*Data for the table `idx_admin_menu` */ insert into `idx_admin_menu`(`menu_id`,`parent_id`,`menu_title`,`menu_url`,`order_number`) values (1,0,'Categories','#',1),(2,0,'Links','#',2),(3,0,'Users','#',3),(4,0,'Editors','#',4),(5,0,'Invoices','#',5),(6,0,'Mailing System','#',6),(7,0,'Templates','#',7),(8,0,'Tools','#',8),(9,0,'Option','#',9),(10,0,'Database','#',10),(11,0,'Plugins','#',11),(12,1,'Add','cat_add.php',NULL),(13,1,'View / Edit / Delete','cat_view.php',NULL),(14,1,'Search','cat_search.php',NULL),(15,1,'Hidden Categories','cat_view_hidden.php',NULL),(16,1,'Registered Users Only','cat_view_registered_only.php',NULL),(17,1,'Set Default Price','cat_set_default_price.php',NULL),(18,1,'Check Category Structure','cat_struc.php',NULL),(19,1,'Update Category Path','cat_path_update.php',NULL),(20,1,'Pending Category','cat_pending_suggestion.php',NULL),(21,2,'Add','link_add.php',NULL),(22,2,'Search / Edit / Delete','link_search.php',NULL),(23,2,'Validate Links','link_validate.php',NULL),(24,2,'Spam Links','link_validate.php?spam=1',NULL),(25,2,'Validate Reviews','review_validate.php',NULL),(26,2,'Editor Pick Links','link_editor_pick.php',NULL),(27,2,'Premium Listing','link_premium_listing.php',NULL),(28,2,'Sponsored Listing','link_sponsored_listing.php',NULL),(29,2,'Suspended Listing','link_suspended_listing.php',NULL),(30,2,'Default Field','link_default_field.php',NULL),(31,2,'Custom Field','link_custom_field.php',NULL),(32,2,'Update Number of Links','app_update_nol.php',NULL),(33,2,'Update Tag Clouds','tag_cloud_update.php',NULL),(34,2,'Discount Coupon','coupon.php',NULL),(35,3,'Add','user_add.php',NULL),(36,3,'Search','user_search.php',NULL),(37,3,'View Unactive','user_active.php?pflag=Unactive',NULL),(38,3,'View Suspend','user_suspend.php',NULL),(39,3,'View All','user_active.php',NULL),(40,4,'Add','editor_add.php',NULL),(41,4,'Validate','editor_validate.php',NULL),(42,4,'View / Delete','cat_view.php',NULL),(43,5,'Configure','inv_config.php ',NULL),(44,5,'Create An Invoice','inv_create.php',NULL),(45,5,'Unpaid Invoice','inv_unpaid.php',NULL),(46,5,'Overdue Invoice','inv_overdue.php',NULL),(47,5,'Paid Invoice','inv_paid.php',NULL),(48,5,'Payment History','pay_history.php',NULL),(49,6,'Create Template','message_create.php',NULL),(50,6,'Send/Edit/Delete','message_view.php',NULL),(51,6,'Mailing List Subscribers','message_subscriber.php',NULL),(52,7,'Template Manager','template_manager.php',NULL),(53,7,'Import','template_import.php',NULL),(54,7,'Export','template_export.php',NULL),(55,7,'Email Template','email_template.php',NULL),(56,7,'Export Email Template','email_template_export.php',NULL),(57,7,'Import Email Template','email_template_import.php',NULL),(58,8,'Find Duplicate Link','link_duplicate.php',NULL),(59,8,'Broken Link Report','link_bad.php',NULL),(60,8,'Spider Link CheckUrl','checkurl_web.php',NULL),(61,8,'CheckUrl Result','link_checkurl.php',NULL),(62,8,'View Search Log','log_search.php',NULL),(63,8,'Bad Words Filter','badword_filter.php',NULL),(64,8,'Clear Template Cache','clear_templates_c.php',NULL),(65,8,'PHP Configuration','phpinfo.php',NULL),(66,8,'Sitemap Generator','sitemap.php',NULL),(67,8,'Cronjobs','cronjobs.php',NULL),(68,8,'Fetch Meta','fetch_meta.php',NULL),(69,8,'Hook Place','hook_place.php',NULL),(70,8,'Block Name server Domain','blocked_domain_list.php',NULL),(71,8,'Add Block Name server Domain','add_blocked_domain.php',NULL),(72,8,'Unavailable domain listing','unavailable_link_list.php',NULL),(73,9,'Setup','app_setup.php',NULL),(74,9,'Page Caching','app_page_caching.php',NULL),(75,9,'Mod-rewrite','app_mod_rewrite.php',NULL),(76,9,'Change Password','app_change_pwd.php',NULL),(77,10,'Import','db_import.php',NULL),(78,10,'Export','db_export.php',NULL),(79,10,'Backup','db_backup.php',NULL),(80,10,'Query','db_query.php',NULL),(81,10,'Find Replace','db_find_replace.php',NULL),(82,11,'View All','plugin_listing.php',NULL);