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: 1 year 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 */;
For more information send a message to info at phpclasses dot org.