| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/mysql5.7.18/data/Data/sakila/ |
Upload File : |
TYPE=TRIGGERS triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW BEGIN\n INSERT INTO film_text (film_id, title, description)\n VALUES (new.film_id, new.title, new.description);\n END' 'CREATE DEFINER=`root`@`localhost` TRIGGER `upd_film` AFTER UPDATE ON `film` FOR EACH ROW BEGIN\n IF (old.title != new.title) OR (old.description != new.description) OR (old.film_id != new.film_id)\n THEN\n UPDATE film_text\n SET title=new.title,\n description=new.description,\n film_id=new.film_id\n WHERE film_id=old.film_id;\n END IF;\n END' 'CREATE DEFINER=`root`@`localhost` TRIGGER `del_film` AFTER DELETE ON `film` FOR EACH ROW BEGIN\n DELETE FROM film_text WHERE film_id = old.film_id;\n END' sql_modes=1574961152 1574961152 1574961152 definers='root@localhost' 'root@localhost' 'root@localhost' client_cs_names='utf8' 'utf8' 'utf8' connection_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci' db_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci' created=171142186067 171142186069 171142186072