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.
|
