/*
SQLyog Community Edition- MySQL GUI v5.22a
Host - 5.0.45 : Database - scart
*********************************************************************
Server version : 5.0.45
*/




create database if not exists `scart`;

USE `scart`;


/*Table structure for table `adminuser` */


CREATE TABLE `adminuser` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(40) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `adminuser` */

insert  into `adminuser`(`id`,`userid`,`password`) values (1,'admin','password');

/*Table structure for table `category` */


CREATE TABLE `category` (
  `categoryid` int(11) NOT NULL auto_increment,
  `categoryname` varchar(60) default NULL,
  PRIMARY KEY  (`categoryid`)
) ENGINE=MyISAM AUTO_INCREMENT=134 DEFAULT CHARSET=latin1;

/*Data for the table `category` */

insert  into `category`(`categoryid`,`categoryname`) values (2,'Phones'),(3,'Acceseries'),(4,'Computers'),(104,'Television'),(125,'automobile'),(126,'automobile'),(132,''),(133,'');

/*Table structure for table `config` */


CREATE TABLE `config` (
  `id` int(11) NOT NULL auto_increment,
  `storename` varchar(50) NOT NULL default '',
  `storeurl` varchar(50) NOT NULL default '',
  `ordernoticeemail` varchar(50) NOT NULL default '',
  `cursymbol` varchar(6) NOT NULL default '',
  `curcode` varchar(6) NOT NULL default '',
  `aboutustext` varchar(200) NOT NULL,
  `shipdeltext` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

/*Data for the table `config` */

insert  into `config`(`id`,`storename`,`storeurl`,`ordernoticeemail`,`cursymbol`,`curcode`,`aboutustext`,`shipdeltext`) values (9,'Gyan Store','http:/mydomain.net','vinay@gmail.com','$','Dollar','This is Vinay','This is Vinay'),(10,'Gyan Store','http:/mydomain.net','vinay@gmail.com','$','Dollar','This is Vinay','This is Vinay'),(11,'Roseindia','http://roseindia.net','vinay@roseindia.net','#','$','This is Vinay','This is Vinay');

/*Table structure for table `orderitems` */


CREATE TABLE `orderitems` (
  `productid` int(11) NOT NULL default '0',
  `orderid` int(11) NOT NULL default '0',
  `name` char(255) default NULL,
  `price` float default NULL,
  `quantity` int(11) default NULL,
  PRIMARY KEY  (`orderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `orderitems` */

insert  into `orderitems`(`productid`,`orderid`,`name`,`price`,`quantity`) values (1,2,'Pulser',65000,23);

/*Table structure for table `orders` */


CREATE TABLE `orders` (
  `orderid` int(11) NOT NULL auto_increment,
  `ordertime` datetime default NULL,
  `custfirstname` varchar(30) default NULL,
  `custlastname` varchar(30) default NULL,
  `custemail` varchar(30) default NULL,
  `custcountry` varchar(30) default NULL,
  `custzip` varchar(30) default NULL,
  `custstate` varchar(30) default NULL,
  `custcity` varchar(30) default NULL,
  `custaddress` varchar(30) default NULL,
  `custphone` varchar(30) default NULL,
  `custfax` int(11) default NULL,
  PRIMARY KEY  (`orderid`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

/*Data for the table `orders` */

insert  into `orders`(`orderid`,`ordertime`,`custfirstname`,`custlastname`,`custemail`,`custcountry`,`custzip`,`custstate`,`custcity`,`custaddress`,`custphone`,`custfax`) values (1,'2006-12-12 09:38:18','sushil','pal','pal@yahoo.com','india','110085','delhi','delhi','rohini sec-3','764584',4536789),(7,'2006-12-12 00:00:00','sushil','pal','pal@yahoo.com','india','110085','delhi','delhi','rohini sec-8','456789',543673),(8,'2006-12-12 00:00:00','vinod','kumar','pal@yahoo.com','india','110085','delhi','delhi','rohini sec-8','456789',543673),(9,'2006-12-12 00:00:00','amit','kumar','amit@yahoo.com','ghhdhdhd','54654654','gdsg','gdsfg','gdgfdgfdg','3245454',5454554),(10,'2006-12-12 00:00:00','deepak','mohan','dd@yahoo.com','grggdgdfd gdfgdf','2423423','ertete','ertret','jhghk  jkf hhd fgdfh df\r\n dfhs','546576887',87786478),(11,'2007-06-23 19:01:12','ravi','kant','dvs','345353','53543','dgfdgdfg',' gfdgdfgdfg','fgd gdgdgdfg','443242',24324324),(12,'2007-06-23 19:04:46','ravi','kant','dvs','345353','53543','dgfdgdfg',' gfdgdfgdfg','fgd gdgdgdfg','443242',24324324),(13,'2007-06-23 19:10:38','sushil','pal','fsdsfs','fgdgdg','5353534','fgdg','dfgdgd','5rdgtrdgdfd','54353',34535);

/*Table structure for table `product` */


CREATE TABLE `product` (
  `productid` int(11) NOT NULL auto_increment,
  `categoryname` varchar(50) default NULL,
  `productname` varchar(60) default NULL,
  `productprice` varchar(40) default NULL,
  `listprice` varchar(20) default NULL,
  `userImage` varchar(60) default NULL,
  `quantity` varchar(11) default NULL,
  `description` varchar(80) default NULL,
  `briefdisc` text,
  PRIMARY KEY  (`productid`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;

/*Data for the table `product` */

insert  into `product`(`productid`,`categoryname`,`productname`,`productprice`,`listprice`,`userImage`,`quantity`,`description`,`briefdisc`) values (6,'63','Lotus Esprit','72000','80000','LotusEsprit.jpg','2','',''),(7,'64','Lamborghini Diablo','190000','230000','LamborghiniDiablo.jpg','2','',''),(8,'14','Samsung R200','135','','','5','',''),(9,'Phones','Samsung N100','157','149','','23','fgh','fhg'),(10,'14','Samsung A100','187','','','15','',''),(11,'14','Samsung A300','249.99','','','11','','The premium SGH-A300, designed to succeed the SGH-A100 and A110, is targeted for people who lead in fashion rather than follow.'),(12,'15','Ericsson T29','173','','EricssonT29.jpg','10','',''),(13,'15','Ericsson T39','266','','EricssonT39.jpg','10','',''),(14,'15','Ericsson T60','345','380','EricssonT60.jpg','20','',''),(15,'14','Samsung R20','125','130','','10','',''),(16,'14','Samsung-n30','200','225','','12','',''),(22,'74','Classic01','50','57','','10','',''),(27,'20','The Last Kiss','15.30','20.00','thelastkiss.jpg','5','',''),(28,'20','Black Dahlia, The (Widescreen)','21.73','29.98','black_dahlia.jpg','10','',''),(29,'20','Step Up(Widescreen)','23.42','29.99','stepup.jpg','20','',''),(30,'20','Woh Lamhe','22.99','25.30','wohlamhe.jpg','20','',''),(31,'20','2 Hot 2 Handle','12.99','14.99','hot_handle.jpg','20','',''),(32,'76','JVC LT-37X987 LCD HDTV','5000','8000','jvclcdtv.jpg','2','',''),(33,'21','Apple iPod Nano (2GB, black)','129','135','Apple_ iPod_Nano.gif','20','',''),(34,'20','GURU','9.00','10.00','guruh061106_3.jpg','20','',''),(35,'17','Nokia 6600','250','280','nokia_6600.jpg','40','',''),(36,'17','Nokia 3230','250','280','nokia3230.jpg','10','',''),(37,'17','Nokia N90','300','315','nokian-90.jpg','5','',''),(38,'17','Nokia N91','625','700','nokia-N91.jpg','5','',''),(39,'40','Sweeter','47','55','480_095_small.jpg','10','',''),(40,'39','Pants','19','25','','5','',''),(41,'38','Pants-Winter','21','25','','10','',''),(42,'51','Fujitsu Siemens LifeBook P-111','1503','2000','','5','',''),(43,'51','IBM ThinkPad T30 2366-89G','3170','3500','','5','',''),(44,'57','3Com Palm m130','250','280','','5','',''),(45,'57','Compaq iPAQ H3760','365','377','','5','','3.8’’, 240 õ 320, 206MHz, 64MB, 32MB ROM, MS Pocket PC 2002'),(46,'58','HP Compaq Evo D310','1207','1300','','5','','P-IV 2.4GHz, 256MB PC2100 DDR SDRAM, 40GB, CD-RW, Direct AGP, 10/100 Eth, WinXP Pro'),(47,'58','IBM NetVista M42','1152','','','5','','P-IV 2.0GHz, 256MB PC2100 DDR SDRAM, 40GB, CD-ROM, AGP, 10/100 Eth, WinXP Pro'),(48,'12','Rollerblade TRS Access','200','225','','10','',''),(49,'12','Roces Majestic 12','149','200','','10','',''),(50,'Phones','BURTON Balance','640','650','','10','',''),(51,'13','BURTON Cruzer','345','380','','5','',''),(52,'13','BURTON Power','659','700','','5','',''),(53,'12','Roces Khuti','179','200','','5','',''),(54,'46','Rum Captain Morgan','14','15','46_captain_morgan.jpg','20','',''),(55,'Phones','Coca-Cola','0.99','1.00','732_469.jpg','50','',''),(56,'46','Budwieser','0.39','0.59','','50','',''),(57,'71','Harry Potter book #1','5.0','8.0','15794s.jpg','20','','Harry Potter has never played a sport while flying on a broomstick. He`s never worn a cloak of invisibility, befriended a giant, or helped hatch a dragon...'),(58,'Phones','Harry Potter book #2','5.0','7.0','15795s.jpg','25','','The Dursleys were so mean and hideous that summer that all Harry Potter wanted was to get back to the Hogwarts School for Witchcraft and Wizardry. '),(59,'71','Harry Potter. Magic Eye. Album','3.0','5.0','','20','',''),(60,'73','Professional PHP programming','15','17','8472s.jpg','10','','PHP is a new technology that is growing fast...'),(61,'73','Visual C++ and MFC','17','20','4064s.jpg','10','','Tap into a collection of programming solutions that use the Microsoft Foundation Class(MFC) library...'),(62,'Phones','Stiv Krug :: Web-design ``Don`','8.0','10.0','10805s.jpg','15','','Exactly how do you deliver great web usability?...'),(63,'Phones','Siemens SL45','240','250','720_ssl45_small.jpg','10','','What if a phone is also an MP3 player, a digital voice recorder, an organizer? Can it still be called a phone? '),(64,'18','Siemens ME45','219','250','532_sme45.jpg','10','','With the ME45 you have it right in your hand. Voice direction and dialling, flexible memorymanagement for total personalisation, easy and fast calendar synchronisation with Microsoft Outlook, GPRS for really fast net action via your notebook or WAP.'),(65,'18','Siemens M35i','95.0','98.0','366_sm35_small.jpg','5','','he M35i gives you mobile web access, Personal Messaging with pictures, Intelligent Typing, and even allows the occasional game whenever life slows down..'),(66,'Computers','BOSE Companion 3 Three Piece Multimedia Computer Speaker Sys','249','250','77861534.jpg','5','',''),(67,'Computers','Ultra USB 2.0 WEB CAM Video Camera','63.05','65.00','68886096.jpg','15','','Creative Labs have created the WebCam Live! Ultra . You can place this camera almost anywhere, such as any flat surface, flat-panel and notebook displays due to the camera\'s built-in flexible four-way base. '),(68,'Computers','Dahon Vitesse D7 with Cyclone Electric Kit','800','805','t_21179.jpg','10','','If your shopping for a electric power-assisted bike, then you simply must check this out!'),(69,'Computers','Felt QX60 - 2007 Model','450','455','t_21835.jpg','10','','Aluminium hybrid bike, by Felt.'),(111,'Computers','Vinay','2314234','34234','17collectionframeworkextended.jpg','1233','zsdfzsdf','fsdgzdfg'),(112,'Acceseries','Viay','32455225','234234','80collectionframeworkextended.jpg','34','zSFDgzsgSG','ZSFgfsGSFGfsgf'),(113,'Acceseries','zregdtg','25234','254325','11Servlet-processing.jpg','523','sdfgszdGg','dfgdgdfgfd'),(114,'Phones','Vinay Kumar ','5252','324532','6document.pdf','23','This is Vinay Kumar','This is Vinay Kumar'),(115,'Acceseries','mobile','5000','4500','151111.gif','2','good','good');

/*Table structure for table `user` */


CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL,
  `password` varchar(30) default NULL,
  `firstname` varchar(30) default NULL,
  `lastname` varchar(30) default NULL,
  `email` varchar(30) default NULL,
  `country` varchar(30) default NULL,
  `zip` varchar(30) default NULL,
  `state` varchar(30) default NULL,
  `city` varchar(30) default NULL,
  `address` varchar(30) default NULL,
  `phone` varchar(30) default NULL,
  `fax` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert  into `user`(`id`,`userid`,`password`,`firstname`,`lastname`,`email`,`country`,`zip`,`state`,`city`,`address`,`phone`,`fax`) values (28,'abc','abc','Gyan','singh','ksjhkfdj.jg@vj','india','77887','guuggug','gjggjkg','gjhgjh','7698798798',89779788),(44,'','','','','','','','','','','',NULL);

