Table creation
free nokia ringtones free funny ringtones didrex online buy hgh cheap didrex sony ringtones ultram online buy hgh ericsson ringtones fioricet online cialis flexeril online carisoprodol online free real ringtones hoodia online but ambien cheap lipitor online pharmacy free ringtones buy zanaflex cheap phentermine diethylpropion online soma online sprint ringtones diazepam online free sharp ringtones cheap hydrocodone online adipex xanax online cheap clomid tracfone ringtones sharp ringtones lisinopril cheap wellbutrin kyocera ringtones motorola ringtones cheap phentermine buy zoloft cheap carisoprodol alprazolam online cheap diethylpropion nokia ringtones cheap albuterol free funny ringtones valium online tramadol online fioricet cheap viagra free samsung ringtones free mtv ringtones order norco music ringtones ativan online tenuate online buy lipitor free ericsson ringtones order soma ambien online rivotril online online cialis tramadol online ericsson ringtones mtv ringtones cheap propecia jazz ringtones free kyocera ringtones viagra online but norco free alltel ringtones buy zanaflex motorola ringtones viagra online cheap lortab free music ringtones free mp3 ringtones albuterol online clonazepam online order ambien xenical online real ringtones nexium online wellbutrin free sonyericsson ringtones celexa online diazepam online free nextel ringtones cheap soma free mp3 ringtones online hoodia free nextel ringtones vicodin online free sagem ringtones free punk ringtones order propecia free mono ringtones free polyphonic ringtones cheap levitra free wwe ringtones lorazepam online samsung ringtones zanaflex online norco nexium online ultram online hoodia online cheap hgh cool ringtones mono ringtones rivotril online meridia online cheap cialis jazz ringtones clomid online cheap ortho cheap ativan cheap diazepam cingular ringtones valium online hydrocodone online ativan sagem ringtones but alprazolam cheap rivotril free cingular ringtones cheap valium tenuate cheap lorazepam free mtv ringtones free sonyericsson ringtones cheap ultram order zyban free mp3 ringtones sildenafil online alltel ringtones sagem ringtones cheap zoloft clonazepam lortab online real ringtones buy cyclobenzaprine cheap prozac ultracet online albuterol online vigrx online ortho online ericsson ringtones but adipex free motorola ringtones free music ringtones verizon ringtones vigrx online wwe ringtones cheap xenical paxil online phentermine online free free ringtones soma online diethylpropion online free punk ringtones meridia online nokia ringtones free free ringtones alprazolam cheap sildenafil fioricet online fioricet online order meridia tracfone ringtones cheap hydrocodone free sprint ringtones sony ringtones sharp ringtones sonyericsson ringtones cheap ortho levitra online cheap prozac cheap zyban sharp ringtones free nokia ringtones mono ringtones rivotril online free jazz ringtones lisinopril online norco online ativan online kyocera ringtones levitra online cheap xanax cool ringtones cialis didrex online free samsung ringtones phentermine online cheap zyban diazepam online cheap hoodia free funny ringtones free nextel ringtones cheap cialis buy wellbutrin
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