<?php namespace com\csga5000\WebGameLib; MySql::$updates = []; ////Versions//// //V1: Add users table MySql::$updates[] = <<<SQL CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(128) NOT NULL, `password` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SQL; MySql::$updates[] = <<<SQL CREATE TABLE `worlds` ( \t`id` INT(11) NOT NULL AUTO_INCREMENT, \t`user_id` INT(11) NOT NULL, \t`name` VARCHAR(50) NOT NULL DEFAULT 'Hello', \t`value` TEXT NOT NULL, \tPRIMARY KEY (`id`) ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB ; SQL ;