SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey guys/gals

    I just read through the entire PHP/mySQL tutorial that Kevin wrote looking for a dump of the tables that he used. I found the actual code he used but could not find the dump. Does anyone have the SQL dump or a link to it?

    Thanks
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    This is an addition I'll make to code.zip in the planned update to the article (along with a few code fixes, corrected Windows installation instructions, and up-to-date info on the MySQL license). Meanwhile, here's the dump of the table structure I used for Chapter 6, "A Content Management System":

    Code:
    #
    # Table structure for table 'authors'
    #
    
    CREATE TABLE authors (
      ID int(11) NOT NULL auto_increment,
      Name varchar(100),
      EMail varchar(100),
      PRIMARY KEY (ID)
    );
    
    #
    # Table structure for table 'categories'
    #
    
    CREATE TABLE categories (
      ID int(11) NOT NULL auto_increment,
      Name varchar(100),
      Desrciption text,
      PRIMARY KEY (ID)
    );
    
    #
    # Table structure for table 'jokelookup'
    #
    
    CREATE TABLE jokelookup (
      JID int(11) DEFAULT '0' NOT NULL,
      CID int(11) DEFAULT '0' NOT NULL,
      PRIMARY KEY (JID,CID)
    );
    
    #
    # Table structure for table 'jokes'
    #
    
    CREATE TABLE jokes (
      ID int(11) NOT NULL auto_increment,
      JokeText text,
      JokeDate date DEFAULT '0000-00-00' NOT NULL,
      AID int(11),
      PRIMARY KEY (ID)
    );
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  3. #3
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    woohoo...from the man himself...
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •