Showing posts with label add vertex. Show all posts
Showing posts with label add vertex. Show all posts

Thursday, 28 January 2016

How to create custom vertex class property and index in orientdb

Go to orientdb bin folder,Run console.sh

Connecting To database
connect remote:localhost/harvest_dev admin admin

Create Class
create class User extends V;
CREATE PROPERTY User.fid STRING;
CREATE PROPERTY User.lid STRING;
CREATE PROPERTY User.fbn STRING;
CREATE PROPERTY User.au STRING;
CREATE INDEX lidx ON User (lid) notunique;
CREATE INDEX fidx ON User (fid) notunique;
Create Class
create class Company extends V
CREATE PROPERTY Company.fcid STRING
CREATE PROPERTY Company.fcn STRING
CREATE PROPERTY Company.cn STRING
CREATE PROPERTY Company.cid STRING
CREATE INDEX fb_cmp_id_inx ON Company (fcid) notunique
CREATE INDEX cidx ON Company (cid) notunique