{"slug":"pdf-rechnungsverwaltung","name":"PDF-Rechnungsverwaltung","description":"Mit diesem Plugin kannst du ganz einfach individuelle Rechnungen im PDF-Format erstellen und verwalten.","author":"mh6webentwicklung","active_installs":0,"version":"0.0.1","wp_org_url":"https://wordpress.org/plugins/pdf-rechnungsverwaltung/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"invoice","full_table_name":"wp_invoice","description":"Stores invoice data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"filename","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(11,2)","nullable":true,"primary_key":false},{"name":"payment_target","type":"int(11)","nullable":true,"primary_key":false},{"name":"start_text","type":"text","nullable":true,"primary_key":false},{"name":"end_text","type":"text","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"paid","type":"date","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_invoice` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(200) DEFAULT NULL, `date` date DEFAULT NULL, `amount` decimal(11,2) DEFAULT NULL, `payment_target` int(11) DEFAULT NULL, `start_text` text, `end_text` text, `customer_id` int(11) DEFAULT NULL, `paid` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"invoice_customer","full_table_name":"wp_invoice_customer","description":"Stores invoice customer data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"salutation","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"company","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"zip","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"mail","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"iban","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"bic","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"bank_name","type":"varchar(200)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_invoice_customer` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `salutation` varchar(200) DEFAULT NULL, `first_name` varchar(200) DEFAULT NULL, `last_name` varchar(200) DEFAULT NULL, `company` varchar(200) DEFAULT NULL, `address` varchar(200) DEFAULT NULL, `zip` varchar(50) DEFAULT NULL, `city` varchar(200) DEFAULT NULL, `country` varchar(200) DEFAULT NULL, `mail` varchar(200) DEFAULT NULL, `iban` varchar(200) DEFAULT NULL, `bic` varchar(200) DEFAULT NULL, `bank_name` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"invoice_position","full_table_name":"wp_invoice_position","description":"Stores invoice position data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"invoice_id","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"position","type":"int(11)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(11,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(11,2)","nullable":true,"primary_key":false},{"name":"unit","type":"varchar(200)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_invoice_position` ( `invoice_id` int(11) unsigned NOT NULL, `position` int(11) NOT NULL, `description` text, `price` decimal(11,2) DEFAULT NULL, `amount` decimal(11,2) DEFAULT NULL, `unit` varchar(200) DEFAULT NULL, PRIMARY KEY (`invoice_id`,`position`) ) ENGINE"}],"table_count":3}