Revision 57518
Added by Michele Artini over 4 years ago
| samples.sql | ||
|---|---|---|
| 1 |
--INSERT INTO openaire_simrels(local_id, oa_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) VALUES ('openorgs____::0000022403','opendoar____::b504d1345f7d151031fd7b96333704f0','2323','ITT Technical Institute','ITT','UK','http://','OpenDOAR');
|
|
| 2 |
--INSERT INTO openaire_simrels(local_id, oa_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) VALUES ('openorgs____::0000022403','ec__________::927fd71a2e566f9f45ce51047a4db54a','986786','Technical Institute','ITT-TI','UK','http://','EC');
|
|
| 3 |
---INSERT INTO openaire_simrels(local_id, oa_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) VALUES ('openorgs____::0000022403','re3data_____::84913f34770f5f7f92af45775009580d','r3344','Institute of Informatics and Telematics','IIT','IT','http://','re3data');
|
|
| 4 |
--INSERT INTO openaire_simrels(local_id, oa_id, oa_original_id, oa_name, oa_acronym, oa_country, oa_url, oa_collectedfrom) VALUES ('openorgs____::0000022403','ec__________::9fdd5957f12affa9b7e50cad05c280b3', '9994324','Istituto Italiano di Tecnologia ','IIT','IT','http://','EC');
|
|
| 5 |
|
|
| 6 | 1 |
INSERT INTO users(email, password, valid, role) VALUES ('michele', '{MD5}'||MD5('dnet'), true, 'SUPERUSER');
|
| 7 | 2 |
INSERT INTO users(email, password, valid, role) VALUES ('claudio', '{MD5}'||MD5('dnet'), true, 'SUPERUSER');
|
| 8 | 3 |
INSERT INTO users(email, password, valid, role) VALUES ('emma', '{MD5}'||MD5('dnet'), true, 'USER');
|
Also available in: Unified diff