DROP DATABASE comanagers;

CREATE DATABASE "comanagers" WITH TEMPLATE = template0 ENCODING = 'UNICODE';

\connect comanagers


CREATE SEQUENCE "linksdb_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

CREATE TABLE "linksdb" (
        "id" integer DEFAULT nextval('linksdb_id_seq'::text) NOT NULL,
        "name" character varying(200),
        "description" text,
        "url" character varying(300),
        "datein" timestamp with time zone,
        "category" integer,
        "gid" integer,
        "status" boolean
);

COPY "linksdb"  FROM stdin;
286	Don Balon (Espańa)	Futbol - Noticias, Reportajes, etc	http://www.donbalon.es/	\N	131	171	t
625	Australian Writers Guild	THE PROFESSIONAL ORGANISATION FOR WRITERS OF FILM, TELEVISION, RADIO, THEATRE, VIDEO AND NEW MEDIA.
\

\
If you are serious about becoming a writer it is advised that you join the Australian Writers' Guild – to increase your bargaining power and to give you access to industry information as well as a wide range of services. 	http://www.awg.com.au/	2001-07-18 13:19:07+10	256	304	t
740	Berwick Village Chamber of Commerce	Website for Berwick Village.  No responsibility is taken for any information or services which may appear on any linked web sites.	ď‚· http://www.berwick-village.com.au/ 	2001-09-24 10:39:16+10	314	441	t
733	Wellington Shire Council	Visitor information.  No responsibility is taken for any information or services which may appear on any linked web sites.	ď‚· http://www.gippsland.org/ 	2001-09-24 10:22:46+10	314	441	t
734	Ararat Online	Community Portal.  See StreetLife component under the business section. No responsibility is taken for any information or services which may appear on any linked web sites.	ď‚· http://www.ararat.asn.au/ 	2001-09-24 10:25:42+10	314	441	t
743	Business Access	Site within Victorian Government’s Department of State and Regional Development.  Provides information on services available and information sheet on business related issues.  No responsibility is taken for any information or services which may appear on any linked web sites.	http://www.businessaccess.vic.gov.au	2001-09-24 11:04:20+10	315	441	t
1053	Do You Want to Play?	Do You Want to Play?
\
An Invitation for Practical Dreamers
\
Our aim here is to suggest that working 
\
together we could all achieve much more 
\
with the resources we have, online and 
\
face-to-face. The key is to build a network 
\
that will allow us to do this – a 
\
network of people, not computers.	http://www.idealist.org/play.html	2001-12-29 17:39:16+11	229	240	t
1086	Immunotherapy	MODERATOR:  Stuart Duncum (Immunotherapy Nurse)
\
<BR>
\
This community aims to provide information and support to people using MS drug treatments or considering drug treatment. 
\
<BR>
\
CHAT: 1 – 2 pm first Wed every month	http://www.mc2.vicnet.net.au/admin.cgi?gid=726 	2002-01-16 17:42:05+11	462	737	t
1088	Keep S’Myelin Kids Community	MODERATOR(S): Felicity Munt (Training & Education Coordinator and Carolyn (partner of Person with MS, teacher, and mother)
\
<BR>
\

\
For children who have a parent, aunt, uncle, friend or person in their life who has MS. 
\
<BR>
\
<I>MSSV has a commitment to providing adult supervision on this site.</I>
\
<BR>
\
CHAT:4.30 to 5.30pm every Sat
\

\
	http://www.mc2.vicnet.net.au/admin.cgi?gid=561 	2002-01-16 17:49:37+11	462	737	t
1091	Women’s Talk	MODERATOR: Felicity Munt (Training and Education Coordinator)
\
<BR>
\
For women that have MS, or have a family member who has MS. The community will focus on issues that are specific to women\	
\
<BR>
\
CHAT: 1 – 2 pm first Mon of every month	http://www.mc2.vicnet.net.au/admin.cgi?gid=725	2002-01-16 17:57:29+11	462	737	t
1176	JOURNEY - Spirituality/Pastoral Care Online	MODERATOR:  Pam Storey (Pastoral Carer)
\
JOURNEY's primary purpose is support, 
\
exploration, encouragement and companionship in times of spiritual need and growth. The community is inclusive and accepting of everyone’s spirituality. It is a community of respect and tolerance for individual beliefs. No attempt will be made to promote any particular belief or tradition.
\

\
CHAT:  3 to 4pm every Friday (from 22 Feb)	http://mc2.vicnet.net.au/admin.cgi?session=27428a227138ff32465947bd6d78c234&action=detail&gid=794&hits=1	2002-02-13 12:44:08+11	463	737	t
1226	Sport and Recreation Victoria	The Victorian Government’s sport web page about Sport, sport & sport	http://www.sport.vic.gov.au 	2002-03-01 15:28:46+11	536	817	t
1246	Youth Substance Abuse Service	YSAS provides drug and alcohol services for people aged between 12 and 21 who are experiencing significant problems related to their drug use.Central to their approach to service delivery is the concept and practice of providing a supportive relationship with the young person. Drug use is only one aspect of the young person’s life and must be addressed in the context of social and personal development, in an environment of trust.	http://www.ysas.org.au	2002-03-01 16:03:52+11	549	817	t
\.