CREATE DATABASE /!32312 IF NOT EXISTS/ lists
/*!40100 DEFAULT CHARACTER SET latin1 */;
USE lists
;
CREATE TABLE comments
(
id
int(11) NOT NULL AUTO_INCREMENT,
text
varchar(45) DEFAULT NULL COMMENT ' ',
user_id
varchar(45) DEFAULT NULL,
epoch
varchar(45) DEFAULT NULL,
task_id
int(11) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=latin1;
CREATE TABLE items
(
id
int(11) NOT NULL AUTO_INCREMENT,
title
varchar(45) DEFAULT NULL,
text
mediumtext,
tags
varchar(45) DEFAULT NULL,
status
varchar(45) DEFAULT NULL,
revision
int(11) DEFAULT NULL,
owner
varchar(45) DEFAULT NULL,
list
varchar(45) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;
ALTER TABLE lists
.items
ADD COLUMN order
INT NULL AFTER list
;
// list and task are the same but the difference is about structure (parents)
CREATE TABLE users
(
id
int(11) NOT NULL AUTO_INCREMENT,
username
varchar(45) DEFAULT NULL,
description
mediumtext,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;
insert into users values ('', 'simonmcmanus', '');
CREATE TABLE userLogin
(
id
int(11) NOT NULL AUTO_INCREMENT,
users_id
varchar(45) DEFAULT NULL,
login
mediumtext,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;
insert into userLogin values ('', ID, '')
select * from userLogin, users where userLogin.login='simonmcmanus' and userLogin.users_id=users.id;
CREATE TABLE category
(
id
int(11) NOT NULL AUTO_INCREMENT,
title
varchar(45) DEFAULT NULL,
text
mediumtext,
status
varchar(45) DEFAULT NULL,
list
varchar(45) DEFAULT NULL,
order
varchar(45) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;
CREATE TABLE taskInCategory
(
id
int(11) NOT NULL AUTO_INCREMENT,
task
varchar(45) DEFAULT NULL,
list
varchar(45) DEFAULT NULL,
order
varchar(45) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;
LOCK TABLES items
WRITE;
/*!40000 ALTER TABLE items
DISABLE KEYS /;
INSERT INTO items
VALUES (45,'animate save new task','
\n a
\n\n b
\n\n ','undefined','inProgress',1,NULL,NULL),(46,'animate save new task','add a nice animation when saving a new task.
','','archieved',1,NULL,NULL),(47,'make delete button','
\n
\n\n
\n\n
\n\n
\n\n b
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n d
\n','undefined','notStarted',1,NULL,NULL),(61,'asdf','asdf','','inProgress',1,'','asd'),(62,'asdf','asdf','','inProgress',1,'','asd'),(63,'as','as','','inProgress',1,'','asd'),(64,'as','as','','inProgress',1,'','asd'),(65,'tosh','ttosh','','notStarted',1,'','asd'),(66,'tosh','ttosh','','notStarted',1,'','asd'),(67,'tosh','ttosh','','notStarted',1,'','asd'),(68,'tosh','ttosh','','notStarted',1,'','asd'),(69,'tosh','ttosh','','notStarted',1,'','asd'),(70,'jquery','\n jQueryPluginsUIMeetupsForumBlogAboutDonateDownloadDocumentationTutorialsBug TrackerDiscussion Search jQuery Go JQUERY API
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n
\n\n asd
\n\n asd
\n\n a
\n\n sd
\n\n
\n\n asd
\n\n asdasd
\n\n asd
\n','undefined','archieved',1,'','postit'),(71,'jquery','jQueryPluginsUIMeetupsForumBlogAboutDonateDownloadDocumentationTutorialsBug TrackerDiscussion\nSearch jQuery Go\nJQUERY API\n','','archieved',1,'','postit'),(72,'','','','archieved',1,'','postit'),(73,'test new task','\n asdasd
\n','undefined','archieved',1,'','postit'),(74,'asdasd','','','archieved',1,'','postit'),(75,'asdasd','\n asdasd
\n','','archieved',1,'','postit'),(76,'asdasd','','','archieved',1,'','postit'),(77,'asdasd','\n asdasd
\n','','archieved',1,'','postit'),(78,'asdasdasd','','','archieved',1,'','postit'),(79,'asdasdasd','\n asdasd
\n','','archieved',1,'','postit'),(80,'asdasdasd','\n asdasd
\n','','archieved',1,'','postit'),(81,'asdasdasds','\n asdasd
\n','','archieved',1,'','postit'),(82,'asd','','','archieved',1,'','postit'),(83,'asdasd','\n s
\n','','archieved',1,'','postit'),(84,'asdasd','\n s
\n\n a
\n\n sd
\n','','archieved',1,'','postit'),(85,'asdasd','','','archieved',1,'','postit'),(86,'asdasd','\n asd
\n','','archieved',1,'','postit'),(87,'asdasd','','','archieved',1,'','postit'),(88,'asdasd','\n asd
\n','','archieved',1,'','postit'),(89,'asdasd','\n asd
\n','','archieved',1,'','postit'),(90,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(91,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(92,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(93,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(94,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(95,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(96,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(97,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(98,'asdasdd','\n asd
\n','','archieved',1,'','postit'),(99,'asd','','','archieved',1,'','postit'),(100,'asd','\n sfd
\n','','archieved',1,'','postit'),(101,'asd','','','archieved',1,'','postit'),(102,'asd','','','archieved',1,'','postit'),(103,'aadsadasd','','','archieved',1,'','postit'),(104,'aaaaasd','','','archieved',1,'','postit'),(105,'aaaaasd','\n asdasdasd
\n','','archieved',1,'','postit'),(106,'aaasadf','','','archieved',1,'','postit'),(107,'aaasadfdsd','\n asdf
\n','','archieved',1,'','postit'),(108,'aaasadfdsds','\n asdf
\n','','archieved',1,'','postit'),(109,'aaasadfdsds','\n asdf
\n','','archieved',1,'','postit'),(110,'aaaaa','','','archieved',1,'','postit'),(111,'aaaaa','\n asdsdasd
\n\n
\n\n asd
\n\n asd
\n\n
\n','','archieved',1,'','postit'),(112,'asdasd','','','archieved',1,'','postit'),(113,'asdasda','','','archieved',1,'','postit'),(114,'asdasd','','','archieved',1,'','postit'),(115,'NEWTESTTASK!!!!!!!!!!!!','','','archieved',1,'','postit'),(116,'!!!!','','','archieved',1,'','postit'),(117,'2222','','','archieved',1,'','postit'),(118,'tobbb','\n sdfsdf
\n\n sd
\n\n f
\n\n sdf
\n\n s
\n\n df
\n\n sd
\n\n f
\n\n sdf
\n\n sdfsd
\n\n ffsd
\n\n sdf
\n\n fsd
\n\n sdf
\n\n sdfssdfdfs
\n\n df
\n\n sdf
\n','undefined','archieved',1,'','postit'),(119,'2d2d2d','','','archieved',1,'','postit'),(120,'aaasd','\n asas
\n\n a
\n\n s
\n\n as
\n\n
\n','undefined','archieved',1,'','postit'),(121,'jghgjkhgkj','','','archieved',1,'','postit'),(122,'asdsdasd','\n sdffsdfsdfsdfsdfsfsdsf
\n\n
\n\n asdf
\n\n asdf
\n\n sadf
\n\n asdf
\n\n
\n\n
\n\n fsd
\n\n
\n\n sdfs
\n\n dfs
\n\n df
\n\n
\n','undefined','archieved',1,'','postit'),(123,'22','\n 2222
\n','','notStarted',1,'','undefined'),(124,'aaaaa','\n abcded
\n','','notStarted',1,'','undefined'),(125,'223333d','\n wdwdwdwd
\n','','notStarted',1,'','undefined'),(126,'asdsdasd','\n asdasdasd
\n','','notStarted',1,'','undefined'),(127,'kjhkjh','\n asdasd
\n','','notStarted',1,'','undefined'),(128,'asd','\n asd
\n','','notStarted',1,'','undefined'),(129,'asd','\n asdasd
\n','','notStarted',1,'','undefined'),(130,'asasdasdasdadsa df','\n asdasdasdasd
\n','','notStarted',1,'','undefined'),(131,'tiger','\n twoz
\n','','notStarted',1,'','undefined'),(132,'tiger','\n sdfsdf
\n','','notStarted',1,'','undefined'),(133,'aaaa','\n aaaa
\n','','notStarted',1,'','undefined'),(134,'sdf','\n sfsf
\n','','notStarted',1,'','undefined'),(135,'sdf','\n sddsd
\n','','notStarted',1,'','undefined'),(136,'sdf','\n sdfdf
\n','','notStarted',1,'','undefined'),(137,'ddd','\n ededed
\n','','archieved',1,'','postit'),(138,'ddd','\n eee
\n','','archieved',1,'','achieve'),(139,'sdfsdf','\n sfsdf
\n','','archieved',1,'','postit'),(140,'eee','\n eeeeee
\n','','archieved',1,'','achieve'),(141,'ff','\n fffdfdf
\n','','archieved',1,'','postit'),(142,'tosh','\n tosiba
\n','','archieved',1,'','postit'),(143,'dad','\n aadas
\n','','archieved',1,'','postit'),(144,'werw','\n werwer
\n','','archieved',1,'','postit'),(145,',.,','\n eee
\n','','archieved',1,'','postit'),(146,'rrrrrrr','\n ffdfdf
\n','','archieved',1,'','postit'),(147,'test edit','\n editing the test
\n','undefined','archieved',1,'','postit'),(148,'2nd new task','\n be able to add two new tasks without having to refresh the page.
\n','','done',1,'','postit'),(149,'popoopo','\n asdasd
\n','','archieved',1,'','test'),(150,'style wysiwyg','\n style the wysiwyg box
\n','','done',1,'','postit'),(151,'consistant form styling','\n style the forms consistantly
\n','','notStarted',1,'','postit'),(152,'sdsd','\n asdasd
\n','','archieved',1,'','test'),(153,'1','\n 1
\n','','archieved',1,'','test'),(154,'2','\n 2
\n','','archieved',1,'','test'),(155,'zoom down to new task','\n when a new task is added automatically bring it down into view.
\n','','archieved',1,'','postit'),(156,'multiple delete per column','\n without a page refresh.
\n','','done',1,'','postit'),(157,'ddd','\n dddsdsd
\n','','archieved',1,'','test'),(158,'focus on new task','\n when a new task is clicked the box should get focus straight away.
\n','','done',1,'','postit'),(159,'firefox horizontal scroll','\n this should not happen. Make it stop.
\n\n
\n\n
\n\n asdasd
\n','undefined','notStarted',1,'','postit'),(160,'asdasdasd','\n dasdasdasd
\n','','archieved',1,'','test'),(161,'aadsd','\n adasd
\n','','archieved',1,'','test'),(162,'asdasdasd','','','archieved',1,'','test'),(163,'adasdasd','\n asdasdasd
\n','','archieved',1,'','test'),(164,'adsasd','\n asdasdasd
\n','','archieved',1,'','test'),(165,'sdfasdfasdf','\n asd
\n\n asd
\n\n asd
\n\n asd
\n\n ads
\n\n das
\n\n ds
\n\n adsasdasd
\n','','archieved',1,'','test'),(166,'asdasd','\n sfasdfasfd
\n','','archieved',1,'','test'),(167,'asd','\n asdaasd
\n','','archieved',1,'','test'),(168,'333','\n ff
\n','','archieved',1,'','test'),(169,'asdasd','\n asdsdasd
\n','','archieved',1,'','test'),(170,'sssss','\n ssssssss
\n\n
\n\n s
\n\n s
\n\n s
\n','','archieved',1,'','test'),(171,'222','\n dssdsd
\n\n s
\n\n sd
\n\n
\n\n
\n\n
\n\n s
\n\n
\n\n
\n\n a
\n\n ds
\n\n
\n\n asd
\n\n ads
\n\n ads
\n\n
\n\n ads
\n\n ads
\n','','archieved',1,'','test'),(172,'dddd','\n dddasd
\n','','archieved',1,'','test'),(173,'dddd','\n ddsasd
\n\n asd
\n\n asd
\n\n asd
\n\n
\n','','archieved',1,'','test'),(174,'dasda','\n adsasdasd
\n','','archieved',1,'','test'),(175,'asdasd','\n asdasdasd
\n','','archieved',1,'','test'),(176,'asdsdasd','\n asdasd
\n','','archieved',1,'','test'),(177,'asdasd','\n asdasdasdasd
\n','','archieved',1,'','test'),(178,'asdasd','\n asdasdasdasd
\n','','archieved',1,'','test'),(179,'asdfsdf','\n asdfsdfsafd
\n','','archieved',1,'','test'),(180,'asdfasdf','\n asdfasdf
\n','','archieved',1,'','test'),(181,'dddd','\n dddddd
\n','','archieved',1,'','test'),(182,'','\n scsdcsdc
\n','','archieved',1,'','test'),(183,'asdasd','\n asdasd
\n','','notStarted',1,'','simonmcmanus@facebook'),(184,'asdasdasd','\n asdasd
\n','','notStarted',1,'','simonmcmanus@facebook'),(185,'asdasd','\n asdasd
\n','','notStarted',1,'','simonmcmanus@facebook'),(186,'twos','\n asd
\n','','notStarted',1,'','simonmcmanus@facebook'),(187,'task :hover in firefox','\n get task hover working in firefox
\n\n a
\n\n sdf
\n\n asdf
\n\n df
\n','undefined','done',1,'','postit'),(188,'sdfsdf','\n sdfsdfsdf
\n','','archieved',1,'','test'),(189,'','\n asdf
\n\n asdf
\n\n asdf
\n\n adsf
\n\n
\n','','archieved',1,'','postit'),(190,'asdfasddsfsdfsdf','\n asdfasdf
\n\n
\n\n asdf
\n','','archieved',1,'','postit'),(191,'asdfsdfaaf','\n asdfsadf
\n','','archieved',1,'','test'),(192,'asdasd','\n asdf
\n','','archieved',1,'','test'),(193,'','','','archieved',1,'','test'),(194,'','','','archieved',1,'','test'),(195,'mlkml','\n mklkmkml
\n','','archieved',1,'','test'),(196,'hkjh','\n jkh
\n','','notStarted',1,'','test'),(197,'','','','archieved',1,'','test'),(198,'asdasd','\n adasd
\n','','notStarted',1,'','test'),(199,'adsasdasd','\n asdsdasdasd
\n','','notStarted',1,'','test'),(200,'SASD','','','bin',1,'','test'),(201,'asdasd','\n aaSDAsdsad
\n','','bin',1,'','test'),(202,'adsasd','\n jk
\n\n
\n\n 123
\n','undefined','deleted',1,'','test'),(203,'ccasc','\n sdfasdaascsassssssacsaacsacacsacsacsacascsacsacsac
\n','','bin',1,'','test'),(204,'d','\n ddd
\n\n
\n\n d
\n\n d
\n\n d
\n\n
\n\n d
\n\n
\n','','done',1,'','test'),(205,'sfdsdf','\n sdf
\n','','archieved',1,'','test'),(206,'xcvxcv','\n xcv
\n','','notStarted',1,'','testxcv'),(207,'asd','\n asd
\n','','notStarted',1,'','testxcv'),(208,'test2','\n ttttt
\n','','bin',1,'','test'),(209,'asdasd','\n asdasd
\n','','bin',1,'','test'),(210,'asdasd','\n asdasd
\n','undefined','deleted',1,'','test'),(211,'test','\n tttttttt
\n','','bin',1,'','test'),(212,'asd','\n asdasdasdasd
\n','undefined','done',1,'','test'),(213,'sdfsdf','\n sdfsdf
\n','','deleted',1,'','test'),(214,'sdfsdf','\n sdfdfsdf
\n','','bin',1,'','test'),(215,'sdfsdf{EDIT2}','\n cumpasdasd
\n\n
\n\n lkmkm
\n\n
\n\n 8
\n\n
\n\n ;lm;lm;
\n','undefined','deleted',1,'','test'),(216,'sdfsdfdsas','\n asd
\n\n a
\n\n assssssssssadasd
\n\n asd
\n','undefined','done',1,'','test'),(217,'test','\n tetet
\n','','archieved',1,'','test'),(218,'test','\n asdasd
\n','','archieved',1,'','test'),(219,'asdasd','\n asdasd
\n','','archieved',1,'','test'),(220,'asd','asdasd','','archieved',1,'','test'),(221,'asdasdas222444','\n sdfsdfsdf
\n','undefined','deleted',1,'','test'),(222,'tolly','\n tollt
\n','','archieved',1,'','test'),(223,'asdasd','\n asdasdasd
\n','','archieved',1,'','achieve'),(224,'asdasd','\n asdasd
\n','','archieved',1,'','achieve'),(225,'ddd','\n d
\n','','archieved',1,'','achieve'),(226,'asdasd','\n adasd
\n','','archieved',1,'','achieve'),(227,'asdas','','','archieved',1,'','achieve'),(228,'asdad','\n asdasda
\n','','archieved',1,'','achieve'),(229,'asdasdasd','\n asdasd
\n','','archieved',1,'','achieve'),(230,'asdaf','\n asdfa
\n','','archieved',1,'','achieve'),(231,'asdaf','\n asdfa
\n','','archieved',1,'','achieve'),(232,'111111','\n asdfa
\n','','archieved',1,'','achieve'),(233,'adss','\n asd
\n','','archieved',1,'','achieve'),(234,'22222','\n 2222222
\n','','archieved',1,'','achieve'),(235,'333','\n 3333
\n','','archieved',1,'','achieve'),(236,'4444','\n 4444
\n','','archieved',1,'','achieve'),(237,'555','\n 5555
\n','','archieved',1,'','achieve'),(238,'666','\n 666
\n','','archieved',1,'','achieve'),(239,'777','\n 77777
\n','','archieved',1,'','achieve'),(240,'df','\n sd
\n','','archieved',1,'','achieve'),(241,'3232323','\n sdfsf
\n','','archieved',1,'','achieve'),(242,'rere','\n erere
\n','','archieved',1,'','achieve'),(243,'f','\n f
\n','','archieved',1,'','achieve'),(244,'twoggle','\n twoggle2
\n','','archieved',1,'','achieve'),(245,'aasdf','\n asdfasdf
\n','','notStarted',1,'','simonmcmanus@facebook'),(246,'asd','\n ads
\n','','done',1,'','postit2'),(247,'ssfs','\n sfdsdf
\n','','archieved',1,'','test'),(248,'asdads','\n asdsd
\n','','archieved',1,'','simonmcmanus'),(249,'aasdad','\n asdasd
\n','','archieved',1,'','simonmcmanus'),(250,'adssdad','\n asdasd
\n','','archieved',1,'','simonmcmanus'),(251,'new tet','\n asssfasdfsafdassadfasfsfs
\n\n
\n\n asdf
\n\n asdf
\n','undefined','archieved',1,'','simonmcmanus'),(252,'er','\n erer
\n','','archieved',1,'','simonmcmanus'),(253,'asdf','\n asdfsafd
\n','','done',1,'','simonmcmanus'),(254,'sdfdfs','\n sdfsdf
\n','','archieved',1,'','achieve'),(255,'dsfsdf','\n sdfsdf
\n','','archieved',1,'','achieve'),(256,'asdfasdf','\n asdfasdfasdf
\n','','archieved',1,'','achieve'),(257,'asdfasd','\n asdsdaf
\n','','archieved',1,'','achieve'),(258,'asd','\n asdsda
\n','','archieved',1,'','achieve'),(259,'asd','\n asd
\n','','archieved',1,'','achieve'),(260,'asdfssfd','\n sfdsadf
\n','','bin',1,'','achieve'),(261,'adfssf','\n asdfasdfasdf
\n','','archieved',1,'','achieve'),(262,'sdf','\n sadf
\n','','archieved',1,'','achieve'),(263,'sff','\n sdfsdf
\n\n a
\n\n sdf
\n\n asdf
\n\n asdf
\n\n asdf
\n\n a
\n\n sdf
\n\n a
\n\n sdf
\n','undefined','done',1,'','achieve'),(264,'sfd','\n sdfasdf
\n\n adsf
\n\n asd
\n\n dsfdsf
\n\n ffff
\n\n
\n\n
\n\n
\n\n asdfasfd
\n','undefined','archieved',1,'','achieve'),(265,'sfdsf','\n sfdsdfsdf
\n','','archieved',1,'','achieve'),(266,'jkhlkjhlkjh','\n kjhkljknnkjn
\n','','bin',1,'','simonmcmanus'),(267,'jhgkjhkj','\n jhklhlkj
\n','','bin',1,'','edit'),(268,'asdasd','\n asd
\n','undefined','deleted',1,'','achieve'),(269,'asdasd','\n asDAsd
\n\n
\n\n
\n\n adsa
\n\n sda
\n\n sd
\n','undefined','deleted',1,'','achieve'),(270,'asdasd','\n asdasd
\n','','done',1,'','achieve'),(271,'asdasd','\n asdasdasd
\n','','deleted',1,'','achieve'),(272,'ssssas','\n adsas
\n','','done',1,'','achieve'),(273,'adsasd','\n adsasdasdfasdf
\n\n aaaasdasdasd
\n\n
\n\n
\n\n asdasdasd
\n','undefined','deleted',1,'','achieve'),(274,'asdasd','','','done',1,'','achieve'),(275,'asdasd','\n asdasd
\n\n aas
\n\n ads
\n\n fa
\n\n fs
\n\n fsdadsfa
\n\n sdf
\n\n sdf
\n\n asdf
\n\n
\n','undefined','done',1,'','achieve'),(276,'eqwdwd','\n asdasdasasdffs
\n','undefined','done',1,'','achieve'),(277,'asdasd','\n what a load of rubihs
\n','undefined','deleted',1,'','achieve'),(278,'asdasd','\n asdads
\n','','inProgress',1,'','edit'),(279,'adsasd [TEST EDIT][6]','','undefined','notStarted',1,'','achieve'),(280,'aada','','','deleted',1,'','achieve'),(281,'asdasdasd','\n asdasdas
\n','','deleted',1,'','postit'),(282,'asdasd','\n asdasd
\n','','deleted',1,'','achieve'),(283,'asdasd','\n asdsd
\n','','deleted',1,'','achieve'),(284,'WWW','\n www
\n','','deleted',1,'','achieve'),(285,'abba','\n abcde
\n','','inProgress',1,'','achieve'),(286,'colla','\n cdefg
\n','','inProgress',1,'','achieve'),(287,'asdadsa','\n asdasd
\n','','inProgress',1,'','achieve'),(288,'2222','\n 222222
\n','','notStarted',1,'','achieve'),(289,'update board on task save','\n When the task is saved update the task on the board read view.
\n','','notStarted',1,'','postit'),(290,'bjhhb','\n jkjnkjnkjn
\n','','notStarted',1,'','test'),(291,'edit second task without page refresh','\n you should be able to open a task, close it. and then open another task.
\n\n
\n Currently this does not work.
\n integrate with google login
\n','','notStarted',1,'','postit'),(293,'twitter integration','\n integrate with twitter
\n','','notStarted',1,'','postit'),(294,'chrome integration','\n make installable web app
\n','','notStarted',1,'','postit'),(295,'make private repository','\n make private github repo
\n','','notStarted',1,'','postit'),(296,'make public sandbox','','','notStarted',1,'','postit'),(297,'fix editing multiple tasks','\n open two tasks in a row.
\n\n
\n\n things are not correct.
\n\n
\n','','notStarted',1,'','postit'),(298,'asdasd','\n asdsdasdsdfasdasd
\n','undefined','inProgress',1,'','simonmcmanus'),(299,'adasd','\n asdasd
\n','','bin',1,'','simonmcmanus'),(300,'drag task to bin and refresh','\n when you drag a task into the bin and then refresh the page the task disappears.
\n','','notStarted',1,'','postit'),(301,'asds','\n sdfsdsfdsf
\n','','done',1,'','simonmcmanus'),(302,'adsasd','\n sdfsdsfdsf
\n','','notStarted',1,'','simonmcmanus'),(303,'fhjgjf','\n nkn;oim
\n','','notStarted',1,'','simonmcmanus'),(304,'sadasd','','','notStarted',1,'','simonmcmanus'),(305,'asdsd','','','inProgress',1,'','simonmcmanus'),(306,'abba','','','notStarted',1,'','simonmcmanus'),(307,'bounty','\n bouty1
\n','','inProgress',1,'','simonmcmanus'),(308,'multiple new tasks','\n when creating multiple tasks at the same time (hit new task 4 times in a row) when you create the task the new task appears at the top of the list. not necessily at the same place in the list where the new task form was.
\n','','notStarted',1,'','postit'),(309,'ordering in same status list','\n doesnt seem to update.
\n\n other problems may be nearby.
\n\n to replicate:
\n\n reorder items in given list, refresh the page, your new ordering is lost.
\n\n
\n\n
\n','','notStarted',1,'','postit'); /!40000 ALTER TABLEitems
ENABLE KEYS */;
UNLOCK TABLES;
wget http://nodejs.org/dist/node-v0.4.9.tar.gz gunzip node-v0.4.9.tar.gz tar -xf node-v0.4.9.tar cd node-v0.4.9 ./configure make sudo make install
export NODE_PATH="/usr/local/lib/node"
sudo apt-get install apache2 sudo a2enmod rewrite
/etc/init.d/apache2 restart