-- --------------------------------------------------------

--
-- Table structure for table `tbl_alist`
--

CREATE TABLE IF NOT EXISTS `tbl_alist` (
  `alist_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`alist_id`),
  KEY `dt_create` (`dt_create`),
  KEY `user_id` (`user_id`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;


--
-- Dumping data for table `tbl_alist`
--

INSERT INTO `tbl_alist` (`alist_id`, `dt_create`, `user_id`, `group_id`) VALUES
(1001, '2000-01-01 00:00:00', 1001, 1001);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_article`
--

CREATE TABLE IF NOT EXISTS `tbl_article` (
  `article_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `alist_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `idx` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(50) DEFAULT NULL,
  `content` text DEFAULT NULL,
  PRIMARY KEY (`article_id`),
  KEY `alist_id` (`alist_id`),
  KEY `status` (`status`),
  KEY `idx` (`idx`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

INSERT INTO `tbl_article` (`dt_create`, `alist_id`, `status`, `idx`, `title`, `content`) VALUES
('2000-01-01 00:00:00', 1001, 1, 1, 'Article 1 : Computer', '<div style=''color:white;background-color:#022;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 1 : Computer</b></p>\n<p>A computer is a device that can be instructed to carry out an arbitrary set of arithmetic or logical operations automatically. The ability of computers to follow a sequence of operations, called a program, make computers very flexible and useful. Such computers are used as control systems for a very wide variety of industrial and consumer devices. This includes simple special purpose devices like microwave ovens and remote controls, factory devices such as industrial robots and computer assisted design, but also in general purpose devices like personal computers and mobile devices such as smartphones. The Internet is run on computers and it connects millions of other computers.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 2, 'Article 2 : World Wide Web', '<div style=''color:white;background-color:#202;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 2 : World Wide Web</b></p>\n<p>The World Wide Web (abbreviated WWW or the Web) is an information space where documents and other web resources are identified by Uniform Resource Locators (URLs), interlinked by hypertext links, and can be accessed via the Internet.English scientist Tim Berners-Lee invented the World Wide Web in 1989. He wrote the first web browser computer programme in 1990 while employed at CERN in Switzerland.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 3, 'Article 3 : Hyperlink', '<div style=''color:white;background-color:#220;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 3 : Hyperlink</b></p>\n<p>In computing, a hyperlink, or simply a link, is a reference to data that the reader can directly follow either by clicking, tapping, or hovering. A hyperlink points to a whole document or to a specific element within a document. Hypertext is text with hyperlinks. The text that is linked is called anchor text. A software system that is used for viewing and creating hypertext is a hypertext system, and to create a hyperlink is to hyperlink (or simply to link). A user following hyperlinks is said to navigate or browse the hypertext.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 4, 'Article 4 : Web browser', '<div style=''color:white;background-color:#200;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 4 : Web browser</b></p>\n<p>A web browser (commonly referred to as a browser) is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier (URI/URL) and may be a web page, image, video or other piece of content. Hyperlinks present in resources enable users easily to navigate their browsers to related resources.</p>\n<p>Although browsers are primarily intended to use the World Wide Web, they can also be used to access information provided by web servers in private networks or files in file systems.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 5, 'Article 5 : HTML', '<div style=''color:white;background-color:#020;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 5 : HTML</b></p>\n<p>HyperText Markup Language (HTML) is the standard markup language for creating web pages and web applications. With Cascading Style Sheets (CSS), and JavaScript, it forms a triad of cornerstone technologies for the World Wide Web. Web browsers receive HTML documents from a webserver or from local storage and render them into multimedia web pages. HTML describes the structure of a web page semantically and originally included cues for the appearance of the document.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 6, 'Article 6 : JavaScript', '<div style=''color:white;background-color:#002;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 6 : JavaScript</b></p>\n<p>JavaScript is a high-level, dynamic, untyped, and interpreted programming language. It has been standardized in the ECMAScript language specification. Alongside HTML and CSS, it is one of the three core technologies of World Wide Web content production; the majority of websites employ it and it is supported by all modern Web browsers without plug-ins. JavaScript is prototype-based with first-class functions, making it a multi-paradigm language, supporting object-oriented, imperative, and functional programming styles. It has an API for working with text, arrays, dates and regular expressions, but does not include any I/O, such as networking, storage, or graphics facilities, relying for these upon the host environment in which it is embedded.</p>\n</div>'),
('2000-01-01 00:00:00', 1001, 1, 7, 'Article 7 : Cascading Style Sheets', '<div style=''color:white;background-color:#022;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 7 : Cascading Style Sheets</b></p>\n<p>Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation of a document written in a markup language.[1] Although most often used to set the visual style of web pages and user interfaces written in HTML and XHTML, the language can be applied to any XML document, including plain XML, SVG and XUL, and is applicable to rendering in speech, or on other media. Along with HTML and JavaScript, CSS is a cornerstone technology used by most websites to create visually engaging webpages, user interfaces for web applications, and user interfaces for many mobile applications.</p>\n</div>'),
('2000-01-01 00:00:00', 1001, 1, 8, 'Article 8 : PHP', '<div style=''color:white;background-color:#202;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 8 : PHP</b></p>\n<p>PHP is a server-side scripting language designed primarily for web development but is also used as a general-purpose programming language. Originally created by Rasmus Lerdorf in 1994, the PHP reference implementation is now produced by The PHP Development Team. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext Preprocessor.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 9, 'Article 9 : MySQL', '<div style=''color:white;background-color:#220;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 9 : MySQL</b></p>\n<p>MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius'' daughter, and "SQL", the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.</p>\n</div>\n'),
('2000-01-01 00:00:00', 1001, 1, 10, 'Article 10 : jQuery (Last Article!)', '<div style=''color:white;background-color:#200;margin:20px 0;padding:20px;font-size:26px;''>\n<p><b>Article 10 : jQuery (Last Article!)</b></p>\n<p>jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML. jQuery is the most popular JavaScript library in use today, with installation on 65% of the top 10 million highest-trafficked sites on the Web. jQuery is free, open-source software licensed under the MIT License.</p>\n</div>');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_cfgdb`
--

CREATE TABLE IF NOT EXISTS `tbl_cfgdb` (
  `cfgdb_id` int(11) NOT NULL AUTO_INCREMENT,
  `ckey` varchar(40) DEFAULT NULL,
  `cval` text DEFAULT NULL,
  PRIMARY KEY (`cfgdb_id`),
  UNIQUE KEY `ckey` (`ckey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002 ;

--
-- Dumping data for table `tbl_cfgdb`
--

INSERT INTO `tbl_cfgdb` (`cfgdb_id`, `ckey`, `cval`) VALUES
(1001, 'cfgapp', '{"tbl:user:default-page-size":10,"tbl:user:default-sort-val":"dt_create:asc"}');


-- --------------------------------------------------------

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `pinidx` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL,
  `b_admin` tinyint(4) NOT NULL DEFAULT '0',
  `username` varchar(100) DEFAULT NULL,
  `passkey` varchar(300) DEFAULT NULL,
  `sess_exp` datetime DEFAULT NULL,
  `sess_sig` varchar(100) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `notes` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `dt_create` (`dt_create`),
  KEY `group_id` (`group_id`),
  KEY `pinidx` (`pinidx`),
  KEY `status` (`status`),
  KEY `username` (`username`),
  KEY `sess_sig` (`sess_sig`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `dt_create`, `group_id`, `pinidx`, `status`, `b_admin`, `username`, `passkey`, `sess_exp`, `sess_sig`, `first_name`, `last_name`, `email`, `notes`) VALUES
(1001, '2000-01-01 00:00:00', 1001, 1, 1, 1, 'admin', 'password', NULL, NULL, NULL, 'Administrator', 'admin@admin.com', NULL);



