Changeset 485 for trunk/phpbms/install/createtables.sql

Timestamp:

04/07/09 11:44:18 (3 years ago)

Author:

nate

Message:

• Merged Nathan branch back into trunk.

Files:

• trunk/phpbms/install/createtables.sql (modified) (10 diffs)

trunk/phpbms/install/createtables.sql

@@ -58 +58 @@
   `assignedtodate` date default NULL,
   `subject` varchar(128) default NULL,
-  `type` char(2) default NULL,
+  `type` char(2) NOT NULL default 'NT',
   `createdby` int(11) NOT NULL default '0',
   `creationdate` datetime NOT NULL default '0000-00-00 00:00:00',
@@ -115 +115 @@
   `displayorder` int(11) NOT NULL default '0',
   `roleid` int(11) NOT NULL default '0',
-  `reportfile` varchar(128) default NULL,
+  `reportfile` varchar(128) NOT NULL,
   `description` text,
   `createdby` int(11) NOT NULL default '0',
@@ -169 +169 @@
   `modifieddate` timestamp NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=INNODB  AUTO_INCREMENT=1000; 
+) ENGINE=INNODB  AUTO_INCREMENT=1000;
 
 CREATE TABLE tablefindoptions (
@@ -180 +180 @@
   PRIMARY KEY  (id),
   KEY tabledef (tabledefid)
-) ENGINE=INNODB  AUTO_INCREMENT=2000; 
+) ENGINE=INNODB  AUTO_INCREMENT=2000;
 
 CREATE TABLE tableoptions (
@@ -193 +193 @@
   PRIMARY KEY  (id),
   KEY tabledef (tabledefid)
-) ENGINE=INNODB  AUTO_INCREMENT=2000; 
+) ENGINE=INNODB  AUTO_INCREMENT=2000;
 
 CREATE TABLE tablesearchablefields (
@@ -211 +211 @@
   firstname varchar(64) NOT NULL default '',
   lastname varchar(64) NOT NULL default '',
+  `lastip` VARCHAR(45) NOT NULL DEFAULT '',
   creationdate datetime NOT NULL default '0000-00-00 00:00:00',
   revoked tinyint(1) NOT NULL default '0',
@@ -259 +260 @@
   `roleid` int(11) NOT NULL default '0',
   PRIMARY KEY  (`id`)
-) ENGINE=INNODB  AUTO_INCREMENT=100; 
+) ENGINE=INNODB  AUTO_INCREMENT=100;
 
 CREATE TABLE `attachments` (
@@ -274 +275 @@
   KEY `thetable` (`tabledefid`),
   KEY `thefile` (`fileid`)
-) ENGINE=INNODB ; 
+) ENGINE=INNODB ;
 
 CREATE TABLE `roles` (
@@ -280 +281 @@
   `name` VARCHAR(64) NOT NULL,
   `description` TEXT,
-  `inactive` tinyint(4) NOT NULL,
+  `inactive` tinyint(4) NOT NULL DEFAULT 0,
   `createdby` INTEGER UNSIGNED,
   `creationdate` DATETIME,
@@ -351 +352 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=INNODB;
-