Table creation: Difference between revisions
Content added Content deleted
mNo edit summary |
m (Undo revision 6967 by Special:Contributions/SzwZpf (User talk:SzwZpf)) |
||
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 |
-- int2: -32768 to +32767 |
||
-- int4: -2147483648 to |
-- int4: -2147483648 to +2147483647 |
||
-- float: decimal |
-- float: decimal |
||
-- date: obvious |
-- date: obvious |
Revision as of 00:09, 20 August 2007
Table creation
You are encouraged to solve this task according to the task description, using any language you may know.
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