PHP Classes

File: tb_cars.sql

Recommend this page to a friend!
  Classes of Eugene Olkhovick   eoPaginator   tb_cars.sql   Download  
File: tb_cars.sql
Role: Configuration script
Content type: text/plain
Description: SQL dump for playing with db_example.php
Class: eoPaginator
Generate navigation for listings split among pages
Author: By
Last change:
Date: 14 years ago
Size: 1,062 bytes
 

Contents

Class file image Download
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE DATABASE `cars`;
USE `cars`;

CREATE TABLE IF NOT EXISTS `tb_cars` (
  `ID` int(11) NOT NULL,
  `VENDOR` varchar(20) CHARACTER SET utf8 NOT NULL,
  `MODEL` varchar(20) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `tb_cars` (`ID`, `VENDOR`, `MODEL`) VALUES
(1, 'AUDI', 'A6'),
(2, 'AUDI', 'A8'),
(3, 'AUDI', 'Q9'),
(4, 'BMW', 'X3'),
(5, 'BMW', 'X5'),
(6, 'BMW', 'Z3'),
(7, 'BMW', 'Z5'),
(8, 'CHEVROLET', 'AVEO'),
(9, 'CHEVROLET', 'LACETTI'),
(10, 'CHEVROLET', 'CAPTIVA'),
(11, 'SUZUKI', 'SWIFT'),
(12, 'SUZUKI', 'SX4'),
(13, 'SUZUKI', 'GRAND VITARA'),
(14, 'TOYOTA', 'AVENSIS'),
(15, 'TOYOTA', 'COROLLA'),
(16, 'TOYOTA', 'CAMRY'),
(17, 'HYUNDAI', 'ACCENT'),
(18, 'HYUNDAI', 'SONATA'),
(19, 'HONDA', 'CIVIC'),
(20, 'HONDA', 'ACCORD'),
(21, 'FORD', 'FIESTA'),
(22, 'FORD ', 'FOCUS'),
(23, 'FORD', 'FUSION'),
(24, 'FORD ', 'TRANSIT'),
(25, 'MAZDA', '3'),
(26, 'MAZDA', '6'),
(27, 'MAZDA', 'CX7'),
(28, 'MITSUBISHI', 'LANCER'),
(29, 'MITSUBISHI', 'PAJERO'),
(30, 'MITSUBISHI', 'L 200');