# DDL to set up a table of bleats, for some first examples of working with
# forms and Ajax.

# Scott D. Anderson
# February 2015

use webdb;

drop table if exists bleats;

create table bleats (
       bid integer auto_increment primary key,
       expires datetime,
       likes integer default 0,
       bleat varchar(140)
);

insert into bleats values (0, '2115-05-31', 10, 'This is the first bleat; it never expires');
insert into bleats values (0, '2115-05-31', 3, 'More whining and complaining');
insert into bleats values (0, '2115-05-31', 100, 'That\'s okay, the sun\'ll come out tomorrow');