fWZpcAWz

1-- --------------------------------------------------
2-- PAGES
3-- --------------------------------------------------
4drop table if exists pages;
5create table if not exists pages (
6  id int(11) not null auto_increment primary key,
7  script_name varchar(255) not null,
8  content  longtext null,
9  date_updated timestamp not null
10) type=innodb charset=utf8;
11
12insert into pages (script_name, content) values 
13  ('hello.php', 'blah blah blah'),
14  ('another.php', 'OK NEATO!');
15
16
17
18-- DUMP
19-- SELECT * FROM pages;
20-- +----+-------------+----------------+----------------+
21-- | id | script_name | content        | date_updated   |
22-- +----+-------------+----------------+----------------+
23-- |  1 | hello.php   | blah blah blah | 20080405065204 | 
24-- |  2 | another.php | OK NEATO!      | 20080405065204 | 
25-- +----+-------------+----------------+----------------+
26-- 2 rows in set (0.03 sec)