[sql] ddadadasd
Viewer
- /* CREATE TABLE */
- CREATE TABLE blabla(
- `id` DOUBLE,
- `href` VARCHAR(100),
- `category` VARCHAR(100),
- `completionDate` VARCHAR(100),
- `description` VARCHAR(100),
- `expectedCompletionDate` VARCHAR(100),
- `externalId` VARCHAR(100),
- `orderDate` VARCHAR(100),
- `priority` DOUBLE,
- `requestedCompletionDate` VARCHAR(100),
- `requestedStartDate` VARCHAR(100),
- `channel0id` DOUBLE,
- `channel0role` VARCHAR(100),
- `channel0name` VARCHAR(100),
- `note0id` DOUBLE,
- `note0author` VARCHAR(100),
- `note0date` VARCHAR(100),
- `note0text` VARCHAR(100),
- `productOrderItem0id` DOUBLE,
- `productOrderItem0quantity` DOUBLE,
- `productOrderItem0action` VARCHAR(100),
- `productOrderItem0productisBundle` VARCHAR(100),
- `productOrderItem0producttype` VARCHAR(100),
- `productOrderItem0productOfferingid` DOUBLE,
- `productOrderItem0productOfferinghref` VARCHAR(100),
- `productOrderItem0productOfferingname` VARCHAR(100),
- `productOrderItem0productOrderItemRelationship0id` DOUBLE,
- `productOrderItem0productOrderItemRelationship0relationshipType` VARCHAR(100),
- `productOrderItem0productOrderItemRelationship1id` DOUBLE,
- `productOrderItem0productOrderItemRelationship1relationshipType` VARCHAR(100),
- `productOrderItem0productOrderItemRelationship2id` DOUBLE,
- `productOrderItem0productOrderItemRelationship2relationshipType` VARCHAR(100),
- `productOrderItem0state` VARCHAR(100),
- `productOrderItem0type` VARCHAR(100),
- `productOrderItem1id` DOUBLE,
- `productOrderItem1quantity` DOUBLE,
- `productOrderItem1action` VARCHAR(100),
- `productOrderItem1itemPrice0description` VARCHAR(100),
- `productOrderItem1itemPrice0name` VARCHAR(100),
- `productOrderItem1itemPrice0priceType` VARCHAR(100),
- `productOrderItem1itemPrice0pricetaxRate` DOUBLE,
- `productOrderItem1itemPrice0pricedutyFreeAmountunit` VARCHAR(100),
- `productOrderItem1itemPrice0pricedutyFreeAmountvalue` DOUBLE,
- `productOrderItem1itemPrice0pricetaxIncludedAmountunit` VARCHAR(100),
- `productOrderItem1itemPrice0pricetaxIncludedAmountvalue` DOUBLE,
- `productOrderItem1payment0id` DOUBLE,
- `productOrderItem1payment0href` VARCHAR(100),
- `productOrderItem1payment0name` VARCHAR(100),
- `productOrderItem1payment0type` VARCHAR(100),
- `productOrderItem1payment0referredType` VARCHAR(100),
- `productOrderItem1productisBundle` VARCHAR(100),
- `productOrderItem1producttype` VARCHAR(100),
- `productOrderItem1productproductCharacteristic0name` VARCHAR(100),
- `productOrderItem1productproductCharacteristic0valueType` VARCHAR(100),
- `productOrderItem1productproductCharacteristic0value` VARCHAR(100),
- `productOrderItem1productproductSpecificationid` DOUBLE,
- `productOrderItem1productproductSpecificationhref` VARCHAR(100),
- `productOrderItem1productproductSpecificationname` VARCHAR(100),
- `productOrderItem1productproductSpecificationversion` DOUBLE,
- `productOrderItem1productproductSpecificationtype` VARCHAR(100),
- `productOrderItem1productOfferingid` DOUBLE,
- `productOrderItem1productOfferinghref` VARCHAR(100),
- `productOrderItem1productOfferingname` VARCHAR(100),
- `productOrderItem1state` VARCHAR(100),
- `productOrderItem1type` VARCHAR(100),
- `productOrderItem2id` DOUBLE,
- `productOrderItem2quantity` DOUBLE,
- `productOrderItem2action` VARCHAR(100),
- `productOrderItem2billingAccountid` DOUBLE,
- `productOrderItem2billingAccounthref` VARCHAR(100),
- `productOrderItem2billingAccounttype` VARCHAR(100),
- `productOrderItem2itemPrice0description` VARCHAR(100),
- `productOrderItem2itemPrice0name` VARCHAR(100),
- `productOrderItem2itemPrice0priceType` VARCHAR(100),
- `productOrderItem2itemPrice0recurringChargePeriod` VARCHAR(100),
- `productOrderItem2itemPrice0pricetaxRate` DOUBLE,
- `productOrderItem2itemPrice0pricedutyFreeAmountunit` VARCHAR(100),
- `productOrderItem2itemPrice0pricedutyFreeAmountvalue` DOUBLE,
- `productOrderItem2itemPrice0pricetaxIncludedAmountunit` VARCHAR(100),
- `productOrderItem2itemPrice0pricetaxIncludedAmountvalue` DOUBLE,
- `productOrderItem2itemPrice0priceAlteration0applicationDuration` DOUBLE,
- `productOrderItem2itemPrice0priceAlteration0description` VARCHAR(100),
- `productOrderItem2itemPrice0priceAlteration0name` VARCHAR(100),
- `productOrderItem2itemPrice0priceAlteration0priceType` VARCHAR(100),
- `productOrderItem2itemPrice0priceAlteration0priority` DOUBLE,
- `productOrderItem2itemPrice0priceAlteration0recurringChargePeriod` VARCHAR(100),
- `productOrderItem2itemPrice0priceAlteration0pricepercentage` DOUBLE,
- `productOrderItem2itemPrice0priceAlteration0pricetaxRate` DOUBLE,
- `productOrderItem2itemPrice0priceAlteration0pricetype` VARCHAR(100),
- `productOrderItem2itemTerm0description` VARCHAR(100),
- `productOrderItem2itemTerm0name` VARCHAR(100),
- `productOrderItem2itemTerm0durationamount` DOUBLE,
- `productOrderItem2itemTerm0durationunits` VARCHAR(100),
- `productOrderItem2productisBundle` VARCHAR(100),
- `productOrderItem2producttype` VARCHAR(100),
- `productOrderItem2productproductSpecificationid` DOUBLE,
- `productOrderItem2productproductSpecificationhref` VARCHAR(100),
- `productOrderItem2productproductSpecificationname` VARCHAR(100),
- `productOrderItem2productproductSpecificationversion` DOUBLE,
- `productOrderItem2productproductSpecificationtype` VARCHAR(100),
- `productOrderItem2productOfferingid` DOUBLE,
- `productOrderItem2productOfferinghref` VARCHAR(100),
- `productOrderItem2productOfferingname` VARCHAR(100),
- `productOrderItem2productOrderItemRelationship0id` DOUBLE,
- `productOrderItem2productOrderItemRelationship0relationshipType` VARCHAR(100),
- `productOrderItem2state` VARCHAR(100),
- `productOrderItem2type` VARCHAR(100),
- `productOrderItem3id` DOUBLE,
- `productOrderItem3quantity` DOUBLE,
- `productOrderItem3action` VARCHAR(100),
- `productOrderItem3productisBundle` VARCHAR(100),
- `productOrderItem3producttype` VARCHAR(100),
- `productOrderItem3productproductCharacteristic0name` VARCHAR(100),
- `productOrderItem3productproductCharacteristic0valueType` VARCHAR(100),
- `productOrderItem3productproductCharacteristic0value` VARCHAR(100),
- `productOrderItem3productproductSpecificationid` DOUBLE,
- `productOrderItem3productproductSpecificationhref` VARCHAR(100),
- `productOrderItem3productproductSpecificationname` VARCHAR(100),
- `productOrderItem3productproductSpecificationversion` DOUBLE,
- `productOrderItem3productproductSpecificationtype` VARCHAR(100),
- `productOrderItem3productOfferingid` DOUBLE,
- `productOrderItem3productOfferinghref` VARCHAR(100),
- `productOrderItem3productOfferingname` VARCHAR(100),
- `productOrderItem3productOrderItemRelationship0id` DOUBLE,
- `productOrderItem3productOrderItemRelationship0relationshipType` VARCHAR(100),
- `productOrderItem3state` VARCHAR(100),
- `productOrderItem3type` VARCHAR(100),
- `relatedParty0id` VARCHAR(100),
- `relatedParty0href` VARCHAR(100),
- `relatedParty0name` VARCHAR(100),
- `relatedParty0role` VARCHAR(100),
- `relatedParty0type` VARCHAR(100),
- `relatedParty0referredType` VARCHAR(100),
- `relatedParty1id` VARCHAR(100),
- `relatedParty1href` VARCHAR(100),
- `relatedParty1name` VARCHAR(100),
- `relatedParty1type` VARCHAR(100),
- `relatedParty1referredType` VARCHAR(100),
- `state` VARCHAR(100),
- `type` VARCHAR(100)
- );
- /* INSERT QUERY NO: 1 */
- INSERT INTO blabla(`id`, `href`, `category`, `completionDate`, `description`, `expectedCompletionDate`, `externalId`, `orderDate`, `priority`, `requestedCompletionDate`, `requestedStartDate`, `channel0id`, `channel0role`, `channel0name`, `note0id`, `note0author`, `note0date`, `note0text`, `productOrderItem0id`, `productOrderItem0quantity`, `productOrderItem0action`, `productOrderItem0productisBundle`, `productOrderItem0producttype`, `productOrderItem0productOfferingid`, `productOrderItem0productOfferinghref`, `productOrderItem0productOfferingname`, `productOrderItem0productOrderItemRelationship0id`, `productOrderItem0productOrderItemRelationship0relationshipType`, `productOrderItem0productOrderItemRelationship1id`, `productOrderItem0productOrderItemRelationship1relationshipType`, `productOrderItem0productOrderItemRelationship2id`, `productOrderItem0productOrderItemRelationship2relationshipType`, `productOrderItem0state`, `productOrderItem0type`, `productOrderItem1id`, `productOrderItem1quantity`, `productOrderItem1action`, `productOrderItem1itemPrice0description`, `productOrderItem1itemPrice0name`, `productOrderItem1itemPrice0priceType`, `productOrderItem1itemPrice0pricetaxRate`, `productOrderItem1itemPrice0pricedutyFreeAmountunit`, `productOrderItem1itemPrice0pricedutyFreeAmountvalue`, `productOrderItem1itemPrice0pricetaxIncludedAmountunit`, `productOrderItem1itemPrice0pricetaxIncludedAmountvalue`, `productOrderItem1payment0id`, `productOrderItem1payment0href`, `productOrderItem1payment0name`, `productOrderItem1payment0type`, `productOrderItem1payment0referredType`, `productOrderItem1productisBundle`, `productOrderItem1producttype`, `productOrderItem1productproductCharacteristic0name`, `productOrderItem1productproductCharacteristic0valueType`, `productOrderItem1productproductCharacteristic0value`, `productOrderItem1productproductSpecificationid`, `productOrderItem1productproductSpecificationhref`, `productOrderItem1productproductSpecificationname`, `productOrderItem1productproductSpecificationversion`, `productOrderItem1productproductSpecificationtype`, `productOrderItem1productOfferingid`, `productOrderItem1productOfferinghref`, `productOrderItem1productOfferingname`, `productOrderItem1state`, `productOrderItem1type`, `productOrderItem2id`, `productOrderItem2quantity`, `productOrderItem2action`, `productOrderItem2billingAccountid`, `productOrderItem2billingAccounthref`, `productOrderItem2billingAccounttype`, `productOrderItem2itemPrice0description`, `productOrderItem2itemPrice0name`, `productOrderItem2itemPrice0priceType`, `productOrderItem2itemPrice0recurringChargePeriod`, `productOrderItem2itemPrice0pricetaxRate`, `productOrderItem2itemPrice0pricedutyFreeAmountunit`, `productOrderItem2itemPrice0pricedutyFreeAmountvalue`, `productOrderItem2itemPrice0pricetaxIncludedAmountunit`, `productOrderItem2itemPrice0pricetaxIncludedAmountvalue`, `productOrderItem2itemPrice0priceAlteration0applicationDuration`, `productOrderItem2itemPrice0priceAlteration0description`, `productOrderItem2itemPrice0priceAlteration0name`, `productOrderItem2itemPrice0priceAlteration0priceType`, `productOrderItem2itemPrice0priceAlteration0priority`, `productOrderItem2itemPrice0priceAlteration0recurringChargePeriod`, `productOrderItem2itemPrice0priceAlteration0pricepercentage`, `productOrderItem2itemPrice0priceAlteration0pricetaxRate`, `productOrderItem2itemPrice0priceAlteration0pricetype`, `productOrderItem2itemTerm0description`, `productOrderItem2itemTerm0name`, `productOrderItem2itemTerm0durationamount`, `productOrderItem2itemTerm0durationunits`, `productOrderItem2productisBundle`, `productOrderItem2producttype`, `productOrderItem2productproductSpecificationid`, `productOrderItem2productproductSpecificationhref`, `productOrderItem2productproductSpecificationname`, `productOrderItem2productproductSpecificationversion`, `productOrderItem2productproductSpecificationtype`, `productOrderItem2productOfferingid`, `productOrderItem2productOfferinghref`, `productOrderItem2productOfferingname`, `productOrderItem2productOrderItemRelationship0id`, `productOrderItem2productOrderItemRelationship0relationshipType`, `productOrderItem2state`, `productOrderItem2type`, `productOrderItem3id`, `productOrderItem3quantity`, `productOrderItem3action`, `productOrderItem3productisBundle`, `productOrderItem3producttype`, `productOrderItem3productproductCharacteristic0name`, `productOrderItem3productproductCharacteristic0valueType`, `productOrderItem3productproductCharacteristic0value`, `productOrderItem3productproductSpecificationid`, `productOrderItem3productproductSpecificationhref`, `productOrderItem3productproductSpecificationname`, `productOrderItem3productproductSpecificationversion`, `productOrderItem3productproductSpecificationtype`, `productOrderItem3productOfferingid`, `productOrderItem3productOfferinghref`, `productOrderItem3productOfferingname`, `productOrderItem3productOrderItemRelationship0id`, `productOrderItem3productOrderItemRelationship0relationshipType`, `productOrderItem3state`, `productOrderItem3type`, `relatedParty0id`, `relatedParty0href`, `relatedParty0name`, `relatedParty0role`, `relatedParty0type`, `relatedParty0referredType`, `relatedParty1id`, `relatedParty1href`, `relatedParty1name`, `relatedParty1type`, `relatedParty1referredType`, `state`, `type`)
- VALUES (30001, 'https://{apiRoot}/productOrderingManagement/v4/productOrder/30001', 'B2C product order', '2019-05-02T08:13:59.506Z', 'Product Order illustration sample', '2019-05-02T08:13:59.506Z', 'PO-456', '2019-04-30T08:13:59.506Z', 1, '2019-05-02T08:13:59.506Z', '2019-05-03T08:13:59.506Z', 1, 'Used channel for order capture', 'Online chanel', 1, 'Jean Pontus', '2019-04-30T08:13:59.509Z', 'This is a TMF product order illustration', 100, 1, 'add', 'true', 'Product', 14277, 'https://host:port/productCatalogManagement/v4/productOffering/14277', 'TMF25', 110, 'bundles', 120, 'bundles', 130, 'bundles', 'completed', 'ProductOrderItem', 110, 1, 'add', 'Access Fee', 'Access Fee', 'nonRecurring', 0, 'EUR', 0.99, 'EUR', 0.99, 2365, 'https://host:port/paymentManagement/v4/cashPayment/2365', 'Cash payment for access fee', 'CashPayment', 'Payment', 'false', 'Product', 'TEL_MSISDN', 'string', '415 279 7439', 14307, 'https://host:port/productCatalogManagement/v4/productSpecification/14307', 'Mobile Telephony', 1, 'ProductSpecificationRef', 14305, 'https://host:port/productCatalogManagement/v4/productOffering/14305', 'TMF Mobile Telephony', 'completed', 'ProductOrderItem', 120, 1, 'add', 1513, 'https://host:port/billingAccountManagement/v4/billingAccount/1513', 'BillingAccount', 'Tariff plan monthly fee', 'MonthlyFee', 'recurring', 'month', 0, 'EUR', 20, 'EUR', 20, 3, '20% for first 3 months', 'WelcomeDiscount', 'recurring', 1, 'month', 20, 0, 'price', 'Tariff plan 12 Months commitment', '12Months', 12, 'month', 'false', 'Product', 14395, 'https://host:port/productCatalogManagement/v4/productSpecification/14395', 'TMF Tariff plan', 1, 'ProductSpecificationRef', 14344, 'https://host:port/productCatalogManagement/v4/productOffering/14344', 'TMF Tariff Plan', 110, 'reliesOn', 'completed', 'ProductOrderItem', 130, 1, 'add', 'false', 'Product', 'CoverageOptions', 'string', 'National', 14353, 'https://host:port/productCatalogManagement/v4/productSpecification/14353', 'Coverage', 1, 'ProductSpecificationRef', 14354, 'https://host:port/productCatalogManagement/v4/productOffering/14354', 'Coverage Options', 110, 'reliesOn', 'completed', 'ProductOrderItem', '456-dd-df45', 'https://host:port/partyManagement/v4/individual/456-dd-df45', 'Joe Doe', 'Seller', 'RelatedParty', 'Individual', 'ff55-hjy4', 'https://host:port/partyRoleManagement/v4/customer/ff55-hjy4', 'Jean Pontus', 'RelatedParty', 'Customer', 'completed', 'ProductOrder');
Editor
You can edit this paste and save as new: