public/install/installation/templates/sql/mysql_schema.php

   1 CREATE TABLE `<?php echo $table_prefix ?>administration_tools` (
   2   `id` tinyint(3) unsigned NOT NULL auto_increment,
   3   `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
   4   `controller` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
   5   `action` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
   6   `order` tinyint(3) unsigned NOT NULL default '0',
   7   PRIMARY KEY  (`id`),
   8   UNIQUE KEY `name` (`name`)
   9 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  10
  11 CREATE TABLE `<?php echo $table_prefix ?>application_logs` (
  12   `id` int(10) unsigned NOT NULL auto_increment,
  13   `taken_by_id` int(10) unsigned default NULL,
  14   `project_id` int(10) unsigned NOT NULL default '0',
  15   `rel_object_id` int(10) NOT NULL default '0',
  16   `object_name` text <?php echo $default_collation ?>,
  17   `rel_object_manager` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  18   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  19   `created_by_id` int(10) unsigned default NULL,
  20   `action` enum('upload','open','close','delete','edit','add') <?php echo $default_collation ?> default NULL,
  21   `is_private` tinyint(1) unsigned NOT NULL default '0',
  22   `is_silent` tinyint(1) unsigned NOT NULL default '0',
  23   PRIMARY KEY  (`id`),
  24   KEY `created_on` (`created_on`),
  25   KEY `project_id` (`project_id`)
  26 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  27
  28 CREATE TABLE `<?php echo $table_prefix ?>attached_files` (
  29   `rel_object_manager` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  30   `rel_object_id` int(10) unsigned NOT NULL default '0',
  31   `file_id` int(10) unsigned NOT NULL default '0',
  32   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  33   `created_by_id` int(10) unsigned default NULL,
  34   PRIMARY KEY  (`rel_object_manager`,`rel_object_id`,`file_id`)
  35 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  36
  37 CREATE TABLE `<?php echo $table_prefix ?>comments` (
  38   `id` int(10) unsigned NOT NULL auto_increment,
  39   `rel_object_id` int(10) unsigned NOT NULL default '0',
  40   `rel_object_manager` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
  41   `text` text <?php echo $default_collation ?>,
  42   `is_private` tinyint(1) unsigned NOT NULL default '0',
  43   `is_anonymous` tinyint(1) unsigned NOT NULL default '0',
  44   `author_name` varchar(50) <?php echo $default_collation ?> default NULL,
  45   `author_email` varchar(100) <?php echo $default_collation ?> default NULL,
  46   `author_homepage` varchar(100) <?php echo $default_collation ?> NOT NULL default '',
  47   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  48   `created_by_id` int(10) unsigned default NULL,
  49   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  50   `updated_by_id` int(10) unsigned default NULL,
  51   PRIMARY KEY  (`id`),
  52   KEY `object_id` (`rel_object_id`,`rel_object_manager`),
  53   KEY `created_on` (`created_on`)
  54 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  55
  56 CREATE TABLE `<?php echo $table_prefix ?>companies` (
  57   `id` smallint(5) unsigned NOT NULL auto_increment,
  58   `client_of_id` smallint(5) unsigned default NULL,
  59   `name` varchar(50) <?php echo $default_collation ?> default NULL,
  60   `email` varchar(100) <?php echo $default_collation ?> default NULL,
  61   `homepage` varchar(100) <?php echo $default_collation ?> default NULL,
  62   `address` varchar(100) <?php echo $default_collation ?> default NULL,
  63   `address2` varchar(100) <?php echo $default_collation ?> default NULL,
  64   `city` varchar(50) <?php echo $default_collation ?> default NULL,
  65   `state` varchar(50) <?php echo $default_collation ?> default NULL,
  66   `zipcode` varchar(30) <?php echo $default_collation ?> default NULL,
  67   `country` varchar(10) <?php echo $default_collation ?> default NULL,
  68   `phone_number` varchar(30) <?php echo $default_collation ?> default NULL,
  69   `fax_number` varchar(30) <?php echo $default_collation ?> default NULL,
  70   `logo_file` varchar(44) <?php echo $default_collation ?> default NULL,
  71   `timezone` float(2,1) NOT NULL default '0.0',
  72   `hide_welcome_info` tinyint(1) unsigned NOT NULL default '0',
  73   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  74   `created_by_id` int(10) unsigned default NULL,
  75   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  76   `updated_by_id` int(10) unsigned default NULL,
  77   PRIMARY KEY  (`id`),
  78   KEY `created_on` (`created_on`),
  79   KEY `client_of_id` (`client_of_id`)
  80 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  81
  82 CREATE TABLE `<?php echo $table_prefix ?>config_categories` (
  83   `id` tinyint(3) unsigned NOT NULL auto_increment,
  84   `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  85   `is_system` tinyint(1) unsigned NOT NULL default '0',
  86   `category_order` tinyint(3) unsigned NOT NULL default '0',
  87   PRIMARY KEY  (`id`),
  88   UNIQUE KEY `name` (`name`),
  89   KEY `order` (`category_order`)
  90 ) ENGINE=InnoDB <?php echo $default_charset ?>;
  91
  92 CREATE TABLE `<?php echo $table_prefix ?>config_options` (
  93   `id` smallint(5) unsigned NOT NULL auto_increment,
  94   `category_name` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
  95   `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  96   `value` text <?php echo $default_collation ?>,
  97   `config_handler_class` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  98   `is_system` tinyint(1) unsigned NOT NULL default '0',
  99   `option_order` smallint(5) unsigned NOT NULL default '0',
 100   `dev_comment` varchar(255) <?php echo $default_collation ?> default NULL,
 101   PRIMARY KEY  (`id`),
 102   UNIQUE KEY `name` (`name`),
 103   KEY `order` (`option_order`),
 104   KEY `category_id` (`category_name`)
 105 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 106
 107 CREATE TABLE `<?php echo $table_prefix ?>file_repo` (
 108   `id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
 109   `content` longblob NOT NULL,
 110   `order` int(10) unsigned NOT NULL default '0',
 111   PRIMARY KEY  (`id`),
 112   KEY `order` (`order`)
 113 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 114
 115 CREATE TABLE `<?php echo $table_prefix ?>file_repo_attributes` (
 116   `id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
 117   `attribute` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 118   `value` text <?php echo $default_collation ?> NOT NULL,
 119   PRIMARY KEY  (`id`,`attribute`)
 120 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 121
 122 CREATE TABLE `<?php echo $table_prefix ?>file_types` (
 123   `id` smallint(5) unsigned NOT NULL auto_increment,
 124   `extension` varchar(10) <?php echo $default_collation ?> NOT NULL default '',
 125   `icon` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
 126   `is_searchable` tinyint(1) unsigned NOT NULL default '0',
 127   `is_image` tinyint(1) unsigned NOT NULL default '0',
 128   PRIMARY KEY  (`id`),
 129   UNIQUE KEY `extension` (`extension`)
 130 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 131
 132 CREATE TABLE `<?php echo $table_prefix ?>im_types` (
 133   `id` tinyint(3) unsigned NOT NULL auto_increment,
 134   `name` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
 135   `icon` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
 136   PRIMARY KEY  (`id`)
 137 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 138
 139 CREATE TABLE `<?php echo $table_prefix ?>message_subscriptions` (
 140   `message_id` int(10) unsigned NOT NULL default '0',
 141   `user_id` int(10) unsigned NOT NULL default '0',
 142   PRIMARY KEY  (`message_id`,`user_id`)
 143 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 144
 145 CREATE TABLE `<?php echo $table_prefix ?>project_companies` (
 146   `project_id` int(10) unsigned NOT NULL default '0',
 147   `company_id` smallint(5) unsigned NOT NULL default '0',
 148   PRIMARY KEY  (`project_id`,`company_id`)
 149 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 150
 151 CREATE TABLE `<?php echo $table_prefix ?>project_file_revisions` (
 152   `id` int(10) unsigned NOT NULL auto_increment,
 153   `file_id` int(10) unsigned NOT NULL default '0',
 154   `file_type_id` smallint(5) unsigned NOT NULL default '0',
 155   `repository_id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
 156   `thumb_filename` varchar(44) <?php echo $default_collation ?> default NULL,
 157   `revision_number` int(10) unsigned NOT NULL default '0',
 158   `comment` text <?php echo $default_collation ?>,
 159   `type_string` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 160   `filesize` int(10) unsigned NOT NULL default '0',
 161   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 162   `created_by_id` int(10) unsigned default NULL,
 163   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 164   `updated_by_id` int(10) unsigned default NULL,
 165   PRIMARY KEY  (`id`),
 166   KEY `file_id` (`file_id`),
 167   KEY `updated_on` (`updated_on`),
 168   KEY `revision_number` (`revision_number`)
 169 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 170
 171 CREATE TABLE `<?php echo $table_prefix ?>project_files` (
 172   `id` int(10) unsigned NOT NULL auto_increment,
 173   `project_id` int(10) unsigned NOT NULL default '0',
 174   `folder_id` smallint(5) unsigned NOT NULL default '0',
 175   `filename` varchar(100) <?php echo $default_collation ?> NOT NULL default '',
 176   `description` text <?php echo $default_collation ?>,
 177   `is_private` tinyint(1) unsigned NOT NULL default '0',
 178   `is_important` tinyint(1) unsigned NOT NULL default '0',
 179   `is_locked` tinyint(1) unsigned NOT NULL default '0',
 180   `is_visible` tinyint(1) unsigned NOT NULL default '0',
 181   `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
 182   `comments_enabled` tinyint(1) unsigned NOT NULL default '0',
 183   `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL default '0',
 184   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 185   `created_by_id` int(10) unsigned default '0',
 186   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 187   `updated_by_id` int(10) unsigned default '0',
 188   PRIMARY KEY  (`id`),
 189   KEY `project_id` (`project_id`)
 190 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 191
 192 CREATE TABLE `<?php echo $table_prefix ?>project_folders` (
 193   `id` smallint(5) unsigned NOT NULL auto_increment,
 194   `project_id` int(10) unsigned NOT NULL default '0',
 195   `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 196   PRIMARY KEY  (`id`),
 197   UNIQUE KEY `project_id` (`project_id`,`name`)
 198 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 199
 200 CREATE TABLE `<?php echo $table_prefix ?>project_forms` (
 201   `id` smallint(5) unsigned NOT NULL auto_increment,
 202   `project_id` int(10) unsigned NOT NULL default '0',
 203   `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 204   `description` text <?php echo $default_collation ?> NOT NULL,
 205   `success_message` text <?php echo $default_collation ?> NOT NULL,
 206   `action` enum('add_comment','add_task') <?php echo $default_collation ?> NOT NULL default 'add_comment',
 207   `in_object_id` int(10) unsigned NOT NULL default '0',
 208   `created_on` datetime default NULL,
 209   `created_by_id` int(10) unsigned NOT NULL default '0',
 210   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 211   `updated_by_id` int(10) unsigned NOT NULL default '0',
 212   `is_visible` tinyint(1) unsigned NOT NULL default '0',
 213   `is_enabled` tinyint(1) unsigned NOT NULL default '0',
 214   `order` smallint(6) NOT NULL default '0',
 215   PRIMARY KEY  (`id`)
 216 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 217
 218 CREATE TABLE `<?php echo $table_prefix ?>project_messages` (
 219   `id` int(10) unsigned NOT NULL auto_increment,
 220   `milestone_id` int(10) unsigned NOT NULL default '0',
 221   `project_id` int(10) unsigned default NULL,
 222   `title` varchar(100) <?php echo $default_collation ?> default NULL,
 223   `text` text <?php echo $default_collation ?>,
 224   `additional_text` text <?php echo $default_collation ?>,
 225   `is_important` tinyint(1) unsigned NOT NULL default '0',
 226   `is_private` tinyint(1) unsigned NOT NULL default '0',
 227   `comments_enabled` tinyint(1) unsigned NOT NULL default '0',
 228   `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL default '0',
 229   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 230   `created_by_id` int(10) unsigned default NULL,
 231   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 232   `updated_by_id` int(10) unsigned default NULL,
 233   PRIMARY KEY  (`id`),
 234   KEY `milestone_id` (`milestone_id`),
 235   KEY `project_id` (`project_id`),
 236   KEY `created_on` (`created_on`)
 237 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 238
 239 CREATE TABLE `<?php echo $table_prefix ?>project_milestones` (
 240   `id` int(10) unsigned NOT NULL auto_increment,
 241   `project_id` int(10) unsigned default NULL,
 242   `name` varchar(100) <?php echo $default_collation ?> default NULL,
 243   `description` text <?php echo $default_collation ?>,
 244   `due_date` datetime NOT NULL default '0000-00-00 00:00:00',
 245   `assigned_to_company_id` smallint(10) NOT NULL default '0',
 246   `assigned_to_user_id` int(10) unsigned NOT NULL default '0',
 247   `is_private` tinyint(1) unsigned NOT NULL default '0',
 248   `completed_on` datetime NOT NULL default '0000-00-00 00:00:00',
 249   `completed_by_id` int(10) unsigned default NULL,
 250   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 251   `created_by_id` int(10) unsigned default NULL,
 252   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 253   `updated_by_id` int(10) unsigned default NULL,
 254   PRIMARY KEY  (`id`),
 255   KEY `project_id` (`project_id`),
 256   KEY `due_date` (`due_date`),
 257   KEY `completed_on` (`completed_on`),
 258   KEY `created_on` (`created_on`)
 259 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 260
 261 CREATE TABLE `<?php echo $table_prefix ?>project_task_lists` (
 262   `id` int(10) unsigned NOT NULL auto_increment,
 263   `milestone_id` int(10) unsigned NOT NULL default '0',
 264   `project_id` int(10) unsigned default NULL,
 265   `name` varchar(100) <?php echo $default_collation ?> default NULL,
 266   `description` text <?php echo $default_collation ?>,
 267   `is_private` tinyint(1) unsigned NOT NULL default '0',
 268   `completed_on` datetime NOT NULL default '0000-00-00 00:00:00',
 269   `completed_by_id` int(10) unsigned default NULL,
 270   `created_on` datetime default NULL,
 271   `created_by_id` int(10) unsigned NOT NULL default '0',
 272   `updated_on` datetime default NULL,
 273   `updated_by_id` int(10) unsigned NOT NULL default '0',
 274   `order` tinyint(3) unsigned NOT NULL default '0',
 275   PRIMARY KEY  (`id`),
 276   KEY `milestone_id` (`milestone_id`),
 277   KEY `project_id` (`project_id`),
 278   KEY `completed_on` (`completed_on`),
 279   KEY `created_on` (`created_on`)
 280 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 281
 282 CREATE TABLE `<?php echo $table_prefix ?>project_tasks` (
 283   `id` int(10) unsigned NOT NULL auto_increment,
 284   `task_list_id` int(10) unsigned default NULL,
 285   `text` text <?php echo $default_collation ?>,
 286   `assigned_to_company_id` smallint(5) unsigned default NULL,
 287   `assigned_to_user_id` int(10) unsigned default NULL,
 288   `completed_on` datetime NOT NULL default '0000-00-00 00:00:00',
 289   `completed_by_id` int(10) unsigned default NULL,
 290   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 291   `created_by_id` int(10) unsigned default NULL,
 292   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 293   `updated_by_id` int(10) unsigned default NULL,
 294   `order` int(10) unsigned NOT NULL default '0',
 295   PRIMARY KEY  (`id`),
 296   KEY `task_list_id` (`task_list_id`),
 297   KEY `completed_on` (`completed_on`),
 298   KEY `created_on` (`created_on`),
 299   KEY `order` (`order`)
 300 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 301
 302 CREATE TABLE `<?php echo $table_prefix ?>project_users` (
 303   `project_id` int(10) unsigned NOT NULL default '0',
 304   `user_id` int(10) unsigned NOT NULL default '0',
 305   `created_on` datetime default NULL,
 306   `created_by_id` int(10) unsigned NOT NULL default '0',
 307   `can_manage_messages` tinyint(1) unsigned default '0',
 308   `can_manage_tasks` tinyint(1) unsigned default '0',
 309   `can_manage_milestones` tinyint(1) unsigned default '0',
 310   `can_upload_files` tinyint(1) unsigned default '0',
 311   `can_manage_files` tinyint(1) unsigned default '0',
 312   `can_assign_to_owners` tinyint(1) unsigned NOT NULL default '0',
 313   `can_assign_to_other` tinyint(1) unsigned NOT NULL default '0',
 314   PRIMARY KEY  (`project_id`,`user_id`)
 315 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 316
 317 CREATE TABLE `<?php echo $table_prefix ?>projects` (
 318   `id` int(10) unsigned NOT NULL auto_increment,
 319   `name` varchar(50) <?php echo $default_collation ?> default NULL,
 320   `description` text <?php echo $default_collation ?>,
 321   `show_description_in_overview` tinyint(1) unsigned NOT NULL default '0',
 322   `completed_on` datetime NOT NULL default '0000-00-00 00:00:00',
 323   `completed_by_id` int(11) default NULL,
 324   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 325   `created_by_id` int(10) unsigned default NULL,
 326   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 327   `updated_by_id` int(10) unsigned default NULL,
 328   PRIMARY KEY  (`id`),
 329   KEY `completed_on` (`completed_on`)
 330 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 331
 332 CREATE TABLE `<?php echo $table_prefix ?>searchable_objects` (
 333   `rel_object_manager` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 334   `rel_object_id` int(10) unsigned NOT NULL default '0',
 335   `column_name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 336   `content` text <?php echo $default_collation ?> NOT NULL,
 337   `project_id` int(10) unsigned NOT NULL default '0',
 338   `is_private` tinyint(1) unsigned NOT NULL default '0',
 339   PRIMARY KEY  (`rel_object_manager`,`rel_object_id`,`column_name`),
 340   KEY `project_id` (`project_id`),
 341   FULLTEXT KEY `content` (`content`)
 342 ) ENGINE=MyISAM <?php echo $default_charset ?>;
 343
 344 CREATE TABLE `<?php echo $table_prefix ?>tags` (
 345   `id` int(10) unsigned NOT NULL auto_increment,
 346   `project_id` int(10) unsigned NOT NULL default '0',
 347   `tag` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
 348   `rel_object_id` int(10) unsigned NOT NULL default '0',
 349   `rel_object_manager` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 350   `created_on` datetime default NULL,
 351   `created_by_id` int(10) unsigned NOT NULL default '0',
 352   `is_private` tinyint(1) NOT NULL default '0',
 353   PRIMARY KEY  (`id`),
 354   KEY `project_id` (`project_id`),
 355   KEY `tag` (`tag`),
 356   KEY `object_id` (`rel_object_id`,`rel_object_manager`)
 357 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 358
 359 CREATE TABLE `<?php echo $table_prefix ?>user_im_values` (
 360   `user_id` int(10) unsigned NOT NULL default '0',
 361   `im_type_id` tinyint(3) unsigned NOT NULL default '0',
 362   `value` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 363   `is_default` tinyint(1) unsigned NOT NULL default '0',
 364   PRIMARY KEY  (`user_id`,`im_type_id`),
 365   KEY `is_default` (`is_default`)
 366 ) ENGINE=InnoDB <?php echo $default_charset ?>;
 367
 368 CREATE TABLE `<?php echo $table_prefix ?>users` (
 369   `id` int(10) unsigned NOT NULL auto_increment,
 370   `company_id` smallint(5) unsigned NOT NULL default '0',
 371   `username` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
 372   `email` varchar(100) <?php echo $default_collation ?> default NULL,
 373   `token` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
 374   `salt` varchar(13) <?php echo $default_collation ?> NOT NULL default '',
 375   `twister` varchar(10) <?php echo $default_collation ?> NOT NULL default '',
 376   `display_name` varchar(50) <?php echo $default_collation ?> default NULL,
 377   `title` varchar(30) <?php echo $default_collation ?> default NULL,
 378   `avatar_file` varchar(44) <?php echo $default_collation ?> default NULL,
 379   `office_number` varchar(20) <?php echo $default_collation ?> default NULL,
 380   `fax_number` varchar(20) <?php echo $default_collation ?> default NULL,
 381   `mobile_number` varchar(20) <?php echo $default_collation ?> default NULL,
 382   `home_number` varchar(20) <?php echo $default_collation ?> default NULL,
 383   `timezone` float(2,1) NOT NULL default '0.0',
 384   `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
 385   `created_by_id` int(10) unsigned default NULL,
 386   `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
 387   `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
 388   `last_visit` datetime NOT NULL default '0000-00-00 00:00:00',
 389   `last_activity` datetime NOT NULL default '0000-00-00 00:00:00',
 390   `is_admin` tinyint(1) unsigned default NULL,
 391   `auto_assign` tinyint(1) unsigned NOT NULL default '0',
 392   PRIMARY KEY  (`id`),
 393   UNIQUE KEY `username` (`username`),
 394   UNIQUE KEY `email` (`email`),
 395   KEY `last_visit` (`last_visit`),
 396   KEY `company_id` (`company_id`),
 397   KEY `last_login` (`last_login`)
 398 ) ENGINE=InnoDB <?php echo $default_charset ?>;