83 lines
12 KiB
SQL
83 lines
12 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.32, for Win64 (x86_64)
|
||
--
|
||
-- Host: localhost Database: iiabmdb_basic_info
|
||
-- ------------------------------------------------------
|
||
-- Server version 8.0.32
|
||
|
||
/*!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 */;
|
||
/*!50503 SET NAMES utf8mb4 */;
|
||
/*!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 `firm_n_prod`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `firm_n_prod`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `firm_n_prod` (
|
||
`code` varchar(20) NOT NULL,
|
||
`n_prod` varchar(10) DEFAULT NULL,
|
||
PRIMARY KEY (`code`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `firm_n_prod`
|
||
--
|
||
|
||
LOCK TABLES `firm_n_prod` WRITE;
|
||
/*!40000 ALTER TABLE `firm_n_prod` DISABLE KEYS */;
|
||
INSERT INTO `firm_n_prod` VALUES
|
||
('1010117174','1'),('1033972427','1'),('11164476478','1'),('11212932825','1'),('11220388001','1'),('1128343125','1'),('11807506','2'),('1186341289','1'),
|
||
('118882692','1'),('1217957486','1'),('1232020820','1'),('1307012237','1'),('1375606900','1'),('1428342684','1'),('144312602','1'),('1452048','2'),
|
||
('145511905','1'),('151606446','1'),('152008168','1'),('1549474227','1'),('15613202','1'),('159511306','1'),('1601593550','1'),('1606833003','1'),
|
||
('16190441','1'),('1679596339','1'),('18065940','1'),('191912252','1'),('194210021','1'),('2010673','1'),('203314437','1'),('213386023','1'),('218633337','1'),
|
||
('22324879','1'),('2310825263','1'),('2311541114','1'),('2311581270','1'),('2311838590','2'),('2312490120','1'),('2312693498','1'),('2313209417','1'),
|
||
('2316161851','1'),('2316990095','1'),('2317245827','1'),('2317695802','1'),('2317841563','1'),('2320102626','1'),('2320475044','1'),('2321109759','1'),
|
||
('2321173423','1'),('2321857672','1'),('2324787028','1'),('2324844174','1'),('2326478786','1'),('2327031723','1'),('2327979389','1'),('2329375731','1'),
|
||
('2333843479','1'),('2334283182','1'),('2337843112','1'),('2337952436','1'),('2339188563','1'),('2339684065','1'),('2341555098','1'),('2343704209','1'),
|
||
('2347013470','1'),('2348941764','1'),('2349168009','1'),('2349656760','1'),('2350111843','1'),('2350418059','1'),('2352036411','1'),('2352538239','1'),
|
||
('2352951203','1'),('2354145351','1'),('2359644835','1'),('2379638202','1'),('2388955897','1'),('239053033','1'),('2424229017','2'),('24284343','1'),
|
||
('24673506','3'),('2481687500','1'),('249316393','1'),('25036634','1'),('251189644','1'),('25228347','1'),('2545430247','1'),('25624519','1'),
|
||
('25685135','2'),('259325842','1'),('25945288','1'),('26162741','1'),('2624175','1'),('26516263','1'),('27075840','1'),('271860868','1'),('2728939','2'),
|
||
('27731896','1'),('278221281','1'),('2791956547','1'),('2820140348','1'),('2944404352','1'),('2944892892','1'),('2965658107','1'),('2977767486','1'),
|
||
('29954548','1'),('3006753238','1'),('301209792','1'),('3025036704','1'),('3026382513','1'),('3029702382','1'),('3031009366','1'),('3045721313','1'),
|
||
('3047163873','1'),('3048263744','1'),('3069206426','1'),('3070859372','1'),('3072715478','1'),('3089095447','1'),('3100891962','1'),('3103797386','1'),
|
||
('3111033905','1'),('3113895788','1'),('3120341363','1'),('3122923980','1'),('3127420424','1'),('3133307899','1'),('314284469','1'),('3147511625','1'),
|
||
('3151203276','1'),('31654817','1'),('3177507356','1'),('3188352290','1'),('3188903709','1'),('3195502499','1'),('3203777710','1'),('3211956484','1'),
|
||
('3215814536','1'),('3221190269','1'),('3226664625','1'),('3267688490','1'),('3269039233','1'),('3269940677','1'),('3271705843','1'),('3288105727','1'),
|
||
('3299144127','1'),('3312358902','1'),('3331430009','1'),('3344297292','1'),('3372913783','1'),('3373311444','2'),('33822284','1'),('3384021594','1'),
|
||
('3391580446','1'),('3395900897','1'),('3398677646','1'),('3407754893','2'),('3409328588','1'),('343012684','1'),('3433628561','1'),('3442780535','1'),
|
||
('3444191691','1'),('3445244192','1'),('3445928818','1'),('3462551351','1'),('354897041','1'),('359737460','1'),('397847929','1'),('400488703','1'),
|
||
('400692942','1'),('4037576402','1'),('413274977','1'),('4144746564','1'),('4208851809','1'),('420984285','1'),('43407343','1'),('448033045','1'),
|
||
('4518234098','1'),('453289520','1'),('474279224','1'),('483081978','1'),('495782506','1'),('499022815','1'),('500189853','1'),('5007015990','1'),
|
||
('503176785','1'),('517717050','1'),('525126393','1'),('5278074','1'),('549184982','1'),('560866402','1'),('561545339','1'),('571058167','1'),
|
||
('581407487','1'),('5849940','1'),('591452402','1'),('59234665','1'),('593312758','1'),('594378026','1'),('607512171','1'),('615763365','1'),
|
||
('620220747','1'),('631449822','1'),('640320','1'),('644292599','1'),('653528340','1'),('654825436','1'),('658759701','1'),('677887241','1'),
|
||
('68804111','1'),('688155470','1'),('695995052','1'),('7','1'),('70634828','1'),('71271700','1'),('720737055','1'),('7299120','1'),('737770776','1'),
|
||
('74680108','1'),('750610681','1'),('762985858','1'),('771821595','1'),('774948022','1'),('80158773','1'),('829768','1'),('830662620','1'),
|
||
('857978527','1'),('863079','1'),('868012326','1'),('872394725','1'),('887840774','1'),('888356483','1'),('888395016','1'),('888478182','1'),
|
||
('888662519','1'),('9','1'),('930767828','1'),('9746245','1'),('996174506','1');
|
||
|
||
/*!40000 ALTER TABLE `firm_n_prod` 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 2025-02-12 21:15:21
|