 --
 
 create table sc_denorm_user(
-	id int(11) NOT NULL auto_increment,
-  login_id int not null,
+    id int(11) NOT NULL auto_increment,
+    login_id int not null,
 	name varchar(64) not null ,
 	nick_name varchar(32) ,
-  first_name  varchar(32) ,
-  last_name  varchar(32) ,
-  email  varchar(64) ,
-  provider varchar(16) NOT NULL,
-  website varchar(128) ,
-  blog varchar(128) ,
-  photo_url varchar(128) ,
-  location varchar(32) ,
-  about_me varchar(512),
-  age int ,
-  bu_bit int default 0,
-  tu_bit int default 0,
-  gender varchar(1) ,
-  ip_address varchar(46),
+    first_name  varchar(32) ,
+    last_name  varchar(32) ,
+    email  varchar(64) ,
+    provider varchar(16) NOT NULL,
+    website varchar(128) ,
+    blog varchar(128) ,
+    photo_url varchar(128) ,
+    location varchar(32) ,
+    about_me varchar(512),
+    age int ,
+    bu_bit int default 0,
+    tu_bit int default 0,
+    gender varchar(1) ,
+    ip_address varchar(46),
 	created_on TIMESTAMP  default '0000-00-00 00:00:00',
-  updated_on TIMESTAMP   default '0000-00-00 00:00:00',
+    updated_on TIMESTAMP   default '0000-00-00 00:00:00',
 	PRIMARY KEY (id)) ENGINE = InnoDB default character set utf8 collate utf8_general_ci;
-
+	
 
 
 DELIMITER //

) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


DROP PROCEDURE IF EXISTS  UPDATE_SITE_TRACKER ;

DELIMITER //

  PRIMARY KEY ( id ),
  UNIQUE KEY  uniq_id  ( google_id )
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;




DROP TRIGGER IF EXISTS trg_google_user_cp;
