11 lines
359 B
SQL
11 lines
359 B
SQL
CREATE OR REPLACE TABLE address_usa (
|
|
uuid uuid DEFAULT uuid() PRIMARY KEY
|
|
COMMENT 'This is more efficient than a text column',
|
|
street varchar(100) NOT NULL,
|
|
city varchar(100) NOT NULL,
|
|
state varchar(100) CHECK (state > ''),
|
|
zip char(5) NOT NULL CHECK (char_length(zip) = 5)
|
|
)
|
|
ENGINE InnoDB,
|
|
COMMENT 'This table is cool'
|
|
;
|