dnet45/modules/cnr-enabling-database-service/trunk/src/main/resources/eu/dnetlib/enabling/database/velocity/manageTable.sql.vm @ 62941
1 |
ALTER TABLE ${table} ADD COLUMN ${idField} VARCHAR(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text); |
---|---|
2 |
CREATE INDEX ${table}_${idField}_idx ON ${table} (${idField}); |