Login   Register  
PHP Classes
elePHPant
Icontem

File: sql/sample.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Zouari  >  db2XML  >  sql/sample.sql  >  Download  
File: sql/sample.sql
Role: License text
Content type: text/plain
Description: Mysql dump for testing
Class: db2XML
Generate XML documents from MySQL query results
Author: By
Last change:
Date: 7 years ago
Size: 9,396 bytes
 

Contents

Class file image Download
CREATE TABLE `book` (
  `idSPr` int(50) NOT NULL auto_increment,
  `idStore` varchar(100) collate latin1_general_ci NOT NULL,
  `itemid` int(50) NOT NULL,
  `itemtype` varchar(20) collate latin1_general_ci NOT NULL,
  `author` varchar(255) collate latin1_general_ci default NULL,
  `userprice` int(100) default NULL,
  `usercomment` text collate latin1_general_ci,
  `instock` tinyint(1) default NULL,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `subject` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `thumbnail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`idStore`,`itemid`,`itemtype`),
  UNIQUE KEY `idSPr` (`idSPr`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table book
#

INSERT INTO `book` VALUES (7,'1',509520,'book','Krug, Steve',22,'Boukadida Haythem',1,'Don\'T Make Me Think','Internet/Web Publishing','./images/books/509520_image.jpg','./images/books/509520_thumbnail.jpg');
INSERT INTO `book` VALUES (10,'1',327059,'book','Passman, Donald S.',19,'NA',1,'All You Need To Know About The Music Business','Music','./images/books/327059_image.jpg','./images/books/327059_thumbnail.jpg');

#
# Table structure for table cd
#

CREATE TABLE `cd` (
  `idSPr` int(50) NOT NULL auto_increment,
  `idStore` int(11) NOT NULL,
  `itemid` int(50) NOT NULL,
  `itemtype` varchar(20) collate latin1_general_ci NOT NULL,
  `artist` varchar(255) collate latin1_general_ci default NULL,
  `userprice` int(100) default NULL,
  `usercomment` text collate latin1_general_ci,
  `instock` tinyint(1) default NULL,
  `genre` varchar(255) collate latin1_general_ci default NULL,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `thumbnail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`idStore`,`itemid`,`itemtype`(1)),
  KEY `idSPr` (`idSPr`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table cd
#


#
# Table structure for table dvd
#

CREATE TABLE `dvd` (
  `idSPr` int(50) NOT NULL auto_increment,
  `idStore` varchar(100) collate latin1_general_ci NOT NULL,
  `itemid` int(50) NOT NULL,
  `itemtype` varchar(20) collate latin1_general_ci NOT NULL,
  `actor` varchar(255) collate latin1_general_ci default NULL,
  `userprice` int(100) default NULL,
  `usercomment` text collate latin1_general_ci,
  `instock` tinyint(1) default NULL,
  `genre` varchar(255) collate latin1_general_ci default NULL,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `thumbnail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`idStore`,`itemid`,`itemtype`(1)),
  UNIQUE KEY `idSPr` (`idSPr`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table dvd
#

INSERT INTO `dvd` VALUES (10,'1',473470,'dvd','Various',15,'NA',1,'How To - Cooking/Diet','Wine For Dummies','./images/dvds/473470_image.jpg','./images/dvds/473470_thumbnail.jpg');

#
# Table structure for table game
#

CREATE TABLE `game` (
  `idSPr` int(50) NOT NULL auto_increment,
  `idStore` varchar(100) collate latin1_general_ci NOT NULL,
  `itemid` int(50) NOT NULL,
  `itemtype` varchar(20) collate latin1_general_ci NOT NULL,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `userprice` int(100) default NULL,
  `usercomment` text collate latin1_general_ci,
  `instock` tinyint(1) default NULL,
  `manufacturer` varchar(255) collate latin1_general_ci default NULL,
  `genre` varchar(255) collate latin1_general_ci default NULL,
  `type` varchar(255) collate latin1_general_ci default NULL,
  `typecode` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `thumbnail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`idStore`,`itemid`,`itemtype`),
  UNIQUE KEY `idSPr` (`idSPr`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table game
#

INSERT INTO `game` VALUES (4,'1',656916,'game','Grand Theft Auto Liberty City Stories',19,'NA',1,'Sony','Game Shooters','Sony PlayStation 2 Game','P2','./images/games/P2_656916_image.jpg','./images/games/P2_656916_thumbnail.jpg');

#
# Table structure for table mp3tracks
#

CREATE TABLE `mp3tracks` (
  `idSPr` int(50) NOT NULL auto_increment,
  `idStore` int(11) NOT NULL,
  `itemid` int(50) NOT NULL,
  `itemtype` varchar(20) collate latin1_general_ci NOT NULL,
  `artist` varchar(255) collate latin1_general_ci default NULL,
  `userprice` int(100) default NULL,
  `usercomment` text collate latin1_general_ci,
  `instock` tinyint(1) default NULL,
  `genre` varchar(255) collate latin1_general_ci default NULL,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `thumbnail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`idStore`,`itemid`,`itemtype`(1)),
  KEY `idSPr` (`idSPr`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table mp3tracks
#

INSERT INTO `mp3tracks` VALUES (1,1,35646,'mp3track',NULL,150,'vhbsdjh bck cnbxcn ncx b, c,mn ,mhbdszjhbsdj jkj',NULL,'World, World Beats','Tanto Tempo (Peter Kruder Remix)','./images/mp3s/35646_image.jpg','./images/mp3s/35646_thumbnail.jpg');

#
# Table structure for table ownproduct
#

CREATE TABLE `ownproduct` (
  `idStore` varchar(100) collate latin1_general_ci NOT NULL,
  `itemid` int(11) NOT NULL auto_increment,
  `title` varchar(255) collate latin1_general_ci default NULL,
  `Condition` text collate latin1_general_ci,
  `Brief_description` text collate latin1_general_ci,
  `detailed_information` text collate latin1_general_ci,
  `suggested_price` float(10,3) NOT NULL default '0.000',
  `shipping` text collate latin1_general_ci,
  `Image_1` varchar(255) collate latin1_general_ci default NULL,
  `Image_2` varchar(255) collate latin1_general_ci default NULL,
  `Image_3` varchar(255) collate latin1_general_ci default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `email` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`itemid`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table ownproduct
#

INSERT INTO `ownproduct` VALUES ('1',46,NULL,NULL,NULL,NULL,0,NULL,'upload/store_1/ownproduct/Cristal.jpg','upload/store_1/ownproduct/Cristal_1.jpg',NULL,1,'');
INSERT INTO `ownproduct` VALUES ('1',42,'asd','asd','asd','asd',12,'asd','upload/store_1/ownproduct/__toiles.jpg','upload/store_1/ownproduct/Dune_3.jpg',NULL,0,'');
INSERT INTO `ownproduct` VALUES ('1',41,'g','g','g','g',0,'g','upload/Espace vortex.jpg','upload/Ondines.jpg','upload/Ami.jpg',1,'');
INSERT INTO `ownproduct` VALUES ('1',43,'qwerty','qwerty','qwerty','qwerty',12,'qwerty','upload/Tropiques.jpg','upload/Ami.jpg','upload/Automne.jpg',1,'');
INSERT INTO `ownproduct` VALUES ('1',44,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'');
INSERT INTO `ownproduct` VALUES ('1',45,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'');

#
# Table structure for table store
#

CREATE TABLE `store` (
  `idStore` int(11) NOT NULL,
  `idC` varchar(100) collate latin1_general_ci NOT NULL,
  `Title` varchar(100) collate latin1_general_ci NOT NULL,
  `banner` varchar(255) collate latin1_general_ci NOT NULL,
  `image` varchar(255) collate latin1_general_ci NOT NULL,
  `Link_1_Text` text collate latin1_general_ci NOT NULL,
  `Link_1_Adresse` varchar(255) collate latin1_general_ci NOT NULL,
  `Link_2_Text` text collate latin1_general_ci NOT NULL,
  `Link_2_Adresse` varchar(255) collate latin1_general_ci NOT NULL,
  `Link_3_Text` text collate latin1_general_ci NOT NULL,
  `Link_3_Adresse` varchar(255) collate latin1_general_ci NOT NULL,
  `Description` text collate latin1_general_ci NOT NULL,
  `metakeywords` text character set latin1,
  PRIMARY KEY  (`idStore`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table store
#

INSERT INTO `store` VALUES (1,'1','BobStore','upload/store_1/storeinfo/Tulipes.jpg','upload/store_1/storeinfo/Dune.jpg','Yahoo','http://www.yahoo.fr','google','http://www.google.com','TriTUX','http://www.tritux.com','My DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy DescriptionMy Description','ggggggggg');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;