Something

CREATE TABLE notes (
   gid serial PRIMARY key,
   typeid bigint,
   username character varying(32),
   title character varying(256),
   datetime time default now(),
   content text,
   comments text
);

INSERT INTO notes (typeid,title,username,content,comments)
VALUES(0,'title','username','content','comment');

SELECT AddGeometryColumn('public', 'notes', 'the_geom', 4326, 'POINT', 2);

UPDATE notes SET the_geom = GeometryFromText('POINT (0.0 0.0)',4326)
WHERE gid = 1;