/[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_4.sh |
Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_4.sh
Parent Directory | Revision Log
Revision 8515 -
(hide annotations)
(download)
(as text)
Mon Feb 8 09:22:28 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 1067 byte(s)
Mon Feb 8 09:22:28 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 1067 byte(s)
-schema version 4 and values version 2, get wireless_ default values from database
1 | niro | 8515 | update_to_database_schema_version_4() |
2 | { | ||
3 | TABLE_DEFINITION=( | ||
4 | "values_network_wireless_auth_mode" | ||
5 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
6 | "value varchar(255) NOT NULL" | ||
7 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
8 | ) | ||
9 | sql_create_table | ||
10 | |||
11 | TABLE_DEFINITION=( | ||
12 | "values_network_channel" | ||
13 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
14 | "value varchar(255) NOT NULL" | ||
15 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
16 | ) | ||
17 | sql_create_table | ||
18 | |||
19 | TABLE_DEFINITION=( | ||
20 | "values_network_wireless_frequency" | ||
21 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
22 | "value varchar(255) NOT NULL" | ||
23 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
24 | ) | ||
25 | sql_create_table | ||
26 | |||
27 | TABLE_DEFINITION=( | ||
28 | "values_network_key_length" | ||
29 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
30 | "value varchar(255) NOT NULL" | ||
31 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
32 | ) | ||
33 | sql_create_table | ||
34 | |||
35 | TABLE_DEFINITION=( | ||
36 | "values_network_wireless_mode" | ||
37 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
38 | "value varchar(255) NOT NULL" | ||
39 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
40 | ) | ||
41 | sql_create_table | ||
42 | } |