File manager - Edit - /home/u608250662/domains/rdsolution.org.in/public_html/jevica/queries.sql
Back
-- TRUNCATE TABLE blue_category; -- TRUNCATE TABLE blue_sub_category; -- TRUNCATE TABLE enquiry; -- TRUNCATE TABLE wdi_admin; -- TRUNCATE TABLE wdi_banner; -- TRUNCATE TABLE wdi_blogs; -- TRUNCATE TABLE wdi_blogss; -- TRUNCATE TABLE wdi_category; -- TRUNCATE TABLE wdi_course; -- TRUNCATE TABLE wdi_email; -- TRUNCATE TABLE wdi_email_temp; -- TRUNCATE TABLE wdi_feedback; -- TRUNCATE TABLE wdi_gallery; -- TRUNCATE TABLE wdi_industrial_trainingchild; -- TRUNCATE TABLE wdi_industrial_trainingmain; -- TRUNCATE TABLE wdi_interview; -- TRUNCATE TABLE wdi_interview_category; -- TRUNCATE TABLE wdi_media; -- TRUNCATE TABLE wdi_pages; -- TRUNCATE TABLE wdi_pcontent; -- TRUNCATE TABLE wdi_projects; -- TRUNCATE TABLE wdi_result; -- TRUNCATE TABLE wdi_scholarship; -- TRUNCATE TABLE wdi_seo; -- TRUNCATE TABLE wdi_service; -- TRUNCATE TABLE wdi_showcourse; -- TRUNCATE TABLE wdi_static_seo; -- TRUNCATE TABLE wdi_testimonials; -- TRUNCATE TABLE wdi_testimonial_f; -- TRUNCATE TABLE wdi_test_series; -- TRUNCATE TABLE wdi__course; CREATE TABLE blue_category ( id INT AUTO_INCREMENT PRIMARY KEY, category VARCHAR(250) DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, description TEXT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, seotitle TEXT DEFAULT NULL, seodescription TEXT DEFAULT NULL, seokeywords TEXT DEFAULT NULL, status INT DEFAULT NULL ); ALTER TABLE blue_category ADD COLUMN imageAlt VARCHAR(255) DEFAULT NULL; ALTER TABLE blue_category ADD COLUMN category_desc TEXT DEFAULT NULL AFTER category; -- sub catgory tabl schema CREATE TABLE blue_sub_category ( id INT AUTO_INCREMENT PRIMARY KEY, category_name VARCHAR(255) DEFAULT NULL, category_url VARCHAR(255) DEFAULT NULL, sub_category VARCHAR(250) DEFAULT NULL, sub_category_url VARCHAR(255) DEFAULT NULL, description TEXT DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, imageAlt VARCHAR(255) DEFAULT NULL, seotitle TEXT DEFAULT NULL, seodescription TEXT DEFAULT NULL, seokeywords TEXT DEFAULT NULL, status INT DEFAULT NULL ); INSERT INTO blue_sub_category ( category_name, category_url, sub_category, sub_category_url, description, image, imageAlt, seotitle, seodescription, seokeywords, status ) VALUES ( 'Category Name', 'category-url', 'Sub Category Name', 'sub-category-url', 'Description here', 'image.jpg', 'image-alt', 'SEO Title Here', 'SEO Description Here', 'SEO Keywords Here', 1 ); -- products table. CREATE TABLE wdi_category ( id INT AUTO_INCREMENT PRIMARY KEY, cate_name VARCHAR(255) NOT NULL, cate_url VARCHAR(255) NOT NULL, sub_cat_name VARCHAR(255) NOT NULL, sub_cat_url VARCHAR(255) NOT NULL, product VARCHAR(255) DEFAULT NULL, product_name VARCHAR(255) DEFAULT NULL, product_url VARCHAR(255) DEFAULT NULL, pdf VARCHAR(255) DEFAULT NULL, doc VARCHAR(255) DEFAULT NULL, product_desc TEXT DEFAULT NULL, seotitle TEXT DEFAULT NULL, seodesc TEXT DEFAULT NULL, seokeywords TEXT DEFAULT NULL, status INT DEFAULT 1 ); ALTER TABLE blue_sub_category ADD COLUMN image_alt VARCHAR(255) DEFAULT NULL; ALTER TABLE blue_sub_category CHANGE product image VARCHAR(255) DEFAULT NULL;
| ver. 1.4 |
Github
|
.
| PHP 8.0.30 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings