Table creation: Difference between revisions
Content added Content deleted
mNo edit summary |
(revert spam) |
||
| Line 1: | Line 1: | ||
{{task}} |
|||
[http://kitmun.cn/yuventus.html yuventus] [http://snailtail.cn/www-spinning/index.html www spinning it] [http://knock-knock.cn/wwwducati-com/index.html wwwducati com] [http://bmwz3.fast-road.cn/index.html bmw z3] [http://knock-knock.cn/www-msn/index.html www msn it] [http://bifulcoagnese.romanikki.cn/index.html bifulco agnese] [http://knock-knock.cn/www-cwgc-org/index.html www cwgc org] [http://blasonariosubalpino.fast-road.cn/index.html blasonario subalpino] [http://knock-knock.cn/warhammer/index.html warhammer] [http://kitmun.cn/you-talk.html you talk too much] [http://snailtail.cn/www-idealstandard/index.html www idealstandard com] [http://knock-knock.cn/www-gladiator/index.html www gladiator thefilm com] [http://bodka.midways.cn/index.html bodka] [http://bancodelmutousoccorso.romanikki.cn/index.html banco del mutou soccorso] [http://knock-knock.cn/wen-a-men/index.html wen a men loved a womman] [http://bussaggioeccentrico.kittiss.cn/index.html bussaggio eccentrico] [http://burpregionepuglia.clung.cn/index.html burp regione puglia] [http://knock-knock.cn/wcw-vd-nwo/index.html wcw vd nwo] [http://bastardkazushihagiwara.romanikki.cn/index.html bastard kazushi hagiwara] [http://snailtail.cn/yeterki-onursuz/index.html yeterki onursuz olmasin ask] [http://wonted.cn/www-hotel/index.html www hotel anissa beach com creta] [http://snailtail.cn/www-iceage/index.html www iceage] [http://bellidaltv.fast-road.cn/index.html belli dal tv] [http://kitmun.cn/ymca-tabs.html ymca tabs testo] [http://quoits.cn/amore-libero.html amore libero] [http://quoits.cn/zvonko-bogdan.html zvonko bogdan] [http://balladimastrog.romanikki.cn/index.html balla di mastro g] [http://knock-knock.cn/wwww-vacanze/index.html wwww vacanze] [http://quoits.cn/amori-in-corsa.html amori in corsa] [http://boysex.romanikki.cn/index.html boy sex] [http://quoits.cn/american-pie.html american pie - il matrimonio] [http://snailtail.cn/x-nap/index.html x nap] [http://quoits.cn/alien-degli.html alien degli abissi] [http://quoits.cn/zauvek-si.html zauvek si ostala u meni] [http://bittermoon.fast-road.cn/index.html bitter moon] [http://bellambriana.romanikki.cn/index.html bella mbriana] [http://quoits.cn/anche-i-boia.html anche i boia muoiono] [http://blueimmagine.kittiss.cn/index.html blue immagine] [http://barbarakocsis.clung.cn/index.html barbara kocsis] [http://bigbroters.fast-road.cn/index.html big broters] [http://snailtail.cn/xena-tutta/index.html xena tutta nuda] [http://knock-knock.cn/www-calgaro/index.html www calgaro it] [http://wonted.cn/www-unicampus/index.html www unicampus it] [http://bozzadocumentoprogrammaticosicurezza.fast-road.cn/index.html bozza documento programmatico sicurezza] [http://wonted.cn/www-relaxbanking/index.html www relaxbanking it] [http://biglietticoncertoevanescence.kittiss.cn/index.html biglietti concerto evanescence] [http://quoits.cn/ziva-dinulovic.html ziva dinulovic] [http://blackeyedpeascom.kittiss.cn/index.html black eyed peas com] [http://quoits.cn/agente-spaziale.html agente spaziale k1] [http://basecremadiburro.kittiss.cn/index.html base crema di burro] [http://kitmun.cn/yankse-seca2.html yankse seca2] [http://snailtail.cn/www-fuji/index.html www fuji film it] [http://snailtail.cn/xx/index.html xx] [http://kitmun.cn/yo-rompere.html yo rompere tus fotos] [http://blowjob.fast-road.cn/index.html blowjob] [http://snailtail.cn/xxx-paris/index.html xxx paris hilton] [http://bluesignedsealeddeliveredimyourss.midways.cn/index.html blue signed sealed delivered i m yours s] [http://wonted.cn/www-la-stampa/index.html www la stampa it] [http://wonted.cn/wham-wake-me/index.html wham wake me up before you go go] [http://knock-knock.cn/watcher/index.html watcher] [http://bellissimedonne.kittiss.cn/index.html bellissime donne] [http://birdhouseskateboards.clung.cn/index.html birdhouse skateboards] [http://bestinmeblue.clung.cn/index.html best in me blue] [http://kitmun.cn/zupa-di-pesce.html zupa di pesce] [http://beastieboyschcheckitoutdownloads.clung.cn/index.html beastie boys ch check it out downloads] [http://knock-knock.cn/www-passalibro/index.html www passalibro it] [http://britneyspearsfotonuda.kittiss.cn/index.html britney spears foto nuda] [http://belizebecom.kittiss.cn/index.html belize be com] [http://barbaraconforto.romanikki.cn/index.html barbara conforto] [http://knock-knock.cn/www-panasonic/index.html www panasonic it] [http://snailtail.cn/yepp-a-mama/index.html yepp a mama] [http://quoits.cn/zeljkop.html zeljkop] [http://quoits.cn/al-tropico.html al tropico del cancro] [http://knock-knock.cn/www-poetare/index.html www poetare it] [http://bananarama.fast-road.cn/index.html bananarama] [http://wonted.cn/www-media/index.html www media player it] [http://snailtail.cn/www-pitareanolana/index.html www pitareanolana it] [http://kitmun.cn/yead-usher.html yead usher] [http://quoits.cn/adorabile.html adorabile] [http://breakonthrough.romanikki.cn/index.html break on through] [http://snailtail.cn/www-sedi/index.html www sedi esami ecdl it] [http://biberongiordani.midways.cn/index.html biberon giordani] [http://kitmun.cn/zie-calde.html zie calde] [http://britti.midways.cn/index.html britti] [http://quoits.cn/alaska,-inferno.html alaska, inferno dell'oro] [http://quoits.cn/amore-maledetto.html amore maledetto] [http://blueleft.midways.cn/index.html blue left] [http://knock-knock.cn/www-unibo/index.html www unibo it] [http://snailtail.cn/www-ragazze/index.html www ragazze lettoni com] [http://kitmun.cn/zero-save.html zero save me] [http://quoits.cn/zasadzimy.html zasadzimy ziarno abradab] [http://wonted.cn/www-techno/index.html www techno it] [http://wonted.cn/www-cellphone/index.html www cellphone com] [http://bonnevacances.kittiss.cn/index.html bonne vacances] [http://knock-knock.cn/wwe-kurt-angle/index.html wwe kurt angle] [http://quoits.cn/zum.html zum] [http://snailtail.cn/www-rosetocalcio/index.html www rosetocalcio it] [http://quoits.cn/american-me.html american me] [http://beatitmichaeljackson.clung.cn/index.html beat it michael jackson] [http://snailtail.cn/x70-panasonic/index.html x70 panasonic] [http://quoits.cn/avere-vent'anni.html avere vent'anni] [http://snailtail.cn/www-giuliano/index.html www giuliano di roma] [http://burgbeheading.clung.cn/index.html burg beheading] [http://bootspictures.midways.cn/index.html boots pictures] [http://kitmun.cn/yo-nem-ai.html yo nem ai] [http://knock-knock.cn/www-dizionario/index.html www dizionario italiano] [http://blink182imissyou.kittiss.cn/index.html blink182 i miss you] [http://bratpit.kittiss.cn/index.html brat pit] [http://knock-knock.cn/www-elvispresleyclubofitaly/index.html www elvispresleyclubofitaly com] [http://bichon.midways.cn/index.html bichon] [http://knock-knock.cn/www-sat-discout/index.html www sat discout ci] [http://knock-knock.cn/www-nauticasupermarket/index.html www nauticasupermarket it] [http://quoits.cn/all-the.html all the king's men] [http://knock-knock.cn/warrick/index.html warrick brown] [http://buscarpono.midways.cn/index.html buscar pono] [http://brevetramadieugeniagrandetdibalzac.clung.cn/index.html breve trama di eugenia grandet di balzac] [http://kitmun.cn/yeah-ft-lil.html yeah ft lil jon and ludacris] [http://quoits.cn/ali-del-futuro.html ali del futuro oltre la barriera del suono] [http://bryndis.fast-road.cn/index.html bryndis] [http://kitmun.cn/y2k-turbine.html y2k turbine] [http://bambolavaleriamarini.fast-road.cn/index.html bambola valeria marini] [http://snailtail.cn/xnnxx/index.html xnnxx] [http://knock-knock.cn/www-cine8-it/index.html www cine8 it] [http://bankofamericaonline.kittiss.cn/index.html bank of america online] [http://knock-knock.cn/www-fuoriditesta/index.html www fuoriditesta it] [http://snailtail.cn/www-talos/index.html www talos com] [http://quoits.cn/alla-ricerca.html alla ricerca della pietra di cristallo -crystalstone] [http://bluetooth.romanikki.cn/index.html bluetooth] [http://baulifici.fast-road.cn/index.html baulifici] [http://bluesystem.romanikki.cn/index.html blue system] [http://barijaserifovic.clung.cn/index.html barija serifovic] [http://biographiephotographe.kittiss.cn/index.html biographie photographe] [http://barzellettesarde.romanikki.cn/index.html barzellette sarde] [http://brittanydaniel.midways.cn/index.html brittany daniel] [http://snailtail.cn/www-slow-food/index.html www slow food torino it] [http://bellefrasi.kittiss.cn/index.html bellefrasi] [http://snailtail.cn/xnxx-com/index.html xnxx com] [http://knock-knock.cn/wwwbdp-it-csa/index.html wwwbdp it csa napoli] [http://bloccoassunzionifinanziaria2005.kittiss.cn/index.html blocco assunzioni finanziaria 2005] [http://benignirobertofilm.kittiss.cn/index.html benigni roberto film] [http://barcheusate.clung.cn/index.html barche usate] [http://brookelogan.midways.cn/index.html brooke logan] [http://baueritalia.clung.cn/index.html bauer italia] [http://biblioteca.fast-road.cn/index.html biblioteca] [http://bollettinoregionalecampania.clung.cn/index.html bollettino regionale campania] [http://bobdylancom.romanikki.cn/index.html bob dylan com] [http://kitmun.cn/you-promisse.html you promisse me] [http://knock-knock.cn/www-women/index.html www women love com] [http://knock-knock.cn/www-www-al/index.html www www al ansar net] [http://blofcountingcrows.midways.cn/index.html blof countingcrows] {{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 14:10, 10 September 2007
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