Try This:
#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_CATEGORY
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_CATEGORY;
CREATE TABLE PORTAL_TODOLIST_CATEGORY
(
CATEGORY_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
DESCRIPTION VARCHAR (250) NOT NULL,
NAME VARCHAR (50) NOT NULL,
PRIMARY KEY(CATEGORY_ID)
);
#
-----------------------------------------------------------------------
# PORTAL_TODOLIST
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST;
CREATE TABLE PORTAL_TODOLIST
(
TODO_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
OWNER VARCHAR (50) NOT NULL,
SINGLE INTEGER default 0,
CATEGORY_ID INTEGER (11) NOT NULL,
SHORT_TEXT VARCHAR (100) NOT NULL,
LONG_TEXT VARCHAR (255),
PRIORITY INTEGER (11) NOT NULL,
USE_EXPIRATION INTEGER (11) NOT NULL,
EXPIRATION_DATE DATETIME,
DONE INTEGER default 0,
PRIMARY KEY(TODO_ID),
FOREIGN KEY (CATEGORY_ID) REFERENCES PORTAL_TODOLIST_CATEGORY
(CATEGORY_ID)
);
#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_GROUP
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_GROUP;
CREATE TABLE PORTAL_TODOLIST_GROUP
(
TODO_GROUP_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
TODO_ID INTEGER (11) NOT NULL,
GROUP_NAME VARCHAR (50) NOT NULL,
PRIMARY KEY(TODO_GROUP_ID),
FOREIGN KEY (TODO_ID) REFERENCES PORTAL_TODOLIST (TODO_ID)
);
#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_USER
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_USER;
CREATE TABLE PORTAL_TODOLIST_USER
(
TODO_USER_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
TODO_ID INTEGER (11) NOT NULL,
USER_NAME VARCHAR (50) NOT NULL,
PRIMARY KEY(TODO_USER_ID),
FOREIGN KEY (TODO_ID) REFERENCES PORTAL_TODOLIST (TODO_ID)
);
--
M. Karthikeyan, Ph.D., Scientist
_| _| _|_|_| _|
_|_| _| _| _|
_| _| _| _| _|
_| _|_| _| _|
_| _| o _|_|_|o _|_|_|_|
National Chemical Laboratory
Pune - 411 008, INDIA
Ph: +91-(0)20-5893 457 FAX: 5893 973
http://www.ncl-india.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
