MySQL returned an empty result set (i.e. zero rows). (Query took 0.0300 seconds.)
CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_payments_backup AS SELECT * FROM kkGNOYNK_crcica_payments;
[ Edit inline ] [ Edit ] [ Create PHP code ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0063 seconds.)
CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_events_backup AS SELECT * FROM kkGNOYNK_crcica_events;
[ Edit inline ] [ Edit ] [ Create PHP code ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0063 seconds.)
CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_event_pricing_tiers_backup AS SELECT * FROM kkGNOYNK_crcica_event_pricing_tiers;
[ Edit inline ] [ Edit ] [ Create PHP code ]


MySQL returned an empty result set (i.e. zero rows). (Query took 0.0076 seconds.)
-- ============================================================ -- STEP 1: CREATE MISSING TABLES (SAFEST — No existing data) -- ============================================================ -- -- CHECK: Do these tables already exist? -- Run this first: /* SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'crcicadb' AND TABLE_NAME IN ( 'kkGNOYNK_crcica_installments', 'kkGNOYNK_crcica_refunds', 'kkGNOYNK_crcica_audit_logs' ); */ -- If the query returns 0 rows, run the FIX below. -- If it returns 3 rows, SKIP this step — tables already exist! -- FIX 1.1: Create installments table CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_installments ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, payment_id BIGINT(20) UNSIGNED NOT NULL, installment_number INT(11) NOT NULL DEFAULT 1, total_installments INT(11) NOT NULL DEFAULT 1, installment_amount DECIMAL(15,4) NOT NULL DEFAULT 0.0000, due_date DATE DEFAULT NULL[...]
[ Edit ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0057 seconds.)
-- VERIFY 1.1: -- SELECT TABLE_NAME FROM information_schema.TABLES -- WHERE TABLE_SCHEMA = 'crcicadb' AND TABLE_NAME = 'kkGNOYNK_crcica_installments'; -- FIX 1.2: Create refunds table CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_refunds ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, payment_id BIGINT(20) UNSIGNED NOT NULL, refund_amount DECIMAL(15,4) NOT NULL DEFAULT 0.0000, refund_reason TEXT, requester_name VARCHAR(200) DEFAULT '', requester_email VARCHAR(200) DEFAULT '', requester_id BIGINT(20) UNSIGNED DEFAULT 0, status VARCHAR(30) DEFAULT 'REQUESTED', admin_notes TEXT, processed_by BIGINT(20) UNSIGNED DEFAULT 0, processed_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY payment_id (payment_id), KEY status (status) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unico[...]
[ Edit ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0082 seconds.)
-- VERIFY 1.2: -- SELECT TABLE_NAME FROM information_schema.TABLES -- WHERE TABLE_SCHEMA = 'crcicadb' AND TABLE_NAME = 'kkGNOYNK_crcica_refunds'; -- FIX 1.3: Create audit_logs table CREATE TABLE IF NOT EXISTS kkGNOYNK_crcica_audit_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED DEFAULT 0, user_name VARCHAR(100) DEFAULT '', user_email VARCHAR(100) DEFAULT '', action VARCHAR(50) NOT NULL, object_type VARCHAR(30) DEFAULT 'payment', object_id BIGINT(20) UNSIGNED DEFAULT 0, details LONGTEXT, ip_address VARCHAR(45) DEFAULT '', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY action (action), KEY object_id (object_id), KEY created_at (created_at) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
[ Edit inline ] [ Edit ] [ Create PHP code ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)
-- VERIFY 1.3: -- SELECT TABLE_NAME FROM information_schema.TABLES -- WHERE TABLE_SCHEMA = 'crcicadb' AND TABLE_NAME = 'kkGNOYNK_crcica_audit_logs'; -- ROLLBACK 1 (if you want to remove these tables): -- DROP TABLE IF EXISTS kkGNOYNK_crcica_installments; -- DROP TABLE IF EXISTS kkGNOYNK_crcica_refunds; -- DROP TABLE IF EXISTS kkGNOYNK_crcica_audit_logs;;
[ Edit inline ] [ Edit ] [ Create PHP code ]

SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_COMMENT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'crcicadb' AND TABLE_NAME = 'kkGNOYNK_crcica_events' ORDER BY ORDINAL_POSITION;
Profiling [ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
				|
	Show all 	|
			Number of rows: 		Filter rows: 		
COLUMN_NAME 	DATA_TYPE 	IS_NULLABLE 	COLUMN_DEFAULT 	COLUMN_COMMENT 	
id
	bigint
	NO
	NULL 	
form_id
	bigint
	YES
	NULL
	
event_id
	varchar
	NO
	NULL 	
event_name
	varchar
	NO
	NULL 	
event_key
	varchar
	YES
	NULL
	
event_form_ids
	longtext
	YES
	NULL
	
active
	tinyint
	NO
	1
	
allow_online
	tinyint
	NO
	1
	
allow_bank_transfer
	tinyint
	NO
	1
	
allow_instapay
	tinyint
	NO
	1
	
allow_cash
	tinyint
	NO
	0
	
allow_sponsor
	tinyint
	NO
	0
	
default_currency
	varchar
	NO
	'EGP'
	
gateway_id
	bigint
	YES
	NULL
	
allowed_gateways
	longtext
	YES
	NULL
	
created_at
	datetime
	NO
	NULL 	
updated_at
	datetime
	NO
	NULL 	
status
	varchar
	NO
	'active'
	
currency
	varchar
	NO
	'EGP'
	
start_date
	date
	YES
	NULL
	
end_date
	date
	YES
	NULL
	
location
	varchar
	YES
	NULL
	
event_type
	varchar
	YES
	'physical'
	
zoom_link
	text
	YES
	NULL
	
zoom_meeting_id
	varchar
	YES
	NULL