Anonymous user
Table creation: Difference between revisions
no edit summary
No edit summary |
|||
Line 22:
`addrZIP` char(10) NOT NULL default '',
PRIMARY KEY (`addrID`)
);
==[[PostgreSQL]]==
CREATE SEQUENCE address_seq start 100;
CREATE TABLE address (
addrID int4 PRIMARY KEY DEFAULT nextval('address_seq'),
street varchar(50) not null,
city varchar(25) not null,
state varchar(2) not null,
zip varchar(20) not null
);
|