< < E-NEF > >
Prog. Perl | Art Roman | Voyager | Cartes ()
next up previous contents index
Next: Suppression des tables de Up: SQL Previous: Création de la base   Table des matières   Index

Remplissage de la base de données orchid

psql orchid_db

orchid_db=> create table servers (name text, url text, availability int, master boolean);

orchid_db=> insert into servers values ('i5','i5.esiea.fr',10,TRUE);
orchid_db=> insert into servers values ('nef','nef.esiea.fr',4,FALSE);

orchid_db=> select * from servers;

orchid_db=> create table users (name text, password text, 
                             info text, profile text, online boolean);

orchid_db=> insert into users values ('philippe.benhamou','a23q','ONERA','',TRUE);
orchid_db=> insert into users values ('antoine.souliez','79ty','ESIEA','',FALSE);
orchid_db=> insert into users values ('ma.darche','12','ESIEA','',TRUE);

orchid_db=> select * from users;

orchid_db=> create table agents (name text, owner text, home text, 
                             currentlocation text, frozen boolean);

orchid_db=> insert into agents values ('ma__philippe.benhamou','philippe.benhamou',
                             'i5.esiea.fr','nef.esiea.fr',FALSE);
orchid_db=> insert into agents values ('ma__antoine.souliez','antoine.souliez',
                             'i5.esiea.fr','nef.esiea.fr',FALSE);
orchid_db=> insert into agents values ('ma__ma.darche','ma.darche',
                             'i5.esiea.fr','i5.esiea.fr',FALSE);

orchid_db=> select * from agents;
orchid_db=> create table meetings (user text, subject text, note text, 
                                initiator text, date date, timeofday int, 
                                duration int, participants text, frozen boolean);

orchid_db=> insert into meetings values ('philippe.benhamou','réunion TPED',
                                      'définition du terme agent',
                                      'ma.darche','1/10/1998',1430,4,
                                      'antoine.souliez frédéric.salvy 
                                       emmanuel.pierre mo.varroy ma.darche',
                                       FALSE);

orchid_db=> select * from meetings;



epierre@e-nef.com
© Copyright 1998-2005 Emmanuel PIERRE. Libre reproduction sous Licence LLDDv1.
Pour tout commentaire, webmaster@e-nef.com
Dernière MaJ

Valid XHTML 1.0!

No Patents/