Table creation: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 22: | Line 22: | ||
`addrZIP` char(10) NOT NULL default '', |
`addrZIP` char(10) NOT NULL default '', |
||
PRIMARY KEY (`addrID`) |
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 |
|||
); |
); |