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 8485 by niro, Fri Feb 5 12:06:33 2016 UTC revision 8548 by niro, Mon Feb 8 13:10:52 2016 UTC
    # Line 1  Line 1 
    1  create_database_schema()  create_database_schema()
    2  {  {
    3   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    4   "meta"   "meta_schema"
    5     "version int(11) NOT NULL PRIMARY KEY"
    6     )
    7     sql_create_table
    8    
    9     TABLE_DEFINITION=(
    10     "meta_values"
    11   "version int(11) NOT NULL PRIMARY KEY"   "version int(11) NOT NULL PRIMARY KEY"
    12   )   )
    13   sql_create_table   sql_create_table
    # Line 249  create_database_schema() Line 255  create_database_schema()
    255   sql_create_table   sql_create_table
    256    
    257   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    258   "client_location"   "client_locations"
    259   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    260   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    261   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    # Line 363  create_database_schema() Line 369  create_database_schema()
    369   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    370   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    371   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    372     )
    373     sql_create_table
    374    
    375     TABLE_DEFINITION=(
    376     "values_network_wireless_auth_mode"
    377     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    378     "value varchar(255) NOT NULL"
    379     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    380     )
    381     sql_create_table
    382    
    383     TABLE_DEFINITION=(
    384     "values_network_wireless_bitrate"
    385     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    386     "value varchar(255) NOT NULL"
    387     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    388     )
    389     sql_create_table
    390    
    391     TABLE_DEFINITION=(
    392     "values_network_wireless_channel"
    393     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    394     "value varchar(255) NOT NULL"
    395     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    396     )
    397     sql_create_table
    398    
    399     TABLE_DEFINITION=(
    400     "values_network_wireless_frequency"
    401     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    402     "value varchar(255) NOT NULL"
    403     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    404     )
    405     sql_create_table
    406    
    407     TABLE_DEFINITION=(
    408     "values_network_wireless_key_length"
    409     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    410     "value varchar(255) NOT NULL"
    411     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    412     )
    413     sql_create_table
    414    
    415     TABLE_DEFINITION=(
    416     "values_network_wireless_mode"
    417     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    418     "value varchar(255) NOT NULL"
    419     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    420   )   )
    421   sql_create_table   sql_create_table
    422    
    Legend:
    Removed from v.8485  
    changed lines
      Added in v.8548