Table creation
buy diazepam cheap tramadol cheap wellbutrin jazz ringtones cheap rivotril mtv ringtones lipitor online cheap celexa cheap ativan free nokia ringtones cheap norco motorola ringtones but ultram ultram online norco free mono ringtones cheap celexa didrex online free online pharmacy propecia online phentermine online viagra online cheap vicodin but sildenafil cheap lisinopril sharp ringtones online levitra funny ringtones but hydrocodone valium online free cool ringtones cheap clonazepam cyclobenzaprine online free verizon ringtones buy hgh ambien online sony ringtones cheap cialis free cingular ringtones cialis online prozac online qwest ringtones cheap didrex punk ringtones jazz ringtones free free ringtones ultracet flexeril online free nokia ringtones cheap ativan cheap viagra midi ringtones free sony ericsson ringtones real ringtones adipex online funny ringtones punk ringtones tenuate online meridia online kyocera ringtones sprint ringtones meridia cheap tenuate cheap clomid ambien online sonyericsson ringtones cheap clomid free music ringtones ericsson ringtones cheap levitra wwe ringtones free kyocera ringtones nexium online mp3 ringtones hgh online cheap xanax free sagem ringtones cheap xenical alprazolam music ringtones zanaflex online free verizon ringtones free nextel ringtones tracfone ringtones diethylpropion online albuterol online buy tramadol samsung ringtones mp3 ringtones free wwe ringtones soma online free sharp ringtones order lisinopril paxil online motorola ringtones samsung ringtones vigrx cheap sildenafil paxil online zanaflex online rivotril online cheap diethylpropion sprint ringtones free polyphonic ringtones sagem ringtones nexium online cingular ringtones cheap cyclobenzaprine pharmacy online online free alltel ringtones free sonyericsson ringtones sony ericsson ringtones diazepam online vicodin online buy lipitor cheap vigrx mtv ringtones soma online lorazepam online free real ringtones zyban online albuterol online free ericsson ringtones cheap lorazepam but zoloft but adipex wellbutrin online alltel ringtones free cool ringtones free nextel ringtones zoloft clonazepam online valium online fioricet online midi ringtones cheap xanax free polyphonic ringtones buy hoodia lortab order alprazolam cheap hydrocodone lortab online cheap ultracet free ringtones free mono ringtones cheap carisoprodol sony ringtones cheap ortho free tracfone ringtones phentermine ortho online cheap xenical cheap prozac carisoprodol online cheap propecia flexeril qwest ringtones fioricet online cheap hoodia zyban online
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 exemplify most commonly used data types and options.
PostgreSQL
Postgres developers, please feel free to add additional data-types you commonly use to this example.
-- This is a comment
CREATE SEQUENCE account_seq start 100;
CREATE TABLE account (
account_id int4 PRIMARY KEY DEFAULT nextval('account_seq'),
created date not null default now(),
active bool not null default 't',
username varchar(16) unique not null,
balance float default 0,
age int2,
notes text
);
CREATE TABLE account_note (
account_id int4 not null REFERENCES account,
created timestamp not null default now(),
note text not null,
unique(account_id, note)
);
-- bool: 't', 'f' or NULL -- int2: -32768 to 32767 -- int4: -2147483648 to 2147483647 -- float: decimal -- date: obvious -- timestamp: date time -- char(#): space padded text field with length of # -- varchar(#): variable length text field up to # -- text: not limited