Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Ajax ISBN: 978-0-471-77778-6
This is the forum to discuss the Wrox book Professional Ajax by Nicholas C. Zakas, Jeremy McPeak, Joe Fawcett; ISBN: 9780471777786
Important: For the new 2nd edition of this book, please post here instead: [url="http://p2p.wrox.com/forum.asp?FORUM_ID=307"]http://p2p.wrox.com/forum.asp?FORUM_ID=307[/url]
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Ajax ISBN: 978-0-471-77778-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 22nd, 2006, 07:48 PM
Registered User
 
Join Date: Mar 2005
Location: Greenwood, IN, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to coders4hire
Default CH 09 AjaxMail SQL

Just in case someone would like to cut and paste instead of writing out the create table commands:

Code:
CREATE TABLE AjaxMailFolders (
    FolderId int(11) NOT NULL auto_increment,
    Name text NOT NULL,
    PRIMARY KEY (FolderId)

    );

INSERT INTO AjaxMailFolders VALUES (1, 'Inbox');
INSERT INTO AjaxMailFolders VALUES (2, 'Trash');

CREATE TABLE AjaxMailMessages (
    MessageId int(11) NOT NULL auto_increment,
    `To` text NOT NULL,
    CC text NOT NULL,
    BCC text NOT NULL,
    `From` text NOT NULL,
    Subject text NOT NULL,
    Date bigint(2) default NULL,
    Message text NOT NULL,
    HasAttachments tinyint(1) NOT NULL default '0',
    Unread tinyint(1) NOT NULL default '1',
    FolderId int(11) NOT NULL default '0',
    PRIMARY KEY (MessageId)

    );

CREATE TABLE AjaxMailAttachments (
    AttachmentId int(11) NOT NULL auto_increment,
    MessageId int(11) NOT NULL default '0',
    Filename text NOT NULL,
    ContentType text NOT NULL,
    Size int(11) NOT NULL default '0',
    Data longtext NOT NULL,
    PRIMARY KEY (AttachmentId)

    );
Doug
http://www.douglaskarr.com

 
Old June 22nd, 2006, 07:55 PM
nzakas's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Peabody, MA, USA.
Posts: 217
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Thanks Doug,

It was an oversight that the SQL script wasn't included in the download. I'll get right on that.

Thanks.

Nicholas C. Zakas
Author, Professional JavaScript for Web Developers (ISBN 0764579088)
http://www.nczonline.net/
 
Old June 22nd, 2006, 08:03 PM
Registered User
 
Join Date: Mar 2005
Location: Greenwood, IN, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to coders4hire
Default

You're most welcome! Thanks for a great book!





Similar Threads
Thread Thread Starter Forum Replies Last Post
AjaxMail doesn't work ?! fly BOOK: Professional Ajax 2nd Edition ISBN: 978-0-470-10949-6 13 March 31st, 2009 01:36 AM
AjaxMail looking for developers nzakas BOOK: Professional Ajax ISBN: 978-0-471-77778-6 0 August 25th, 2006 09:56 PM
What Setting r required for AjaxMail Earth BOOK: Professional Ajax ISBN: 978-0-471-77778-6 0 August 23rd, 2006 02:06 AM
How can I get the exercise code of 1-861006-09-8? mechart All Other Wrox Books 1 September 5th, 2003 08:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.