DB Tables

CREATE TABLE USER_INFO(USERNAME TEXT NOT NULL,PASSWORD TEXT NOT NULL,NAME TEXT,SEX TEXT,DOB TEXT,STATUS TEXT,PICINFO TEXT);\n
CREATE TABLE HISTORY_MESSAGE(ID INTEGER PRIMARY KEY AUTOINCREMENT, MESSAGE TEXT NOT NULL, SENDER TEXT NOT NULL, LINKS TEXT NOT NULL, TIME TEXT NOT NULL, MYINFO TEXT); \n
CREATE TABLE USERCHAT_HISTORY_MESSAGE(ID INTEGER PRIMARY KEY AUTOINCREMENT, MESSAGE TEXT NOT NULL, SENDER_ID TEXT NOT NULL, RECIEVER_ID TEXT NOT NULL, LINKS TEXT NOT NULL, STATUS TEXT NOT NULL, DATETIME TEXT NOT NULL, MESSAGEID TEXT, MESSAGEDLVRY TEXT, FILETYPE TEXT, LOCALPATH TEXT, FILEUPLOADSTATUS TEXT);\n
CREATE TABLE USER_FRIENDS_LIST(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, USER_ID TEXT NOT NULL, STATUS_MESSAGE TEXT NOT NULL, DISPLAY_PIC TEXT NOT NULL,CONTACT_NUMBER TEXT,BUZZ_USER TEXT, IS_CHAT_AVAILABLE TEXT, IS_PHONE_CONTACT TEXT); \n
CREATE TABLE BLOCKED_USERS_LIST(ID INTEGER PRIMARY KEY AUTOINCREMENT, USER_ID TEXT NOT NULL, NAME TEXT, DISPLAY_PIC TEXT); \n





CREATE TABLE USERCHAT_HISTORY_MESSAGE(ID INTEGER PRIMARY KEY AUTOINCREMENT, MESSAGE TEXT NOT NULL, SENDER_ID TEXT NOT NULL, RECIEVER_ID TEXT NOT NULL, LINKS TEXT NOT NULL, STATUS TEXT NOT NULL, DATETIME TEXT NOT NULL);



ALTER TABLE USER_INFO ADD NAME TEXT;\n
ALTER TABLE USER_INFO ADD STATUS TEXT;\n
ALTER TABLE USER_INFO ADD PICINFO TEXT;\n
ALTER TABLE USERCHAT_HISTORY_MESSAGE ADD MESSAGEID TEXT;\n
ALTER TABLE USERCHAT_HISTORY_MESSAGE ADD MESSAGEDLVRY TEXT;\n
CREATE TABLE USER_FRIENDS_LIST(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, USER_ID TEXT NOT NULL, STATUS_MESSAGE TEXT NOT NULL, DISPLAY_PIC TEXT NOT NULL); \n
CREATE TABLE BLOCKED_USERS_LIST(ID INTEGER PRIMARY KEY AUTOINCREMENT, USER_ID TEXT NOT NULL); \n



ALTER TABLE HISTORY_MESSAGE ADD MYINFO TEXT;\n







ALTER TABLE USERCHAT_HISTORY_MESSAGE ADD FILETYPE TEXT;\n
ALTER TABLE USERCHAT_HISTORY_MESSAGE ADD LOCALPATH TEXT;\n
ALTER TABLE USERCHAT_HISTORY_MESSAGE ADD FILEUPLOADSTATUS TEXT;\n



ALTER TABLE BLOCKED_USERS_LIST ADD NAME TEXT;\n
ALTER TABLE BLOCKED_USERS_LIST ADD DISPLAY_PIC TEXT;


ALTER TABLE USER_INFO ADD SEX TEXT;\n
ALTER TABLE USER_INFO ADD DOB TEXT;\n
ALTER TABLE USER_FRIENDS_LIST ADD CONTACT_NUMBER TEXT;\n
ALTER TABLE USER_FRIENDS_LIST ADD BUZZ_USER TEXT;\n
ALTER TABLE USER_FRIENDS_LIST ADD IS_CHAT_AVAILABLE TEXT;\n
ALTER TABLE USER_FRIENDS_LIST ADD IS_PHONE_CONTACT TEXT;\n
DELETE FROM USER_FRIENDS_LIST;\n
DELETE FROM USER_INFO;\n