DDL: polnenje_dml.sql

File polnenje_dml.sql, 45.5 KB (added by 161029, 3 years ago)
Line 
1---- Product Categories
2
3insert into product_category(category_name) values ('Vitamins');
4insert into product_category(category_name) values ('Anti-aging');
5insert into product_category(category_name) values ('Antioxidants');
6insert into product_category(category_name) values ('Digestion');
7
8---- Products with category 1
9
10INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1000', 'Super K Vitamins', 'Vitamin K1, K2 (MK-4 and MK-7) found in Super K with Advanced K2 Complex can support anti-calcification of arteries, promotes normal bone density and promotes a healthy heart. Use Vitamin K1, K2, MK-4 and MK-7 found in Super K with Advanced K2 to support anti calcification of your cardiovascular system and promote strong bones.', 'assets/images/products/vitamins/VITAMINS-1000.png',true, 100, 24.03, 1, NOW());
11
12INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1001', 'BioActive Complete B-Complex', 'The Vitamin B vitamins in Bioactive Complete B-Complex can Provide potent, scientifically studied B-vitamin dosages formulated with the bioactive forms of each nutrient. Bioactive Complete promotes healthy metabolism of glucose, fat and alcohol, encourages healthy organ function, cognitive health and helps inhibit potential vitamin B deficiency.', 'assets/images/products/vitamins/VITAMINS-1001.png',true, 100, 14.50, 1, NOW());
13
14INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1002', 'Vitamins D & K', 'The active ingredients in Vitamins D and K can support healthy cognitive function, promote bone, immune & cardiovascular health, help inhibit calcium buildup in the arteries and help counteract possible iodine deficiency in healthy diets. Because bone strength may weaken with age, maintaining strong bones gets increasingly important the older you get. Supplementing your diet with a combination of Vitamin D, K is a viable option as these two nutrients work synergistically to promote bone strength. Iodine is essential for the production of thyroid hormones.', 'assets/images/products/vitamins/VITAMINS-1002.png',true, 100, 29.90, 1, NOW());
15
16INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1003', 'Vitamin C and Quercetin', 'Vitamin C and ultra-absorbable quercetin found in VITAMIN C and Bio-Quercetin Phytosome can help protect your body from oxidative stress and promote collagen formation as well as healthy iron absorption and healthy immune function.', 'assets/images/products/vitamins/VITAMINS-1003.png',true, 100, 17.03, 1, NOW());
17
18INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1004', 'Liposomal Vitamin C', 'As an antioxidant, vitamin C neutralizes free radicals in the body and protects tissues from oxidative stress. Vitamin C also promotes the formation of collagen, the connective tissue that supports arterial walls, skin, bones and teeth, supports the immune system and helps regenerate other antioxidants, including vitamin E.', 'assets/images/products/vitamins/VITAMINS-1004.png',true, 100, 17.03, 1, NOW());
19
20INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1005', 'Folate & Vitamin B12', 'Maintaining adequate folate- and vitamin B12 levels is crucial. With age, the body often absorbs less of these vitamins. By taking BioActive Folate & Vitamin B12 supplements in the advised doses you can support normal brain- and cognitive function in the aging body, and support heart health, as well as normal production rates of red blood cells.', 'assets/images/products/vitamins/VITAMINS-1005.png',true, 100, 12.30, 1, NOW());
21
22INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1006', 'Vitamin D3', 'Vitamin D3 can be synthesised by humans through the skin upon exposure to sunlight. Due to the winter, weather conditions and sun block, your bodys ability to produce enough vitamin D may be hindered. These factors emphasise the importance of taking vitamin D supplements. Vitamin D has long provided significant support for healthy bone density. Along with it, vitamin D has been proven to play a role in regulating healthy proliferation and on immunity.', 'assets/images/products/vitamins/VITAMINS-1006.png',true, 100, 12.30, 1, NOW());
23
24INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1007', 'Super K Elite', 'Vitamin K is not just a single vitamin. In fact, there are several different types of vitamin K, which all support different aspects of your health, from arterial health to bone health. Super K Elite delivers an unparalleled variety of vitamin K forms found in nature. Coming in clinically studied doses, the Super K Elite formula is crafted and designed to give you the optimum health', 'assets/images/products/vitamins/VITAMINS-1007.png',true, 100, 12.30, 1, NOW());
25
26INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1008', 'Optimized Folate', 'Folate, a member of the B-complex family, is involved in neurotransmitter synthesis and many other critical enzymatic reactions throughout the body. Optimal levels of this essential vitamin are necessary for healthy cell division and protein synthesis. In addition, folate helps maintain homocysteine levels within the normal range, thereby promoting cardiovascular health and nervous system function.', 'assets/images/products/vitamins/VITAMINS-1008.png',true, 100, 17.99, 1, NOW());
27
28INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1009', 'Gamma E with Tocopherols', 'Vitamin E is actually an umbrella term for eight different antioxidant compounds. Unlike most vitamin E supplements, Gamma E Mixed Tocopherols & Tocotrienols contains all eight forms of vitamin E for optimal antioxidant protection, eye health, nervous system support and more.', 'assets/images/products/vitamins/VITAMINS-1009.png',true, 100, 35.60, 1, NOW());
29
30INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1010', 'Liquid Vitamin D3', 'Vitamin D3 can be synthesised by humans through the skin upon exposure to sunlight. Due to the winter, weather conditions and sun block, your bodys ability to produce enough vitamin D may be hindered. These factors emphasise the importance of taking vitamin D supplements. Vitamin D has long provided significant support for healthy bone density.', 'assets/images/products/vitamins/VITAMINS-1010.png',true, 100, 22.60, 1, NOW());
31
32INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1011', 'Low Dose Vitamin K2', 'Vitamin K in Low-Dose Vitamin K2 can help contribute to counter calcification of the arteries thereby helping to maintain a healthy cardiovascular system, and support building healthy bones. ', 'assets/images/products/vitamins/VITAMINS-1011.png',true, 100, 12.90, 1, NOW());
33
34INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1012', 'Gamma E Mixed Tocopherols', 'Gamma E Mixed Tocopherols contains gamma tocopherol, a critically important form of vitamin E not found in traditional vitamin E supplements which rely on alpha-tocopherol. Tocopherols belong to the vitamin E family and are antioxidants that are inhibiting free radicals in the human body, thereby countering the aging process, and protecting the cells.', 'assets/images/products/vitamins/VITAMINS-1012.png',true, 100, 25.90, 1, NOW());
35
36INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1013', 'Liposomal Methyl B-Complex', 'B-vitamins play an essential role in many metabolic reactions such as the release of energy from carbohydrates, fat, and protein. A deficiency of one B-vitamin can affect optimal functioning of organ systems throughout the body.', 'assets/images/products/vitamins/VITAMINS-1013.png',true, 100, 38.38, 1, NOW());
37
38INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1014', 'Once-Daily Health Booster', 'Use Once-Daily Health Booster to provide additional nutrient support for your eyes, cardiovascular system, bones, and more. Once-Daily Health Booster also contains unique antioxidants which can help fight free radicals protect DNA and thereby fight the natural ageing process.', 'assets/images/products/vitamins/VITAMINS-1014.png',true, 100, 54.50, 1, NOW());
39
40INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1015', 'Buffered Vitamin C', 'Buffered Vitamin C powder contains essential Vitamin C which can help reduce oxidative stress, support collagen formation and support the immune system, while it simultaneously brings essential minerals calcium, magnesium, zinc and potassium into the mix.', 'assets/images/products/vitamins/VITAMINS-1015.png',true, 100, 28.34, 1, NOW());
41
42INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1016', 'Vitamin B3 Niacin', 'Without proper transformation of food into energy, cells throughout the body cannot function correctly. Securing normal conversion of carbohydrates, fats, and protein into energy for the cells should be a priority for a healthily functioning body. Sustaining adequate vitamin B3 levels is crucial to the body at a very basic level because vitamin B3 helps convert food into energy.', 'assets/images/products/vitamins/VITAMINS-1016.png',true, 100, 18.34, 1, NOW());
43
44INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1017', 'No Flush Niacin', 'Niacin is a form of B vitamin. No-Flush Niacin contains a special type of niacin, inositol hexanicotinate, which is hydrolysed in the body to free niacin and inositol. Its unique properties allow for true niacin activity without the characteristic niacin flush that is unacceptable to many people.', 'assets/images/products/vitamins/VITAMINS-1017.png',true, 100, 19.22, 1, NOW());
45
46INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1018', 'Biotin', 'Biotin is a member of the water-soluble B-complex family, normally only required in minute amounts. Biotin is used as a cofactor of enzymes involved in fatty acid metabolism, gluconeogenesis, and amino acid catabolism, and is essential in maintaining internal balance.', 'assets/images/products/vitamins/VITAMINS-1018.png',true, 100, 7.59, 1, NOW());
47
48INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1019', 'Super Vitamin E', 'There was a long standing debate as to whether natural or synthetic vitamin E is better. For most vitamins, there is no difference between natural and synthetic. With vitamin E, however, the natural form has proven superior. Natural vitamin E is distributed through the body much better than the synthetic form. The reason is that specific carrier proteins in the liver selectively bind to natural vitamin E and transport it through the blood to cells throughout the body.', 'assets/images/products/vitamins/VITAMINS-1019.png',true, 100, 28.59, 1, NOW());
49
50INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1020', 'Pantothenic Acid', 'There was a long standing debate as to whether natural or synthetic vitamin E is better. For most vitamins, there is no difference between natural and synthetic. With vitamin E, however, the natural form has proven superior. Natural vitamin E is distributed through the body much better than the synthetic form. The reason is that specific carrier proteins in the liver selectively bind to natural vitamin E and transport it through the blood to cells throughout the body.', 'assets/images/products/vitamins/VITAMINS-1020.png',true, 100, 16.59, 1, NOW());
51
52INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1021', 'Vitamin C + Elderberry', 'Vitamin C + Elderberry is a potent combination of vitamin C and black elderberry, designed to support immune defenses throughout the year to help get you over unexpected health challenges.', 'assets/images/products/vitamins/VITAMINS-1021.png',true, 100, 18.56, 1, NOW());
53
54INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('VITAMINS-1022', 'Black Elderberry + Vitamin C', 'This formula combines standardized black elderberry extract, which has been shown in clinical and preclinical research to support immune health, with the tried-and-true immune support benefits of vitamin C. Vitamin C + Elderberry is a potent combination of vitamin C and black elderberry, designed to support immune defenses throughout the year to help get you over unexpected health challenges.', 'assets/images/products/vitamins/VITAMINS-1022.png',true, 100, 24.56, 1, NOW());
55
56
57---- Products with category 2
58
59INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1000', 'Carnosine', 'Carnosine is a natural antioxidant found in your body, as well as available through food. It is made of two amino acids, beta-alanine and L-histidine. Long-lived cells such as nerve cells (neurons) and muscle cells (myocytes) contain high levels of carnosine. The carnosine found in the muscle cells seems to assist in extending life-span in animals. Along with its antioxidant properties, carnosine has been shown to act as an anti-glycating agent.', 'assets/images/products/antiaging/ANTIAGING-1000.png', true, 100, 36.40, 2, NOW());
60
61INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1001', 'NAD Cell Regenerator', 'NAD+ Cell Regenerator promote NAD+ levels in aging cells, thereby contributing to maintaining vitality and healthy energy levels. It fights fatigue, supports youthful cell methabolism and contributes to maintaining vitality.', 'assets/images/products/antiaging/ANTIAGING-1001.png', true, 100, 44.69, 2, NOW());
62
63INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1002', 'Neuro-Mag Magnesium Threonate', 'Neuro-Mag Magnesium Threonate supports healthy memory and cognition by optimizing magnesium levels in the brain. Because of its superior absorption into the bloodstream and nervous system, Neuro-Mag provides the ideal form of magnesium for enhanced memory and cognitive function. Magnesium is required for more than 300 biochemical reactions and 600 enzymatic reactions in the body. Furthermore, magnesium is also needed to support cardiovascular, bone health, energy metabolism, glucose metabolism, mood, sleep and vitamin D status.', 'assets/images/products/antiaging/ANTIAGING-1002.png', true, 100, 32.37, 2, NOW());
64
65INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1003', 'NAD+ Cell Regenerator', 'NAD+ Cell RegeneratoR can promote systemic youthful functions by providing nicotinamide riboside — a patented compound which plays a role in reversing age-related decline of NAD+ levels. Found in every cell in the body, this enzyme plays a role in helping to maintain healthy cell metabolism. With the highly innovative NAD+ Cell Regenerator, there is finally a product designed to promote higher NAD+enzyme levels for refreshed vitality.', 'assets/images/products/antiaging/ANTIAGING-1003.png', true, 100, 20.84, 2, NOW());
66
67INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1004', 'Super Ubiquinol CoQ10', 'Ubiquinol CoQ10 and Shilajit can with its enhanced absorption formula support mitochondria for cellular energy production and promote heart-, brain-, and kidney-health', 'assets/images/products/antiaging/ANTIAGING-1004.png', true, 100, 47.84, 2, NOW());
68
69INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1005', 'Optimized Resveratrol', 'Life Extension has identified certain compounds that mimic the benefits of a calorie restricted diet, a process that slows down aspects related to ageing. These compounds include trans-resveratrol (which researchers contend is the most active constituent), quercetin, whole grape extract, but also certain compounds found in berries, like trans -pterostilbene and now fisetin.', 'assets/images/products/antiaging/ANTIAGING-1005.png', true, 100, 40.96, 2, NOW());
70
71INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1006', 'Liposomal GABA', 'GABA (Gamma-aminobutyric acid) is an amino acid derivative produced in the human body that functions as a neurotransmitter in the central nervous system. Neurotransmitters are chemical messengers that carry messages between cells.', 'assets/images/products/antiaging/ANTIAGING-1006.png', true, 100, 40.96, 2, NOW());
72
73INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1007', 'Optimized Ashwagandha Extract', 'Ashwagandha can counter stress and has neuroprotective health benefits. Moreover, Ashwagandha is an antioxidant that can seek out and annihilate free radicals, that cause oxidative stress and play a role in premature aging.', 'assets/images/products/antiaging/ANTIAGING-1007.png', true, 100, 11.04, 2, NOW());
74
75INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1008', 'Astaxanthin with Phospholipids', 'Use Astaxanthin with Phospholipids to get most of the health benefits that astaxanthin can give you, from joint support to immune, brain, cardiovascular, mitochondrial and eye health support - Astaxanthin can support it all!', 'assets/images/products/antiaging/ANTIAGING-1008.png', true, 100, 14.04, 2, NOW());
76
77INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1009', 'Super Omega-3 Plus', 'Omega-3 acids and DHA in Super Omega-3 Plus EPA DHA with Sesame Lignans, Olive Extract, Krill & Astaxanthin can help support your cardiovascular system and brain, enhance mitochondrial function, and help maintain adequate levels of important fatty acids.', 'assets/images/products/antiaging/ANTIAGING-1009.png', true, 100, 37.24, 2, NOW());
78
79INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1010', 'Super Ubiquinol CoQ10', 'Mitochondria are the energy factories of the human cells and coenzyme Q10 (CoQ10) is an essential component for healthy cell function. CoQ10 is required to extract energy from fats and sugars. However, the production of CoQ10 in our body declines as we age and we need to supplement the daily need. That is because CoQ10 in sufficient quantities helps the cells work.', 'assets/images/products/antiaging/ANTIAGING-1010.png', true, 100, 38.31, 2, NOW());
80
81INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1011', 'Super R Lipoic Acid', 'Super R-Lipoic Acid is truly unique antioxidant that not only protects the cells against free radicals but also supports energy production in the cells at the same time. This means that Super R-Lipoic Acid both allows cells to produce energy and function under better-than-normal conditions, providing your body with the energy it needs while protecting the cells for better cell work.', 'assets/images/products/antiaging/ANTIAGING-1011.png', true, 100, 43.60, 2, NOW());
82
83INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1012', 'PQQ Caps', 'Mitochondria are the energy factories of the human cells that lie behind every physiological process in your body. Their function is so crucial that a growing number of scientists believe mitochondrial longevity may determine overall health in humans. Diets based on low calories and exercise were until recently the only way to proliferate these power producers. PQQ is the alternative to these exhaustive solutions.', 'assets/images/products/antiaging/ANTIAGING-1012.png', true, 100, 31.60, 2, NOW());
84
85INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1013', 'Super Omega-3', 'Super Omega-3 EPA/DHA with Sesame Lignans & Olive Extract contains carefully extracted healthy omega-3 oil from one natural source and can support cardiovascular health, anti-aging, and cognitive health in your body.', 'assets/images/products/antiaging/ANTIAGING-1013.png', true, 100, 32.26, 2, NOW());
86
87INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1014', 'Extend-Release Magnesium', 'Extend-Release Magnesium supplies the body with magnesium for longer than ordinary magnesium, supporting cardiovascular- and bone health.', 'assets/images/products/antiaging/ANTIAGING-1014.png', true, 100, 13.15, 2, NOW());
88
89INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1015', 'Cognitex Elite', 'Cognitive decline can be a natural consequence of ageing and can impact what you understand, process and remember. Thats why Life Extension has now developed Cognitex Elite; a very advanced brain support formula. This fantastic formula contains a wealth of brain-friendly nutrients that your brain needs daily to support and maintain cognitive function and health.', 'assets/images/products/antiaging/ANTIAGING-1015.png', true, 100, 13.15, 2, NOW());
90
91INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1016', 'Bio Quercetin', 'Quercetin is a highly versatile bio-flavonoid, which has a long tradition of being used for relieving the effects of seasonal immune challenges. It supports a wide variety of health aspects, including cardiovascular and endothelial health and it also offers support for the immune system and the inflammatory response.', 'assets/images/products/antiaging/ANTIAGING-1016.png', true, 100, 13.15, 2, NOW());
92
93INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1017', 'Super Omega-3 Fish Oil', 'Super Omega-3 Fish Oil EPA DHA with Sesame Lignans & Olive Extract contains carefully extracted healthy omega-3 oil from one natural source and can support cardiovascular health, anti-aging, and cognitive health, in your body.', 'assets/images/products/antiaging/ANTIAGING-1017.png', true, 100, 30.15, 2, NOW());
94
95INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1018', 'Skin Restoring Ceramides', 'Ceramides play a central role in preserving healthy-looking skin. They are an important component of the skins membrane, where they provide protection and lock in moisture. The problem is that our bodys production of ceramides declines with age. The ceramides that young skin naturally produces to retain its supple appearance are identical to those present in wheat.', 'assets/images/products/antiaging/ANTIAGING-1018.png', true, 100, 21.49, 2, NOW());
96
97INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1019', 'Optimized Quercetin', 'Quercetin is a dietary flavonoid that supports the healthy function of cells. Studies have shown that it helps to reduce inflammation and supports immune response during seasonal changes. This compound demonstrated capability to support a healthy cardiovascular system and healthy blood glucose levels. Optimised Quercetin is a proprietary formulation that sets the gold standard for high-quality quercetin derived from a food-source blend.', 'assets/images/products/antiaging/ANTIAGING-1019.png', true, 100, 22.25, 2, NOW());
98
99INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIAGING-1020', 'Taurine', 'Taurine supports the cardiovascular- and nervous system, and can also promote liver and cognitive health.', 'assets/images/products/antiaging/ANTIAGING-1020.png', true, 100, 13.25, 2, NOW());
100
101--- Products with category 3
102
103INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1000', 'Curcumin Elite Turmeric Extract', 'Curcumin Elite Turmeric Extract is formulated in a way that delivers 45.5 times more bioavailable free curcuminoids as well as 270 times better absorption of curcuminoids than standard curcumin. The much higher bioavailability and absorption rates can enhance the many health benefits of curcumin supplementation.', 'assets/images/products/antioxidants/ANTIOXIDANT-1000.png', true, 100, 25.89, 3, NOW());
104
105INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1001', 'Optimized Ashwagandha Extract', 'Ashwagandha can counter stress and has neuroprotective health benefits. Moreover, Ashwagandha is an antioxidant that can seek out and annihilate free radicals, that cause oxidative stress and play a role in premature aging.', 'assets/images/products/antioxidants/ANTIOXIDANT-1001.png', true, 100, 11.04, 3, NOW());
106
107INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1002', 'Cognitex Elite', 'Cognitive decline can be a natural consequence of ageing and can impact what you understand, process and remember. Thats why Life Extension has now developed Cognitex Elite - a very advanced brain support formula. This fantastic formula contains a wealth of brain-friendly nutrients that your brain needs daily to support and maintain cognitive function and health.', 'assets/images/products/antioxidants/ANTIOXIDANT-1002.png', true, 100, 52.32, 3, NOW());
108
109INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1003', 'Super Bio-Curcumin Turmeric Extract', 'Use the curcumin extract in Super Bio-Curcumin to help support your immune and inflammatory response regulation and benefit from the many other health benefits that extracts from the superfood turmeric can bring to your body. Curcumin extracts can inhibit inflammatory factors in the body, support your digestive function, and encourage healthy cell division. It can also contribute to maintaining normal, healthy brain, platelet and pancreatic function.','assets/images/products/antioxidants/ANTIOXIDANT-1003.png', true, 100, 31.83, 3, NOW());
110
111INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1004', 'Mega Green Tea Extract', 'Green tea is loaded with health-promoting polyphenols that form a powerful antioxidant. This antioxidant has been subjected to extensive scientific research, found to be much more potent than vitamins C and E. One cup of green tea provides roughly 200 mg of polyphenols and has antioxidant effects that are greater than a serving of broccoli, spinach or carrots.','assets/images/products/antioxidants/ANTIOXIDANT-1004.png', true, 100, 24.94, 3, NOW());
112
113INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1005', 'Rhodiola Extract', 'As people age the cells produce less energy. Scientists believe it to be a critical factor behind many health problems. Rhodiola has demonstrated a remarkable ability to promote the production of energy and fight fatigue.','assets/images/products/antioxidants/ANTIOXIDANT-1005.png', true, 100, 15.34, 3, NOW());
114
115INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1006', 'Triple Action Thyroid', 'The thyroid gland acts as the bodys thermostat and is one of the major regulators of metabolism. The two main hormones it produces are T3 and T4, which travel through the bloodstream to reach almost every cell in the body. Optimal thyroid function can help improve energy levels, metabolism, healthy weight management, motivation and concentration.','assets/images/products/antioxidants/ANTIOXIDANT-1006.png', true, 100, 36.41, 3, NOW());
116
117INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1007', 'Advanced Milk Thistle', 'Advanced Milk Thistle uses the Advanced Phospholipid Delivery system to deliver nutrients from extracts of milk thistle to the liver for supporting this organ. Milk thistle promotes normal liver function.','assets/images/products/antioxidants/ANTIOXIDANT-1007.png', true, 100, 42.51, 3, NOW());
118
119INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1008', 'Estrogen for Women', 'Estrogen for Women has a specially designed formula which includes a blend of a patented hops extract as well as extracts from licorice, broccoli, the Dong Quai plant, and chaste berry.','assets/images/products/antioxidants/ANTIOXIDANT-1008.png', true, 100, 28.34, 3, NOW());
120
121INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1009', 'Life Extension Mix', 'The many nutrients in Life Extension Mix Capsules can give you full daily coverage of the nutrients that your body requires to function properly every day.','assets/images/products/antioxidants/ANTIOXIDANT-1009.png', true, 100, 73.03, 3, NOW());
122
123INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1010', 'Ginkgo Biloba Extract', 'Ginkgo biloba is one of the oldest trees known, used to support health for nearly 2,800 years. Ginkgo has been found to support healthy circulation and help maintain the normal function and tone of blood vessels.','assets/images/products/antioxidants/ANTIOXIDANT-1010.png', true, 100, 44.48, 3, NOW());
124
125INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1011', 'PalmettoGuard', 'PalmettoGuard Saw Palmetto with Beta-Sitosterol helps regulate a normal inflammatory response in the prostate gland, plays a role in countering age-related prostate issues and supports normal urinary function. Berry extracts from Saw Palmetto can support a healthy prostate function in the aging male body.','assets/images/products/antioxidants/ANTIOXIDANT-1011.png', true, 100, 15.16, 3, NOW());
126
127INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1012', 'Reishi Extract Mushroom', 'Reishi mushroom has been traditionally used to boost immune system vitality. Its broad-spectrum benefits have been demonstrated in thousands of studies. Evidence demonstrates that Reishi nutrients enhance the protective activity of many crucial immune factors.','assets/images/products/antioxidants/ANTIOXIDANT-1012.png', true, 100, 30.33, 3, NOW());
128
129INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1013', 'Venotone', 'Venotone is an extract of horse chestnut, which has been standardised to ensure the highest quality, consistency and biological activity. Horse chestnut extract supports a healthy fluid balance, helps the veins and protects the other blood vessels as well. Besides it has also antioxidant properties.','assets/images/products/antioxidants/ANTIOXIDANT-1013.png', true, 100, 19.16, 3, NOW());
130
131INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1014', 'Eye Pressure Support', 'As you grow older, the fluid contained within the chambers of your eyes may gradually and imperceptibly increase. This has been shown to contribute to many unwanted age-related vision issues. Researchers have found that a proprietary blend widely available in Europe, called Mirtogenol, may effectively support eye pressure already within healthy range, as we age.','assets/images/products/antioxidants/ANTIOXIDANT-1014.png', true, 100, 19.16, 3, NOW());
132
133INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1015', 'Cran-Max', 'Many published studies indicate that cranberry polyphenols may help to support a healthy urinary tract. Cranberries have been known for this benefit for decades. Clinical research demonstrates that cranberries proanthocyanidins are powerful antioxidants.','assets/images/products/antioxidants/ANTIOXIDANT-1015.png', true, 100, 15.92, 3, NOW());
134
135INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1016', 'Pomegranate Complete', 'Few nutritional sources have gained as much scientific validation as pomegranate. The surprising number of benefits attributable to pomegranate include everything from supporting healthy prostate and breast tissue to promoting a healthy heart, joints, liver and kidneys.','assets/images/products/antioxidants/ANTIOXIDANT-1016.png', true, 100, 15.92, 3, NOW());
136
137INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1017', 'Curcumin Elite Turmeric Extract', 'Curcumin Elite Turmeric Extract is formulated in a way that delivers 45.5 times more bioavailable free curcuminoids as well as 270 times better absorption of curcuminoids than standard curcumin. The much higher bioavailability and absorption rates can enhance the many health benefits of curcumin supplementation.','assets/images/products/antioxidants/ANTIOXIDANT-1017.png', true, 100, 18.52, 3, NOW());
138
139INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1018', 'Blueberry Extract with Pomegranate', 'Blueberries seem to have the strongest antioxidant ability among fruit. Combating oxidative stress and inflammation, they improve cognitive capacity and help to maintain healthy blood flow and vascular function. These fruit are known for two of its most active compounds. One of them, anthocyanins, is considered one of nature’s most potent antioxidants.','assets/images/products/antioxidants/ANTIOXIDANT-1018.png', true, 100, 26.69, 3, NOW());
140
141INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('ANTIOXIDANT-1019', 'Enhanced Sleep without Melatonin', 'Bioactive Milk Peptides and Sendara found in Enhanced Sleep without Melatonin can support normal sleep patterns, contribute to reduce stress and maintaining a normal skin complexion.','assets/images/products/antioxidants/ANTIOXIDANT-1019.png', true, 100, 19.18, 3, NOW());
142
143---- Products with category 4
144
145INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1000', 'FLORASSIST Balance', 'Probiotics are mostly used for intestinal health, but their benefits extend beyond that. Science has proven that imbalance of good-to-bad bacteria can affect all your body. FLORASSIST is a new method to support a proper balance of intestinal flora.', 'assets/images/products/digestion/DIGESTION-1000.png', true, 100, 16.99, 4, NOW());
146
147INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1001', 'FLORASSIST Oral Hygiene', 'Probiotics Lactobacillus plantarum L-137 bacteria and S. salivarius found in FLORASSIST Oral Hygiene can help balance your oral environment, promote protection of your gums and teeth and support your overall oral health and inhibition of oral inflammation.', 'assets/images/products/digestion/DIGESTION-1001.png', true, 100, 15.17, 4, NOW());
148
149INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1002', 'FLORASSIST Mood Improve', 'The ingredients in FLORASSIST Mood Improve promote balanced mood and brain health with saffron and specific probiotics, support healthy communication between the gut and the brain, promote reduction in perceived stress and emotional well-being.', 'assets/images/products/digestion/DIGESTION-1002.png', true, 100, 28.87, 4, NOW());
150
151INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1003', 'FLORASSIST Throat Health', 'FLORASSIST Throat Health is an oral probiotic that provides novel friendly bacteria to populate the throat and control the growth of harmful, unwanted bacteria.', 'assets/images/products/digestion/DIGESTION-1003.png', true, 100, 28.87, 4, NOW());
152
153INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1004', 'FLORASSIST Prebiotic', 'Probiotics are good bacteria for your GI tract and need fuel (prebiotics) to work optimally. FLORASSIST Prebiotic Chewable tablets contain PreticX prebiotic fibre. PreticX contains around 70% xylooligosaccharides that can stimulate the growth of a type of beneficial bacteria in the gut called bifidobacteria.', 'assets/images/products/digestion/DIGESTION-1004.png', true, 100, 20.22, 4, NOW());
154
155INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1005', 'FLORASSIST Nasal', 'FLORASSIST Immune and Nasal contains a unique formula containing two strains of probiotics that can help calm immune system reactions to seasonal environmental changes, and help you maintain eye and skin comfort, as well as a comfortable airflow through your nose.', 'assets/images/products/digestion/DIGESTION-1005.png', true, 100, 20.22, 4, NOW());
156
157INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1006', 'Theralac', 'Theralac is a product that used breakthrough technology, guaranteeing 100% live delivery of the probiotics into the intestinal tract. Once in the bowel, Theralac action are stimulated by LactoStim, a patented prebiotic that feeds probiotics. The intestinal surface is, then, rapidly colonised and bowel movements quickly normalise.', 'assets/images/products/digestion/DIGESTION-1006.png', true, 100, 48.48, 4, NOW());
158
159INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1007', 'Gastro-Ease', 'The stomach contains acids to help break down the foods we eat. These acids would damage the delicate stomach wall, if not for a protective coating of mucous. Gastro-Ease contains a specialized form of zinc plus a patented probiotic strain to support this protective mucous layer.', 'assets/images/products/digestion/DIGESTION-1007.png', true, 100, 48.48, 4, NOW());
160
161INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1008', 'FLORASSIST Heart Health', 'Research is demonstrating how important probiotics are to general health. Beyond improving digestive health, these good bacteria provide a broad spectrum of benefits throughout the body.', 'assets/images/products/digestion/DIGESTION-1008.png', true, 100, 32.35, 4, NOW());
162
163INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1009', 'Winter Immune Support', 'The stomach contains acids to help break down the foods we eat. These acids would damage the delicate stomach wall, if not for a protective coating of mucous. Winter Immune Support contains a specialized form of zinc plus a patented probiotic strain to support this protective mucous layer.', 'assets/images/products/digestion/DIGESTION-1009.png', true, 100, 40.99, 4, NOW());
164
165INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1010', 'TruFlora', 'TruFlora combines powerful probiotic strains and fiber-digesting enzymes in a formulation that can be used alone or rotated with other probiotics to enhance overall probiotic effectiveness.', 'assets/images/products/digestion/DIGESTION-1010.png', true, 100, 40.99, 4, NOW());
166
167INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1011', 'TruFiber', 'TruFiber is a formulation for stimulating probiotics to restore regularity in the form of tasteless, white powder that mixes fast and clears with no thickening. One serving of this product provides slightly more than 14 percent of the recommended daily dose of fibre.', 'assets/images/products/digestion/DIGESTION-1011.png', true, 100, 40.99, 4, NOW());
168
169INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1012', 'Nutra-Go Milkshake Vanilla', 'An ideal on-the-go shake for those looking to increase their daily protein intake and looking for a great taste.', 'assets/images/products/digestion/DIGESTION-1012.png', true, 100, 5.59, 4, NOW());
170
171INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1013', 'Nutra-Go Milkshake Strawberry', 'An ideal on-the-go shake for those looking to increase their daily protein intake and looking for a great taste.', 'assets/images/products/digestion/DIGESTION-1013.png', true, 100, 5.59, 4, NOW());
172
173INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1014', 'Nutramino XL Protein Shake', 'For you, if you are looking for a flavored boost that will support your muscle and boost your recovery from high-intensity training.', 'assets/images/products/digestion/DIGESTION-1014.png', true, 100, 3.89, 4, NOW());
174
175INSERT INTO product (sku, name, description, image_url, active, units_in_stock, unit_price, category_id,date_created) VALUES ('DIGESTION-1015', 'Nutra-Go Milkshake', 'For you, if you are looking for a flavored boost that will support your muscle and boost your recovery from high-intensity training.', 'assets/images/products/digestion/DIGESTION-1015.png', true, 100, 3.89, 4, NOW());
176
177
178
179INSERT INTO address (street, city, country, zip_code) values ('Egejska Makedonija br.20', 'Kumanovo', 'Makedonija', '1300');
180
181INSERT INTO address (street, city, country, zip_code) values ('Boro Prcan', 'Kumanovo', 'Makedonija', '1300');
182
183INSERT INTO address (street, city, country, zip_code) values ('3ta MUB', 'Kumanovo', 'Makedonija', '1300');
184
185
186INSERT INTO customer (first_name, last_name, email) values ('Bisera', 'Peshevska', 'pesevskab1997@gmail.com');
187
188INSERT INTO customer (first_name, last_name, email) values ('Marta', 'Peshevska', 'pesevskamarta@gmail.com');
189
190INSERT INTO customer (first_name, last_name, email) values ('Jovana', 'Peshevska', 'pesevskaj@gmail.com');
191
192
193
194INSERT INTO orders(order_tracking_number, total_price, total_quantity, customer_id, billing_address_id, shipping_address_id) values ('df4c164e-ab1c-4446-8f8a-adfdfe11272b', 44.93, 2, 1, 1, 1);
195
196INSERT INTO orders(order_tracking_number, total_price, total_quantity, customer_id, billing_address_id, shipping_address_id) values ('6d9655bd-9a66-412f-b886-07343a9944f2', 60.53, 8, 1, 1, 1);
197
198INSERT INTO orders(order_tracking_number, total_price, total_quantity, customer_id, billing_address_id, shipping_address_id) values ('6f9cbf1f-b8cc-4d2c-8374-083c7af58fd9', 136.47, 3, 2, 2, 2);
199
200
201INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 1, 28.34, 1, 16 );
202
203INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 1, 16.59, 1, 21 );
204
205INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 1, 5.59, 2, 77);
206
207INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 1, 29.9, 2, 3 );
208
209INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 1, 5.59, 2, 78 );
210
211INSERT into order_item (image_url, quantity, unit_price, order_id, product_id) values ('/images/image', 5, 3.89, 2, 80 );
212
213