data.sql

INSERT INTO `product` (`id`, `name`, `sku`, `slug`, `shortDescription`, `description`, `price`, `onSale`, `onSalePrice`, `externalUrl`, `productImage`, `createdAt`) VALUES
(
    1,
    "Samsung P300",
    "10000",
    "samsung-p300",
    "The Samsung P300 is an exceptional mobile phone for individualists with high standards.",
    "The Samsung P300 is an exceptional mobile phone for individualists with high standards. At only 9 mm, it is as thin as a credit card, making it the ideal companion. Experience how exciting it can be to be on the move with the P300. Keep track of your work wherever you are in the world, without sacrificing mobility or independence. It fits into any shirt pocket and, thanks to its slimline shape, does not look like a mobile phone. Try your hand at being a secret agent and show people what you are made of.With the Samsung P300's handy functions, you can experience the true freedom of mobile communication. Make tri-band calls worldwide in all 900/1, 800/1, 900 MHz networks or use the hands-free button to talk without having to hold the phone. And the integrated MP3 player means you always have your favorite music to hand. With the P300, you are at the center of the world wherever you are.A day at the beach. A winter landscape or your friends at a party. Capture your favorite scenes with the Samsung P300's 1.3 megapixel camera and immortalize them in brilliant photos. Bring light into the darkness and make use of the flash. With the P300's 1.3 megapixel camera, the forces of light are always victorious.",
    33.0,
    0,
    0,
    "https//www.store.com/id/2432423",
    "image000100.jpg",
    "2020-07-22 00:00:00"
),
(
    2,
    "Bang and Olufsen Serenata",
    "10001",
    "bang-and-olufsen-serenata",
    "Two icons of excellence come together in Serenata.",
    "Two icons of excellence come together in Serenata, a music player and mobile phone in one. It’s high quality on a higher level, with the advanced acoustics, interface experience and design ingenuity of Bang & Olufsen combined with the intelligent mobile phone engineering of Samsung. Experience unparalled pleasure in a sublime design – in the palm of your hand.",
    103.0,
    0,
    0,
    "https//www.store.com/id/54345",
    "image00200.jpg",
    "2020-07-22 00:00:00"
),
(
    3,
    "Bang and Olufsen Serene",
    "10002",
    "bang-and-olufsen-serene",
    "Bang & Olufsen and Samsung formed the joint venture with the aim of competing in the high end mobile phone market.",
    "Bang & Olufsen and Samsung formed the joint venture with the aim of competing in the high end mobile phone market, primarily competing with several handsets from Nokia. The partnership has drawn on the design strengths of Bang & Olufsen and Samsung's mobile phone technology enabling Bang & Olufsen to re-enter the mobile phone market after an absence of several years and Samsung to expand into premium mobile phones. ",
    103.0,
    0,
    0,
    "https//www.store.com/id/4563453",
    "image000300.jpg",
    "2020-07-22 00:00:00"
),
(
    4,
    "C91 Golden-Buddha Phone",
    "10003",
    "c91-golden-buddha-phone",
    "There are not too many mobile phones available into the wild with a Buddhist design, yet it seems that they are getting increasingly popular these days",
    "There are not too many mobile phones available into the wild with a Buddhist design, yet it seems that they are getting increasingly popular these days, which means that more are to come in the near future. We have already seen a similar phone about a year and a half ago, and now another one shows up, available for purchase, only that the new phone, unlike the older one, sports a rather interesting design, as well as dual-SIM capabilities.",
    233.0,
    0,
    0,
    "https//www.store.com/id/34324",
    "image000400.jpg",
    "2020-07-22 00:00:00"
),

(
    5,
    "Super Nintendo Entertainment System",
    "22000",
    "super-nintendo-entertainment-system",
    "The Super Nintendo Entertainment System, commonly shortened to Super Nintendo",
    "The Super Nintendo Entertainment System, commonly shortened to Super Nintendo, Super NES or SNES[c] is a 16-bit home video game console developed by Nintendo that was released in 1990 in Japan and South Korea, 1991 in North America, 1992 in Europe and Oceania, and 1993 in South America. In Japan, it is called the Super Famicom (SFC). In South Korea, it is called the Super Comboy and was distributed by Hyundai Electronics. The system was released in Brazil on August 30, 1993, by Playtronic. Although each version is essentially the same, several forms of regional lockout prevent cartridges for one version from being used in other versions.",
    255.0,
    0,
    0,
    "https//www.store.com/id/3434342",
    "image000340.jpg",
    "2020-07-22 00:00:00"
),
(
    6,
    "Playstation",
    "34234",
    "playstation",
    "The PlayStation (abbreviated as PS, commonly known as the PS1/PS one or its codename PSX) is a home video game console",
    "The PlayStation (abbreviated as PS, commonly known as the PS1/PS one or its codename PSX) is a home video game console developed and marketed by Sony Interactive Entertainment. It was released in Japan on 3 December 1994, in North America on 9 September 1995, in Europe on 29 September 1995, and in Australia on 15 November 1995. As a fifth-generation console, the PlayStation primarily competed with the Nintendo 64 and the Sega Saturn. ",
    144.0,
    0,
    0,
    "https//www.store.com/id/7676",
    "image02e40.jpg",
    "2020-07-22 00:00:00"
),

(
    7,
    "Game Boy",
    "33200",
    "gameboy",
    "The Game Boy is an 8-bit fourth generation handheld game console developed and manufactured by Nintendo.",
    "The Game Boy is an 8-bit fourth generation handheld game console developed and manufactured by Nintendo. It was first released in Japan on April 21, 1989, in North America later the same year, and in Europe in late 1990. It was designed by the same team that developed the Game & Watch series of handheld electronic games and several Nintendo Entertainment System (NES) games: Satoru Okada, Gunpei Yokoi, and Nintendo Research & Development.",
    231.0,
    0,
    0,
    "https//www.store.com/id/423423",
    "image0033340.jpg",
    "2020-07-22 00:00:00"
),
(
    8,
    "Game Gear",
    "34234",
    "game-gear",
    "The Game Gear is an 8-bit fourth generation handheld game console",
    "The Game Gear is an 8-bit fourth generation handheld game console released by Sega on October 6, 1990, in Japan, in April 1991 throughout North America and Europe, and during 1992 in Australia. The Game Gear primarily competed with Nintendo's Game Boy, the Atari Lynx, and NEC's TurboExpress. It shares much of its hardware with the Master System, and can play Master System games through the use of an adapter. Sega positioned the Game Gear, which had a full-color backlit screen with a landscape format, as a technologically superior handheld to the Game Boy. ",
    144.0,
    0,
    0,
    "https//www.store.com/id/33",
    "image022220.jpg",
    "2020-07-22 00:00:00"
);

INSERT INTO `category` (`id`, `name`, `slug`, `shortDescription`, `description`, `categoryImage`, `createdAt`) VALUES
(
    1,
    "Phones",
    "phones",
    "Category containing phones.",
    "Introducing our wide range of smartphones, designed to cater to every individual's needs and preferences. At our webshop, you'll find a diverse collection of phones meticulously categorized to help you discover the perfect device that suits your lifestyle",
    "image34440.jpg",
    "2020-07-22 00:00:00"
),
(
    2,
    "Consoles",
    "consoles",
    "Category containing retro consoles.",
    "Explore our remarkable collection of retro consoles, carefully curated to bring back the cherished memories of classic gaming. Dive into the world of vintage gaming with our distinct categories. ",
    "image34440.jpg",
    "2020-07-22 00:00:00"
),
(
    3,
    "Handhelds",
    "handhelds",
    "Category containing retro handhelds.",
    "Step into the world of portable gaming with our captivating selection of retro handhelds. These handheld consoles are designed to reignite your passion for nostalgic gaming on the go.",
    "image87640.jpg",
    "2020-07-22 00:00:00"
);


INSERT INTO `tag` (`id`, `name`, `slug`, `createdAt`) VALUES
(
    1,
    "New",
    "new",
    "2020-07-22 00:00:00"
),
(
    2,
    "Used",
    "used",
    "2020-07-22 00:00:00"
),
(
    3,
    "Broken",
    "broken",
    "2020-07-22 00:00:00"
);

INSERT INTO `order` (`id`, `name`, `address`, `state`, `country`, `town`, `phone`, `email`, `zipCode`, `note`) VALUES
(
    1,
    "John Johnson",
    "Long street 176",
    "Newstate",
    "Gnomeland",
    "Newtown",
    "342234234",
    "john@jemail.com",
    "34343",
    "This is delivery note..."
),
(
    2,
    "Emily Anderson",
    "Maple Avenue 42",
    "Sunshine City",
    "Fantasiaville",
    "Dreamland",
    "123456789",
    "emily@jemail.com",
    "98765",
    "This is a sample invoice for reference..."
),
(
    3,
    "Michael Thompson",
    "Oak Street 88",
    "Moonlight Town",
    "Enchantia",
    "Wonderland",
    "555-1234",
    "michael@jemail.com",
    "67890",
    "This is a sample receipt for your records..."
);

INSERT INTO `order_products_links` (`id`, `orderId`, `productId`, `amount`) VALUES
(
    1,
    1,
    2,
    4
),
(
    2,
    2,
    5,
    2
),
(
    3,
    2,
    4,
    1
);

INSERT INTO `product_category_links` (`id`, `categoryId`, `productId`) VALUES
(
    1,
    1,
    1
),
(
    2,
    1,
    2
),
(
    3,
    1,
    3
),
(
    4,
    1,
    4
),
(
    5,
    2,
    5
),
(
    6,
    2,
    6
),
(
    7,
    3,
    7
),
(
    8,
    3,
    8
);


INSERT INTO `product_tag_links` (`id`, `tagId`, `productId`) VALUES
(
    1,
    1,
    1
),
(
    2,
    2,
    2
),
(
    3,
    2,
    3
),
(
    4,
    2,
    4
),
(
    5,
    2,
    5
),
(
    6,
    3,
    6
),
(
    7,
    2,
    7
),
(
    8,
    2,
    8
);