Login   Register  
PHP Classes
elePHPant
Icontem

File: example.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Andrioli Darvin  >  Yet Another Pager  >  example.sql  >  Download  
File: example.sql
Role: Auxiliary data
Content type: text/plain
Description: Data required by the examples
Class: Yet Another Pager
Database row pager with edit and search support
Author: By
Last change:
Date: 2003-11-21 13:30
Size: 16,191 bytes
 

Contents

Class file image Download 
# Example file to use to load into Mysql to run the test
# examples coming with Yap
#
# MySQL-Front Dump 2.5
#
# Host: localhost   Database: log
# --------------------------------------------------------
# Server version 3.23.53-max-nt


#
# Table structure for table 'dlog'
#

CREATE TABLE dlog (
  id int(10) unsigned NOT NULL auto_increment,
  DEvent varchar(14) default '0',
  errno int(3) default '0',
  text varchar(250) default '0',
  filename varchar(250) default '0',
  line int(3) default '0',
  RemAddr varchar(20) NOT NULL default '',
  Browser varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Test per Dlog';



#
# Dumping data for table 'dlog'
#

INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("6", "7", "0", "Info l\'e bello", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("7", "20030425154059", "0", "Info 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("8", "20030425154516", "0", "Info 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("9", "20030425154543", "0", "Info 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("10", "20030425154544", "1024", "Test", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "12", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("11", "20030425154544", "512", "Test 2", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "13", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("12", "20030425154614", "0", "Info 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("13", "20030425154615", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "12", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("14", "20030425154615", "512", "Test 2", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "13", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("15", "20030425154647", "0", "Info 1", "D:\\Programmi\\WebDarvin\\dlog\\dlog_test.php", "11", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("16", "20030427102317", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "15", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("17", "20030427102319", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("18", "20030427102319", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("19", "20030427102827", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "15", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("20", "20030427102828", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("21", "20030427102828", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("22", "20030427102913", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "15", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("23", "20030427102913", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("24", "20030427102913", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("26", "20030427102958", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("27", "20030427102958", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("28", "20030427103338", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("29", "20030427103338", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("30", "20030427103338", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("31", "20030427103423", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("32", "20030427103423", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "17", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("33", "20030427103423", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("34", "20030427104550", "1024", "Sono un test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "20", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("35", "20030427104550", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "21", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("36", "20030427104550", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "22", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("37", "20030427104550", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "23", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("38", "20030427104608", "1024", "Sono un test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "20", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("39", "20030427104608", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "21", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("40", "20030427104608", "1025", "Test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "22", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("41", "20030427104608", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "23", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("42", "20030428213213", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "25", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("43", "20030428213215", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "27", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("44", "20030428213215", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "28", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("45", "20030428213319", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "25", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("46", "20030428213320", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "27", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("47", "20030428213320", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "28", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("48", "20030428213412", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "25", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("49", "20030428213412", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "27", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("50", "20030428213412", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "28", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("51", "20030428213510", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "25", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("52", "20030428213510", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "27", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("53", "20030428213510", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "28", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("54", "20030428224604", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "22", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("55", "20030428224629", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "22", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("56", "20030428224629", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "25", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("57", "20030428224629", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "27", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("58", "20030428224629", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "28", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("59", "20030428224931", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "21", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("60", "20030428224931", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "23", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("61", "20030428224931", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("62", "20030428224931", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "29", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("63", "20030428225103", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("64", "20030428225103", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("65", "20030428225103", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "19", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("66", "20030428225103", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("67", "20030428225216", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("68", "20030428225216", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("69", "20030428225216", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "19", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("70", "20030428225216", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("71", "20030428225221", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("72", "20030428225221", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("73", "20030428225221", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "19", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("74", "20030428225221", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("75", "20030428225235", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("76", "20030428225235", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("77", "20030428225235", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "19", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("78", "20030428225235", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "", "");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("79", "20030429211753", "0", "Info 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "16", "2.2.2.2", "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) Opera 7.10  [en]");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("80", "20030429211755", "1024", "Test 1", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "18", "2.2.2.2", "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) Opera 7.10  [en]");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("81", "20030429211755", "512", "Test 2", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "19", "2.2.2.2", "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) Opera 7.10  [en]");
INSERT INTO dlog (id, DEvent, errno, text, filename, line, RemAddr, Browser) VALUES("82", "20030429211755", "1024", "Only a test", "D:\\Programmi\\WebDarvin\\classistd\\dlog\\dlog_test.php", "24", "2.2.2.2", "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) Opera 7.10  [en]");