PHP Classes

File: sqldata.sql

Recommend this page to a friend!
  Classes of Iván Campaña   Data Objects   sqldata.sql   Download  
File: sqldata.sql
Role: Auxiliary data
Content type: text/plain
Description: Sample SQL data for the default test script
Class: Data Objects
Supply an interface to treat table rows as objects
Author: By
Last change:
Date: 19 years ago
Size: 554 bytes
 

Contents

Class file image Download 
CREATE TABLE `producto` (
  `id` int(11) NOT NULL auto_increment,
  `nombre` varchar(50) NOT NULL default '',
  `cantidad` int(11) NOT NULL default '0',
  `valor` float NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `nombre` (`nombre`),
  FULLTEXT KEY `nombre_2` (`nombre`)
);

#
# Volcar la base de datos para la tabla `producto`
#

INSERT INTO `producto` (`id`, `nombre`, `cantidad`, `valor`) VALUES (1, 'Vino de cocox', 5, '28.7');
INSERT INTO `producto` (`id`, `nombre`, `cantidad`, `valor`) VALUES (2, 'Vino de cocox', 6, '14');