Table creation

Table creation
You are encouraged to solve this task according to the task description, using any language you may know.

In this task, the goal is to create a table to store addresses.

UDB DB2

CREATE TABLE Address (
	addrID		Integer		generated by default as identity,
	addrStreet	Varchar(50)	not null,
	addrCity	Varchar(25)	not null,
	addrState	Char(2)		not null,
	addrZIP		Char(10)	not null
)

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`)
);