Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

Parent Directory | Revision Log | Patch

	revision 9469 by niro, Thu Apr 6 13:34:54 2017 UTC	revision 10646 by niro, Wed Aug 30 13:56:46 2017 UTC
#	Line 13  create_database_schema()	Line 13  create_database_schema()
13	sql_create_table	sql_create_table
14
15	TABLE_DEFINITION=(	TABLE_DEFINITION=(
	"cfg_fluxbox_autostart"
	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
	"serial int(11) NOT NULL"
	"name varchar(255) NOT NULL"
	"exec varchar(255) DEFAULT NULL"
	"enabled tinyint(1) NOT NULL DEFAULT '1'"
	"flg_modified tinyint(1) NOT NULL DEFAULT '0'"
	)
	sql_create_table
	TABLE_DEFINITION=(
16	"cfg_citrix_serverlist"	"cfg_citrix_serverlist"
17	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
18	"serial int(11) NOT NULL"	"serial int(11) NOT NULL"
#	Line 279  create_database_schema()	Line 268  create_database_schema()
268	"serial int(11) NOT NULL PRIMARY KEY"	"serial int(11) NOT NULL PRIMARY KEY"
269	"os varchar(50) NOT NULL"	"os varchar(50) NOT NULL"
270	"utils varchar(50) NOT NULL"	"utils varchar(50) NOT NULL"
271		"arch varchar(50) NOT NULL"
272	)	)
273	sql_create_table	sql_create_table
274
#	Line 359  create_database_schema()	Line 349  create_database_schema()
349	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
350	"value varchar(255) NOT NULL"	"value varchar(255) NOT NULL"
351	"enabled tinyint(1) NOT NULL DEFAULT '1'"	"enabled tinyint(1) NOT NULL DEFAULT '1'"
352	"description varchar(255) DEFAULT NULL AFTER value"	"description varchar(255) DEFAULT NULL"
353	)	)
354	sql_create_table	sql_create_table
355

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.9469   changed lines   Added in v.10646