Login   Register  
PHP Classes
elePHPant
Icontem

File: sqldata.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 2005-03-30 09:52
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');