How to start?

Is it possible to include a file with SQL statements to create sample databases?

An example and documentation (how to use) would also be very helpful.

Thanks.

on the fly create this tables and add two fields to your users table (not tested)

CREATE TABLE IF NOT EXISTS `notifications`
(
`actor_id` int(11) unsigned NOT NULL,
`subject_id` int(11) unsigned NOT NULL,
`object_id` int(11) unsigned NOT NULL,
`type_id` int(11) unsigned NOT NULL,
`status` varchar(15) COLLATE utf8_unicode_ci NOT NULL, -- seen | unseen
`count` int(11) unsigned NOT NULL,
`created_date` date DEFAULT NULL,
`updated_date` date DEFAULT NULL,
)

CREATE TABLE IF NOT EXISTS `status`
(
`actor_id` int(11) unsigned NOT NULL;
}

add this varchar fields to your users table: actor , subject

this line is without comma:

`updated_date` date DEFAULT NULL