Table creation: Difference between revisions

Content added Content deleted

Inline

@@ Line 16: / Line 16: @@
  CREATE TABLE `Address` (
-   `addrID` int(11) NOT NULL auto_increment,
+   `addrID`       int(11)     NOT NULL   auto_increment,
-   `addrStreet` varchar(50) NOT NULL default '',
+   `addrStreet`   varchar(50) NOT NULL   default '',
-   `addrCity` varchar(25) NOT NULL default '',
+   `addrCity`     varchar(25) NOT NULL   default '',
-   `addrState` char(2) NOT NULL default '',
+   `addrState`    char(2)     NOT NULL   default '',
-   `addrZIP` char(10) NOT NULL default '',
+   `addrZIP`      char(10)    NOT NULL   default '',
-   PRIMARY KEY  (`addrID`)
+   PRIMARY KEY (`addrID`)
  );