preference.sql

Java的框架

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
;