jcs.org
a tiny mvc framework for php using php-activerecord
1CREATE TABLE authors(
2 author_id INTEGER NOT NULL PRIMARY KEY,
3 parent_author_id INT,
4 name VARCHAR (25) NOT NULL DEFAULT default_name, -- don't touch those spaces
5 updated_at datetime,
6 created_at datetime,
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 INTEGER NOT NULL 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
21);
22
23CREATE TABLE venues (
24 Id INTEGER NOT NULL 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 INTEGER NOT NULL 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 INTEGER NOT NULL PRIMARY KEY,
44 name VARCHAR(25)
45);
46
47CREATE TABLE employees (
48 id INTEGER NOT NULL 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 INTEGER NOT NULL 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` INT NOT NULL,
63 `rm-name` VARCHAR(10) NOT NULL,
64 `space out` VARCHAR(1) NOT NULL
65);
66
67CREATE TABLE awesome_people(
68 id integer not null primary key,
69 author_id int,
70 is_awesome int default 1
71);
72
73CREATE TABLE amenities(
74 `amenity_id` INTEGER NOT NULL PRIMARY KEY,
75 `type` varchar(40) DEFAULT NULL
76);
77
78CREATE TABLE property(
79 `property_id` INTEGER NOT NULL PRIMARY KEY
80);
81
82CREATE TABLE property_amenities(
83 `id` INTEGER NOT NULL PRIMARY KEY,
84 `amenity_id` INT NOT NULL,
85 `property_id` INT NOT NULL
86);
87
88CREATE TABLE users (
89 id INTEGER NOT NULL PRIMARY KEY
90);
91
92CREATE TABLE newsletters (
93 id INTEGER NOT NULL PRIMARY KEY
94);
95
96CREATE TABLE user_newsletters (
97 id INTEGER NOT NULL PRIMARY KEY,
98 user_id INTEGER NOT NULL,
99 newsletter_id INTEGER NOT NULL
100);