PHP Classes

How to start?

Recommend this page to a friend!

      PHP Notification System  >  All threads  >  How to start?  >  (Un) Subscribe thread alerts  
Subject:How to start?
Summary:Documentation and example is missing
Messages:3
Author:Gerry Danen
Date:2015-10-02 14:39:46
 

  1. How to start?   Reply   Report abuse  
Picture of Gerry Danen Gerry Danen - 2015-10-02 14:39:46
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.

  2. Re: How to start?   Reply   Report abuse  
Picture of Karl Karl - 2015-10-30 23:42:32 - In reply to message 1 from Gerry Danen
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

  3. Re: How to start?   Reply   Report abuse  
Picture of Karl Karl - 2015-10-30 23:45:57 - In reply to message 2 from Karl
this line is without comma:

`updated_date` date DEFAULT NULL

 
For more information send a message to info at phpclasses dot org.