jcs.org
a tiny mvc framework for php using php-activerecord
1CREATE TABLE authors(
2 author_id SERIAL PRIMARY KEY,
3 parent_author_id INT,
4 name VARCHAR(25) NOT NULL DEFAULT 'default_name',
5 updated_at timestamp,
6 created_at timestamp,
7 some_date date,
8 some_time time,
9 some_text text,
10 encrypted_password varchar(50),
11 "mixedCaseField" varchar(50)
12);
13
14CREATE TABLE books(
15 book_id SERIAL PRIMARY KEY,
16 Author_Id INT,
17 secondary_author_id INT,
18 name VARCHAR(50),
19 numeric_test VARCHAR(10) DEFAULT '0',
20 special NUMERIC(10,2) DEFAULT 0.0
21);
22
23CREATE TABLE venues (
24 Id SERIAL PRIMARY KEY,
25 name varchar(50),
26 city varchar(60),
27 state char(2),
28 address varchar(50),
29 phone varchar(10) default NULL,
30 UNIQUE(name,address)
31);
32
33CREATE TABLE events (
34 id SERIAL PRIMARY KEY,
35 venue_id int NOT NULL,
36 host_id int NOT NULL,
37 title varchar(60) NOT NULL,
38 description varchar(10),
39 type varchar(15) default NULL
40);
41
42CREATE TABLE hosts(
43 id SERIAL PRIMARY KEY,
44 name VARCHAR(25)
45);
46
47CREATE TABLE employees (
48 id SERIAL PRIMARY KEY,
49 first_name VARCHAR(255) NOT NULL,
50 last_name VARCHAR(255) NOT NULL,
51 nick_name VARCHAR(255) NOT NULL
52);
53
54CREATE TABLE positions (
55 id SERIAL PRIMARY KEY,
56 employee_id int NOT NULL,
57 title VARCHAR(255) NOT NULL,
58 active SMALLINT NOT NULL
59);
60
61CREATE TABLE "rm-bldg"(
62 "rm-id" SERIAL PRIMARY KEY,
63 "rm-name" VARCHAR(10) NOT NULL,
64 "space out" VARCHAR(1) NOT NULL
65);
66
67CREATE TABLE awesome_people(
68 id serial primary key,
69 author_id int,
70 is_awesome int default 1
71);
72
73CREATE TABLE amenities(
74 amenity_id serial primary key,
75 type varchar(40) NOT NULL
76);
77
78CREATE TABLE property(
79 property_id serial primary key
80);
81
82CREATE TABLE property_amenities(
83 id serial primary key,
84 amenity_id int not null,
85 property_id int not null
86);