diff options
Diffstat (limited to 'dcaedt_be/src/main/resources/schema.sql')
| -rw-r--r-- | dcaedt_be/src/main/resources/schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/dcaedt_be/src/main/resources/schema.sql b/dcaedt_be/src/main/resources/schema.sql new file mode 100644 index 0000000..487b5e5 --- /dev/null +++ b/dcaedt_be/src/main/resources/schema.sql @@ -0,0 +1,4 @@ +--DROP TABLE composition_status; +CREATE TABLE IF NOT EXISTS composition_status (id varchar(20) NOT NULL, revision varchar(20) DEFAULT 0, name blob(1024), is_changed varchar(2), PRIMARY KEY (id, revision)); +CREATE TABLE IF NOT EXISTS test (id varchar(20) NOT NULL, name varchar(20), is_changed varchar(2), PRIMARY KEY (id)); + |