Source

myswap / 1 / code / App / sql.txt

Full commit
~-~-create_database-~-~
CREATE TABLE think_user (
user_id INT(11) NOT NULL AUTO_INCREMENT,
username CHAR(20) NOT NULL, 
email CHAR(40) NOT NULL, 
password VARCHAR(40) NOT NULL,
friends TEXT NOT NULL,
userAliases TEXT NOT NULL,
PRIMARY KEY (user_id)
);

CREATE TABLE think_swap (
swap_id INT(11) NOT NULL AUTO_INCREMENT,
user_id INT(11) NOT NULL,
alias CHAR(20) NOT NULL, 
content TEXT NOT NULL,
PRIMARY KEY (swap_id)
);
~-~-create_database-~-~