PHP Classes

File: newsletter_queue.sql

Recommend this page to a friend!
  Classes of solomongaby   Newsletter Queue   newsletter_queue.sql   Download  
File: newsletter_queue.sql
Role: Auxiliary data
Content type: text/plain
Description: sql create table for queue
Class: Newsletter Queue
Queue newsletters in MySQL for delivering later
Author: By
Last change: bug removal
Date: 15 years ago
Size: 1,175 bytes
 

Contents

Class file image Download
CREATE TABLE `newsletter_queue` ( `newsletterQID` int(11) NOT NULL auto_increment, `method` set('mail','smtp') collate latin1_general_ci NOT NULL default '', `From` varchar(255) collate latin1_general_ci NOT NULL default '', `FromName` varchar(255) collate latin1_general_ci NOT NULL default '', `Host` varchar(255) collate latin1_general_ci NOT NULL default '', `SMTPAuth` varchar(255) collate latin1_general_ci NOT NULL default '', `Username` varchar(255) collate latin1_general_ci NOT NULL default '', `Password` varchar(255) collate latin1_general_ci NOT NULL default '', `recepientMail` varchar(255) collate latin1_general_ci NOT NULL default '', `recepientName` varchar(255) collate latin1_general_ci NOT NULL default '', `subject` varchar(255) collate latin1_general_ci NOT NULL default '', `body` text collate latin1_general_ci NOT NULL, `ContentType` varchar(50) collate latin1_general_ci NOT NULL default '', `priority` int(1) NOT NULL default '0', `SendDate` varchar(20) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (`newsletterQID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;