Инструменты пользователя
Это старая версия документа.
====== РИВР. Руководство администратора ====== ===== Назначение информационной системы ===== РИВР - акроним фразы "Распространение инвазионных видов растений". Целью создания информационной системы РИВР является автоматизация процесса сбора и отображения сведений о географическом распространении инвазионных видов растений. На сайте http://proborshevik.ru/map РИВР отображает сведения о географическом распространении борщевика Сосновского и предоставляет возможность пользователям ресурса дополнять эти сведения самостоятельно. ===== Структура базы данных ===== <html> <h2>age_status</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> name </td> <td class="nowrap" lang="en" dir="ltr">varchar(100)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> picture </td> <td class="nowrap" lang="en" dir="ltr">varchar(100)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>foto</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> id_point </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> file </td> <td class="nowrap" lang="en" dir="ltr">varchar(50)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>point</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> id_user </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> place_coll </td> <td class="nowrap" lang="en" dir="ltr">text</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> date_coll </td> <td class="nowrap" lang="en" dir="ltr">date</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> projective </td> <td class="nowrap" lang="en" dir="ltr">float</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> lat </td> <td class="nowrap" lang="en" dir="ltr">float</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> lon </td> <td class="nowrap" lang="en" dir="ltr">float</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> foto </td> <td class="nowrap" lang="en" dir="ltr">varchar(100)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>point_age_status</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> id_point </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> id_age </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> number </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> height </td> <td class="nowrap" lang="en" dir="ltr">float</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>polygon</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> id_user </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> place </td> <td class="nowrap" lang="en" dir="ltr">text</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> coord </td> <td class="nowrap" lang="en" dir="ltr">varchar(600)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>status</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> name </td> <td class="nowrap" lang="en" dir="ltr">varchar(50)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> <h2>users</h2> <table width="100%" class="print"> <tr><th width="50">Столбец</th> <th width="80">Тип</th> <th width="40">Null</th> <th width="70">По умолчанию</th> <th>Комментарии</th> </tr> <tr class="odd"> <td class="nowrap"> id </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> surname </td> <td class="nowrap" lang="en" dir="ltr">varchar(50)</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> name </td> <td class="nowrap" lang="en" dir="ltr">varchar(50)</td> <td>Да</td> <td class="nowrap"><i>NULL</i></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> patronymic </td> <td class="nowrap" lang="en" dir="ltr">varchar(50)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> mail </td> <td class="nowrap" lang="en" dir="ltr">varchar(20)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> login </td> <td class="nowrap" lang="en" dir="ltr">varchar(20)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="odd"> <td class="nowrap"> password </td> <td class="nowrap" lang="en" dir="ltr">varchar(20)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> <tr class="even"> <td class="nowrap"> id_status </td> <td class="nowrap" lang="en" dir="ltr">int(11)</td> <td>Нет</td> <td class="nowrap"></td> <td></td> </tr> </table> </html> ===== Программные модули ===== ===== Установка системы ===== ===== Управление учетными записями пользователей =====
Инструменты страницы
