PHP Classes

File: example_database.sql

Recommend this page to a friend!
  Classes of SPAM   pork.dbObject   example_database.sql   Download  
File: example_database.sql
Role: Auxiliary data
Content type: text/plain
Description: Example database
Class: pork.dbObject
Map objects into MySQL database table rows
Author: By
Last change:
Date: 16 years ago
Size: 1,820 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 23, 2007 at 03:27 AM -- Server version: 5.0.21 -- PHP Version: 5.1.6 -- -- Pork.dbObject sample database -- -- -- Database: `weblog` -- -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `ID_Blog` int(11) NOT NULL, `strPost` text NOT NULL, `datPosted` datetime NOT NULL, `strPoster` varchar(200) NOT NULL, `strTitle` varchar(255) NOT NULL, PRIMARY KEY (`ID_Blog`) ) TYPE=MyISAM COMMENT='This is where the blog posts are' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `blogs_x_tags` -- CREATE TABLE `blogs_x_tags` ( `ID_BlogTag` int(11) NOT NULL, `ID_Blog` int(11) NOT NULL, `ID_Tag` int(11) NOT NULL, PRIMARY KEY (`ID_BlogTag`), KEY `ID_Blog` (`ID_Blog`,`ID_Tag`) ) TYPE=MyISAM COMMENT='This is where blogs are connected to tags' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `reactions` -- CREATE TABLE `reactions` ( `ID_Reaction` int(11) NOT NULL, `ID_Blog` int(11) NOT NULL, `strPoster` varchar(255) NOT NULL, `strEmail` varchar(255) NOT NULL, `strIp` varchar(15) NOT NULL, `strReaction` text NOT NULL, `datReply` date NOT NULL, PRIMARY KEY (`ID_Reaction`) ) TYPE=MyISAM COMMENT='This is where the replies to the posts are' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `ID_Tag` int(11) NOT NULL, `strTag` varchar(100) NOT NULL, PRIMARY KEY (`ID_Tag`) ) TYPE=MyISAM COMMENT='This is where tags are stored' AUTO_INCREMENT=1 ;