157 lines
3.9 KiB
SQL
157 lines
3.9 KiB
SQL
-- --------------------------------------------------------
|
||
-- Хост: 127.0.0.1
|
||
-- Версия на сървъра: 11.4.0-MariaDB - mariadb.org binary distribution
|
||
-- ОС на сървъра: Win64
|
||
-- HeidiSQL Версия: 12.3.0.6589
|
||
-- --------------------------------------------------------
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
|
||
;
|
||
/*!40101 SET NAMES utf8 */
|
||
;
|
||
/*!50503 SET NAMES utf8mb4 */
|
||
;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */
|
||
;
|
||
/*!40103 SET TIME_ZONE='+00:00' */
|
||
;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */
|
||
;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */
|
||
;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */
|
||
;
|
||
|
||
-- Дъмп данни за таблица cart.location: ~0 rows (приблизително)
|
||
DELETE FROM `Location`;
|
||
|
||
INSERT INTO
|
||
`Location` (
|
||
`id`,
|
||
`name`,
|
||
`address`,
|
||
`isActive`
|
||
)
|
||
VALUES (
|
||
1,
|
||
'Стадион Васил Левски',
|
||
'',
|
||
1
|
||
), (
|
||
2,
|
||
'Софийски Университет',
|
||
'',
|
||
1
|
||
), (3, 'Сердика', '', 1),
|
||
(4, 'Лъвов Мост', '', 1),
|
||
(5, 'ц.ж.п. Гара', '', 1),
|
||
(6, 'НДК', '', 1),
|
||
(7, 'Паметник Патриарх Евтимий', '', 1);
|
||
|
||
-- Дъмп данни за таблица cart.cartevent: ~1 rows (приблизително)
|
||
DELETE FROM `CartEvent`;
|
||
|
||
INSERT INTO
|
||
`CartEvent` (
|
||
`id`,
|
||
`startTime`,
|
||
`endTime`,
|
||
`dayofweek`,
|
||
`isActive`,
|
||
`locationId`,
|
||
`shiftDuration`,
|
||
`eventType`,
|
||
`numberOfPublishers`
|
||
)
|
||
VALUES (
|
||
1,
|
||
'2023-12-27 07:00:33.174',
|
||
'2023-12-27 16:00:33.174',
|
||
'Monday',
|
||
1,
|
||
1,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
), (
|
||
2,
|
||
'2023-12-27 07:00:33.174',
|
||
'2023-12-27 16:00:33.174',
|
||
'Tuesday',
|
||
1,
|
||
2,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
), (
|
||
3,
|
||
'2023-12-28 07:00:33.174',
|
||
'2023-12-28 16:00:33.174',
|
||
'Wednesday',
|
||
1,
|
||
3,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
), (
|
||
4,
|
||
'2023-12-29 07:00:33.174',
|
||
'2023-12-29 16:00:33.174',
|
||
'Thursday',
|
||
1,
|
||
4,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
), (
|
||
5,
|
||
'2023-12-30 07:00:33.174',
|
||
'2023-12-30 16:00:33.174',
|
||
'Friday',
|
||
0,
|
||
5,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
), (
|
||
6,
|
||
'2023-12-27 10:00:49.048',
|
||
'2023-12-27 16:00:49.048',
|
||
'Saturday',
|
||
1,
|
||
6,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
),
|
||
(
|
||
7,
|
||
'2023-12-30 07:00:33.174',
|
||
'2023-12-30 16:00:33.174',
|
||
'Friday',
|
||
1,
|
||
7,
|
||
90,
|
||
'PW_Cart',
|
||
4
|
||
);
|
||
|
||
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */
|
||
;
|
||
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */
|
||
;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */
|
||
;
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
|
||
;
|
||
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */
|
||
;
|
||
|
||
-- INSERT INTO `cartevent` (`id`, `startTime`, `endTime`, `dayofweek`, `isActive`, `locationId`, `shiftDuration`, `eventType`, `numberOfPublishers`)
|
||
-- VALUES
|
||
-- (2, '2023-12-27 07:00:33.174', '2023-12-27 16:00:33.174', 'Tuesday', 1, 2, 90, 'PW_Cart', 4),
|
||
-- (3, '2023-12-28 07:00:33.174', '2023-12-28 16:00:33.174', 'Wednesday', 1, 3, 90, 'PW_Cart', 4),
|
||
-- (4, '2023-12-29 07:00:33.174', '2023-12-29 16:00:33.174', 'Thursday', 1, 4, 90, 'PW_Cart', 4),
|
||
-- (5, '2023-12-30 07:00:33.174', '2023-12-30 16:00:33.174', 'Friday', 1, 5, 90, 'PW_Cart', 4),
|
||
-- (6, '2023-12-31 07:00:33.174', '2023-12-31 16:00:33.174', 'Saturday', 1, 6, 90, 'PW_Cart', 4),
|
||
-- (7, '2024-01-01 07:00:33.174', '2024-01-01 16:00:33.174', 'Sunday', 1, 7, 90, 'PW_Cart', 4) |