
CREATE TABLE IF NOT EXISTS `cart` (
`cId` int(255) NOT NULL,
  `pId` int(255) NOT NULL,
  `uName` varchar(255) NOT NULL,
  `pQty` int(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;


INSERT INTO `cart` (`cId`, `pId`, `uName`, `pQty`) VALUES
(1, 1, 'channa', 1),
(10, 17, 'channa', 1),
(14, 11, 'channa', 2),
(17, 7, 'user', 4),
(18, 14, 'hash', 1),
(19, 3, 'mehdi@bandegani.de', 3),
(20, 3, 'mehdi@bandegani.de', 1),
(21, 3, 'mehdi@bandegani.de', 1),
(22, 3, 'mehdi@bandegani.de', 1),
(23, 9, 'mehdi@bandegani.de', 2),
(24, 18, 'mehdi@bandegani.de', 1),
(25, 3, 'mehdi@bandegani.de', 1),
(26, 2, 'mehdi@bandegani.de', 4);



CREATE TABLE IF NOT EXISTS `collection_table` (
`c_id` int(255) NOT NULL,
  `collection` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


INSERT INTO `collection_table` (`c_id`, `collection`) VALUES
(1, 'women'),
(2, 'men'),
(3, 'accessories');


CREATE TABLE IF NOT EXISTS `products` (
`pId` int(255) NOT NULL,
  `pName` varchar(255) NOT NULL,
  `pPrice` int(255) NOT NULL,
  `pQty` int(255) NOT NULL,
  `pCollection` varchar(255) NOT NULL,
  `pImg` varchar(255) NOT NULL,
  `pAImg` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;


INSERT INTO `products` (`pId`, `pName`, `pPrice`, `pQty`, `pCollection`, `pImg`, `pAImg`) VALUES
(1, 'pleated skirt', 4, 2, 'women', 'https://static.wixstatic.com/media/84770f_92ad288f7eb849c68652826216de56dc.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_92ad288f7eb849c68652826216de56dc.webp', 'https://static.wixstatic.com/media/84770f_8660c9c0527c4107869f4159281b3957.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_8660c9c0527c4107869f4159281b3957.webp'),
(2, 'Navy Suit', 14, 0, 'men', 'https://static.wixstatic.com/media/84770f_174a1833c8394bd1af133b4795f7e33b.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_174a1833c8394bd1af133b4795f7e33b.webp', 'https://static.wixstatic.com/media/84770f_aa82a8fc608f41ac82139564e5d10e93.jpg/v1/fill/w_625,h_625,al_c,q_85,usm_0.66_1.00_0.01/84770f_aa82a8fc608f41ac82139564e5d10e93.webp'),
(3, 'printed chiffon dress', 20, 2, 'women', 'https://static.wixstatic.com/media/84770f_8745e3f04d8e4662ba23b4d575602616.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_8745e3f04d8e4662ba23b4d575602616.webp', 'https://static.wixstatic.com/media/84770f_6d22d3fd17e74bd2948588ab408fd231.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_6d22d3fd17e74bd2948588ab408fd231.webp'),
(4, 'printed top', 19, 2, 'women', 'https://static.wixstatic.com/media/84770f_fd449a34dc724242b659cf1476e073dd.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_fd449a34dc724242b659cf1476e073dd.webp', 'https://static.wixstatic.com/media/84770f_c088c666b370405194b8dd2d12f248b3.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_c088c666b370405194b8dd2d12f248b3.webp'),
(5, 'Striped Mini Skirt', 18, 2, 'women', 'https://static.wixstatic.com/media/84770f_c4238cadc128447a90c5c4ec07cb8532.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_c4238cadc128447a90c5c4ec07cb8532.webp', 'https://static.wixstatic.com/media/84770f_315c3ab348104bcd83146532d72e2ef1.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_315c3ab348104bcd83146532d72e2ef1.webp'),
(6, 'Knee Length Dress', 13, 2, 'women', 'https://static.wixstatic.com/media/84770f_d9b51e08b51c43319cc6a36f808d7bf9.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_d9b51e08b51c43319cc6a36f808d7bf9.webp', 'https://static.wixstatic.com/media/84770f_0f5fb1bcf1ff442396a8cde48380693a.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_0f5fb1bcf1ff442396a8cde48380693a.webp'),
(7, 'Plaint White Shorts', 7, 2, 'women', 'https://static.wixstatic.com/media/84770f_8bba0cf04db947de8d9542f081e545ad.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_8bba0cf04db947de8d9542f081e545ad.webp', 'https://static.wixstatic.com/media/84770f_a93eaf951ab94858b7a2976d9489744e.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_a93eaf951ab94858b7a2976d9489744e.webp'),
(8, 'Chinese Shirt', 26, 0, 'women', 'https://static.wixstatic.com/media/84770f_685a7e84e1f6459592ea52b10d6ec70f.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_685a7e84e1f6459592ea52b10d6ec70f.webp', 'https://static.wixstatic.com/media/84770f_bdb4bcdcc06d4dcf94ad9181c12557be.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_bdb4bcdcc06d4dcf94ad9181c12557be.webp'),
(9, 'Straight Pant', 19, 0, 'women', 'https://static.wixstatic.com/media/84770f_2c647846e52d4b5d9cc3a6e1e8e38ba5.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_2c647846e52d4b5d9cc3a6e1e8e38ba5.webp', 'https://static.wixstatic.com/media/84770f_7fa958c8c2414423a3e585c5c27779b3.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_7fa958c8c2414423a3e585c5c27779b3.webp'),
(10, 'casual t-shirt', 18, 0, 'men', 'https://static.wixstatic.com/media/84770f_fa2cb753b49b43faa1e9b3da2e8f72c0.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_fa2cb753b49b43faa1e9b3da2e8f72c0.webp', 'https://static.wixstatic.com/media/84770f_b26b140c7de74e6a910e3ad516980681.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_b26b140c7de74e6a910e3ad516980681.webp'),
(11, 'Side Zip T-Shirt', 22, 0, 'men', 'https://static.wixstatic.com/media/84770f_ad69de0ded0845ecb2be4c325fc0d7b2.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_ad69de0ded0845ecb2be4c325fc0d7b2.webp', 'https://static.wixstatic.com/media/84770f_f9de83a5802c4c8fb60703dd1f706df4.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_f9de83a5802c4c8fb60703dd1f706df4.webp'),
(12, 'Pattern t-shirt', 13, 0, 'men', 'https://static.wixstatic.com/media/84770f_1720a41d8a7f4f51be2e910b346afb2d.jpg/v1/fill/w_625,h_625,al_c,q_85,usm_0.66_1.00_0.01/84770f_1720a41d8a7f4f51be2e910b346afb2d.webp', 'https://static.wixstatic.com/media/84770f_b4141d6d0e294322abc6e3906f6d5056.jpg/v1/fill/w_625,h_625,al_c,q_85,usm_0.66_1.00_0.01/84770f_b4141d6d0e294322abc6e3906f6d5056.webp'),
(13, 'Foldover Purse', 6, 0, 'accessories', 'https://static.wixstatic.com/media/84770f_86f6b8eadd0144ff8123a42842ae37a5.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_86f6b8eadd0144ff8123a42842ae37a5.webp', 'https://static.wixstatic.com/media/84770f_04708dcecb9446e89167e6ac4ca7ba82.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_04708dcecb9446e89167e6ac4ca7ba82.webp'),
(14, 'Handcraft Clutch', 5, 2, 'accessories', 'https://static.wixstatic.com/media/84770f_5a144aac1232446497775d71890dd188.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_5a144aac1232446497775d71890dd188.webp', 'https://static.wixstatic.com/media/84770f_775e9afa293b43f89eec9736b8c42d08.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_775e9afa293b43f89eec9736b8c42d08.webp'),
(15, 'Green Necklace', 2, 2, 'accessories', 'https://static.wixstatic.com/media/84770f_f8e77c4203dd40c19eb913ae3b4ccb1a.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_f8e77c4203dd40c19eb913ae3b4ccb1a.webp', 'https://static.wixstatic.com/media/84770f_dc75910eb7ab4aa782542c6af9770fd2.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_dc75910eb7ab4aa782542c6af9770fd2.webp'),
(16, 'black necklace', 12, 2, 'accessories', 'https://static.wixstatic.com/media/84770f_480159a712a64e04addd28ca090a5cb8.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_480159a712a64e04addd28ca090a5cb8.webp', 'https://static.wixstatic.com/media/84770f_dad2829a0b8148a78096aecefb5d84e9.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_dad2829a0b8148a78096aecefb5d84e9.webp'),
(17, 'Silver Ornament', 11, 0, 'accessories', 'https://static.wixstatic.com/media/84770f_e38be8301e254aeab5e032ecba6be649.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_e38be8301e254aeab5e032ecba6be649.webp', 'https://static.wixstatic.com/media/84770f_0c74978c768a4103b2cbc34f488ffd6d.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_0c74978c768a4103b2cbc34f488ffd6d.webp'),
(18, 'Grey belt', 29, 0, 'accessories', 'https://static.wixstatic.com/media/84770f_21d996d935eb4aa186fcf2431893cb5f.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_21d996d935eb4aa186fcf2431893cb5f.webp', 'https://static.wixstatic.com/media/84770f_7e554aae23ec4e3b8f0d5ed0603f2916.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_7e554aae23ec4e3b8f0d5ed0603f2916.webp'),
(19, 'Cateye Sunglasses', 49, 0, 'accessories', 'https://static.wixstatic.com/media/84770f_054a710970294c8a91eeea7d1b20f44d.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_054a710970294c8a91eeea7d1b20f44d.webp', 'https://static.wixstatic.com/media/84770f_119268614ecb4043b06bd1893ea3eb02.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_119268614ecb4043b06bd1893ea3eb02.webp'),
(20, 'Round sunglasses', 32, 0, 'accessories', 'https://static.wixstatic.com/media/84770f_3d58b9767c674b0f9c75805fe1e63a85.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_3d58b9767c674b0f9c75805fe1e63a85.webp', 'https://static.wixstatic.com/media/84770f_43f5bbf6c55b4e5a96386072e3f469b5.png/v1/fill/w_625,h_625,al_c,q_90,usm_0.66_1.00_0.01/84770f_43f5bbf6c55b4e5a96386072e3f469b5.webp');

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `cart`
--
ALTER TABLE `cart`
 ADD PRIMARY KEY (`cId`);

--
-- Indizes für die Tabelle `collection_table`
--
ALTER TABLE `collection_table`
 ADD PRIMARY KEY (`c_id`);

--
-- Indizes für die Tabelle `products`
--
ALTER TABLE `products`
 ADD PRIMARY KEY (`pId`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `cart`
--
ALTER TABLE `cart`
MODIFY `cId` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT für Tabelle `collection_table`
--
ALTER TABLE `collection_table`
MODIFY `c_id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT für Tabelle `products`
--
ALTER TABLE `products`
MODIFY `pId` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;

