[Renuka]

Attached screen shot of the yog

[Renuka]

Thank you very much for your replies

 

Mysql Version

---

> 5.5.16-log

SqlYog  

---

>1.0.0.1

UI—>its a UI with jsp’s

used Hibernate3 in application.

 

Application doesn’t contain any specific client side operation for read/write data from db.

This problem is only for the few rows and it doesn’t have any encrypted data.

 

CREATE TABLE `CUSTOMERORDER` (

  `Pk` varchar(32) NOT NULL,

  `PurchCustomerPk` varchar(32) DEFAULT NULL,

  `RegCustomerPk` varchar(32) DEFAULT NULL,

  `SalesRep` varchar(32) NOT NULL DEFAULT ‘Unknown’ COMMENT ‘OSS System Name Of Sales Rep Placing The Order’,

  `UpdateRep` varchar(32) DEFAULT NULL COMMENT ‘Rep That Last Updated The Record’,

  `OfferingPk` bigint(20) unsigned DEFAULT NULL COMMENT ‘Reference To The Purchased Offer’,

  `BundleName` varchar(64) DEFAULT NULL COMMENT ‘Reference To The Bundle’,

  `PaymentMethodPk` varchar(32) NOT NULL,

  `Currency` varchar(3) NOT NULL DEFAULT ‘USD’ COMMENT ‘Order Currency’,

  `CustomerAddressBillPk` varchar(32) NOT NULL COMMENT ‘Reference To Customer Billing Address’,

  `CustomerAddressSvcPk` varchar(32) DEFAULT NULL COMMENT ‘Reference To Customer Service Address’,

  `CustomerAddressShipPk` varchar(32) NOT NULL COMMENT ‘Reference To Customer Shipping Address’,

  `PGID` int(10) unsigned NOT NULL COMMENT ‘Processing GroupID’,

  `OrderID` varchar(32) NOT NULL,

  `Created` datetime NOT NULL,

  `Updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `ProcessOn` datetime NOT NULL DEFAULT ‘1900-01-01 00:00:00’ COMMENT ‘Date/Time After Which The Order Can Be Processed’,

  `Status` enum(‘NEW’,’REJECT’,’PAY’,’PAID’,’FAILPAY’,’PARTPAID’,’DELAYPROV’,’READYIN’,’READYOUT’,’PROV’,’PROVPART’,’PROVFAIL’,’INSERV’,’OUTAGE’,’SUSPEND’,’TERM’,’DELAYPAY’,’DELAYFUL’) NOT NULL DEFAULT ‘NEW’ COMMENT ‘Order Status Indicator (ENUM)’,

  PRIMARY KEY (`Pk`),

  UNIQUE KEY `OrderID` (`OrderID`),

  KEY `Indx_CORD_Referal` (`PGID`),

  KEY `FK_CO_REF` (`RegCustomerPk`),

  KEY `FK_CO_SVCADDR` (`CustomerAddressSvcPk`),

  KEY `FK_CO_BILLADDR` (`CustomerAddressBillPk`),

  KEY `FK_CO_SHIPADDR` (`CustomerAddressShipPk`),

  KEY `Indx_CO_PGID` (`PGID`),

  KEY `Indx_CO_ICID` (`PurchCustomerPk`),

  KEY `FK_CO_OFFER` (`OfferingPk`),

  KEY `FK_CO_BUND` (`BundleName`) USING BTREE,

  KEY `OStatus` (`Status`),

  CONSTRAINT `FK_CO_BILLADDR` FOREIGN KEY (`CustomerAddressBillPk`) REFERENCES `CUSTOMERADDRESS` (`Pk`),

  CONSTRAINT `FK_CO_BUNDLE` FOREIGN KEY (`BundleName`) REFERENCES `BUNDLE` (`Name`) ON UPDATE CASCADE,

  CONSTRAINT `FK_CO_OFFER` FOREIGN KEY (`OfferingPk`) REFERENCES `OFFERING` (`Pk`),

  CONSTRAINT `FK_CO_SHIPADDR` FOREIGN KEY (`CustomerAddressShipPk`) REFERENCES `CUSTOMERADDRESS` (`Pk`),

  CONSTRAINT `FK_CO_SVCADDR` FOREIGN KEY (`CustomerAddressSvcPk`) REFERENCES `CUSTOMERADDRESS` (`Pk`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=’Table For Customer Orders Placed For Products’

[Author]

Posts