--
-- Host: MySQL-8.0    Database: counters
-- ------------------------------------------------------


--
-- Table structure for table `bills`
--

CREATE TABLE `bills` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `provider_id` int NOT NULL,
  `payment_date` timestamp NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bills`
--

INSERT INTO `bills` VALUES (1,'2024-06-06 10:53:58','2024-06-06 10:53:58',7,'2023-12-20 21:00:00',6883.00),(2,'2024-06-06 10:53:58','2024-06-06 10:53:58',5,'2023-12-20 21:00:00',2261.00),(3,'2024-06-06 10:54:56','2024-06-06 10:54:56',3,'2024-01-07 21:00:00',5148.00),(4,'2024-06-06 10:54:56','2024-06-06 10:54:56',4,'2024-01-07 21:00:00',763.00),(5,'2024-06-06 10:54:56','2024-06-06 10:54:56',8,'2024-01-07 21:00:00',4258.00),(6,'2024-06-06 10:56:47','2024-06-06 10:56:47',7,'2024-02-04 21:00:00',7173.00),(7,'2024-06-06 10:56:47','2024-06-06 10:56:47',4,'2024-02-04 21:00:00',455.00),(8,'2024-06-06 10:56:47','2024-06-06 10:56:47',5,'2024-02-04 21:00:00',2262.00),(9,'2024-06-06 10:56:47','2024-06-06 10:56:47',8,'2024-02-04 21:00:00',4142.00),(10,'2024-06-06 10:58:22','2024-06-06 10:58:22',4,'2024-03-03 21:00:00',522.00),(11,'2024-06-06 10:58:22','2024-06-06 10:58:22',5,'2024-03-03 21:00:00',2895.00),(12,'2024-06-06 10:58:22','2024-06-06 10:58:22',7,'2024-03-03 21:00:00',6978.00),(13,'2024-06-06 10:58:22','2024-06-06 10:58:22',8,'2024-03-03 21:00:00',4152.00),(14,'2024-06-06 11:01:09','2024-06-06 11:01:09',3,'2024-04-02 21:00:00',5815.00),(15,'2024-06-06 11:01:09','2024-06-06 11:01:09',4,'2024-04-02 21:00:00',567.00),(16,'2024-06-06 11:01:09','2024-06-06 11:01:09',5,'2024-04-02 21:00:00',1950.00),(17,'2024-06-06 11:01:09','2024-06-06 11:01:09',7,'2024-04-02 21:00:00',6979.00),(18,'2024-06-06 11:01:09','2024-06-06 11:01:09',8,'2024-04-02 21:00:00',4094.00),(19,'2024-06-06 11:03:08','2024-06-06 11:03:08',3,'2024-05-02 21:00:00',5407.00),(20,'2024-06-06 11:03:08','2024-06-06 11:03:08',4,'2024-05-02 21:00:00',557.00),(21,'2024-06-06 11:03:08','2024-06-06 11:03:08',5,'2024-05-02 21:00:00',2224.00),(22,'2024-06-06 11:03:08','2024-06-06 11:03:08',7,'2024-05-02 21:00:00',6979.00),(23,'2024-06-06 11:03:08','2024-06-06 11:03:08',8,'2024-05-02 21:00:00',4344.00),(24,'2024-06-06 11:04:08','2024-06-06 11:04:08',5,'2024-05-16 21:00:00',1121.00),(25,'2024-06-06 11:04:08','2024-06-06 11:04:08',7,'2024-05-16 21:00:00',6979.00),(26,'2024-06-06 11:05:01','2024-06-06 11:05:01',3,'2024-06-02 21:00:00',4495.00),(27,'2024-06-06 11:05:01','2024-06-06 11:05:01',4,'2024-06-02 21:00:00',514.00),(28,'2024-06-06 11:05:01','2024-06-06 11:05:01',5,'2024-06-02 21:00:00',749.00),(29,'2024-06-06 11:05:01','2024-06-06 11:05:01',8,'2024-06-02 21:00:00',4320.00);

--
-- Table structure for table `counters`
--

CREATE TABLE `counters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `counters`
--

INSERT INTO `counters` VALUES (1,'CWC','2024-05-29 15:35:00','2024-05-29 15:44:38'),(2,'HWC','2024-05-29 15:35:00','2024-05-29 15:43:58'),(3,'CWS','2024-05-31 12:14:54','2024-05-31 12:14:54'),(4,'HWS','2024-05-31 12:15:58','2024-05-31 12:15:58'),(5,'ET1','2024-06-04 09:25:58','2024-06-04 09:25:58'),(6,'ET2','2024-06-04 09:26:15','2024-06-04 09:26:15');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2024_05_28_192830_create_mycounters_table',1),(6,'2024_05_28_194259_create_counters_table',2),(7,'2024_05_28_194434_create_providers_table',2),(8,'2024_05_28_194502_create_bills_table',3),(9,'2024_06_05_102148_created_at',4);

--
-- Table structure for table `mycounters`
--

CREATE TABLE `mycounters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `counter_id` int NOT NULL,
  `value` int NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mycounters`
--

INSERT INTO `mycounters` VALUES (1,1,1,'2024-06-10 15:03:35','2024-06-10 15:03:35'),(2,2,12,'2024-06-10 15:03:35','2024-06-10 15:03:35'),(3,3,98,'2024-06-10 15:03:35','2024-06-10 15:03:35'),(4,4,76,'2024-06-10 15:03:35','2024-06-10 15:03:35'),(5,6,79,'2024-06-10 15:03:35','2024-06-10 15:03:35'),(6,5,19,'2024-06-10 15:26:16','2024-06-10 15:26:16');

--
-- Table structure for table `providers`
--

CREATE TABLE `providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `providers`
--

INSERT INTO `providers` VALUES (3,'mosobleirc',NULL,NULL),(4,'strogino mosenergo',NULL,NULL),(5,'opalikha mosenergo',NULL,NULL),(7,'ZKU Strogino','2024-06-04 10:38:09','2024-06-04 10:38:09'),(8,'fenix','2024-06-06 10:23:43','2024-06-06 10:23:43');


