Table creation: Difference between revisions

From Rosetta Code
Content added Content deleted
mNo edit summary
Line 1: Line 1:
{{task}}
[http://kalian42.ifrance.com/text/directory/nokia-i/ nokia 6230i gprs] [http://akmokanzen.ifrance.com/images/small/giggi-dalesio.htm giggi dalesio] [http://lovereceier.ifrance.com/lib/rathdrum-irlanda.htm rathdrum irlanda] [http://yeeden.ifrance.com/img/styles/cercasi-case/ cercasi case vendita] [http://igaros.ifrance.com/lib/jo-lo/ jo lo] [http://yeeden.ifrance.com/img/styles/discotechetransex/ discoteche,transex] [http://speedofsoun.ifrance.com/text/directory/tastiera-senza.htm tastiera senza fili ottica logitech] [http://lovereceier.ifrance.com/lib/clogs.htm clogs] [http://voltia.ifrance.com/content/view/grandi-cazzi.htm grandi cazzi] [http://toofarfrommaybe.ifrance.com/view/new/superstar-/ superstar 2 adidas] [http://tizolaa.ifrance.com/web/chiesetta-alpina/ chiesetta alpina mp3] [http://lordsander.ifrance.com/topic/l-invasione.htm l invasione degli omini verdi] [http://tizolaa.ifrance.com/web/copiare-dvd/ copiare dvd protetti] [http://toofarfrommaybe.ifrance.com/view/new/trasporto-merci/ trasporto merci logistica] [http://jdawsona.ifrance.com/data/www-gogle/ www gogle net] [http://lovereceier.ifrance.com/lib/www-comune.htm www comune firenze] [http://voltia.ifrance.com/content/view/italgiure.htm italgiure] [http://broadwaylili.ifrance.com/content/view/i-r.htm i r p i r roma] [http://oiyaoi.ifrance.com/images/small/video-porno/ video porno con animali gratis] [http://deviantrus.ifrance.com/topic/ho-sposato/ ho sposato un fantasma] [http://voltia.ifrance.com/content/view/wwww-mappy.htm wwww mappy com] [http://tizolaa.ifrance.com/web/borsa-cani/ borsa cani] [http://highbulp.ifrance.com/images/small/accessori-palmari/ accessori palmari compact flash] [http://lovereceier.ifrance.com/lib/ezio-greggio.htm ezio greggio] [http://noxuhax.ifrance.com/content/view/pensioni-roma.htm pensioni roma tiburtina] [http://noxuhax.ifrance.com/content/view/data-pasqua.htm data pasqua 2005] [http://lovereceier.ifrance.com/lib/eudemonismo.htm eudemonismo] [http://oiyaoi.ifrance.com/images/small/claudio-ba/ claudio ba] [http://akmokanzen.ifrance.com/images/small/foto-di.htm foto di orietta berti] [http://lordsander.ifrance.com/topic/veleno-mina.htm veleno mina] [http://girlwho-is.ifrance.com/img/styles/yves-rocher.htm yves rocher] [http://tizolaa.ifrance.com/web/richiesta-ambiti/ richiesta ambiti] [http://kalian42.ifrance.com/text/directory/albergo-trentino/ albergo trentino alto adige] [http://tizolaa.ifrance.com/web/david-duchovny/ david duchovny] [http://akmokanzen.ifrance.com/images/small/start-business.htm start business] [http://kalian42.ifrance.com/text/directory/terriccio-piante/ terriccio piante] [http://tizolaa.ifrance.com/web/queen-live/ queen live] [http://yeeden.ifrance.com/img/styles/motorola-mpx/ motorola mpx220 smartphone] [http://demurediablo.ifrance.com/library/html/secret-top/ secret top] [http://demurediablo.ifrance.com/library/html/white-elwyn/ white, elwyn brooks] [http://deviantrus.ifrance.com/topic/microonde-a/ microonde a incasso] [http://deviantrus.ifrance.com/topic/l-equilibrista/ l equilibrista] [http://tizolaa.ifrance.com/web/erika-bella/ erika bella] [http://broadwaylili.ifrance.com/content/view/xxx-donne.htm xxx donne famose] [http://toofarfrommaybe.ifrance.com/view/new/jolanda-porno/ jolanda porno] [http://highbulp.ifrance.com/images/small/giochi-gatti/ giochi gatti] [http://akmokanzen.ifrance.com/images/small/www-sexy.htm www sexy ladys com] [http://girlwho-is.ifrance.com/img/styles/gioco-manageriale.htm gioco manageriale online] [http://noxuhax.ifrance.com/content/view/ahmad-shah.htm ahmad shah massoud] [http://noxuhax.ifrance.com/content/view/personal-domain.htm personal domain name] [http://toofarfrommaybe.ifrance.com/view/new/decapitazione-in/ decapitazione in video] [http://singaporepets.ifrance.com/library/html/xxxadult.htm xxxadult] [http://akmokanzen.ifrance.com/images/small/integratori-alimentari.htm integratori alimentari magnesio potassio] [http://deviantrus.ifrance.com/topic/addiction-puzzle/ addiction puzzle] [http://igaros.ifrance.com/lib/immagini-bandiera/ immagini bandiera] [http://girlwho-is.ifrance.com/img/styles/per-cani.htm per cani perdita pelo] [http://speedofsoun.ifrance.com/text/directory/casse-acustiche.htm casse acustiche tannoy] [http://tat-ooin.ifrance.com/resources/articles/bluetooth-antenna.htm bluetooth antenna] [http://tat-ooin.ifrance.com/resources/articles/dvdr-spindle.htm dvd-r spindle] [http://deviantrus.ifrance.com/topic/final-fantasy/ final fantasy xii (ri)presentato tra un mese] [http://highbulp.ifrance.com/images/small/stadio-equilibrio/ stadio equilibrio instabile] [http://deviantrus.ifrance.com/topic/aggressor/ aggressor] [http://highbulp.ifrance.com/images/small/incontro-sirmione/ incontro sirmione] [http://toofarfrommaybe.ifrance.com/view/new/pill/ pill] [http://oiyaoi.ifrance.com/images/small/spogliami-tutta/ spogliami tutta] [http://tat-ooin.ifrance.com/resources/articles/enrico-cascella.htm enrico cascella] [http://kalian42.ifrance.com/text/directory/schedatura/ schedatura] [http://voltia.ifrance.com/content/view/immagini-per.htm immagini per mms] [http://demurediablo.ifrance.com/library/html/lancia-musa/ lancia musa km zero] [http://lovereceier.ifrance.com/lib/zucchina.htm zucchina] [http://broadwaylili.ifrance.com/content/view/stampante-hp.htm stampante hp deskjet] [http://kalian42.ifrance.com/text/directory/adventura-degli/ adventura degli elfi] [http://girlwho-is.ifrance.com/img/styles/un-freno.htm un freno a disco] [http://lordsander.ifrance.com/topic/extreme-ngtx.htm extreme n7800gtx pci-e] [http://highbulp.ifrance.com/images/small/vampiro-screensaver/ vampiro screensaver] [http://yeeden.ifrance.com/img/styles/produzione-materie/ produzione materie pla] [http://broadwaylili.ifrance.com/content/view/cd-mannoia.htm cd mannoia] [http://noxuhax.ifrance.com/content/view/i-perseguitati.htm i perseguitati] [http://kalian42.ifrance.com/text/directory/www-booble/ www booble com] [http://toofarfrommaybe.ifrance.com/view/new/hi-fi/ hi fi bang] [http://singaporepets.ifrance.com/library/html/cha-cha.htm cha cha della segretaria testo] [http://tat-ooin.ifrance.com/resources/articles/monarcos.htm monarcos] [http://tizolaa.ifrance.com/web/geolite/ geolite] [http://tat-ooin.ifrance.com/resources/articles/divx-avi.htm divx avi] [http://voltia.ifrance.com/content/view/pornostar.htm pornostar] [http://broadwaylili.ifrance.com/content/view/hdc-p.htm hdc 9p] [http://noxuhax.ifrance.com/content/view/kisses.htm kisses] [http://lovereceier.ifrance.com/lib/driver-hp.htm driver hp] [http://deviantrus.ifrance.com/topic/home-makeovers/ home makeovers] [http://lordsander.ifrance.com/topic/copertina-l.htm copertina l anno zero] [http://igaros.ifrance.com/lib/acer-aspire/ acer aspire 1692wlmi] [http://jdawsona.ifrance.com/data/envoyer/ envoyer] [http://toofarfrommaybe.ifrance.com/view/new/devics/ devics] [http://oiyaoi.ifrance.com/images/small/tachikawa/ tachikawa] [http://toofarfrommaybe.ifrance.com/view/new/volvo-polar/ volvo polar 240] [http://demurediablo.ifrance.com/library/html/blue-la/ blue la band] [http://speedofsoun.ifrance.com/text/directory/xantia.htm xantia 1.8] [http://toofarfrommaybe.ifrance.com/view/new/renzo-piano/ renzo piano] [http://tizolaa.ifrance.com/web/moto-a/ moto a batteria] [http://jdawsona.ifrance.com/data/kingmax-rs/ kingmax rs mmc] [http://tat-ooin.ifrance.com/resources/articles/truccare.htm truccare] [http://highbulp.ifrance.com/images/small/angel-of/ angel of darkness] [http://highbulp.ifrance.com/images/small/labyrint/ labyrint] [http://girlwho-is.ifrance.com/img/styles/championship-motocross.htm championship motocross 2001] [http://voltia.ifrance.com/content/view/sesso-al.htm sesso al cinema] [http://akmokanzen.ifrance.com/images/small/files-seca.htm files seca] [http://toofarfrommaybe.ifrance.com/view/new/campionato-professionisti/ campionato professionisti 2004 danza spo] [http://lordsander.ifrance.com/topic/hd-gb.htm hd 80gb usb] [http://igaros.ifrance.com/lib/hard-disk/ hard disk teac] [http://singaporepets.ifrance.com/library/html/lago-di.htm lago di bolsena] [http://toofarfrommaybe.ifrance.com/view/new/car-audio/ car audio mp3] [http://speedofsoun.ifrance.com/text/directory/www-regalo.htm www regalo delta integrale it] [http://highbulp.ifrance.com/images/small/doppio-display/ doppio display cellulari] [http://girlwho-is.ifrance.com/img/styles/christina-aguilera.htm christina aguilera nuda in uno spot] [http://lordsander.ifrance.com/topic/registratore-cd.htm registratore cd registratori] [http://singaporepets.ifrance.com/library/html/ursula-k.htm ursula k. le guin] [http://lordsander.ifrance.com/topic/tavolo-ping.htm tavolo ping pong] [http://oiyaoi.ifrance.com/images/small/pioneer-dvr/ pioneer dvr] [http://highbulp.ifrance.com/images/small/testi-pupo/ testi pupo] [http://demurediablo.ifrance.com/library/html/design-della/ design della comunicazione] [http://demurediablo.ifrance.com/library/html/el-pais/ el pais] [http://lovereceier.ifrance.com/lib/traghetti-capri.htm traghetti capri ischia] [http://oiyaoi.ifrance.com/images/small/eva-henger/ eva henger free] [http://kalian42.ifrance.com/text/directory/dischi-/ dischi 10 kg 30 mm] [http://jdawsona.ifrance.com/data/la-familia/ la familia] [http://highbulp.ifrance.com/images/small/konotop/ konotop] [http://deviantrus.ifrance.com/topic/blu-jeans/ blu jeans] [http://kalian42.ifrance.com/text/directory/calzato/ calzato] [http://tizolaa.ifrance.com/web/delmas/ delmas] [http://noxuhax.ifrance.com/content/view/serge-lutens.htm serge lutens] [http://igaros.ifrance.com/lib/codes-de/ codes de tps] [http://tat-ooin.ifrance.com/resources/articles/impianti-audio.htm impianti audio proel] [http://kalian42.ifrance.com/text/directory/lets-outside/ lets outside alone] [http://noxuhax.ifrance.com/content/view/sexchat-it.htm sexchat it] [http://demurediablo.ifrance.com/library/html/frau-marlene/ frau marlene] [http://tat-ooin.ifrance.com/resources/articles/otra-dia.htm otra dia mas sin verte] [http://jdawsona.ifrance.com/data/rick-astley/ rick astley] [http://lordsander.ifrance.com/topic/hotel-a.htm hotel a bressanone] [http://deviantrus.ifrance.com/topic/sigla-a/ sigla a team] [http://toofarfrommaybe.ifrance.com/view/new/olympus-mjumini/ olympus mju-mini silver] [http://deviantrus.ifrance.com/topic/lione-ristorante/ lione ristorante] [http://demurediablo.ifrance.com/library/html/gay-nord/ gay nord] [http://yeeden.ifrance.com/img/styles/jane-birkin/ jane birkin je t aime moi non plus] [http://speedofsoun.ifrance.com/text/directory/urundi.htm urundi] [http://lovereceier.ifrance.com/lib/porno-femenino.htm porno femenino] [http://demurediablo.ifrance.com/library/html/luomo-che/ luomo che valeva miliardi] [http://jdawsona.ifrance.com/data/luce-laser/ luce laser] [http://tizolaa.ifrance.com/web/te-llevare/ te llevare] [http://deviantrus.ifrance.com/topic/cable-dsl/ cable dsl router switch] [http://deviantrus.ifrance.com/topic/volkswagen-polo/ volkswagen polo 1.0] [http://igaros.ifrance.com/lib/la-storia/ la storia di indro montanelli] [http://jdawsona.ifrance.com/data/piccolo-nardi/ piccolo nardi] [http://voltia.ifrance.com/content/view/passeggino-tre.htm passeggino tre ruote] [http://igaros.ifrance.com/lib/ufficio-ventimiglia/ ufficio ventimiglia] [http://yeeden.ifrance.com/img/styles/demetra-snc/ demetra snc] [http://tizolaa.ifrance.com/web/sensi-proibiti/ sensi proibiti] [http://noxuhax.ifrance.com/content/view/friggitrici-moulinex.htm friggitrici moulinex] [http://tat-ooin.ifrance.com/resources/articles/attac-castle.htm attac castle] [http://tat-ooin.ifrance.com/resources/articles/entony-.htm entony entony] [http://tizolaa.ifrance.com/web/califor/ califor] [http://toofarfrommaybe.ifrance.com/view/new/copertina-cd/ copertina cd vasco rossi buoni e cattivi] [http://tizolaa.ifrance.com/web/stazioni-radio/ stazioni radio su internet] [http://kalian42.ifrance.com/text/directory/fornello-coleman/ fornello coleman] [http://tizolaa.ifrance.com/web/donne-che/ donne che fumano] [http://lovereceier.ifrance.com/lib/cordial-theater.htm cordial theater hotel vienna] [http://lovereceier.ifrance.com/lib/wresteling.htm wresteling] [http://voltia.ifrance.com/content/view/la-cuccagna.htm la cuccagna] [http://oiyaoi.ifrance.com/images/small/powerline-ethernet/ powerline ethernet kit] [http://lovereceier.ifrance.com/lib/attenti-a.htm attenti a quei due... chiamate londra] [http://yeeden.ifrance.com/img/styles/fujifilm-finepix/ fujifilm finepix a205s] [http://demurediablo.ifrance.com/library/html/come-accadde/ come accadde la prima volta] [http://oiyaoi.ifrance.com/images/small/bleszinski-su/ bleszinski su unreal tournament 2004] [http://akmokanzen.ifrance.com/images/small/pad-epremium.htm p5ad2 e-premium i925xe] [http://tizolaa.ifrance.com/web/prestito-verbania/ prestito verbania] [http://tizolaa.ifrance.com/web/free-porno/ free porno 3x2] [http://singaporepets.ifrance.com/library/html/sex-asia.htm sex asia] [http://highbulp.ifrance.com/images/small/parabole-parabola/ parabole parabola 120] [http://oiyaoi.ifrance.com/images/small/seconda-aurora/ seconda aurora] [http://noxuhax.ifrance.com/content/view/rivera-ismael.htm rivera ismael] [http://voltia.ifrance.com/content/view/ingegner-antonio.htm ingegner antonio tini] [http://jdawsona.ifrance.com/data/tacco-alto/ tacco alto roberto cavalli calzature] [http://toofarfrommaybe.ifrance.com/view/new/divina-commedia/ divina commedia parafrasi purgatorio] [http://lordsander.ifrance.com/topic/palmare-telefono.htm palmare telefono] [http://lordsander.ifrance.com/topic/sculaccia.htm sculaccia] [http://broadwaylili.ifrance.com/content/view/cloroplasti.htm cloroplasti] [http://igaros.ifrance.com/lib/fujitsu-tv/ fujitsu tv lcd myrica] [http://girlwho-is.ifrance.com/img/styles/anastasia-outside.htm anastasia outside alone] [http://noxuhax.ifrance.com/content/view/bigboys.htm bigboys] [http://lordsander.ifrance.com/topic/uniroyal.htm uniroyal] [http://yeeden.ifrance.com/img/styles/midi-player/ midi player] [http://tat-ooin.ifrance.com/resources/articles/dlink-di.htm d-link di-614] [http://noxuhax.ifrance.com/content/view/vilo-moja.htm vilo moja mp3] [http://deviantrus.ifrance.com/topic/savi-srl/ savi srl] [http://speedofsoun.ifrance.com/text/directory/ancora-beta.htm ancora beta tester per eve online] [http://oiyaoi.ifrance.com/images/small/lazio-calcio/ lazio calcio midi] [http://voltia.ifrance.com/content/view/roma-barcellona.htm roma barcellona biglietti aerei] [http://voltia.ifrance.com/content/view/e-per.htm e per te] [http://broadwaylili.ifrance.com/content/view/big-bubble.htm big bubble] [http://lovereceier.ifrance.com/lib/casale-vendita.htm casale vendita regione marche] [http://voltia.ifrance.com/content/view/isola-di.htm isola di rodi grecia] {{task}}


In this task, the goal is to create a table to exemplify most commonly used data types and options.
In this task, the goal is to create a table to exemplify most commonly used data types and options.
Line 29: Line 29:


-- bool: 't', 'f' or NULL
-- bool: 't', 'f' or NULL
-- int2: -32768 to 32767
-- int2: -32768 to +32767
-- int4: -2147483648 to 2147483647
-- int4: -2147483648 to +2147483647
-- float: decimal
-- float: decimal
-- date: obvious
-- date: obvious

Revision as of 00:09, 20 August 2007

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