-- $Id: insert_lams_tool_twitter_data.sql,v 1.9 2006/03/21 06:54:17 fmalikoff Exp $


-- test data for twitter content table

INSERT INTO tl_fptwit10_content ( uid,
								twitter_content_id,
								title,
								content,
								online_instructions,
								offline_instructions,
								teacherTwittewrUsername,
								learnersTwitterUsernames,
								hashtags,
								tweetNumber,
								define_later,
								force_offline,
								content_in_use,
								creator_user_id,
								date_created,
								date_updated) 
VALUES (null,
		'2500',
		'Welcome',
		'Welcome to these activities',
		'Enter the online instructions here',
		'Enter the offline instructions here',
		'',
		'',
		'',
		1,
		0,
		0,
		0,
		'2300',
		now(),
		NULL);


INSERT INTO tl_fptwit10_session ( uid,
								twitter_session_id,
								twitter_content_uid,
								session_start_date,
								session_end_date,
								session_status)
VALUES (null,
		'2400',
		LAST_INSERT_ID(),
		now(),
		now(),
		'INCOMPLETE');
		
INSERT INTO tl_fptwit10_user ( 	uid,
								user_id,
								twitter_session_uid,
								username,
								fullname,
								user_status)
VALUES (null,
		'2600',
		LAST_INSERT_ID(),
		'test',
		'test',
		'NOT_ATTEMPTED');
		
-- Data needed to run the examples on the twitter starter page

INSERT INTO tl_fptwit10_content ( uid,
								twitter_content_id,
								title,
								content,
								online_instructions,
								offline_instructions,
								teacherTwittewrUsername,
								learnersTwitterUsernames,
								hashtags,
								tweetNumber,
								define_later,
								force_offline,
								content_in_use,
								creator_user_id,
								date_created,
								date_updated) 
VALUES (null,
		'355',
		'Welcome',
		'Welcome to these activities',
		'Enter the online instructions here',
		'Enter the offline instructions here',
		'',
		'',
		'',
		1,
		0,
		0,
		0,
		NULL,
		now(),
		NULL);
		
		INSERT INTO tl_fptwit10_session ( uid,
								twitter_session_id,
								twitter_content_uid,
								session_start_date,
								session_end_date,
								session_status)
VALUES (null,
		'455',
		LAST_INSERT_ID(),
		now(),
		now(),
		'NOT_ATTEMPTED');
