Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
149 lines (129 sloc) 2.94 KB
SET search_path = public, pg_catalog;
CREATE TABLE accounts (
id serial,
firm_id integer,
credit_limit integer,
PRIMARY KEY (id)
);
SELECT setval('accounts_id_seq', 100);
CREATE TABLE companies (
id serial,
"type" character varying(50),
"ruby_type" character varying(50),
firm_id integer,
name character varying(50),
client_of integer,
rating integer default 1,
PRIMARY KEY (id)
);
SELECT setval('companies_id_seq', 100);
CREATE TABLE developers_projects (
developer_id integer NOT NULL,
project_id integer NOT NULL,
joined_on date
);
CREATE TABLE developers (
id serial,
name character varying(100),
salary integer DEFAULT 70000,
PRIMARY KEY (id)
);
SELECT setval('developers_id_seq', 100);
CREATE TABLE projects (
id serial,
name character varying(100),
PRIMARY KEY (id)
);
SELECT setval('projects_id_seq', 100);
CREATE TABLE topics (
id serial,
title character varying(255),
author_name character varying(255),
author_email_address character varying(255),
written_on timestamp without time zone,
bonus_time time,
last_read date,
content text,
replies_count integer default 0,
parent_id integer,
"type" character varying(50),
approved smallint DEFAULT 1,
PRIMARY KEY (id)
);
SELECT setval('topics_id_seq', 100);
CREATE TABLE customers (
id serial,
name character varying,
balance integer default 0,
address_street character varying,
address_city character varying,
address_country character varying,
PRIMARY KEY (id)
);
SELECT setval('customers_id_seq', 100);
CREATE TABLE movies (
movieid serial,
name text,
PRIMARY KEY (movieid)
);
CREATE TABLE subscribers (
nick text NOT NULL,
name text,
PRIMARY KEY (nick)
);
CREATE TABLE booleantests (
id serial,
value boolean,
PRIMARY KEY (id)
);
CREATE TABLE defaults (
id serial,
modified_date date default CURRENT_DATE,
fixed_date date default '2004-01-01',
modified_time timestamp default CURRENT_TIMESTAMP,
fixed_time timestamp default '2004-01-01 00:00:00.000000-00',
char1 char(1) default 'Y',
char2 character varying(50) default 'a varchar field',
char3 text default 'a text field'
);
CREATE TABLE auto_id_tests (
auto_id serial,
value integer,
PRIMARY KEY (auto_id)
);
CREATE TABLE entrants (
id serial,
name text,
course_id integer
);
CREATE TABLE colnametests (
id serial,
"references" integer NOT NULL
);
CREATE TABLE mixins (
id serial,
parent_id integer,
type character varying,
pos integer,
lft integer,
rgt integer,
root_id integer,
created_at timestamp,
updated_at timestamp,
PRIMARY KEY (id)
);
CREATE TABLE people (
id serial,
first_name text,
lock_version integer default 0,
PRIMARY KEY (id)
);
CREATE TABLE binaries (
id serial ,
data bytea,
PRIMARY KEY (id)
);
CREATE TABLE computers (
id serial,
developer integer NOT NULL
);
Jump to Line
Something went wrong with that request. Please try again.