X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=doc%2FtableStructure.sql;h=76babce874bb48494cb613d01bc8e23231725db5;hp=2012fb1903c61bfc7d94f93a178c7b5e7f519122;hb=c6248b0ce2483e48fa729532b1079f22f2f0b6ed;hpb=b0a970a60d0001260594468f3ffffbf92a19bc44 diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql index 2012fb19..76babce8 100644 --- a/doc/tableStructure.sql +++ b/doc/tableStructure.sql @@ -31,8 +31,8 @@ CREATE TABLE `users` ( ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; -DROP TABLE IF EXISTS `domain`; -CREATE TABLE `domain` ( +DROP TABLE IF EXISTS `domains`; +CREATE TABLE `domains` ( `id` int(11) NOT NULL AUTO_INCREMENT, `memid` int(11) NOT NULL, `domain` varchar(255) NOT NULL, @@ -45,8 +45,8 @@ CREATE TABLE `domain` ( KEY `stats_domains_deleted` (`deleted`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS `email`; -CREATE TABLE `email` ( +DROP TABLE IF EXISTS `emails`; +CREATE TABLE `emails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `memid` int(11) NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '',