-- MySQL dump 10.18  Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: archiv
-- ------------------------------------------------------
-- Server version	10.3.27-MariaDB-0+deb10u1

/*!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 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 `canvas`
--

DROP TABLE IF EXISTS `canvas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `canvas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `c_registr` timestamp NOT NULL DEFAULT current_timestamp(),
  `c_code` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `c_email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `c_phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `c_zip` int(8) DEFAULT NULL COMMENT 'postal zip',
  `lastLogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `c_count` int(11) NOT NULL,
  `c_trial14` int(11) DEFAULT NULL COMMENT 'trial period in days',
  `c_remark` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `c_enabled` tinyint(1) NOT NULL,
  `c_upload` tinyint(1) NOT NULL DEFAULT 0,
  `c_2email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'send docs to',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `canvas`
--

LOCK TABLES `canvas` WRITE;
/*!40000 ALTER TABLE `canvas` DISABLE KEYS */;
INSERT INTO `canvas` VALUES (1,'Drs. Test/Müller','2021-09-23 06:18:10','wA56','egerlach@aiai.de','555555',NULL,'2021-10-17 09:39:55',516,0,'',0,0,'egerlach@aiai.de'),(2,'Drs. Jim & Fred Miller','2021-09-23 06:17:03','gR03','egerlach@aiai.de','555555',NULL,'2021-11-01 21:19:52',173,0,'',1,1,NULL),(3,'My name','2021-08-26 19:22:08','3Xf4','email','phone',NULL,'2021-08-26 19:22:08',3,0,'',1,0,NULL),(4,'Dr. Testtest','2021-08-25 16:46:09','p98G','egerlach@aiai.de','065328447',NULL,'2021-08-25 16:46:09',0,0,'',1,0,NULL),(15,'Dr. Schmitt, Testdorf','2021-10-10 06:37:26','s8V7','egerlach@aiai.de','01719287307',76448,'2021-11-01 00:58:23',307,0,'',1,1,'egerlach@zeitprax.com'),(152,'Dr. Schmitt, Testdorf','2021-10-16 19:13:01','a2H9','egerlach@aiai.de','01719287307',76448,'2021-10-16 19:16:24',1,0,'',1,0,NULL),(153,'Dr. Schmitt, Testdorf','2021-10-16 19:16:46','A4r6','egerlach@aiai.de','01719287307',76448,'2021-10-16 19:16:46',0,0,'',1,0,NULL),(181,'Praxis Geiselgasteig Grünwald','2021-11-01 16:56:12','Al65','mjk@praxis-geiselgasteig.de','+498964954228',82031,'2021-11-01 16:56:12',0,14,NULL,1,0,NULL),(182,'Kraus Grünwald','2021-11-01 20:23:35','86jH','mjk@praxis-geiselgasteig.de','+498964954228',82031,'2021-11-01 21:24:15',11,14,NULL,1,0,NULL);
/*!40000 ALTER TABLE `canvas` 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 2021-11-02  1:18:52
