CREATE TABLE IF NOT EXISTS config_file_content \r
- (\r
- macid varchar(255) not null,\r
- file_content mediumtext not null,\r
- primary key(macid)\r
-);
\ No newline at end of file
+ (\r
+ ID int null,\r
+ macid varchar(255) not null,\r
+ file_content mediumtext not null,\r
+ SW_VERSION varchar(64) not null,\r
+ HW_VERSION varchar(64) not null,\r
+ primary key(macid, SW_VERSION, HW_VERSION)\r
+);\r
+\r
+CREATE SEQUENCE IF NOT EXISTS hibernate_sequence MINVALUE 1 MAXVALUE 4611686018427387903 CYCLE CACHE 10;
\ No newline at end of file