Comments (2)
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
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: content; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE TABLE content (
node_id integer NOT NULL,
version integer DEFAULT 0 NOT NULL,
text text DEFAULT ''::text NOT NULL,
modified timestamp without time zone,
comment text DEFAULT ''::text NOT NULL,
moderated boolean DEFAULT true NOT NULL,
verified timestamp without time zone,
verified_info text DEFAULT ''::text NOT NULL
);
ALTER TABLE public.content OWNER TO actuser_wiki;
--
-- Name: internal_links; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE TABLE internal_links (
link_from character varying(200) DEFAULT ''::character varying NOT NULL,
link_to character varying(200) DEFAULT ''::character varying NOT NULL
);
ALTER TABLE public.internal_links OWNER TO actuser_wiki;
--
-- Name: metadata; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE TABLE metadata (
node_id integer NOT NULL,
version integer DEFAULT 0 NOT NULL,
metadata_type character varying(200) DEFAULT ''::character varying NOT NULL,
metadata_value text DEFAULT ''::text NOT NULL
);
ALTER TABLE public.metadata OWNER TO actuser_wiki;
--
-- Name: node_seq; Type: SEQUENCE; Schema: public; Owner: actuser_wiki
--
CREATE SEQUENCE node_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.node_seq OWNER TO actuser_wiki;
--
-- Name: node_seq; Type: SEQUENCE SET; Schema: public; Owner: actuser_wiki
--
SELECT pg_catalog.setval('node_seq', 1, false);
--
-- Name: node; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE TABLE node (
id integer DEFAULT nextval('node_seq'::regclass) NOT NULL,
name character varying(200) DEFAULT ''::character varying NOT NULL,
version integer DEFAULT 0 NOT NULL,
text text DEFAULT ''::text NOT NULL,
modified timestamp without time zone,
moderate boolean DEFAULT false NOT NULL
);
ALTER TABLE public.node OWNER TO actuser_wiki;
--
-- Name: schema_info; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE TABLE schema_info (
version integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.schema_info OWNER TO actuser_wiki;
--
-- Data for Name: content; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--
COPY content (node_id, version, text, modified, comment, moderated, verified, verified_info) FROM stdin;
\.
--
-- Data for Name: internal_links; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--
COPY internal_links (link_from, link_to) FROM stdin;
\.
--
-- Data for Name: metadata; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--
COPY metadata (node_id, version, metadata_type, metadata_value) FROM stdin;
\.
--
-- Data for Name: node; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--
COPY node (id, name, version, text, modified, moderate) FROM stdin;
\.
--
-- Data for Name: schema_info; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--
COPY schema_info (version) FROM stdin;
10
\.
--
-- Name: pk_id; Type: CONSTRAINT; Schema: public; Owner: actuser_wiki; Tablespace:
--
ALTER TABLE ONLY node
ADD CONSTRAINT pk_id PRIMARY KEY (id);
--
-- Name: pk_node_id; Type: CONSTRAINT; Schema: public; Owner: actuser_wiki; Tablespace:
--
ALTER TABLE ONLY content
ADD CONSTRAINT pk_node_id PRIMARY KEY (node_id, version);
--
-- Name: internal_links_pkey; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE UNIQUE INDEX internal_links_pkey ON internal_links USING btree (link_from, link_to);
--
-- Name: metadata_index; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE INDEX metadata_index ON metadata USING btree (node_id, version, metadata_type, metadata_value);
--
-- Name: node_name; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace:
--
CREATE UNIQUE INDEX node_name ON node USING btree (name);
--
-- Name: fk_node_id; Type: FK CONSTRAINT; Schema: public; Owner: actuser_wiki
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT fk_node_id FOREIGN KEY (node_id) REFERENCES node(id);
--
-- Name: fk_node_id; Type: FK CONSTRAINT; Schema: public; Owner: actuser_wiki
--
ALTER TABLE ONLY content
ADD CONSTRAINT fk_node_id FOREIGN KEY (node_id) REFERENCES node(id);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--
from act.
Thanks, seems to be working!
from act.
Related Issues (20)
- Create default configuration so one can start working on Act on a first docker start HOT 1
- Create a mail container that sends e-mail so we don't have multiple services running in one docker container HOT 1
- Create Dockerfile that just works HOT 1
- Create docker-compose.yml for instant gratitifaction HOT 2
- Create proper readme for developers and users so they can act accordingly HOT 1
- Create seperate database for the wiki HOT 3
- Change directory layout for conferences HOT 5
- PSGI or not (which branch becomes leading master or PSGI) HOT 16
- Where to store photo's HOT 5
- Serving CSS and other static files HOT 2
- Password checking maybe broken HOT 7
- Publish image to a registry HOT 1
- Allow files to be placed on S3/Swift HOT 5
- Make testsuite work HOT 2
- Act::Config shouldn't load the configuration files by default HOT 1
- Photo's aren't shown to the user HOT 1
- Not all static files are shown HOT 2
- Automate Makefile.PL / cpanfile creation HOT 1
- Use sqitch for DB management HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from act.