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