--
-- PostgreSQL database dump
--

-- Started on 2006-11-06 19:53:35 SAST

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;


CREATE TABLE clientplugins (
    name character varying(255) NOT NULL,
    description text,
    "trigger" character varying(100),
    url text
);


--
-- TOC entry 1190 (class 1259 OID 16626)
-- Dependencies: 4
-- Name: login; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "login" (
    username character varying(100) NOT NULL,
    "password" character varying(32),
    units bigint,
    status character varying(50),
    machine character varying(100)
);


--
-- TOC entry 1193 (class 1259 OID 16643)
-- Dependencies: 4
-- Name: offers; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE offers (
    description character varying(200) NOT NULL,
    extras text,
    units bigint,
    price double precision
);


--
-- TOC entry 1191 (class 1259 OID 16628)
-- Dependencies: 4
-- Name: serverplugins; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE serverplugins (
    name character varying(255) NOT NULL,
    description text,
    "trigger" character varying(100) NOT NULL,
    command text NOT NULL
);


--
-- TOC entry 1192 (class 1259 OID 16633)
-- Dependencies: 4
-- Name: settings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE settings (
    currencysymbol character varying(3) NOT NULL,
    unitlength bigint NOT NULL,
    priceperunit double precision NOT NULL,
    adminpw character varying(32)
);



--
-- TOC entry 1529 (class 0 OID 16643)
-- Dependencies: 1193
-- Data for Name: offers; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 1527 (class 0 OID 16628)
-- Dependencies: 1191
-- Data for Name: serverplugins; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 1528 (class 0 OID 16633)
-- Dependencies: 1192
-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO settings (currencysymbol, unitlength, priceperunit, adminpw) VALUES ('$', 60, 1, '');


--
-- TOC entry 1516 (class 2606 OID 16636)
-- Dependencies: 1189 1189
-- Name: clientplugins_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY clientplugins
    ADD CONSTRAINT clientplugins_pkey PRIMARY KEY (name);


--
-- TOC entry 1518 (class 2606 OID 16638)
-- Dependencies: 1190 1190
-- Name: login_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY "login"
    ADD CONSTRAINT login_pkey PRIMARY KEY (username);


--
-- TOC entry 1524 (class 2606 OID 16649)
-- Dependencies: 1193 1193
-- Name: offers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY offers
    ADD CONSTRAINT offers_pkey PRIMARY KEY (description);


--
-- TOC entry 1520 (class 2606 OID 16640)
-- Dependencies: 1191 1191
-- Name: serverplugins_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY serverplugins
    ADD CONSTRAINT serverplugins_pkey PRIMARY KEY (name);


--
-- TOC entry 1522 (class 2606 OID 16642)
-- Dependencies: 1192 1192
-- Name: settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY settings
    ADD CONSTRAINT settings_pkey PRIMARY KEY (currencysymbol);


-- Completed on 2006-11-06 19:53:35 SAST

--
-- PostgreSQL database dump complete
--