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 13666 by niro, Thu Jul 25 12:55:42 2019 UTC revision 14425 by niro, Wed Jul 15 07:23:38 2020 UTC
    # Line 154  create_database_schema() Line 154  create_database_schema()
    154   "screensaver varchar(255) NOT NULL"   "screensaver varchar(255) NOT NULL"
    155   "timeout int(11) DEFAULT '10'"   "timeout int(11) DEFAULT '10'"
    156   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    157     "dpms tinyint(1) NOT NULL DEFAULT '1'"
    158   )   )
    159   sql_create_table   sql_create_table
    160    
    # Line 256  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 267  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.13666  
    changed lines
      Added in v.14425