summaryrefslogtreecommitdiff
path: root/sql/createTables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/createTables.sql')
-rw-r--r--sql/createTables.sql13
1 files changed, 0 insertions, 13 deletions
diff --git a/sql/createTables.sql b/sql/createTables.sql
deleted file mode 100644
index 6442b6b..0000000
--- a/sql/createTables.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-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;