mysql - How can i store old and new updated value at same time? -


i have built database:

slots(user_id,current_slots,old_slots,current_expiry,old_expiry);    credit_transfer(transfer_id, sender_id, receiver_id,date,num_slots);   history(history_id, reseller_id,transfer_id)

user_id coming user table.
sender_id , receiver_id foreign keys of user_id.
reseller_id foreign key of user table

when user buys new slots, entry recorded in history table new history id, i.e slots table.

the problem facing when new history_id added, i.e when new slots added, slots previous history id updated.

how can change design, old history id row doesn't change.

well simplest thing place unique constraint on userid. ensure not have duplicates same user entry.

i not sure language using or if you're using stored procedures. in case, detect duplicate/unique constraint exception , update slot count or expiry information.


Comments

Post a Comment

Popular posts from this blog

r - Trouble relying on third party package imports in my package -

my package uses ggplot2 extensively make custom plots. import ggplot2 in namespace file. can build, install, , load package r without errors. when call function package, complains can't find function in imported package. function called had absolute nothing plotting , didn't make use of ggplot2 . how can make function calls package work without these types of errors? error in theme_beata() (from plot.r#14) : not find function "theme_classic" the first function erroring is: #' custom ggplot2 theme beata #' @import ggplot2 #' @family themes #' inheritparams ggplot2::theme_classic #' @export theme_beata <- function(base_size = 14, base_family="serif", ticks = true) { ret <- theme_classic() + theme(axis.line = element_line(size=0.6), axis.text = element_text(size = base_size), axis.title = element_text(size= base_size + 2), title = element_text(size=base_size + 4)) if (...
Read more

Payment information shows nothing in one page checkout page magento -

i using magento ver. 1.9.1.0 want remove shipping information , shipping method step 1 page checkout page. changed code in core file like in app\code\core\mage\checkout\block\onepage.php public function getsteps() { $steps = array(); $stepcodes = $this->_getstepcodes(); /* remove shipping address , shipping method */ $excludestep=array_diff($stepcodes,array('shipping','shipping_method')); //$excludestep=$stepcodes; if ($this->iscustomerloggedin()) { $stepcodes = array_diff($excludestep, array('login')); } foreach ($excludestep $step) { $steps[$step] = $this->getcheckout()->getstepdata($step); } return $steps; } and in app\code\core\mage\checkout\controllers\onepagecontroller.php public function savebillingaction() { if ($this->_expireajax()) { return; } if ($this->getrequest()-...
Read more