diff options
Diffstat (limited to 'src/main/sql/create.sql')
-rw-r--r-- | src/main/sql/create.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/main/sql/create.sql b/src/main/sql/create.sql index 27d5034..22f290e 100644 --- a/src/main/sql/create.sql +++ b/src/main/sql/create.sql @@ -1,5 +1,5 @@ -create table "COMPUTERS" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL,"MANUFACTURER_ID" INTEGER NOT NULL); -create table "COMPANIES" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL); +create table IF NOT EXISTS "COMPUTERS" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL,"MANUFACTURER_ID" INTEGER NOT NULL); +create table IF NOT EXISTS "COMPANIES" ("ID" INTEGER NOT NULL,"NAME" VARCHAR NOT NULL); insert into "COMPANIES" values (1,'Apple Inc.'); |