Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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

Reply With Quote
  #2 (permalink)  
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/
Reply With Quote
  #3 (permalink)  
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!

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 12:14 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.