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 8573 by niro, Tue Feb 9 13:07:06 2016 UTC revision 9464 by niro, Thu Apr 6 12:57:07 2017 UTC
    # Line 257  create_database_schema() Line 257  create_database_schema()
    257   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    258   "client_locations"   "client_locations"
    259   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    260     "bootserver varchar(255) NOT NULL"
    261   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    262   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    263   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL"
    # Line 275  create_database_schema() Line 276  create_database_schema()
    276    
    277   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    278   "client_serials"   "client_serials"
    279   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    280   "location varchar(255) NOT NULL"   "location varchar(255) NOT NULL"
    281   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    282   "mac varchar(17) NOT NULL"   "mac varchar(17) NOT NULL"
    # Line 369  create_database_schema() Line 370  create_database_schema()
    370   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    371   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    372   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    373     "description varchar(255) DEFAULT NULL AFTER value"
    374   )   )
    375   sql_create_table   sql_create_table
    376    
    # Line 445  create_database_schema() Line 447  create_database_schema()
    447   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    448   )   )
    449   sql_create_table   sql_create_table
    450    
    451     TABLE_DEFINITION=(
    452     "client_boot"
    453     "serial int(255) NOT NULL PRIMARY KEY"
    454     "cmdline varchar(255) DEFAULT NULL"
    455     )
    456     sql_create_table
    457  }  }
    Legend:
    Removed from v.8573  
    changed lines
      Added in v.9464