Lines Matching full:default
31 `g_title` varchar(50) NOT NULL DEFAULT '',
32 `g_user_title` varchar(50) DEFAULT NULL,
33 `g_promote_min_posts` int(10) unsigned NOT NULL DEFAULT '0',
34 `g_promote_next_group` int(10) unsigned NOT NULL DEFAULT '0',
35 `g_moderator` tinyint(1) NOT NULL DEFAULT '0',
36 `g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',
37 `g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',
38 `g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',
39 `g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',
40 `g_mod_promote_users` tinyint(1) NOT NULL DEFAULT '0',
41 `g_read_board` tinyint(1) NOT NULL DEFAULT '1',
42 `g_view_users` tinyint(1) NOT NULL DEFAULT '1',
43 `g_post_replies` tinyint(1) NOT NULL DEFAULT '1',
44 `g_post_topics` tinyint(1) NOT NULL DEFAULT '1',
45 `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',
46 `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',
47 `g_delete_topics` tinyint(1) NOT NULL DEFAULT '1',
48 `g_post_links` tinyint(1) NOT NULL DEFAULT '1',
49 `g_set_title` tinyint(1) NOT NULL DEFAULT '1',
50 `g_search` tinyint(1) NOT NULL DEFAULT '1',
51 `g_search_users` tinyint(1) NOT NULL DEFAULT '1',
52 `g_send_email` tinyint(1) NOT NULL DEFAULT '1',
53 `g_post_flood` smallint(6) NOT NULL DEFAULT '30',
54 `g_search_flood` smallint(6) NOT NULL DEFAULT '30',
55 `g_email_flood` smallint(6) NOT NULL DEFAULT '60',
56 `g_report_flood` smallint(6) NOT NULL DEFAULT '60',
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
79 `group_id` int(10) unsigned NOT NULL DEFAULT '3',
80 `username` varchar(200) NOT NULL DEFAULT '',
81 `password` varchar(40) NOT NULL DEFAULT '',
82 `email` varchar(80) NOT NULL DEFAULT '',
83 `title` varchar(50) DEFAULT NULL,
84 `realname` varchar(40) DEFAULT NULL,
85 `url` varchar(100) DEFAULT NULL,
86 `jabber` varchar(80) DEFAULT NULL,
87 `icq` varchar(12) DEFAULT NULL,
88 `msn` varchar(80) DEFAULT NULL,
89 `aim` varchar(30) DEFAULT NULL,
90 `yahoo` varchar(30) DEFAULT NULL,
91 `location` varchar(30) DEFAULT NULL,
93 `disp_topics` tinyint(3) unsigned DEFAULT NULL,
94 `disp_posts` tinyint(3) unsigned DEFAULT NULL,
95 `email_setting` tinyint(1) NOT NULL DEFAULT '1',
96 `notify_with_post` tinyint(1) NOT NULL DEFAULT '0',
97 `auto_notify` tinyint(1) NOT NULL DEFAULT '0',
98 `show_smilies` tinyint(1) NOT NULL DEFAULT '1',
99 `show_img` tinyint(1) NOT NULL DEFAULT '1',
100 `show_img_sig` tinyint(1) NOT NULL DEFAULT '1',
101 `show_avatars` tinyint(1) NOT NULL DEFAULT '1',
102 `show_sig` tinyint(1) NOT NULL DEFAULT '1',
103 `timezone` float NOT NULL DEFAULT '0',
104 `dst` tinyint(1) NOT NULL DEFAULT '0',
105 `time_format` tinyint(1) NOT NULL DEFAULT '0',
106 `date_format` tinyint(1) NOT NULL DEFAULT '0',
107 `language` varchar(25) NOT NULL DEFAULT 'English',
108 `style` varchar(25) NOT NULL DEFAULT 'Air',
109 `num_posts` int(10) unsigned NOT NULL DEFAULT '0',
110 `last_post` int(10) unsigned DEFAULT NULL,
111 `last_search` int(10) unsigned DEFAULT NULL,
112 `last_email_sent` int(10) unsigned DEFAULT NULL,
113 `last_report_sent` int(10) unsigned DEFAULT NULL,
114 `registered` int(10) unsigned NOT NULL DEFAULT '0',
115 `registration_ip` varchar(39) NOT NULL DEFAULT '0.0.0.0',
116 `last_visit` int(10) unsigned NOT NULL DEFAULT '0',
117 `admin_note` varchar(30) DEFAULT NULL,
118 `activate_string` varchar(80) DEFAULT NULL,
119 `activate_key` varchar(8) DEFAULT NULL,
123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;