setup.js

来自「一个聊天室demo~~用的是最近出来的Jaxer1.2服务器（号称是第一个完全的」· JavaScript 代码 · 共 31 行

(function() {
	
if (Jaxer.application.isInitialized) return;

var sql;

sql = "CREATE TABLE IF NOT EXISTS users " +
	"( id INTEGER PRIMARY KEY AUTO_INCREMENT" +
	", username VARCHAR(255) NOT NULL" +
	", password VARCHAR(255) NOT NULL" +
	", created DATETIME NOT NULL" +
	", last_login DATETIME NOT NULL" +
	", UNIQUE (username)" +
	")";

Jaxer.DB.execute(sql);

sql = "CREATE TABLE IF NOT EXISTS messages " +
	"( id INTEGER PRIMARY KEY AUTO_INCREMENT" +
	", room_id INTEGER NOT NULL" +
	", sent DATETIME NOT NULL" +
	", user_id INTEGER NOT NULL" +
	", contents TEXT NOT NULL" +
	")";

Jaxer.DB.execute(sql);

Jaxer.application.isInitialized = true;
			
})();