| Server IP : 188.114.96.4 / Your IP : 104.23.243.200 Web Server : Apache/2.4.59 (Debian) System : Linux EDL-STRETCH 4.19.0-27-amd64 #1 SMP Debian 4.19.316-1 (2024-06-25) x86_64 User : edlftp ( 1002) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/roundcube/SQL/mysql/ |
Upload File : |
-- Updates from version 0.7 /*!40014 SET FOREIGN_KEY_CHECKS=0 */; ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts`; ALTER TABLE `contacts` DROP INDEX `user_contacts_index`; ALTER TABLE `contacts` MODIFY `email` text NOT NULL; ALTER TABLE `contacts` ADD INDEX `user_contacts_index` (`user_id`,`del`); ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `cache` ALTER `user_id` DROP DEFAULT; ALTER TABLE `cache_index` ALTER `user_id` DROP DEFAULT; ALTER TABLE `cache_thread` ALTER `user_id` DROP DEFAULT; ALTER TABLE `cache_messages` ALTER `user_id` DROP DEFAULT; ALTER TABLE `contacts` ALTER `user_id` DROP DEFAULT; ALTER TABLE `contactgroups` ALTER `user_id` DROP DEFAULT; ALTER TABLE `contactgroupmembers` ALTER `contact_id` DROP DEFAULT; ALTER TABLE `identities` ALTER `user_id` DROP DEFAULT; ALTER TABLE `searches` ALTER `user_id` DROP DEFAULT; /*!40014 SET FOREIGN_KEY_CHECKS=1 */;