Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    revision 14424 by niro, Thu Jul 25 14:21:41 2019 UTC revision 14425 by niro, Wed Jul 15 07:23:38 2020 UTC
    # Line 257  create_database_schema() Line 257  create_database_schema()
    257   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    258   "client_serials"   "client_serials"
    259   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    260   "location varchar(255) NOT NULL"   "location varchar(255) DEFAULT NULL"
    261   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    262   "mac varchar(17) NOT NULL"   "mac varchar(17) DEFAULT NULL"
    263   "hwdetected tinyint(1) NOT NULL DEFAULT '0'"   "hwdetected tinyint(1) NOT NULL DEFAULT '0'"
    264   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    265   )   )
    # Line 268  create_database_schema() Line 268  create_database_schema()
    268   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    269   "client_version"   "client_version"
    270   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY"
    271   "os varchar(50) NOT NULL"   "os varchar(50) DEFAULT NULL"
    272   "utils varchar(50) NOT NULL"   "utils varchar(50) DEFAULT NULL"
    273   "arch varchar(50) NOT NULL"   "arch varchar(50) NOT NULL"
    274   )   )
    275   sql_create_table   sql_create_table
    Legend:
    Removed from v.14424  
    changed lines
      Added in v.14425