Table creation

From Rosetta Code

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

Task
Table creation
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