WatchMarkaz.pk (WatchMarkaz.com.pk) Database Leaked [Download]

Table: contactform - id INT(11) AUTO_INCREMENT NOT NULL, quantity INT(11) NOT NULL, productname VARCHAR(255) NOT NULL, productmodel VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, lastname VARCHAR(155) NOT NULL, email VARCHAR(255) NOT NULL, mobile VARCHAR(12) NOT NULL, address_region VARCHAR(255) NOT NULL, address TEXT NOT NULL, city VARCHAR(255) NOT NULL, phone VARCHAR(20) NOT NULL, date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, omid INT(155) NOT NULL, PRIMARY KEY (id) - ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2727;

Table: brandsfilter - brandsfilterid INT(55) AUTO_INCREMENT NOT NULL, filtername TEXT NOT NULL, brandid VARCHAR(255) NOT NULL, materialid INT(55) NOT NULL, PRIMARY KEY (brandsfilterid) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Table: category - id INT(155) AUTO_INCREMENT NOT NULL, name VARCHAR(255) DEFAULT NULL, pic VARCHAR(255) DEFAULT NULL, isvisible INT(1) NOT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

Table: brands - brandsid INT(155) AUTO_INCREMENT NOT NULL, name VARCHAR(55) NOT NULL, picture VARCHAR(55) NOT NULL, details TEXT NOT NULL, brandcode INT(55) NOT NULL, category_id INT(11) NOT NULL, isvisible INT(1) NOT NULL, brandtag VARCHAR(15) NOT NULL, url VARCHAR(255) NOT NULL, PRIMARY KEY (brandsid) - ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Table: admin - id INT(50) AUTO_INCREMENT NOT NULL, admin_id VARCHAR(255) DEFAULT NULL, admin_pwd VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8;

Table: tempordermaster1 - id INT(11) AUTO_INCREMENT NOT NULL, customerid VARCHAR(255) DEFAULT NULL, odate DATE DEFAULT NULL, total DECIMAL(10,2) DEFAULT NULL, tax DECIMAL(10,2) DEFAULT NULL, gross DECIMAL(10,2) DEFAULT NULL, discount DECIMAL(10,2) DEFAULT NULL, isdelivered INT(1) DEFAULT NULL, deliverydate DATE DEFAULT NULL, deliveredby VARCHAR(10) DEFAULT NULL, warrantytotal DECIMAL(10,2) DEFAULT NULL, shippingcharges DECIMAL(10,2) DEFAULT NULL, leatherBox DECIMAL(10,2) NOT NULL, giftBox DECIMAL(10,2) NOT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5983;

... and so on for the remaining tables.

Table: contactform - id INT(11) AUTO_INCREMENT NOT NULL, quantity INT(11) NOT NULL, productname VARCHAR(255) NOT NULL, productmodel VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, lastname VARCHAR(155) NOT NULL, email VARCHAR(255) NOT NULL, mobile VARCHAR(12) NOT NULL, address_region VARCHAR(255) NOT NULL, address TEXT NOT NULL, city VARCHAR(255) NOT NULL, phone VARCHAR(20) NOT NULL, date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, omid INT(155) NOT NULL, PRIMARY KEY (id) - ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2727;

Table: brandsfilter - brandsfilterid INT(55) AUTO_INCREMENT NOT NULL, filtername TEXT NOT NULL, brandid VARCHAR(255) NOT NULL, materialid INT(55) NOT NULL, PRIMARY KEY (brandsfilterid) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Table: category - id INT(155) AUTO_INCREMENT NOT NULL, name VARCHAR(255) DEFAULT NULL, pic VARCHAR(255) DEFAULT NULL, isvisible INT(1) NOT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

Table: brands - brandsid INT(155) AUTO_INCREMENT NOT NULL, name VARCHAR(55) NOT NULL, picture VARCHAR(55) NOT NULL, details TEXT NOT NULL, brandcode INT(55) NOT NULL, category_id INT(11) NOT NULL, isvisible INT(1) NOT NULL, brandtag VARCHAR(15) NOT NULL, url VARCHAR(255) NOT NULL, PRIMARY KEY (brandsid) - ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Table: admin - id INT(50) AUTO_INCREMENT NOT NULL, admin_id VARCHAR(255) DEFAULT NULL, admin_pwd VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8;

Table: tempordermaster1 - id INT(11) AUTO_INCREMENT NOT NULL, customerid VARCHAR(255) DEFAULT NULL, odate DATE DEFAULT NULL, total DECIMAL(10,2) DEFAULT NULL, tax DECIMAL(10,2) DEFAULT NULL, gross DECIMAL(10,2) DEFAULT NULL, discount DECIMAL(10,2) DEFAULT NULL, isdelivered INT(1) DEFAULT NULL, deliverydate DATE DEFAULT NULL, deliveredby VARCHAR(10) DEFAULT NULL, warrantytotal DECIMAL(10,2) DEFAULT NULL, shippingcharges DECIMAL(10,2) DEFAULT NULL, leatherBox DECIMAL(10,2) NOT NULL, giftBox DECIMAL(10,2) NOT NULL, PRIMARY KEY (id) - ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5983;

... and so on for the remaining tables.