Db forge |
Hi sorry for english , i have two answer about db forge :
Code: function create_users_table(){ The first , i have this error : Error Number: 1067 Invalid default value for 'data_registrazione' CREATE TABLE `users_codeigniter` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `email` VARCHAR(100) NOT NULL UNIQUE, `username` VARCHAR(50) NULL DEFAULT NULL, `password_hash` VARCHAR(255) NOT NULL, `activation_hash` VARCHAR(255) NULL DEFAULT NULL, `password_reset_hash` VARCHAR(255) NULL DEFAULT NULL, `data_registrazione` timestamp(6) NOT NULL DEFAULT 'CURRENT_TIMESTAMP', `id_ruolo` INT(11) NOT NULL DEFAULT 1, `id_stato` INT(11) NOT NULL DEFAULT 1, `last_login` DATETIME NULL DEFAULT NULL, CONSTRAINT `pk_users_codeigniter` PRIMARY KEY(`id`) ) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci Filename: models/User_model.php Line Number: 481 The second , how can i add a foreign key? |
Messages In This Thread |
Db forge - by pippuccio76 - 07-05-2017, 11:11 AM
RE: Db forge - by arisroyo - 07-09-2017, 03:45 PM
|