9 lines
329 B
MySQL
9 lines
329 B
MySQL
|
CREATE TABLE `Address` (
|
||
|
|
`addrID` int(11) NOT NULL auto_increment,
|
||
|
|
`addrStreet` varchar(50) NOT NULL default '',
|
||
|
|
`addrCity` varchar(25) NOT NULL default '',
|
||
|
|
`addrState` char(2) NOT NULL default '',
|
||
|
|
`addrZIP` char(10) NOT NULL default '',
|
||
|
|
PRIMARY KEY (`addrID`)
|
||
|
|
);
|