PHP Classes

File: examples/example2/tables.sql

Recommend this page to a friend!
  Classes of Slawomir Kaleta   Dframe MyMail   examples/example2/tables.sql   Download  
File: examples/example2/tables.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Dframe MyMail
Compose and send email messages using PHPMailer
Author: By
Last change: Resolved #4, Update To PHPMailer 6.x
Date: 3 years ago
Size: 1,832 bytes
 

Contents

Class file image Download
-- -- Struktura tabeli dla tabeli `mails` -- CREATE TABLE `mails` ( `mail_id` int(11) NOT NULL, `mail_name` varchar(255) NOT NULL, `mail_address` varchar(255) NOT NULL, `mail_sender` varchar(255) DEFAULT NULL, `mail_subject` varchar(1024) NOT NULL, `mail_body` text NOT NULL, `mail_enqueued` int(11) NOT NULL COMMENT 'Unix timestamp zakolejkowania', `mail_sent` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp wyslania', `mail_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - nie wyslane, 1 - wyslane', `mail_buffer_date` datetime NOT NULL, `mail_send_date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maile do wyslania'; -- -- Struktura tabeli dla tabeli `mails_attachments` -- CREATE TABLE `mails_attachments` ( `mail_attachment_id` int(11) NOT NULL, `mail_id` int(11) NOT NULL, `file_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Indeksy dla zrzutów tabel -- -- -- Indexes for table `mails` -- ALTER TABLE `mails` ADD PRIMARY KEY (`mail_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT dla tabeli `mails` -- ALTER TABLE `mails` MODIFY `mail_id` int (11) NOT NULL AUTO_INCREMENT; COMMIT; -- -- Indexes for table `mails_attachments` -- ALTER TABLE `mails_attachments` ADD KEY `mail_attachment_id` (`mail_attachment_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT dla tabeli `mails_attachments` -- ALTER TABLE `mails_attachments` MODIFY `mail_attachment_id` int (11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;