CREATE TABLE users (
  user_id int NOT NULL AUTO_INCREMENT,
  username varchar(50) NOT NULL,
  password varchar(255) NOT NULL,
  email varchar(100) NOT NULL,
  mobile_number varchar(15) DEFAULT NULL,
  created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  utr varchar(45) DEFAULT NULL,
  refer_code varchar(45) NOT NULL,
  is_subscribe tinyint(1) NOT NULL DEFAULT '0',
  class_name varchar(45) NOT NULL,
  refer_by int DEFAULT NULL,
  referno int DEFAULT '0',
  PRIMARY KEY (user_id),
  UNIQUE KEY username (username),
  UNIQUE KEY email (email)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 

Q1JFQVRFIFRBQkxFIHVzZXJzICgKICB1c2VyX2lkIGludCBOT1QgTlVMTCBBVVRPX0lOQ1JFTUVOVCwKICB1c2VybmFtZSB2YXJjaGFyKDUwKSBOT1QgTlVMTCwKICBwYXNzd29yZCB2YXJjaGFyKDI1NSkgTk9UIE5VTEwsCiAgZW1haWwgdmFyY2hhcigxMDApIE5PVCBOVUxMLAogIG1vYmlsZV9udW1iZXIgdmFyY2hhcigxNSkgREVGQVVMVCBOVUxMLAogIGNyZWF0ZWRfYXQgdGltZXN0YW1wIE5VTEwgREVGQVVMVCBDVVJSRU5UX1RJTUVTVEFNUCwKICB1dHIgdmFyY2hhcig0NSkgREVGQVVMVCBOVUxMLAogIHJlZmVyX2NvZGUgdmFyY2hhcig0NSkgTk9UIE5VTEwsCiAgaXNfc3Vic2NyaWJlIHRpbnlpbnQoMSkgTk9UIE5VTEwgREVGQVVMVCAnMCcsCiAgY2xhc3NfbmFtZSB2YXJjaGFyKDQ1KSBOT1QgTlVMTCwKICByZWZlcl9ieSBpbnQgREVGQVVMVCBOVUxMLAogIHJlZmVybm8gaW50IERFRkFVTFQgJzAnLAogIFBSSU1BUlkgS0VZICh1c2VyX2lkKSwKICBVTklRVUUgS0VZIHVzZXJuYW1lICh1c2VybmFtZSksCiAgVU5JUVVFIEtFWSBlbWFpbCAoZW1haWwpCikgRU5HSU5FPUlubm9EQiBBVVRPX0lOQ1JFTUVOVD00NSBERUZBVUxUIENIQVJTRVQ9dXRmOG1iNCBDT0xMQVRFPXV0ZjhtYjRfMDkwMF9haV9jaTsKCg==