preference.sql

来自「Java的框架」· SQL 代码 · 共 26 行

USE PRRM;

CREATE TABLE IF NOT EXISTS PREFERENCE (
	ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	NAME VARCHAR (200) NOT NULL UNIQUE,
	VERSION INTEGER NOT NULL,
	VALUE VARCHAR (255) NOT NULL,
	READ_ONLY BIT NOT NULL
) ENGINE=INNODB
;


CREATE TABLE IF NOT EXISTS USER_PREFERENCE (
	ID INT NOT NULL,
	USERNAME VARCHAR(20) NOT NULL,
	VALUE VARCHAR (255) NOT NULL,
	PRIMARY KEY (ID, USERNAME),
	INDEX (USERNAME),
	FOREIGN KEY (USERNAME) REFERENCES USER (USERNAME) ON DELETE CASCADE,
	INDEX (ID),
	FOREIGN KEY (ID) REFERENCES PREFERENCE (ID) ON DELETE CASCADE
) ENGINE=INNODB
;