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