jcs.org
a tiny mvc framework for php using php-activerecord
1DROP TABLE IF EXISTS authors;
2CREATE TABLE authors(
3 author_id INTEGER NOT NULL PRIMARY KEY,
4 parent_author_id INT,
5 name VARCHAR (25) NOT NULL DEFAULT default_name, -- don't touch those spaces
6 updated_at datetime,
7 created_at datetime,
8 some_date date
9);
10
11DROP TABLE IF EXISTS books;
12CREATE TABLE books(
13 book_id INTEGER NOT NULL PRIMARY KEY,
14 author_id INT,
15 secondary_author_id INT,
16 name VARCHAR(50),
17 numeric_test VARCHAR(10) DEFAULT '0',
18 special NUMERIC(10,2) DEFAULT 0
19);
20
21DROP TABLE IF EXISTS venues;
22CREATE TABLE venues (
23 id INTEGER NOT NULL PRIMARY KEY,
24 name varchar(50),
25 city varchar(60),
26 state char(2),
27 address varchar(50),
28 phone varchar(10) default NULL,
29 UNIQUE(name,address)
30);
31
32DROP TABLE IF EXISTS events;
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(50) NOT NULL,
38 description varchar(10),
39 type varchar(15) default NULL
40);
41
42DROP TABLE IF EXISTS hosts;
43CREATE TABLE hosts(
44 id INTEGER NOT NULL PRIMARY KEY,
45 name VARCHAR(10)
46);
47
48DROP TABLE IF EXISTS employees;
49CREATE TABLE employees (
50 id INTEGER NOT NULL PRIMARY KEY,
51 first_name VARCHAR( 255 ) NOT NULL ,
52 last_name VARCHAR( 255 ) NOT NULL ,
53 nick_name VARCHAR( 255 ) NOT NULL
54);
55
56DROP TABLE IF EXISTS positions;
57CREATE TABLE positions (
58 id INTEGER NOT NULL PRIMARY KEY,
59 employee_id int NOT NULL,
60 title VARCHAR(255) NOT NULL,
61 active SMALLINT NOT NULL
62);
63
64DROP TABLE IF EXISTS `rm-bldg`;
65CREATE TABLE `rm-bldg`(
66 `rm-id` INT NOT NULL,
67 `rm-name` VARCHAR(10) NOT NULL,
68 `space out` VARCHAR(1) NOT NULL
69);