Magellan Linux

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 8515 by niro, Mon Feb 8 09:22:28 2016 UTC revision 8548 by niro, Mon Feb 8 13:10:52 2016 UTC
# Line 255  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 381  create_database_schema() Line 381  create_database_schema()
381   sql_create_table   sql_create_table
382    
383   TABLE_DEFINITION=(   TABLE_DEFINITION=(
384   "values_network_channel"   "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"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
394   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
395   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
# Line 397  create_database_schema() Line 405  create_database_schema()
405   sql_create_table   sql_create_table
406    
407   TABLE_DEFINITION=(   TABLE_DEFINITION=(
408   "values_network_key_length"   "values_network_wireless_key_length"
409   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
410   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
411   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"

Legend:
Removed from v.8515  
changed lines
  Added in v.8548