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

Parent Directory | Revision Log | Patch

	revision 9473 by niro, Thu Apr 6 13:57:45 2017 UTC	revision 13666 by niro, Thu Jul 25 12:55:42 2019 UTC
#	Line 36  create_database_schema()	Line 36  create_database_schema()
36	"name varchar(255) NOT NULL"	"name varchar(255) NOT NULL"
37	"exec varchar(255) NOT NULL"	"exec varchar(255) NOT NULL"
38	"comment varchar(255) DEFAULT NULL"	"comment varchar(255) DEFAULT NULL"
39		"enabled tinyint(1) NOT NULL DEFAULT '1'"
40	)	)
41	sql_create_table	sql_create_table
42
#	Line 268  create_database_schema()	Line 269  create_database_schema()
269	"serial int(11) NOT NULL PRIMARY KEY"	"serial int(11) NOT NULL PRIMARY KEY"
270	"os varchar(50) NOT NULL"	"os varchar(50) NOT NULL"
271	"utils varchar(50) NOT NULL"	"utils varchar(50) NOT NULL"
272		"arch varchar(50) NOT NULL"
273	)	)
274	sql_create_table	sql_create_table
275
#	Line 348  create_database_schema()	Line 350  create_database_schema()
350	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
351	"value varchar(255) NOT NULL"	"value varchar(255) NOT NULL"
352	"enabled tinyint(1) NOT NULL DEFAULT '1'"	"enabled tinyint(1) NOT NULL DEFAULT '1'"
353	"description varchar(255) DEFAULT NULL AFTER value"	"description varchar(255) DEFAULT NULL"
354	)	)
355	sql_create_table	sql_create_table
356

---

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

Legend: Removed from v.9473   changed lines   Added in v.13666