MSQL - Setup audit tables using triggers

$10-30 AUD

Imeghairiwa

Imechapishwa

almost 5 years ago

$10-30 AUD

Kulipwa wakati wa kufikishwa

This is quick job for someone who has already done this. We have 4 tables: packages, transactions, book history, user table. We need to create audit table for each to track any changes made to above. So, whenever there is insert, update or delete, it creates new entry in the packages_audit, ... etc tables. Candiate: * show me example of what you done before * deliverable is mysql statements that we can deploy to install triggers. Obviously put if exists delete trigger on top so that it is rerunnable. also, obviously need to create the tables as well.

MySQL

Kitambulisho cha mradi: 19771957

Kuhusu mradi

10 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

10 wafanyakazi huru wana zabuni kwa wastani $34 AUD kwa kazi hii

@Creativeartbd

Hi there, Simple and easy job for me. I will write that SQL query within couples of an hour but before I to do so I need the access to your website. You may send me the FTP access too. Basically, I will write few SQL queries for every query you run for that 4 tables. That's you will be full audit report for those tables transactions. Thanks.

$30 AUD ndani ya siku 1

4.8

(36 hakiki)

5.7

@kishan1383

Dear Sir/Ma'am, I am full time experienced web developer. If you want to check my previous work then you can check my portfolio for your reference, I have done many project in PHP and also done Angular 4,5,6 project with back end PHP. Just message me once if you want to discuss more about project as I always be there. Waiting for your reply Thanks & Regards, Kishan Chauhan

$30 AUD ndani ya siku 1

5.0

(12 hakiki)

3.6

@rinabuoy13

Hello, I am an independent, experienced ML expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$100 AUD ndani ya siku 1

5.0

(3 hakiki)

3.1

@vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.5 years experience in MS SQL Server and 3 years experience in MySQL. Please let me know more details and when we will start. Sky pe jikenjd

$29 AUD ndani ya siku 1

4.9

(6 hakiki)

2.9

@techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"

$27 AUD ndani ya siku 7

0.0

(0 hakiki)

0.0

@ranjanrahul910

I have an experience of 2+ yrs in pl/SQL. i am proficient in writing procedure, function, package, trigger. I have also experience in nosql mongodb.

$25 AUD ndani ya siku 5

0.0

(0 hakiki)

0.0

@alirazaidi

Hi i am Ali Raza, database consultant . I have 12 years of experience in industry and Oracle certified professional in Advance pl/sql developer and Oracle certified associate in DBA. Also proficient in MS sql,mysql ,postgre-sql and db2. Ping me on skype to discuss more details. skype:alirazaidi

$12 AUD ndani ya siku 1