Login   Register  
PHP Classes
elePHPant
Icontem

File: init-customers.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Paul C  >  PersistentObject  >  init-customers.sql  >  Download  
File: init-customers.sql
Role: Unit test script
Content type: text/plain
Description: Demo SQL Table
Class: PersistentObject
Encapsulates a database table row in a class
Author: By
Last change:
Date: 2003-07-02 13:08
Size: 379 bytes
 

Contents

Class file image Download
/**
  * @Author:  Paul Campbell <paul@campbell-multimedia.com>
  * @Company: Campbell Multimedia <www.campbell-multimedia.com>
  * @Date:    2nd July 2003
  */

DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
    id INT NOT NULL AUTO_INCREMENT, 
    name VARCHAR(255) NOT NULL,
    index( id ),
    primary key ( id )
);

INSERT INTO customers ( name ) VALUES ( 'First Customer' );