Login   Register  
PHP Classes
elePHPant
Icontem

File: dbsearchtest.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of markitos  >  dbsearch  >  dbsearchtest.sql  >  Download  
File: dbsearchtest.sql
Role: ???
Content type: text/plain
Description: Database structure for test/Estructura de la base de datos para el test
Class: dbsearch
Author: By
Last change:
Date: 13 years ago
Size: 1,479 bytes
 

Contents

Class file image Download
# --------------------------------------------------------
#
# Table structure for table 'names'
#

CREATE TABLE names (
   id int(10) unsigned NOT NULL auto_increment,
   name char(25) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);

#
# Dumping data for table 'names'
#

INSERT INTO names VALUES( '1', 'markitos');
INSERT INTO names VALUES( '2', 'juanito');
INSERT INTO names VALUES( '3', 'markitos2');
INSERT INTO names VALUES( '4', 'markitos3');
INSERT INTO names VALUES( '5', 'markitos4');
INSERT INTO names VALUES( '6', 'mArKitos');
INSERT INTO names VALUES( '7', 'mArKitos2');
INSERT INTO names VALUES( '8', 'mArKitos3');
INSERT INTO names VALUES( '9', 'mArKitos4');
INSERT INTO names VALUES( '10', 'juanito4');
INSERT INTO names VALUES( '11', 'juanito2');
INSERT INTO names VALUES( '12', 'juanito3');
INSERT INTO names VALUES( '13', 'mark');
INSERT INTO names VALUES( '14', 'mark2');
INSERT INTO names VALUES( '15', 'mark3');
INSERT INTO names VALUES( '16', 'mark4');
INSERT INTO names VALUES( '17', 'mArK');
INSERT INTO names VALUES( '18', 'mArK2');
INSERT INTO names VALUES( '19', 'mArK3');
INSERT INTO names VALUES( '20', 'mArK4');

# --------------------------------------------------------
#
# Table structure for table 'nosearch'
#

CREATE TABLE nosearch (
   id int(10) unsigned NOT NULL auto_increment,
   value char(25) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);