|
|
Prog. Perl | Art Roman | Voyager | Cartes | |
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;
|
|
Pour tout commentaire, webmaster@e-nef.com Dernière MaJ 15/12/2017 |
|
|
|