|
| 1 | +-- MySQL dump 10.17 Distrib 10.3.13-MariaDB, for Win64 (AMD64) |
| 2 | +-- |
| 3 | +-- Host: localhost Database: hoja2base2 |
| 4 | +-- ------------------------------------------------------ |
| 5 | +-- Server version 10.3.13-MariaDB |
| 6 | + |
| 7 | +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
| 8 | +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
| 9 | +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
| 10 | +/*!40101 SET NAMES utf8mb4 */; |
| 11 | +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
| 12 | +/*!40103 SET TIME_ZONE='+00:00' */; |
| 13 | +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
| 14 | +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
| 15 | +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
| 16 | +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
| 17 | + |
| 18 | +-- |
| 19 | +-- Table structure for table `cliente` |
| 20 | +-- |
| 21 | + |
| 22 | +DROP TABLE IF EXISTS `cliente`; |
| 23 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 24 | +/*!40101 SET character_set_client = utf8 */; |
| 25 | +CREATE TABLE `cliente` ( |
| 26 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 27 | + `Nombre` varchar(45) DEFAULT NULL, |
| 28 | + `Nit` varchar(45) DEFAULT NULL, |
| 29 | + `Direccion` varchar(45) DEFAULT NULL, |
| 30 | + `Saldo` float DEFAULT NULL, |
| 31 | + PRIMARY KEY (`id`) |
| 32 | +) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1; |
| 33 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 34 | + |
| 35 | +-- |
| 36 | +-- Dumping data for table `cliente` |
| 37 | +-- |
| 38 | + |
| 39 | +LOCK TABLES `cliente` WRITE; |
| 40 | +/*!40000 ALTER TABLE `cliente` DISABLE KEYS */; |
| 41 | +INSERT INTO `cliente` VALUES (1,'Cliente1','1111-2222','Direccion1',1000),(2,'Cliente2','2222-3333','Direccion2',9100),(3,'Cliente3','3333-4443','Direccion3',18500),(4,'Cliente4','4444-5555','Direccion4',1200),(5,'Cliente5','5555-6666','Direccion5',2850),(7,'Cliente 7','9999-2222','Direccion7',900),(10,'Cliente 8','9999-2222','Direccion7',100),(12,'Cliente 9','0000-335','Direccion7',10010),(17,'cliente 10','0000-1110','Direccion10',0),(18,'cliente 11','0001-1111','Direccion11',0),(22,'cliente13','555-443','direccion13',0); |
| 42 | +/*!40000 ALTER TABLE `cliente` ENABLE KEYS */; |
| 43 | +UNLOCK TABLES; |
| 44 | +/*!50003 SET @saved_cs_client = @@character_set_client */ ; |
| 45 | +/*!50003 SET @saved_cs_results = @@character_set_results */ ; |
| 46 | +/*!50003 SET @saved_col_connection = @@collation_connection */ ; |
| 47 | +/*!50003 SET character_set_client = utf8mb4 */ ; |
| 48 | +/*!50003 SET character_set_results = utf8mb4 */ ; |
| 49 | +/*!50003 SET collation_connection = utf8mb4_general_ci */ ; |
| 50 | +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; |
| 51 | +/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
| 52 | +DELIMITER ;; |
| 53 | +/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER eliminarCliente |
| 54 | +BEFORE DELETE ON cliente |
| 55 | +FOR EACH ROW |
| 56 | +BEGIN |
| 57 | +DELETE FROM pagoscredito WHERE Cliente_id = old.id; |
| 58 | +DELETE FROM factura WHERE Cliente_id = old.id; |
| 59 | +END */;; |
| 60 | +DELIMITER ; |
| 61 | +/*!50003 SET sql_mode = @saved_sql_mode */ ; |
| 62 | +/*!50003 SET character_set_client = @saved_cs_client */ ; |
| 63 | +/*!50003 SET character_set_results = @saved_cs_results */ ; |
| 64 | +/*!50003 SET collation_connection = @saved_col_connection */ ; |
| 65 | + |
| 66 | +-- |
| 67 | +-- Table structure for table `detallefactura` |
| 68 | +-- |
| 69 | + |
| 70 | +DROP TABLE IF EXISTS `detallefactura`; |
| 71 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 72 | +/*!40101 SET character_set_client = utf8 */; |
| 73 | +CREATE TABLE `detallefactura` ( |
| 74 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 75 | + `Factura_id` int(11) NOT NULL, |
| 76 | + `Producto_id` int(11) NOT NULL, |
| 77 | + `Cantidad` float DEFAULT NULL, |
| 78 | + `Subtotal` float DEFAULT NULL, |
| 79 | + PRIMARY KEY (`id`), |
| 80 | + KEY `Factura_id` (`Factura_id`), |
| 81 | + KEY `Producto_id` (`Producto_id`), |
| 82 | + CONSTRAINT `detallefactura_ibfk_1` FOREIGN KEY (`Factura_id`) REFERENCES `factura` (`id`), |
| 83 | + CONSTRAINT `detallefactura_ibfk_2` FOREIGN KEY (`Producto_id`) REFERENCES `producto` (`id`) |
| 84 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 85 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 86 | + |
| 87 | +-- |
| 88 | +-- Dumping data for table `detallefactura` |
| 89 | +-- |
| 90 | + |
| 91 | +LOCK TABLES `detallefactura` WRITE; |
| 92 | +/*!40000 ALTER TABLE `detallefactura` DISABLE KEYS */; |
| 93 | +/*!40000 ALTER TABLE `detallefactura` ENABLE KEYS */; |
| 94 | +UNLOCK TABLES; |
| 95 | + |
| 96 | +-- |
| 97 | +-- Table structure for table `detallepago` |
| 98 | +-- |
| 99 | + |
| 100 | +DROP TABLE IF EXISTS `detallepago`; |
| 101 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 102 | +/*!40101 SET character_set_client = utf8 */; |
| 103 | +CREATE TABLE `detallepago` ( |
| 104 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 105 | + `PagosCredito_id` int(11) NOT NULL, |
| 106 | + `Monto` float DEFAULT NULL, |
| 107 | + `Factura_id` int(11) DEFAULT NULL, |
| 108 | + PRIMARY KEY (`id`), |
| 109 | + KEY `PagosCredito_id` (`PagosCredito_id`), |
| 110 | + KEY `Factura_id` (`Factura_id`), |
| 111 | + CONSTRAINT `detallepago_ibfk_1` FOREIGN KEY (`PagosCredito_id`) REFERENCES `pagoscredito` (`id`), |
| 112 | + CONSTRAINT `detallepago_ibfk_2` FOREIGN KEY (`Factura_id`) REFERENCES `factura` (`id`) |
| 113 | +) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; |
| 114 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 115 | + |
| 116 | +-- |
| 117 | +-- Dumping data for table `detallepago` |
| 118 | +-- |
| 119 | + |
| 120 | +LOCK TABLES `detallepago` WRITE; |
| 121 | +/*!40000 ALTER TABLE `detallepago` DISABLE KEYS */; |
| 122 | +INSERT INTO `detallepago` VALUES (1,1,300,1),(2,2,100,1),(3,3,100,1),(4,4,400,1),(5,5,100,1),(6,6,200,1),(7,7,1000,1),(8,8,300,2),(11,9,990,13),(12,9,0,14),(13,10,900,14),(14,11,570,8); |
| 123 | +/*!40000 ALTER TABLE `detallepago` ENABLE KEYS */; |
| 124 | +UNLOCK TABLES; |
| 125 | + |
| 126 | +-- |
| 127 | +-- Table structure for table `factura` |
| 128 | +-- |
| 129 | + |
| 130 | +DROP TABLE IF EXISTS `factura`; |
| 131 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 132 | +/*!40101 SET character_set_client = utf8 */; |
| 133 | +CREATE TABLE `factura` ( |
| 134 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 135 | + `Fecha` datetime DEFAULT NULL, |
| 136 | + `Total` float DEFAULT NULL, |
| 137 | + `Credito` tinyint(1) DEFAULT NULL, |
| 138 | + `Impresa` tinyint(1) DEFAULT NULL, |
| 139 | + `Saldo` float DEFAULT NULL, |
| 140 | + `Anulada` float DEFAULT NULL, |
| 141 | + `Cliente_id` int(11) NOT NULL, |
| 142 | + PRIMARY KEY (`id`), |
| 143 | + KEY `Cliente_id` (`Cliente_id`), |
| 144 | + CONSTRAINT `factura_ibfk_1` FOREIGN KEY (`Cliente_id`) REFERENCES `cliente` (`id`) |
| 145 | +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; |
| 146 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 147 | + |
| 148 | +-- |
| 149 | +-- Dumping data for table `factura` |
| 150 | +-- |
| 151 | + |
| 152 | +LOCK TABLES `factura` WRITE; |
| 153 | +/*!40000 ALTER TABLE `factura` DISABLE KEYS */; |
| 154 | +INSERT INTO `factura` VALUES (1,'2020-08-17 20:52:07',1000,0,1,0,1,1),(2,'2020-08-17 20:52:07',3000,0,1,0,1,1),(3,'2020-08-17 20:52:07',5000,1,1,4300,0,2),(4,'2020-08-17 20:52:07',500,0,1,0,1,3),(5,'2020-08-17 20:52:08',20000,1,1,18500,0,3),(6,'2020-08-17 20:52:08',1400,0,1,0,1,4),(7,'2020-08-17 20:59:42',1600,1,1,1200,0,4),(8,'2020-08-17 20:59:42',600,0,1,0,1,5),(9,'2020-08-17 20:59:42',3000,1,1,2850,0,5),(13,'2020-08-20 21:33:26',1050,0,1,0,1,1),(14,'2020-08-20 21:33:26',2200,1,1,1000,0,1),(15,'2020-08-20 21:33:26',5000,1,1,4600,0,2); |
| 155 | +/*!40000 ALTER TABLE `factura` ENABLE KEYS */; |
| 156 | +UNLOCK TABLES; |
| 157 | +/*!50003 SET @saved_cs_client = @@character_set_client */ ; |
| 158 | +/*!50003 SET @saved_cs_results = @@character_set_results */ ; |
| 159 | +/*!50003 SET @saved_col_connection = @@collation_connection */ ; |
| 160 | +/*!50003 SET character_set_client = utf8mb4 */ ; |
| 161 | +/*!50003 SET character_set_results = utf8mb4 */ ; |
| 162 | +/*!50003 SET collation_connection = utf8mb4_general_ci */ ; |
| 163 | +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; |
| 164 | +/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
| 165 | +DELIMITER ;; |
| 166 | +/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `eliminarFactura` BEFORE DELETE ON `factura` FOR EACH ROW BEGIN |
| 167 | +DELETE FROM detallefactura WHERE Factura_id = old.id; |
| 168 | +DELETE FROM detallepago WHERE Factura_id = old.id; |
| 169 | +END */;; |
| 170 | +DELIMITER ; |
| 171 | +/*!50003 SET sql_mode = @saved_sql_mode */ ; |
| 172 | +/*!50003 SET character_set_client = @saved_cs_client */ ; |
| 173 | +/*!50003 SET character_set_results = @saved_cs_results */ ; |
| 174 | +/*!50003 SET collation_connection = @saved_col_connection */ ; |
| 175 | + |
| 176 | +-- |
| 177 | +-- Table structure for table `pagoscredito` |
| 178 | +-- |
| 179 | + |
| 180 | +DROP TABLE IF EXISTS `pagoscredito`; |
| 181 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 182 | +/*!40101 SET character_set_client = utf8 */; |
| 183 | +CREATE TABLE `pagoscredito` ( |
| 184 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 185 | + `fecha` datetime DEFAULT NULL, |
| 186 | + `Total` float DEFAULT NULL, |
| 187 | + `Cliente_id` int(11) NOT NULL, |
| 188 | + PRIMARY KEY (`id`), |
| 189 | + KEY `Cliente_id` (`Cliente_id`), |
| 190 | + CONSTRAINT `pagoscredito_ibfk_1` FOREIGN KEY (`Cliente_id`) REFERENCES `cliente` (`id`) |
| 191 | +) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; |
| 192 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 193 | + |
| 194 | +-- |
| 195 | +-- Dumping data for table `pagoscredito` |
| 196 | +-- |
| 197 | + |
| 198 | +LOCK TABLES `pagoscredito` WRITE; |
| 199 | +/*!40000 ALTER TABLE `pagoscredito` DISABLE KEYS */; |
| 200 | +INSERT INTO `pagoscredito` VALUES (1,'2020-08-17 22:59:06',300,1),(2,'2020-08-17 22:59:24',100,1),(3,'2020-08-17 22:59:37',100,1),(4,'2020-08-17 23:03:03',400,1),(5,'2020-08-17 23:04:44',100,1),(6,'2020-08-17 23:04:55',200,1),(7,'2020-08-17 23:05:06',1000,1),(8,'2020-08-17 23:05:19',300,1),(9,'2020-08-20 22:28:35',990,1),(10,'2020-08-20 22:29:25',900,1),(11,'2020-08-20 22:34:41',570,5); |
| 201 | +/*!40000 ALTER TABLE `pagoscredito` ENABLE KEYS */; |
| 202 | +UNLOCK TABLES; |
| 203 | +/*!50003 SET @saved_cs_client = @@character_set_client */ ; |
| 204 | +/*!50003 SET @saved_cs_results = @@character_set_results */ ; |
| 205 | +/*!50003 SET @saved_col_connection = @@collation_connection */ ; |
| 206 | +/*!50003 SET character_set_client = utf8mb4 */ ; |
| 207 | +/*!50003 SET character_set_results = utf8mb4 */ ; |
| 208 | +/*!50003 SET collation_connection = utf8mb4_general_ci */ ; |
| 209 | +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; |
| 210 | +/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
| 211 | +DELIMITER ;; |
| 212 | +/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `nuevoPago` AFTER INSERT ON `pagoscredito` FOR EACH ROW begin |
| 213 | +declare varSaldo,varPago float; |
| 214 | +declare varIdFactura int; |
| 215 | +declare cont1 int default 0; |
| 216 | +
|
| 217 | +declare curFactura cursor for select F.id,F.Saldo from factura F where F.Cliente_id = new.Cliente_id and F.Anulada = 0; |
| 218 | + |
| 219 | +declare continue handler for sqlstate '02000' set cont1 = 1; |
| 220 | +set varPago = new.Total; |
| 221 | +open curFactura; |
| 222 | +fetch curFactura into varIdFactura,varSaldo; |
| 223 | +while not cont1 do |
| 224 | +
|
| 225 | +if varPago >= varSaldo then |
| 226 | +
|
| 227 | +insert into detallePago(PagosCredito_id,Monto,Factura_id) values(new.id,varSaldo,varIdFactura); |
| 228 | +update factura set Saldo = 0, Anulada = 1, Credito = 0 where id = varIdFactura; |
| 229 | +update cliente set Saldo = Saldo - varSaldo where id = new.Cliente_id; |
| 230 | +set varPago = varPago - varSaldo; |
| 231 | +
|
| 232 | +if varPago = 0 then |
| 233 | +set cont1 = 1; |
| 234 | +end if; |
| 235 | +
|
| 236 | +else |
| 237 | +insert into detallePago(PagosCredito_id,Monto,Factura_id) values(new.id,varPago,varIdFactura); |
| 238 | +update factura set Saldo = Saldo-varPago where id = varIdFactura; |
| 239 | +update cliente set Saldo = Saldo - varPago where id = new.Cliente_id; |
| 240 | +set cont1 = 1; |
| 241 | +end if; |
| 242 | +
|
| 243 | +fetch curFactura into varIdFactura,varSaldo; |
| 244 | +end while; |
| 245 | +
|
| 246 | +end */;; |
| 247 | +DELIMITER ; |
| 248 | +/*!50003 SET sql_mode = @saved_sql_mode */ ; |
| 249 | +/*!50003 SET character_set_client = @saved_cs_client */ ; |
| 250 | +/*!50003 SET character_set_results = @saved_cs_results */ ; |
| 251 | +/*!50003 SET collation_connection = @saved_col_connection */ ; |
| 252 | +/*!50003 SET @saved_cs_client = @@character_set_client */ ; |
| 253 | +/*!50003 SET @saved_cs_results = @@character_set_results */ ; |
| 254 | +/*!50003 SET @saved_col_connection = @@collation_connection */ ; |
| 255 | +/*!50003 SET character_set_client = utf8mb4 */ ; |
| 256 | +/*!50003 SET character_set_results = utf8mb4 */ ; |
| 257 | +/*!50003 SET collation_connection = utf8mb4_general_ci */ ; |
| 258 | +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; |
| 259 | +/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
| 260 | +DELIMITER ;; |
| 261 | +/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER eliminarCredito |
| 262 | +BEFORE DELETE ON pagoscredito |
| 263 | +FOR EACH ROW |
| 264 | +BEGIN |
| 265 | +DELETE FROM detallepago WHERE PagosCredito_id = old.id; |
| 266 | +END */;; |
| 267 | +DELIMITER ; |
| 268 | +/*!50003 SET sql_mode = @saved_sql_mode */ ; |
| 269 | +/*!50003 SET character_set_client = @saved_cs_client */ ; |
| 270 | +/*!50003 SET character_set_results = @saved_cs_results */ ; |
| 271 | +/*!50003 SET collation_connection = @saved_col_connection */ ; |
| 272 | + |
| 273 | +-- |
| 274 | +-- Table structure for table `producto` |
| 275 | +-- |
| 276 | + |
| 277 | +DROP TABLE IF EXISTS `producto`; |
| 278 | +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 279 | +/*!40101 SET character_set_client = utf8 */; |
| 280 | +CREATE TABLE `producto` ( |
| 281 | + `id` int(11) NOT NULL AUTO_INCREMENT, |
| 282 | + `Nombre` varchar(45) DEFAULT NULL, |
| 283 | + `Existencias` float DEFAULT NULL, |
| 284 | + `Precio` float DEFAULT NULL, |
| 285 | + PRIMARY KEY (`id`) |
| 286 | +) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1; |
| 287 | +/*!40101 SET character_set_client = @saved_cs_client */; |
| 288 | + |
| 289 | +-- |
| 290 | +-- Dumping data for table `producto` |
| 291 | +-- |
| 292 | + |
| 293 | +LOCK TABLES `producto` WRITE; |
| 294 | +/*!40000 ALTER TABLE `producto` DISABLE KEYS */; |
| 295 | +INSERT INTO `producto` VALUES (31,'Producto 1',10,15.5),(32,'Producto 2',10,18.5),(33,'Producto 3',10,120),(34,'Producto 4',10,13.6),(35,'Producto 5',10,89),(36,'Producto 6',10,11.5),(47,'Producto 7',10,15.5),(48,'Producto 8',10,15.5),(49,'Producto 9',10,15.5),(50,'Producto 10',10,15.5),(51,'Producto 11',10,15.5),(52,'Producto 12',10,15.5),(53,'Producto 13',10,15.5),(54,'Producto 14',10,15.5),(55,'Producto 15',10,15.5),(56,'Producto 16',10,15.5),(67,'Producto 17',10,15.5),(68,'Producto 18',10,15.5),(69,'Producto 19',10,15.5),(70,'Producto 20',10,15.5),(71,'Producto 21',10,15.5),(72,'Producto 22',10,15.5),(73,'Producto 23',10,15.5),(74,'Producto 24',10,15.5),(75,'Producto 25',10,15.5),(76,'Producto 26',10,15.5),(77,'Producto 27',10,10),(93,'Producto 28',10,10),(94,'Producto 29',10,10),(95,'Producto 30',10,10),(96,'Producto 31',10,10); |
| 296 | +/*!40000 ALTER TABLE `producto` ENABLE KEYS */; |
| 297 | +UNLOCK TABLES; |
| 298 | +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 299 | + |
| 300 | +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 301 | +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 302 | +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
| 303 | +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
| 304 | +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
| 305 | +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
| 306 | +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
| 307 | + |
| 308 | +-- Dump completed on 2020-09-15 21:47:30 |
|
0 commit comments