# ----------------------------------------------------------------------- | |
# ID_TABLE | |
# ----------------------------------------------------------------------- | |
drop table if exists ID_TABLE; | |
CREATE TABLE ID_TABLE | |
( | |
ID_TABLE_ID INTEGER NOT NULL AUTO_INCREMENT, | |
TABLE_NAME VARCHAR (255) NOT NULL, | |
NEXT_ID INTEGER, | |
QUANTITY INTEGER, | |
PRIMARY KEY(ID_TABLE_ID), | |
UNIQUE (TABLE_NAME) | |
); | |