· 9 years ago · Oct 27, 2016, 08:40 AM
1/*
2CREATE TABLE IF NOT EXISTS USERTABLE (
3UserID INT(20) NOT NULL AUTO_INCREMENT,
4Username VARCHAR(20) NOT NULL,
5Money BIGINT(255) NOT NULL,
6ManagerBought INT(1) NOT NULL,
7PRIMARY KEY (UserID)
8);
9
10
11CREATE TABLE IF NOT EXISTS LOGINDATA (
12LoginID INT(10) NOT NULL AUTO_INCREMENT,
13LoginName VARCHAR(255) NOT NULL,
14Passcode VARCHAR(255) NOT NULL,
15UserID INT(10) NOT NULL,
16PRIMARY KEY (LoginID),
17FOREIGN KEY (UserID) REFERENCES USERTABLE(UserID)
18);
19*/