[Cs-webapplibs-commits] SF.net SVN: cs-webapplibs:[191] trunk/0.4/tests/files/test_db.sql

[<cra...@us...>]

Revision: 191
          http://cs-webapplibs.svn.sourceforge.net/cs-webapplibs/?rev=191&view=rev
Author:   crazedsanity
Date:     2011-01-15 05:27:39 +0000 (Sat, 15 Jan 2011)

Log Message:
-----------
File with the minimum requirements for testing.

Added Paths:
-----------
    trunk/0.4/tests/files/test_db.sql

Added: trunk/0.4/tests/files/test_db.sql
===================================================================
--- trunk/0.4/tests/files/test_db.sql	                        (rev 0)
+++ trunk/0.4/tests/files/test_db.sql	2011-01-15 05:27:39 UTC (rev 191)
@@ -0,0 +1,96 @@
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = public, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: cs_authentication_table; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE cs_authentication_table (
+    uid integer NOT NULL,
+    username text NOT NULL,
+    passwd character varying(32),
+    is_active boolean DEFAULT true NOT NULL,
+    date_created date DEFAULT now() NOT NULL,
+    last_login timestamp with time zone,
+    email text,
+    user_status_id integer
+);
+
+
+--
+-- Name: cs_authentication_table_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
+--
+
+CREATE SEQUENCE cs_authentication_table_uid_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+
+--
+-- Name: cs_authentication_table_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+--
+
+ALTER SEQUENCE cs_authentication_table_uid_seq OWNED BY cs_authentication_table.uid;
+
+
+--
+-- Name: cs_authentication_table_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: -
+--
+
+SELECT pg_catalog.setval('cs_authentication_table_uid_seq', 121, true);
+
+
+--
+-- Name: uid; Type: DEFAULT; Schema: public; Owner: -
+--
+
+ALTER TABLE cs_authentication_table ALTER COLUMN uid SET DEFAULT nextval('cs_authentication_table_uid_seq'::regclass);
+
+
+--
+-- Data for Name: cs_authentication_table; Type: TABLE DATA; Schema: public; Owner: -
+--
+
+INSERT INTO cs_authentication_table VALUES (101, 'slaughter', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'sla...@de...ll', 1);
+INSERT INTO cs_authentication_table VALUES (101, 'mary', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'ma...@de...ll', 1);
+INSERT INTO cs_authentication_table VALUES (101, 'einstein', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'ein...@de...ll', 1);
+INSERT INTO cs_authentication_table VALUES (101, 'alexander.graham.bell', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'ale...@de...ll', 1);
+INSERT INTO cs_authentication_table VALUES (101, 'john', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'jo...@de...ll', 1);
+INSERT INTO cs_authentication_table VALUES (101, 'xavier', 'x', true, '2008-06-01', '2011-01-10 21:07:07.029629-06', 'xa...@de...ll', 1);
+
+
+--
+-- Name: cs_authentication_table_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY cs_authentication_table
+    ADD CONSTRAINT cs_authentication_table_pkey PRIMARY KEY (uid);
+
+
+--
+-- Name: cs_authentication_table_username_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY cs_authentication_table
+    ADD CONSTRAINT cs_authentication_table_username_key UNIQUE (username);
+
+
+--
+-- PostgreSQL database dump complete
+--
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.