-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscript.sql
115 lines (100 loc) · 23 KB
/
script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema subscribe
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema subscribe
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `subscribe` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ;
USE `subscribe` ;
-- -----------------------------------------------------
-- Table `subscribe`.`posts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subscribe`.`posts` (
`post_id` INT NOT NULL AUTO_INCREMENT,
`post_cont` TEXT NULL DEFAULT NULL,
`post_title` VARCHAR(255) NULL DEFAULT NULL,
`thumbURL` VARCHAR(2048) NULL DEFAULT NULL,
`date_time` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`post_id`))
ENGINE = InnoDB
AUTO_INCREMENT = 14
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
INSERT INTO `posts` VALUES (1,'<h1>How to make Oreo recipe?</h1><div><br></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709462813221.jpg\" data-filename=\"IMG_4013-scaled.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Ingredients:</h2><div><br></div><ul><li>4-6 Oreo cookies</li><li>1-2 cups of milk</li><li>2-3 scoops of vanilla ice cream</li></ul><div><br></div><h2>Instructions:</h2><div><br></div><ul><li><div style=\"background-color: yellow; display: inline;\">Prepare the Oreos:</div> Open the Oreo cookies and separate the cream filling from the cookies. You can do this by gently twisting them apart. Set the cream aside, as you\'ll only be using the cookies for the shake.</li><li><div style=\"background-color: yellow; display: inline;\">Crush the Oreos: </div>Place the Oreo cookies into a blender or food processor. Blend them until they are finely crushed. You want them to be broken down into small pieces.<br></li><li><div style=\"background-color: yellow; display: inline;\">Add Milk:</div> Pour 1-2 cups of milk into the blender, depending on how thick or thin you want your shake to be. Start with 1 cup and add more if needed.<br></li><li><div style=\"background-color: yellow; display: inline;\">Add Ice Cream:</div> Scoop 2-3 generous scoops of vanilla ice cream into the blender with the crushed Oreos and milk. The ice cream adds creaminess and sweetness to the shake.<br></li><li><div style=\"background-color: yellow; display: inline;\">Blend:</div> Blend all the ingredients together until smooth and creamy. You may need to stop and scrape down the sides of the blender to ensure everything is mixed evenly.<br></li><li><div style=\"background-color: yellow; display: inline;\">Serve:</div> Once the shake reaches your desired consistency, pour it into a glass. You can garnish the top with a dollop of the reserved Oreo cream filling or with crushed Oreo cookie crumbs for extra flair.<br></li><li><div style=\"background-color: yellow; display: inline;\">Enjoy:</div> Grab a straw and enjoy your delicious homemade Oreo shake! It\'s perfect for a sweet treat or indulgent dessert.<br></li></ul><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/uZHY09ieSNw\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"></div>','Oreo Shake recipe','http://localhost:8080/image-1709462813221.jpg','2024-03-03 10:46:53'),(2,'<h1>Make cool summer lassi</h1><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709463191388.jpg\" data-filename=\"rose_lassi_1-1160x1536.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Ingredients:</h2><ul><li>1 cup plain yogurt </li><li>1/2 cup chilled water<br></li><li>2-3 tablespoons sugar (adjust to taste)<br></li><li>A pinch of salt<br></li><li>A pinch of ground cardamom (optional)<br></li><li>Crushed ice (optional)<br></li><li>Fresh mint leaves or crushed pistachios for garnish (optional)</li></ul><h2>Instructions:</h2><ul><li>Prepare Ingredients: Gather all the ingredients and ensure the yogurt is chilled. </li><li>Combine Ingredients: In a blender, add the plain yogurt, chilled water, sugar, a pinch of salt, and ground cardamom (if using).<br></li><li>Blend: Blend all the ingredients together until smooth and frothy. If you prefer a thicker lassi, you can reduce the amount of water or add more yogurt.<br></li><li>Taste and Adjust: Taste the lassi and adjust the sweetness according to your preference by adding more sugar if needed. You can also adjust the consistency by adding more water if it\'s too thick.<br></li><li>Serve: Pour the lassi into glasses. If desired, add a few ice cubes to each glass to make it extra refreshing.<br></li><li>Garnish: Garnish each glass with fresh mint leaves or crushed pistachios for a decorative touch and added flavor.<br></li><li>Enjoy: Serve the lassi immediately while it\'s cold and refreshing. Enjoy its creamy texture and sweet, tangy flavor as a delightful beverage or accompaniment to your favorite Indian meal.<br></li></ul><div><br></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/SlqpgRCdSyo\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"><div style=\"background-color: yellow; display: inline;\"><div><div style=\"display: inline;\"><div style=\"background-color: yellow; display: inline;\"><br></div></div></div>Lassis are versatile, so feel free to experiment with different flavors such as mango, strawberry, or rose by adding fresh fruit or flavored syrups during blending.</div></div><div style=\"display: inline;\"></div>','Summer Lassi','http://localhost:8080/image-1709463191388.jpg','2024-03-03 10:53:11'),(3,'<h1>Indian Chicken curry recipe</h1><div><br></div><h2>Ingredients:</h2><ul><li>500g boneless chicken </li><li>2 onions finely chopped </li><li>2 tomatoes chopped </li><li>2 tbsp ginger-garlic paste </li><li>1 tbsp vegetable oil or ghee </li><li>1 tsp cumin seeds </li><li>1 tsp turmeric powder </li><li>1 tsp red chili powder </li><li>1 tsp coriander powder </li><li>1 tsp garam masala </li><li>salt to taste</li><li> fresh coriander leaves for garnish (optional)</li></ul><div><br></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709463815205.jpg\" data-filename=\"chicken-chettinad-curry-recipes.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instructions:</h2><ul><li>Marinate chicken with 1 tbsp ginger-garlic paste, 1/2 tsp turmeric, and salt sauté onions.</li><li>Add remaining ginger-garlic paste cumin seeds then tomatoes cook till soft.</li><li>Add spices cook for 2 mins add chicken cook till done adjust seasoning garnish with coriander.</li></ul><div><br></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/jwyge5daKUQ\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"></div>','Indian chicken curry','http://localhost:8080/image-1709463815205.jpg','2024-03-03 11:03:35'),(4,'<h1>Yummy YUMMY...</h1><div><br></div><h2>Ingredients required:</h2><ul><li>Sugar, Hydrogenated Vegetable Fat</li><li> Milk Solids</li><li> Cocoa Solids</li><li>Emulsifiers</li><li>Stabilizer</li><li>Maltodextrin</li><li>Glazing Agent </li><li>Colours</li></ul><h2>Ok now let\'s watch the process to make these yummy dairy milk shots...</h2><div><br></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/iqrEXDQSYBY\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\">Ok guys....enjoy the taste of these shots by preparing in your home...btw it\'s one of my fav chocolates..hope it\'ll be ur fav too boii guyss?</div><div><br><h3>Wait a min!! Do you wanna watch the image of this chocolate?? Ok lemme show you...</h3></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709491070402.jpg\" data-filename=\"81mNZ1rtW+L._AC_UF1000,1000_QL80_.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div>','Dairy Milk Shots!!','http://localhost:8080/image-1709491070402.jpg','2024-03-03 18:37:50'),(5,'<h1>Kala jamun recipe</h1><h2>Ingredients:</h2><ul><li>1 cup milk powder</li><li>1/4 cup all purpose flour</li><li>1/4 tsp baking soda</li><li>2 tbsp ghee</li><li>1/4 cup milk</li><li>Oil for frying</li><li>Sugar syrup</li></ul><div><br></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709982112388.jpeg\" data-filename=\"IMG_6157.jpeg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instructions:</h2><ul><li>Mix ingredients to make dough balls.</li><li>Fry until golden brown.</li><li>Boil sugar, water, spices for syrup.</li><li>Soak fried balls in syrup.</li><li>Serve and Enjoy !!</li></ul><div><br></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/mXjSAfmChVQ\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"><div><div style=\"display: inline;\"><br></div></div>Thanks.</div>','Kala jamun','http://localhost:8080/image-1709982112388.jpeg','2024-03-09 11:01:52'),(6,'<h1>Chicken Tangdi Kabab</h1><div><br></div><h2>Ingredients:</h2><ul><li>6-8 chicken drumsticks (with skin on)</li><li>1 cup yogurt (preferably Greek yogurt)</li><li>2 tablespoons ginger-garlic paste</li><li>2 tablespoons lemon juice</li><li>1 tablespoon red chili powder</li><li>1teaspoon turmeric powder</li><li>1 teaspoon ground cumin</li><li>1 teaspoon ground coriander</li><li>1 teaspoon garam masala</li><li>Salt to taste</li><li>2 tablespoons vegetable oil</li><li>Fresh cilantro leaves (for garnish)</li><li>Lemon wedges (for serving)</li></ul><div><br></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709993125631.jpg\" data-filename=\"Chicken-Tangdi-Kabab_2-scaled.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instructions:</h2><ul><li>Begin by cleaning the chicken drumsticks. Make 2-3 deep cuts on each drumstick. This will help the marinade penetrate better and ensure even cooking.</li><li>In a large mixing bowl, combine yogurt, ginger-garlic paste, lemon juice, red chili powder, turmeric powder, ground cumin, ground coriander, garam masala, salt, and vegetable oil. Mix well to form a smooth marinade.</li><li>Add the chicken drumsticks to the marinade, making sure they are well coated. Cover the bowl and refrigerate for at least 2 hours, or preferably overnight to allow the flavors to infuse.</li><li>Preheat your grill or oven to medium-high heat. If using a grill, grease the grates lightly to prevent sticking.</li><li>Remove the marinated chicken from the refrigerator and let it sit at room temperature for about 15-20 minutes.</li><li>Thread the chicken drumsticks onto skewers, shaking off any excess marinade.</li><li>Grill the chicken drumsticks for about 15-20 minutes, turning occasionally, until they are cooked through and charred on the outside. If using an oven, you can bake them at 400°F (200°C) for approximately 25-30 minutes, or until fully cooked.</li><li>Once the chicken is cooked through, remove it from the grill or oven and let it rest for a few minutes.</li><li>Garnish the Chicken Tangdi Kabab with fresh cilantro leaves and serve hot with lemon wedges on the side.</li></ul><div><br></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/1GI187w8DDA\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"></div><div><div style=\"display: inline;\"><div style=\"background-color: yellow; display: inline;\">Enjoy your delicious Chicken Tangdi Kabab as a starter or a main course dish with some mint chutney or yogurt dip!</div></div></div>','Chicken Tangdi Kabab','http://localhost:8080/image-1709993125631.jpg','2024-03-09 14:05:25'),(7,'<h1>Lemon Juice recipe</h1><div><br></div><h2>Ingredients:</h2><ul><li><li>2-3 large lemons</li><li>4-6 cups of water (adjust to taste)</li><li>Sugar or honey (optional)</li><li>Ice cubes (optional)</li><li>Mint leaves for garnish (optional)</li></li></ul><div class=\"img-container\"><img src=\"http://localhost:8080/image-1710249207933.jpg\" data-filename=\"lemon.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instructions:</h2><ul><li><li>Wash the lemons thoroughly under running water to remove any dirt or residue.</li><li>Roll each lemon on a hard surface while applying gentle pressure. This helps to soften the lemons and make them easier to juice.</li><li>Cut the lemons in half crosswise using a sharp knife.</li><li>Juice the lemons using a citrus juicer or a handheld lemon squeezer. You can also use a fork to press and twist the lemon halves to extract the juice.</li><li>Strain the lemon juice through a fine-mesh sieve to remove any seeds or pulp if desired.</li><li>Pour the freshly squeezed lemon juice into a pitcher or large jar.</li><li>Add 4-6 cups of cold water to dilute the lemon juice. You can adjust the amount of water based on your taste preferences for tartness.</li><li>Stir in sugar or honey to sweeten the lemon juice if desired. Start with 1/4 cup of sugar or honey and adjust to taste.</li><li>Add ice cubes to the pitcher to chill the lemon juice or refrigerate it for at least 30 minutes before serving.</li><li>Serve the lemon juice over ice in glasses garnished with fresh mint leaves for a refreshing touch.</li></li></ul><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/bFdAQruqAGg\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\">Enjoy your homemade lemon juice! Adjust the sweetness and tartness according to your preference by adding more sugar, honey, or lemon juice as needed.</div>','Lemon Juice','http://localhost:8080/image-1710249207933.jpg','2024-03-12 18:43:27'),(8,'<h1>Masala Dosa, a popular South Indian dish</h1><div><br></div><h2>Ingredients:</h2><ul><li><li>1 cup dosa rice (parboiled rice)</li><li>1/2 cup urad dal (black gram lentils)</li><li>1/4 cup chana dal (split chickpeas)</li><li>1/4 tsp fenugreek seeds (methi seeds)</li><li>Salt to taste</li><li>Oil or ghee for cooking</li></li></ul><h2>For the Potato Filling (Masala):</h2><ul><li><li>3-4 medium potatoes, boiled and mashed</li><li>1 onion, finely chopped</li><li>1-2 green chilies, finely chopped</li><li>1/2 inch ginger, grated</li><li>A handful of curry leaves</li><li>1/2 tsp mustard seeds</li><li>1/2 tsp cumin seeds</li><li>1/2 tsp turmeric powder</li><li>Salt to taste</li><li>Fresh coriander leaves for garnish</li><li>Lemon wedges (optional)<br></li></li></ul><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709996412595.jpg\" data-filename=\"image2.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instructions:</h2><ul><li><div style=\"background-color: yellow; display: inline;\">Prepare the Batter</div>:<div>Wash and soak dosa rice, urad dal, chana dal, and fenugreek seeds in water separately for 4-6 hours or overnight.</div><div>Drain the water and grind each ingredient separately to a smooth batter using a little water as needed.</div><div>Mix the ground rice and lentil batters together, add salt, and mix well. The batter should have a pouring consistency. Allow the batter to ferment for 8-10 hours or overnight.</div><div><br></div></li><li><div><div style=\"background-color: yellow; display: inline;\">Prepare the Potato Filling (Masala)</div>:</div><div>Heat oil in a pan and add mustard seeds. When they start to splutter, add cumin seeds and curry leaves.</div><div>Add chopped onions and green chilies, sauté until onions turn translucent.</div><div>Add grated ginger and turmeric powder, sauté for a minute.</div><div>Add mashed potatoes, salt, and mix well. Cook for 2-3 minutes until the flavors blend.</div><div>Garnish with chopped coriander leaves and keep the filling aside.</div><div><br></div></li><li><div><span style=\"color: var(--bs-body-color); font-size: var(--bs-body-font-size); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\"><div style=\"background-color: yellow; display: inline;\">Make Masala Dosa</div>:<br></span>Heat a non-stick dosa tawa (griddle) and lightly grease it with oil or ghee.</div><div>Pour a ladleful of dosa batter onto the center of the tawa and spread it in a circular motion to form a thin dosa.</div><div>Drizzle oil or ghee around the edges of the dosa and cook until the bottom side turns golden brown and crisp.</div><div>Place a spoonful of potato filling (masala) in the center of the dosa and fold it over.</div><div>Press gently and cook for another minute until the dosa is crisp and golden brown.</div><div>Repeat the process with the remaining batter and filling to make more dosas.</div><div><br></div></li><li><div><div><div style=\"background-color: yellow; display: inline;\">Serve</div>:</div><div>Serve hot Masala Dosas with coconut chutney, sambar, or a dollop of butter.</div><div>Optionally, serve with lemon wedges for a tangy flavor.</div></div></li></ul><div><br></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div style=\"display: inline;\"></div><div class=\"img-container\"><img src=\"http://localhost:8080/image-1709996413080.jpg\" data-filename=\"089a700211a4aa3f343e88f2c76e7488.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/81MOXdJexbU\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\">Enjoy the delicious and flavorful Masala Dosas as a breakfast or snack option!</div><div><div style=\"display: inline;\"></div></div><h2>Tips:</h2><ul><li><li>Ensure the dosa batter is well-fermented for a light and airy texture.</li><li>Adjust the thickness of the dosa according to your preference by adding more or less batter to the tawa.</li><li>Use a well-seasoned cast iron skillet or a non-stick dosa tawa for best results.</li><li>You can also add a sprinkle of idli podi (gunpowder) or grated cheese to the dosa before folding for added flavor.</li></li></ul>','Masala Dosa - by jack','http://localhost:8080/image-1709996412595.jpg','2024-03-09 15:00:13'),(9,'<h1>Orange juice recipe</h1><h2>Ingredients:</h2><ul><li><li>4-6 large oranges</li><li>Ice cubes (optional)</li><li>Sugar or honey (optional)</li><li>Mint leaves for garnish (optional)</li></li></ul><div class=\"img-container\"><img src=\"http://localhost:8080/image-1710249887815.jpg\" data-filename=\"bright-citrus-citrus-fruit-1937743.jpg\" class=\"img-adjustment\"></div><div style=\"display: inline;\"></div><h2>Instrutions:</h2><ul><li><li>Wash the oranges thoroughly under running water to remove any dirt or residue.</li><li>Cut the oranges in half crosswise using a sharp knife.</li><li>Juice the oranges using a citrus juicer or a handheld orange squeezer. You can also use a fork to press and twist the orange halves to extract the juice.</li><li>Strain the orange juice through a fine-mesh sieve to remove any seeds or pulp if desired.</li><li>Pour the freshly squeezed orange juice into a pitcher or large jar.</li><li>Add ice cubes to the pitcher to chill the orange juice or refrigerate it for at least 30 minutes before serving.</li><li>Stir in sugar or honey to sweeten the orange juice if desired. Start with 1/4 cup of sugar or honey and adjust to taste.</li><li>Serve the orange juice over ice in glasses garnished with fresh mint leaves for a refreshing touch.</li></li></ul><div class=\"vid-container\"><iframe src=\"//www.youtube.com/embed/diUvkHsCbQg\" allowfullscreen=\"\" class=\"img-adjustment\"></iframe></div><div style=\"display: inline;\"></div>','Orange juice','http://localhost:8080/image-1710249887815.jpg','2024-03-12 18:54:47');
-- -----------------------------------------------------
-- Table `subscribe`.`users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subscribe`.`users` (
`id` INT NOT NULL AUTO_INCREMENT,
`username` VARCHAR(100) NOT NULL,
`password` VARCHAR(255) NOT NULL,
`role` ENUM('user', 'admin') NOT NULL DEFAULT 'user',
PRIMARY KEY (`id`),
UNIQUE INDEX `email` (`username` ASC) VISIBLE)
ENGINE = InnoDB
AUTO_INCREMENT = 3
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
INSERT INTO `users` VALUES (1,'dheeraj','$2b$10$vBsFSNe.QQ6RO2h/Xrynsu6kWwpLi85Inw6I7J5ZNj6hCcKk4Lfm.','user'),(2,'ben','$2b$10$yb2q3s0pbfoxyUsLxfkbcesaqp7ozYPIc948KrNkxQ58d3v3EOZ2.','user');
-- -----------------------------------------------------
-- Table `subscribe`.`subscriptions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subscribe`.`subscriptions` (
`id` INT NOT NULL AUTO_INCREMENT,
`subscriber_id` INT NOT NULL,
`subscribed_to_id` INT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `subscriber_id` (`subscriber_id` ASC, `subscribed_to_id` ASC) VISIBLE,
INDEX `subscribed_to_id` (`subscribed_to_id` ASC) VISIBLE,
CONSTRAINT `subscriptions_ibfk_1`
FOREIGN KEY (`subscriber_id`)
REFERENCES `subscribe`.`users` (`id`),
CONSTRAINT `subscriptions_ibfk_2`
FOREIGN KEY (`subscribed_to_id`)
REFERENCES `subscribe`.`users` (`id`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
INSERT INTO `subscriptions` VALUES (1,1,2);
-- -----------------------------------------------------
-- Table `subscribe`.`user_details`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subscribe`.`user_details` (
`id` INT NULL DEFAULT NULL,
`profilepic` VARCHAR(500) NULL DEFAULT NULL,
`iglink` VARCHAR(500) NULL DEFAULT NULL,
`ytlink` VARCHAR(500) NULL DEFAULT NULL,
`lilink` VARCHAR(500) NULL DEFAULT NULL,
`twlink` VARCHAR(500) NULL DEFAULT NULL,
INDEX `id` (`id` ASC) VISIBLE,
CONSTRAINT `user_details_ibfk_1`
FOREIGN KEY (`id`)
REFERENCES `subscribe`.`users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
-- -----------------------------------------------------
-- Table `subscribe`.`user_posts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subscribe`.`user_posts` (
`id` INT NOT NULL,
`posts` JSON NULL DEFAULT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `user_posts_ibfk_1`
FOREIGN KEY (`id`)
REFERENCES `subscribe`.`users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
INSERT INTO `user_posts` VALUES (1,'[1, 3, 5, 7, 8, 9]'),(2,'[2, 4, 6]');
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;