"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/2.5.0-2011-12-19.sql" (12 Sep 2021, 953 Bytes) of package /linux/www/Joomla_3.10.2-Stable-Full_Package.tar.bz2:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. See also the last Fossies "Diffs" side-by-side code changes report for "2.5.0-2011-12-19.sql": 3.9.25_vs_3.9.27.

    1 CREATE TABLE IF NOT EXISTS `#__user_notes` (
    2   `id` int unsigned NOT NULL AUTO_INCREMENT,
    3   `user_id` int unsigned NOT NULL DEFAULT '0',
    4   `catid` int unsigned NOT NULL DEFAULT '0',
    5   `subject` varchar(100) NOT NULL DEFAULT '',
    6   `body` text NOT NULL,
    7   `state` tinyint NOT NULL DEFAULT '0',
    8   `checked_out` int unsigned NOT NULL DEFAULT '0',
    9   `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   10   `created_user_id` int unsigned NOT NULL DEFAULT '0',
   11   `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   12   `modified_user_id` int unsigned NOT NULL,
   13   `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   14   `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   15   `publish_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
   16   `publish_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
   17   PRIMARY KEY (`id`),
   18   KEY `idx_user_id` (`user_id`),
   19   KEY `idx_category_id` (`catid`)
   20 ) DEFAULT CHARSET=utf8;