Login   Register  
PHP Classes
elePHPant
Icontem

File: data/databases_mysql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Giovanni Ramos  >  PDO4You  >  data/databases_mysql.sql  >  Download  
File: data/databases_mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PDO4You
Access SQL databases using the PDO extension
Author: By
Last change: Update
Date: 2 years ago
Size: 1,577 bytes
 

Contents

Class file image Download
---------------------------------
--CREATE DATABASE pdo4you;
---------------------------------
DROP TABLE IF EXISTS pdo4you.users;
CREATE TABLE pdo4you.users (
	id INT(11) NOT NULL AUTO_INCREMENT,
	firstname VARCHAR(20) NOT NULL,
	lastname VARCHAR(20) NOT NULL,
	mail VARCHAR(30) NULL,
	PRIMARY KEY (id)
) ENGINE=InnoDB;

INSERT INTO pdo4you.users (firstname, lastname, mail) VALUES 
('Giovanni', 'Ramos', 'pdo4you@gmail.com');


DROP TABLE IF EXISTS pdo4you.books;
CREATE TABLE pdo4you.books (
	id INT(11) NOT NULL AUTO_INCREMENT,
	title VARCHAR(100) NOT NULL,
	author VARCHAR(50) NOT NULL,
	description TEXT NULL,
	PRIMARY KEY (id)
) ENGINE=InnoDB;

INSERT INTO pdo4you.books VALUES 
(1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', 'Giovanni Ramos', NULL);


---------------------------------
--CREATE DATABASE bookstore;
---------------------------------
DROP TABLE IF EXISTS bookstore.books;
CREATE TABLE bookstore.books (
	id INT(11) NOT NULL AUTO_INCREMENT,
	title VARCHAR(100) NOT NULL,
	author VARCHAR(50) NOT NULL,
	description TEXT NULL,
	PRIMARY KEY (id)
) ENGINE=InnoDB;

INSERT INTO bookstore.books VALUES 
(1, 'Head First PHP & MySQL', 'Lynn Beighley, Michael Morrison', NULL),
(2, 'Head First JavaScript ', 'Michael Morrison', NULL),
(3, 'Head First Ajax', 'Rebecca M. Riordan', NULL),
(4, 'Head First jQuery', 'Ryan Benedetti', NULL),
(5, 'Head First Java, 2nd Edition', 'Kathy Sierra', NULL),
(6, 'Head First Python', 'Paul Barry', NULL),
(7, 'Head First Networking', 'Al Anderson', NULL),
(8, 'Head First Web Design', 'Ethan Watrall', NULL);