Notes ACCESS 2022 | Browsers | Css | Htacess | Html | Html5 | Javascript | Microsoft Excel | Mysql | Mysql Dumps | Php | Vb.net | VBscript | Windows <=8 | Windows >=10 | WP | WP Plugin | WP Themes | _Misc Software | ABCDEFGHIJKLMNOPQRSTUVWXYZONPRTOFF codeid operationid title keywords application code languageid show_html show_iframe make_public viewed viewed_date language operation <- Look Inside DataConditions:Order: 2 Language Operation Title Keywords Application Code Languageid Show Html Show Iframe Make Public Viewed Viewed Date Mysql Dumps Archive Database: `softwax3_myfiles file contact -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 25, 2023 at 11:46 AM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `softwax3_myfiles` -- -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `contactid` smallint(6) NOT NULL, `last_name` varchar(25) NOT NULL, `first_name` varchar(25) NOT NULL, `phone` varchar(12) NOT NULL, `email` varchar(50) NOT NULL, `additional_info` varchar(300) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `file` -- CREATE TABLE `file` ( `fileid` mediumint(9) NOT NULL, `categoryid` tinyint(4) NOT NULL, `file` varchar(100) NOT NULL, `description` text NOT NULL, `computer_used` varchar(10) NOT NULL, `date_created` date NOT NULL, `date_modified` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `fileCategory` -- CREATE TABLE `fileCategory` ( `categoryid` tinyint(4) NOT NULL, `category` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `fileUpdates` -- CREATE TABLE `fileUpdates` ( `fileid` smallint(6) NOT NULL, `session` int(11) NOT NULL, `title` varchar(50) NOT NULL, `version` varchar(19) NOT NULL, `description` text NOT NULL, `file_exe` varchar(50) NOT NULL, `file_ini` varchar(50) NOT NULL, `file_other` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `folderCategory` -- CREATE TABLE `folderCategory` ( `categoryid` tinyint(4) NOT NULL, `category` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `folders` -- CREATE TABLE `folders` ( `folderid` smallint(6) NOT NULL, `categoryid` smallint(6) NOT NULL, `folder_num` smallint(6) NOT NULL, `description` varchar(40) NOT NULL, `keywords` tinytext NOT NULL, `archive` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `government` -- CREATE TABLE `government` ( `movieid` smallint(6) NOT NULL, `title` varchar(100) NOT NULL, `comment` varchar(400) NOT NULL, `file` varchar(100) NOT NULL, `image` varchar(10) NOT NULL, `viewed` smallint(6) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `iphistory` -- CREATE TABLE `iphistory` ( `historyid` mediumint(9) NOT NULL, `date` date NOT NULL, `ipaddress` varchar(19) NOT NULL, `counter` smallint(6) NOT NULL, `blocking` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `movie` -- CREATE TABLE `movie` ( `movieid` mediumint(9) NOT NULL, `title` varchar(50) NOT NULL, `star5` tinyint(4) NOT NULL, `coverImage` varchar(9) NOT NULL, `rating` tinyint(4) NOT NULL, `genere` varchar(60) NOT NULL, `description` text NOT NULL, `year` smallint(6) NOT NULL, `download` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `projectid` smallint(6) NOT NULL, `project` varchar(20) NOT NULL, `date_modified` date NOT NULL, `table_name` varchar(25) NOT NULL, `fields` text NOT NULL, `date_fields` varchar(25) NOT NULL, `txx` text NOT NULL, `date_txx` varchar(25) NOT NULL, `txtFileName` varchar(25) NOT NULL, `txxFileName` varchar(25) NOT NULL, `txxPath` varchar(50) NOT NULL, `computer` varchar(100) NOT NULL, `list_report` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `storage` -- CREATE TABLE `storage` ( `storageid` tinyint(4) NOT NULL, `date_stored` date NOT NULL, `stored` varchar(250) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `useradmin` -- CREATE TABLE `useradmin` ( `userid` mediumint(9) NOT NULL, `lastname` varchar(30) NOT NULL DEFAULT '', `firstname` varchar(30) NOT NULL DEFAULT '', `email` varchar(70) NOT NULL DEFAULT '', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(20) NOT NULL DEFAULT '', `level` tinyint(4) NOT NULL DEFAULT '0', `logintimes` mediumint(9) NOT NULL DEFAULT '0', `lastlogin` date NOT NULL DEFAULT '0000-00-00', `accesspages` varchar(255) NOT NULL DEFAULT '', `ipaddress` varchar(19) NOT NULL, `locked` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`contactid`), ADD KEY `last_name` (`last_name`,`first_name`); -- -- Indexes for table `file` -- ALTER TABLE `file` ADD PRIMARY KEY (`fileid`), ADD KEY `categoryid` (`categoryid`); -- -- Indexes for table `fileCategory` -- ALTER TABLE `fileCategory` ADD PRIMARY KEY (`categoryid`); -- -- Indexes for table `fileUpdates` -- ALTER TABLE `fileUpdates` ADD PRIMARY KEY (`fileid`); -- -- Indexes for table `folderCategory` -- ALTER TABLE `folderCategory` ADD PRIMARY KEY (`categoryid`); -- -- Indexes for table `folders` -- ALTER TABLE `folders` ADD PRIMARY KEY (`folderid`); -- -- Indexes for table `government` -- ALTER TABLE `government` ADD PRIMARY KEY (`movieid`); -- -- Indexes for table `iphistory` -- ALTER TABLE `iphistory` ADD PRIMARY KEY (`historyid`); -- -- Indexes for table `movie` -- ALTER TABLE `movie` ADD PRIMARY KEY (`movieid`), ADD KEY `download` (`download`); -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`projectid`); -- -- Indexes for table `useradmin` -- ALTER TABLE `useradmin` ADD PRIMARY KEY (`userid`), ADD KEY `lastname` (`lastname`,`firstname`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `contactid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file` -- ALTER TABLE `file` MODIFY `fileid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fileCategory` -- ALTER TABLE `fileCategory` MODIFY `categoryid` tinyint(4) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fileUpdates` -- ALTER TABLE `fileUpdates` MODIFY `fileid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `folderCategory` -- ALTER TABLE `folderCategory` MODIFY `categoryid` tinyint(4) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `folders` -- ALTER TABLE `folders` MODIFY `folderid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `government` -- ALTER TABLE `government` MODIFY `movieid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `iphistory` -- ALTER TABLE `iphistory` MODIFY `historyid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie` -- ALTER TABLE `movie` MODIFY `movieid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `projectid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `useradmin` -- ALTER TABLE `useradmin` MODIFY `userid` mediumint(9) NOT NULL AUTO_INCREMENT; COMMIT; Mysql Dumps 3 09/09/2023 Mysql Dumps Archive Database: `softwax3_codeSaver` code language operation Backup -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 25, 2023 at 11:57 AM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `softwax3_codeSaver` -- -- -------------------------------------------------------- -- -- Table structure for table `code` -- CREATE TABLE `code` ( `codeid` mediumint(9) NOT NULL, `code` text NOT NULL, `title` varchar(70) NOT NULL, `keywords` varchar(100) NOT NULL, `application` varchar(35) NOT NULL, `languageid` tinyint(4) NOT NULL, `operationid` mediumint(9) NOT NULL, `show_html` tinyint(4) NOT NULL, `show_iframe` tinyint(4) NOT NULL, `make_public` tinyint(4) NOT NULL, `viewed` mediumint(9) NOT NULL, `viewed_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `contactid` mediumint(9) NOT NULL, `Subject` varchar(100) NOT NULL, `Body` text NOT NULL, `EmailReply` tinyint(4) NOT NULL, `Email` varchar(80) NOT NULL, `PhoneReply` tinyint(4) NOT NULL, `Phone` varchar(20) NOT NULL, `MailReply` tinyint(4) NOT NULL, `Name` varchar(50) NOT NULL, `Address` varchar(50) NOT NULL, `City` varchar(20) NOT NULL, `State` varchar(20) NOT NULL, `Zip` varchar(20) NOT NULL, `dateof` date NOT NULL, `ipaddress` varchar(19) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `language` -- CREATE TABLE `language` ( `languageid` tinyint(6) NOT NULL, `language` varchar(25) NOT NULL, `menu_column` tinyint(4) NOT NULL, `menu_row` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `operation` -- CREATE TABLE `operation` ( `operationid` smallint(6) NOT NULL, `operation` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `settingid` smallint(6) NOT NULL, `title` varchar(30) NOT NULL, `value` varchar(70) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `settings_Large` -- CREATE TABLE `settings_Large` ( `settingid` smallint(6) NOT NULL, `title` varchar(30) NOT NULL, `value` varchar(1000) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `useradmin` -- CREATE TABLE `useradmin` ( `userid` mediumint(9) NOT NULL, `lastname` varchar(30) NOT NULL DEFAULT '', `firstname` varchar(30) NOT NULL DEFAULT '', `email` varchar(70) NOT NULL DEFAULT '', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(20) NOT NULL DEFAULT '', `level` tinyint(4) NOT NULL DEFAULT '0', `logintimes` mediumint(9) NOT NULL DEFAULT '0', `lastlogin` date NOT NULL DEFAULT '0000-00-00', `accesspages` varchar(255) NOT NULL DEFAULT '', `ipaddress` varchar(19) NOT NULL, `locked` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `websites` -- CREATE TABLE `websites` ( `siteid` smallint(6) NOT NULL, `url` varchar(100) NOT NULL, `title` varchar(50) NOT NULL, `comment` text NOT NULL, `year` smallint(6) NOT NULL, `personal` tinyint(4) NOT NULL, `ecommerce` tinyint(4) NOT NULL, `event_register` tinyint(4) NOT NULL, `email_news` tinyint(4) NOT NULL, `calendar` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `code` -- ALTER TABLE `code` ADD PRIMARY KEY (`codeid`), ADD KEY `languageid` (`languageid`), ADD KEY `operationid` (`operationid`), ADD KEY `application` (`application`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`contactid`); -- -- Indexes for table `language` -- ALTER TABLE `language` ADD PRIMARY KEY (`languageid`); -- -- Indexes for table `operation` -- ALTER TABLE `operation` ADD PRIMARY KEY (`operationid`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`settingid`); -- -- Indexes for table `settings_Large` -- ALTER TABLE `settings_Large` ADD PRIMARY KEY (`settingid`); -- -- Indexes for table `useradmin` -- ALTER TABLE `useradmin` ADD PRIMARY KEY (`userid`), ADD KEY `lastname` (`lastname`,`firstname`); -- -- Indexes for table `websites` -- ALTER TABLE `websites` ADD PRIMARY KEY (`siteid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `code` -- ALTER TABLE `code` MODIFY `codeid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `contactid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `language` -- ALTER TABLE `language` MODIFY `languageid` tinyint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `operation` -- ALTER TABLE `operation` MODIFY `operationid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `settingid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings_Large` -- ALTER TABLE `settings_Large` MODIFY `settingid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `useradmin` -- ALTER TABLE `useradmin` MODIFY `userid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `websites` -- ALTER TABLE `websites` MODIFY `siteid` smallint(6) NOT NULL AUTO_INCREMENT; COMMIT; Mysql Dumps 3 09/09/2023