Differences

This shows you the differences between two versions of the page.

--- arch-upstream [2017/03/23 11:59] – 46.223.128.124
+++ arch-upstream [2021/10/31 10:42] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+<code>https://github.com/reuben/pgdump2sql</code>
+<code>CREATE TABLE projects (
+    id integer NOT NULL,
+    name character varying(200) NOT NULL,
+    homepage character varying(200) NOT NULL,
+    backend character varying(20),
+    version_url character varying(200),
+    regex character varying(200),
+    latest_version character varying(50),
+    logs text,
+    updated_on timestamp,
+    created_on timestamp,
+    insecure boolean DEFAULT false NOT NULL,
+    version_prefix character varying(200),
+    ecosystem_name character varying(200)
+);
+CREATE TABLE packages (
+    id integer NOT NULL,
+    distro character varying(200),
+    project_id integer,
+    package_name character varying(200)
+);</code>
+<code>select project_id,package_name from packages where package_name="0ad" and distro="Arch Linux";
+select latest_version from projects where id="5830";</code>

Project-Insanity