devops/zzz/schema/oss_store_volumes.sql

-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: 192.168.0.210    Database: reghao_bnt_tdb
-- ------------------------------------------------------
-- Server version	5.7.36

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `oss_store_volumes`
--

DROP TABLE IF EXISTS `oss_store_volumes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oss_store_volumes` (
  `store_node_id` int(11) NOT NULL,
  `block_id` varchar(255) DEFAULT NULL,
  `avail_inode` bigint(20) NOT NULL,
  `avail_space` bigint(20) NOT NULL,
  `fs_type` varchar(255) DEFAULT NULL,
  `mount_point` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `store_dir` varchar(255) DEFAULT NULL,
  `total_inode` bigint(20) NOT NULL,
  `total_space` bigint(20) NOT NULL,
  `volume` varchar(255) DEFAULT NULL,
  KEY `FK1kcrqmowoyk62q46kslo9bh9f` (`store_node_id`),
  CONSTRAINT `FK1kcrqmowoyk62q46kslo9bh9f` FOREIGN KEY (`store_node_id`) REFERENCES `oss_store_node` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oss_store_volumes`
--

LOCK TABLES `oss_store_volumes` WRITE;
/*!40000 ALTER TABLE `oss_store_volumes` DISABLE KEYS */;
INSERT INTO `oss_store_volumes` VALUES (6,'10995d9d-26ba-4c89-a392-84f7a2e00872',483091640,3593958514688,'ext4','/opt/oss/disk/13f654c8-af87-4710-aac9-7aa086c99aec','/dev/mapper/myusb1','/opt/oss/disk/13f654c8-af87-4710-aac9-7aa086c99aec/',488308736,15873616670720,'/dev/mapper/myusb1'),(5,'e0c3cbdb-8e65-4ea9-bce1-9041f60c3e45',28163957,430141091840,'ext4','/opt/disk/f8e05c21-3d45-404f-81a6-f8282fd9776f','/dev/mapper/veracrypt1','/opt/disk/f8e05c21-3d45-404f-81a6-f8282fd9776f/',28180480,453313044480,'/dev/mapper/veracrypt1');
/*!40000 ALTER TABLE `oss_store_volumes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-12-15 22:47:21