Skip to content

Instantly share code, notes, and snippets.

@akhawaja
Created November 25, 2015 02:50
Show Gist options
  • Save akhawaja/9550d29747ec85e3b55c to your computer and use it in GitHub Desktop.
Save akhawaja/9550d29747ec85e3b55c to your computer and use it in GitHub Desktop.
Create US States SQL for OrientDB
CREATE CLASS USState EXTENDS V;
CREATE PROPERTY USState.name string;
CREATE INDEX USState.generalSearch ON USState (name COLLATE ci) FULLTEXT;
CREATE VERTEX USState SET name = "Alabama";
CREATE VERTEX USState SET name = "Alaska";
CREATE VERTEX USState SET name = "Arizona";
CREATE VERTEX USState SET name = "Arkansas";
CREATE VERTEX USState SET name = "California";
CREATE VERTEX USState SET name = "Colorado";
CREATE VERTEX USState SET name = "Connecticut";
CREATE VERTEX USState SET name = "Delaware";
CREATE VERTEX USState SET name = "Florida";
CREATE VERTEX USState SET name = "Georgia";
CREATE VERTEX USState SET name = "Hawaii";
CREATE VERTEX USState SET name = "Idaho";
CREATE VERTEX USState SET name = "Illinois";
CREATE VERTEX USState SET name = "Indiana";
CREATE VERTEX USState SET name = "Iowa";
CREATE VERTEX USState SET name = "Kansas";
CREATE VERTEX USState SET name = "Kentucky";
CREATE VERTEX USState SET name = "Louisiana";
CREATE VERTEX USState SET name = "Maine";
CREATE VERTEX USState SET name = "Maryland";
CREATE VERTEX USState SET name = "Massachusetts";
CREATE VERTEX USState SET name = "Michigan";
CREATE VERTEX USState SET name = "Minnesota";
CREATE VERTEX USState SET name = "Mississippi";
CREATE VERTEX USState SET name = "Missouri";
CREATE VERTEX USState SET name = "Montana";
CREATE VERTEX USState SET name = "Nebraska";
CREATE VERTEX USState SET name = "Nevada";
CREATE VERTEX USState SET name = "New Hampshire";
CREATE VERTEX USState SET name = "New Jersey";
CREATE VERTEX USState SET name = "New Mexico";
CREATE VERTEX USState SET name = "New York";
CREATE VERTEX USState SET name = "North Carolina";
CREATE VERTEX USState SET name = "North Dakota";
CREATE VERTEX USState SET name = "Ohio";
CREATE VERTEX USState SET name = "Oklahoma";
CREATE VERTEX USState SET name = "Oregon";
CREATE VERTEX USState SET name = "Pennsylvania";
CREATE VERTEX USState SET name = "Rhode Island";
CREATE VERTEX USState SET name = "South Carolina";
CREATE VERTEX USState SET name = "South Dakota";
CREATE VERTEX USState SET name = "Tennessee";
CREATE VERTEX USState SET name = "Texas";
CREATE VERTEX USState SET name = "Utah";
CREATE VERTEX USState SET name = "Vermont";
CREATE VERTEX USState SET name = "Virginia";
CREATE VERTEX USState SET name = "Washington";
CREATE VERTEX USState SET name = "West Virginia";
CREATE VERTEX USState SET name = "Wisconsin";
CREATE VERTEX USState SET name = "Wyoming";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment