PHP Classes

File: init-customers.sql

Recommend this page to a friend!
  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: 21 years ago
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' );