Changeset 17 for web/database.sql

Timestamp:

Jul 27, 2016, 11:20:41 PM (8 years ago)

Author:

chronos

Message:

• Modified: Old database class replaced by newer from Common package to fix compatibility with PHP7.

Location:

web

Files:

• . (modified) (1 prop)
• database.sql (modified) (2 diffs)

web/database.sql

@@ -4 +4 @@
   `name` varchar(255) NOT NULL default '',
   `hits` int(11) NOT NULL default '0',
-  `date` date NOT NULL default '0000-00-00',
+  `date` date NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
@@ -12 +12 @@
 CREATE TABLE IF NOT EXISTS `user_notes` (
   `id` int(11) NOT NULL auto_increment,
-  `time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `time` datetime NOT NULL,
   `nick` varchar(32) NOT NULL default '',
   `title` varchar(64) NOT NULL default '',