Login   Register  
PHP Classes
elePHPant
Icontem

File: step7.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Neil Francis  >  SQLite PDO  >  step7.sql  >  Download  
File: step7.sql
Role: Auxiliary data
Content type: text/plain
Description: sqlite 3 database sample
Class: SQLite PDO
Retrieve SQLite database data using PDO
Author: By
Last change:
Date: 2008-10-12 16:06
Size: 755 bytes
 

Contents

Class file image Download 
DROP TABLE IF EXISTS "currval";
CREATE TABLE "currval" ("currid" INTEGER PRIMARY KEY  NOT NULL ,"currname" VARCHAR NOT NULL ,"currval" VARCHAR NOT NULL ,"currvolume" VARCHAR NOT NULL , "currspread" VARCHAR NOT NULL  DEFAULT '');
INSERT INTO "currval" VALUES(1,'GBP/USD','1.0000','10000','4');
INSERT INTO "currval" VALUES(2,'EUR/USD','1.0000','10000','3');
INSERT INTO "currval" VALUES(3,'USD/CAD','1.0000','10000','5');
INSERT INTO "currval" VALUES(4,'USD/CHF','1.0000','10000','5');
INSERT INTO "currval" VALUES(5,'AUD/USD','1.0000','10000','5');
INSERT INTO "currval" VALUES(6,'USD/JPY','1.0000','100','5');
INSERT INTO "currval" VALUES(7,'NZD/USD','1.0000','10000','4');
DROP TABLE IF EXISTS "sqlite_sequence";
CREATE TABLE sqlite_sequence(name,seq);