New accounts will be written to a mysql database

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/createTables.sql b/sql/createTables.sql
new file mode 100644
index 0000000..6442b6b
--- /dev/null
+++ b/sql/createTables.sql
@@ -0,0 +1,13 @@
+CREATE TABLE `tmw_accounts` 
+(
+   `ID`              INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+   `USERNAME`        VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
+   `PASSWORD`        VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
+   `EMAIL`           VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
+   `STATE`           TINYINT UNSIGNED NOT NULL DEFAULT '0',
+   `REGISTRATION`    TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
+   `GENDER`          TINYINT UNSIGNED NOT NULL DEFAULT '0',
+   --
+   INDEX ( `STATE` ) ,
+   UNIQUE ( `USERNAME` )
+) ENGINE = InnoDB;