SHARE
TWEET

Untitled

a guest Apr 25th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -------------------------------------------------------------------
  2. -- Make new table
  3. -------------------------------------------------------------------
  4. CREATE TABLE admin_user_login_log
  5. (
  6.     id serial NOT NULL,
  7.     adminid integer NOT NULL,
  8.     last_success timestamp without time zone,
  9.     last_fail timestamp without time zone,
  10.     success_count integer
  11.     failed_count integer
  12.     CONSTRAINT admin_user_login_log_pkey PRIMARY KEY (id),
  13.     CONSTRAINT admin_user_login_log_fkey FOREIGN KEY (adminid)
  14.         REFERENCES admin_user (id) MATCH SIMPLE
  15.         ON UPDATE NO ACTION
  16.         ON DELETE NO ACTION
  17. );
  18. -------------------------------------------------------------------
  19. -- Set ownership to new table
  20. -------------------------------------------------------------------
  21. ALTER TABLE admin_user_login_log OWNER to openwifi;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top