CREATE TABLE messages(
msg_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
parent_id INT NOT NULL,
status VARCHAR(3) NOT NULL,
from_who VARCHAR(30) NOT NULL,
to_who VARCHAR(30) NOT NULL,
sent_when DATETIME NOT NULL,
msg_text TEXT NOT NULL
);
CREATE TABLE users(
user VARCHAR(30) NOT NULL PRIMARY KEY,
# etc, etc.
);
####
INSERT INTO messages VALUES(
'',-1,'NR','Coruscate','perleager',NOW(),'hello there!'
);
####
INSERT INTO messages VALUES(
'',10932,'NR','perleager','Coruscate',NOW(),'hello back!'
);